Details: After installing Oracle GoldenGate for Oracle and run ggsci, I got the following error:
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory ./ggsci ./ggsci: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
What's the reason? How to resolve this?
Answer: The missing libnnz11.so error is because of missing OCI libraries needed for GoldenGate to connect to database. You only need to install the free Oracle Database client (Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client). After the installation, set the LD_LIBRARY_PATH shown as the following example (please update the path based on your setup):
Answer: The missing libnnz11.so error is because of missing OCI libraries needed for GoldenGate to connect to database. You only need to install the free Oracle Database client (Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client). After the installation, set the LD_LIBRARY_PATH shown as the following example (please update the path based on your setup):
export LD_LIBRARY_PATH=/home/ec2-user/oracle11/lib
The libaio.so.1 error is because of missing LINUX package. The installation step is shown as follows:
[ec2-user@ip-10-184-238-104 oracle11]$ yum -y install libaio-devel Loaded plugins: amazon-id, rhui-lb, search-disabled-repos Repo rhui-REGION-client-config-server-7 forced skip_if_unavailable=True due to: /etc/pki/rhui/cdn.redhat.com-chain.crt Repo rhui-REGION-client-config-server-7 forced skip_if_unavailable=True due to: /etc/pki/rhui/product/rhui-client-config-server-7.crt Repo rhui-REGION-client-config-server-7 forced skip_if_unavailable=True due to: /etc/pki/rhui/rhui-client-config-server-7.key Repo rhui-REGION-rhel-server-releases forced skip_if_unavailable=True due to: /etc/pki/rhui/cdn.redhat.com-chain.crt Repo rhui-REGION-rhel-server-releases forced skip_if_unavailable=True due to: /etc/pki/rhui/product/content-rhel7.crt Repo rhui-REGION-rhel-server-releases forced skip_if_unavailable=True due to: /etc/pki/rhui/content-rhel7.key Repo rhui-REGION-rhel-server-rh-common forced skip_if_unavailable=True due to: /etc/pki/rhui/cdn.redhat.com-chain.crt Repo rhui-REGION-rhel-server-rh-common forced skip_if_unavailable=True due to: /etc/pki/rhui/product/content-rhel7.crt Repo rhui-REGION-rhel-server-rh-common forced skip_if_unavailable=True due to: /etc/pki/rhui/content-rhel7.key You need to be root to perform this command. [ec2-user@ip-10-184-238-104 oracle11]$ sudo yum -y install libaio-devel Loaded plugins: amazon-id, rhui-lb, search-disabled-repos Resolving Dependencies --> Running transaction check ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed --> Processing Dependency: libaio(x86-64) = 0.3.109-13.el7 for package: libaio-devel-0.3.109-13.el7.x86_64 --> Running transaction check ---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================ Package Arch Version Repository Size ============================================================================================ Installing: libaio-devel x86_64 0.3.109-13.el7 rhui-REGION-rhel-server-releases 13 k Installing for dependencies: libaio x86_64 0.3.109-13.el7 rhui-REGION-rhel-server-releases 24 k Transaction Summary ============================================================================================ Install 1 Package (+1 Dependent package) Total download size: 37 k Installed size: 46 k Downloading packages: (1/2): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00 (2/2): libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00 -------------------------------------------------------------------------------------------- Total 129 kB/s | 37 kB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : libaio-0.3.109-13.el7.x86_64 1/2 Installing : libaio-devel-0.3.109-13.el7.x86_64 2/2 Verifying : libaio-0.3.109-13.el7.x86_64 1/2 Verifying : libaio-devel-0.3.109-13.el7.x86_64 2/2 Installed: libaio-devel.x86_64 0:0.3.109-13.el7 Dependency Installed: libaio.x86_64 0:0.3.109-13.el7 Complete!