This KA covers the client install and tnsnames.ora file creation

(1) ORACLE CLIENT INSTALL

1. Log into the Application server/Oracle Client Linux VM as ‘root’ and create a directory to download the installer (such as /bmc/local/home/oracle_install).  Download the Oracle 12c Client from the Oracle Website. 

1. The file is a compressed .zip file.  Once the file is uploaded into the directory of your choice, unzip it using the following command:

1. From any directory in the CLI, run the following 3 commands to determine which dependencies still need to be installed for the Oracle Client to function:

1. For any package that is not installed, run “yum provides <name of package>”. It will show you the repository with the required dependency.  Once listed, run “yum install <name of repository>”. (As this is 64 bit Linux, use the 64 bit repository unless noted otherwise). 
2. Install this additional dependency with the following command:

1. Create the oracle user and password, running the command: 

• useradd -m oracle
• passwd oracle 

1. Exit out of ‘root’ and login as ‘oracle’ user (the installer may fail to load if you do not log in directly). 
2. Navigate to the Oracle install directory and run “./runInstaller” (where /media/client is where you extracted the Oracle Client archive).

1. Eventually, and Oracle GUI will load, giving you the installer screen. Follow the next screens to properly install the Oracle Client.

Please do a Custom install.
 
    
 
The default language is ok here. Click Next.
 
 
 
  
Change the install path for the Oracle client so it says
/opt/oracle/app/oracle
The software location will update automatically
You may need to adjust permissions on the /opt folder if there is an error. make sure the owner user has permissions to write, read and execute on the target directory and try the install again.
 
 
 
 
Leave this as default and click next.

 
 
 
 Checkmark the following components for the install:

• Oracle DB Utilities
• Oracle Java Client
• SQL *Plus
• ORACLE JDBC / THIN Interfaces
• Oracle Call Interface
• Oracle Programmer
• Oracle Net

Click next once all components are selected.
 
 
 
 
 A prerequisite check will appear having you install additional dependencies.


There will be packages missing. To correct these, you will need to open a command line window to the box and manually install these.
While many of these can be installed with the ‘yum’ commands, you may not be able to find them with ‘yum provides <dependency name>’.  For those, download the .rpm files from the internet.
To find those .rpm files, you can search for them by name with Google or with rpmfind.net in a browser window.
An example of this is below:

Choose the .rpm for Linux version you are running, then copy the .rpm link address (right click on the .rpm file name)
 
 


 
 
Once the link location is copied, open a new ssh session to the same VM as ‘root’.  Navigate to a directory where you can download the files (e.g. /tmp), then with the run the wget command and paste the link location to download the file. Install the file by running the rpm –i <filename> to install it.
wget <link location>
Let it download, then run
rpm –i <filename>
After running the rpm –i command, it will return to the prompt without further information. However, the package will be installed.

NOTE: if you encounter issues with rpm -i installing the rpm packages due to missing dependencies, you can just run yum -y install <name of package> e.g. sudo yum -y install compat-libcap1-1.10 this way, it will force to install the missing dependencies.

To see the changes reflected, run Check Again from the GUI.
 
 
Once you do this for all remaining packages, it will only list the error regarding the “Users With Same UID.”
 
 
 
This error can be ignored. Please chose the “Ignore All” checkbox to proceed with the install.
Proceed by pressing next then yes when prompted.
 
 
 
 
  
Confirm all the settings look correct.  Make note of these location as you will use them when installing the application server.



Press Install when ready.
As it runs, the installer progress will look like this. It is almost done.  As it nears the end of the install, it will ask to have the ‘root’ user run an additional script.
 
 
 
 
 
 Follow the steps listed before hitting ok.
 

 
You will see the output in the command line similar to the one above.

Once Complete, create the tnsnames.ora.


 

(2) TNSNAMES.ORA CREATION