Author: dbalifeeasy

./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

While running ‘ggsci’, the following error occures:

$ cd GG_HOME
$./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

Solution

Set up correct env variable $LD_LIBRARY_PATH by :

$ . oraenv
ORACLE_SID = [oracle] ? amer
The Oracle base has been set to /u01/app/oracle
$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
...
..
.

Oracle CPU/PSU/BP/RU/RUR : Loading Modified SQL Files into Database

After applied Oracle CPU/PSU/BP/RU/RUR patch sets, one post installation task is “Loading Modified SQL Files Into the Database”.

For RAC and non-RAC, Exadata including ExaCC, ExaCS and non-Exadata, OJVM and non-OJVM, before 12c and after 12c versions, the way to execute SQL files are different from version to version. This post will demonstrate how to run it under different circumstances.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

TNS-01101: Could not find listener name or service name LISTENER_SCAN1

A non-grid user tries to run the following command with TNS-01101 error: 

$ /u01/app/19.0.0.0/grid/bin/lsnrctl status LISTENER_SCAN1

...
..
.

TNS-01101: Could not find listener name or service name LISTENER_SCAN1

SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Tune OEM 13c Agent Parameters when Agent is Monitoring Big Amount of Targets

In Exadata environment, the OEM agent is monitoring up to one hundred of targets. The agent always stopped or bounced by itself with the following different errors. This post demonstrates how to tune the agent parameters to improve the agent satiability and performance.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe