This blog includes an example installation of Oracle Client (Oracle Database 12.2.0.1 client) for Oracle GoldenGate remote capture. The example runs on AWS EC2.
After download the Oracle Database client from OTN, you can unzip the file to a directory for installation. To perform silent installation, you can edit the example response file defined as follows. Note that we choose the "Administrator" option to enable Oracle GoldenGate replication.
After download the Oracle Database client from OTN, you can unzip the file to a directory for installation. To perform silent installation, you can edit the example response file defined as follows. Note that we choose the "Administrator" option to enable Oracle GoldenGate replication.
[ec2-user@ip-172-30-3-146 client]$ more response/client_install.rsp ############################################################################### ## Copyright(c) Oracle Corporation 1998,2017. All rights reserved. ## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ############################################################################### #------------------------------------------------------------------------------- # Do not change the following system generated value. #------------------------------------------------------------------------------- oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema _v12.2.0 #------------------------------------------------------------------------------- # Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=ec2-user #------------------------------------------------------------------------------- # Inventory location. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/home/ec2-user/oracle/oraInventory #------------------------------------------------------------------------------- # Complete path of the Oracle Home #------------------------------------------------------------------------------- ORACLE_HOME=/home/ec2-user/oracle/product/12.2.0.1/ #------------------------------------------------------------------------------- # Complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/home/ec2-user/oracle #------------------------------------------------------------------------------ #Name : INSTALL_TYPE #Datatype : String #Description: Installation type of the component. # # The following choices are available. The value should contain # only one of these choices. # - InstantClient # - Administrator # - Runtime # - Custom # #Example : INSTALL_TYPE = Administrator #------------------------------------------------------------------------------ oracle.install.client.installType=Administrator #------------------------------------------------------------------------------- # Name : oracle.install.client.customComponents # Datatype : StringList # # This property is considered only if INSTALL_TYPE is set to "Custom" # # Description: List of Client Components you would like to install # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to install. # # oracle.sqlj:12.2.0.1.0 -- "Oracle SQLJ" # oracle.rdbms.util:12.2.0.1.0 -- "Oracle Database Utilities" # oracle.javavm.client:12.2.0.1.0 -- "Oracle Java Client" # oracle.sqlplus:12.2.0.1.0 -- "SQL*Plus" # oracle.dbjava.jdbc:12.2.0.1.0 -- "Oracle JDBC/THIN Interfaces" # oracle.ldap.client:12.2.0.1.0 -- "Oracle Internet Directory Client" # oracle.rdbms.oci:12.2.0.1.0 -- "Oracle Call Interface (OCI)" # oracle.precomp:12.2.0.1.0 -- "Oracle Programmer" # oracle.xdk:12.2.0.1.0 -- "Oracle XML Development Kit" # oracle.network.aso:12.2.0.1.0 -- "Oracle Advanced Security" # oracle.oraolap.mgmt:12.2.0.1.0 -- "OLAP Analytic Workspace Manager and Worksheet" # oracle.network.client:12.2.0.1.0 -- "Oracle Net" # oracle.network.cman:12.2.0.1.0 -- "Oracle Connection Manager" # oracle.network.listener:12.2.0.1.0 -- "Oracle Net Listener" # oracle.ordim.client:12.2.0.1.0 -- "Oracle Multimedia Client Option" # oracle.odbc:12.2.0.1.0 -- "Oracle ODBC Driver" # oracle.has.client:12.2.0.1.0 -- "Oracle Clusterware High Availability API" # oracle.dbdev:12.2.0.1.0 -- "Oracle SQL Developer" # oracle.rdbms.scheduler:12.2.0.1.0 -- "Oracle Scheduler Agent" # # Example : oracle.install.client.customComponents="oracle.precomp:12.2.0.1.0","orac le.oraolap.mgmt:12.2.0.1.0","oracle.rdbms.scheduler:12.2.0.1.0" #------------------------------------------------------------------------------- oracle.install.client.customComponents= #------------------------------------------------------------------------------- # Host name to be used for by the Oracle Scheduler Agent. # This needs to be entered in case oracle.rdbms.scheduler is selected in the # list of custom components during custom install # # Example : oracle.install.client.schedulerAgentHostName = acme.domain.com #------------------------------------------------------------------------------ oracle.install.client.schedulerAgentHostName=localhost #------------------------------------------------------------------------------ # Port number to be used for by the Oracle Scheduler Agent. # This needs to be entered in case oracle.rdbms.scheduler is selected in the # list of custom components during custom install # # Example: oracle.install.client.schedulerAgentPortNumber = 1500 #------------------------------------------------------------------------------ oracle.install.client.schedulerAgentPortNumber=1500
The installation command is as follows:
./runInstaller -silent -nowait -responseFile /home/ec2-user/software/client/response/client_install.rsp
After you get the client installed successfully, you can start the SQL*Plus to connect to remote database.
$export ORACLE_HOME=/home/ec2-user/oracle/product/12.2.0.1 $export LD_LIBRARY_PATH=$ORACLE_HOME/lib $export PATH=$PATH:$ORACLE_HOME/bin $sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Thu Sep 21 18:09:55 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL>
Why do I get the "sqlplus: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory" error?
Answer: The problem is that your system (like AWS LINUX) doesn't have all the prerequisites for the Oracle database client installation. I took the following steps and resolved the issue.
Answer: The problem is that your system (like AWS LINUX) doesn't have all the prerequisites for the Oracle database client installation. I took the following steps and resolved the issue.
$sudo yum install compat-libcap1 $sudo yum install libaio-devel $sudo yum install compat-libstdc++-33 $sudo yum install libstdc++-devel $sudo yum install gcc $sudo yum install ksh $sudo yum install gcc-c++ $sudo yum install libaio-devel $./runInstaller -silent -nowait -responseFile /home/ec2-user/software/client/response/client_install.rsp $$ORACLE_HOME/bin/relink all