Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.
Showing posts with label Oracle Client. Show all posts
Showing posts with label Oracle Client. Show all posts
Wednesday, May 22, 2019
Deprecated security parameter in Oracle 12c: SEC_CASE_SENSITIVE_LOGON
Oracle states:
"The use of the Oracle instance initialization parameter SEC_CASE_SENSITIVE_LOGON is deprecated in favor of setting the SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter to 12 to ensure that passwords are treated in a case-sensitive fashion.
Disabling password case sensitivity is not supported in Exclusive mode (when SQLNET.ALLOWED_LOGON_VERSION_SERVER is set to 12 or 12a.)
See this post for an example used during implementation
Documentation here
Tuesday, April 21, 2015
What do do when Oracle Universal Installer reports missing package pdksh-5.2.14 oracle
On RHEL 6, if you encounter situations where the OUI is complaining about the absence of a package pdksh-5.2.14 oracle, do the following:
When installing a 32-bit client like in my case, the OUI will warn that "all requirements have not been met".
This message can be ignored and you can proceed with the installation.
Source: MOS document ID 1454982.1
1. Change directory to/database/stage/cvu/cv/admin 2. Backup cvu_config: % cp cvu_config backup_cvu_config 3. Edit cvu_config and change the following line: CV_ASSUME_DISTID=OEL4 to: CV_ASSUME_DISTID=OEL6 4. Save the updated cvu_config file 5. Install the 11.2.0.3 or 11.2.0.4 software using /database/runInstaller % cd /database % ./runInstaller
When installing a 32-bit client like in my case, the OUI will warn that "all requirements have not been met".
This message can be ignored and you can proceed with the installation.
Source: MOS document ID 1454982.1
Wednesday, June 18, 2014
How to install the instant client from Oracle on a Linux application server
This is how I quite quickly installed sqlplus on a Linux appserver on request from my customer:
1. Download the two files
2. Create Directory for the installation files
3. Ftp the files over to the server
4. Put the installation files in the install Directory:
5. Unzip the files:
6. Create a Directory for networking:
7. set up the .bash_profile:
8. Create file tnsnames.ora, add an entry for each of the databases you'd like to Access via sqlplus.
All done!
Note that you do need *both* the basic and the sqlplus instantclient zip files to be unpacked into the same directory. If not, you will be missing Libraries in your installation and you'll receive the following error when launching sqlplus:
1. Download the two files
instantclient-basic-linux.x64-11.2.0.4.0.zip instantclient-sqlplus-linux.x64-11.2.0.4.0.zipfrom the otn network.
2. Create Directory for the installation files
mkdir /u01/oracle/product/admin/install
3. Ftp the files over to the server
4. Put the installation files in the install Directory:
mv /tmp/instantclient*.zip /u01/oracle/product/admin/install
5. Unzip the files:
unzip instantclient-basic-linux.x64-11.2.0.4.0.zip -d /u01/oracle/product unzip instantclient-sqlplus-linux.x64-11.2.0.4.0.zip -d /u01/oracle/productThe files will be unzipped to the Directory /u01/oracle/Product/instantclient_11_2
6. Create a Directory for networking:
mkdir $ORACLE_HOME/network/admin
7. set up the .bash_profile:
export ORACLE_BASE=/u01/oracle export ORACLE_HOME=/u01/oracle/product/instantclient_11_2 export PATH=$PATH:$HOME/bin:$ORACLE_HOME export LD_LIBRARY_PATH=/u01/oracle/product/instantclient_11_2 export NLS_LANG=NORWEGIAN_NORWAY.UTF8 export TNS_ADMIN=$ORACLE_HOME/network/admin
8. Create file tnsnames.ora, add an entry for each of the databases you'd like to Access via sqlplus.
All done!
Note that you do need *both* the basic and the sqlplus instantclient zip files to be unpacked into the same directory. If not, you will be missing Libraries in your installation and you'll receive the following error when launching sqlplus:
sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or Directory
Subscribe to:
Posts (Atom)