Friday 22 January 2021

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

Error while connecting to ggsci after install, due to missing shared files 

[oracle@racnode01 prddb01]$ ./ggsci

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

Check missing file with ldd:

'ldd' of the ggsci executable will show the following libraries missing 

[oracle@racnode01 prddb01]$ldd ggsci

libnnz19.so => not found

libclntsh.so.19.1 => not found

libclntshcore.so.19.1 => not found


Solution 1: Export Library path 

[oracle@racnode01 prddb01]$ export LD_LIBRARY_PATH=/u01/app/19.8.0.0/grid/lib:/san/gg/prddb01

[oracle@racnode01 prddb01]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO

Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29

Operating system character set identified as UTF-8.

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

GGSCI (racnode01) 1> 


Second option: Create softlink from grid_home or oracle_home lib folder 

cd /u01/app/19.8.0.0/grid/lib

[oracle@racnode01 lib]$ ls -ltr libnnz*

-rw-r--r-- 1 root oinstall  6586360 Jul 10  2020 libnnz19.so

-rw-r--r-- 1 root oinstall  1967164 Jul 10  2020 libnnz19.a

-rw-r--r-- 1 root oinstall 20418322 Jul 10  2020 libnnzst19.a

[oracle@racnode01 lib]$ cd /san/gg/prddb01/

$ ln -s /u01/app/19.8.0.0/grid/lib/libnnz19.so libnnz19.so

$ ln -s /u01/app/19.8.0.0/grid/lib/libclntsh.so.19.1 libclntsh.so.19.1

$ ln -s /u01/app/19.8.0.0/grid/lib/libclntshcore.so.19.1 libclntshcore.so.19.1

[oracle@racnode01 prddb01]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO

Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29

Operating system character set identified as UTF-8.

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

GGSCI (racnode01) 1> 

Monday 18 January 2021

Manage wallet configurations with mkstore

View entries in wallet key using mkstore:

[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -list

Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

Oracle Secret Store entries: 

oracle.security.client.connect_string1

oracle.security.client.password1

oracle.security.client.username1



View entry details:

[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -viewEntry oracle.security.client.connect_string1


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

oracle.security.client.connect_string1 = TSTDB_TNS


[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -viewEntry oracle.security.client.username1


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

oracle.security.client.username1 = TSTDB_USER


[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -viewEntry oracle.security.client.password1


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

oracle.security.client.password1 = tstdbuser_pwd


Modify entry configurations:

[oracle@racnode01 tns_admin]$  mkstore -wrl /u01/app/oracle/db_wallet/wallet -modifyEntry oracle.security.client.connect_string1 PRODDB_TNS


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:  


Check entry update or not in wallet key: 

[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -viewEntry oracle.security.client.connect_string1


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

oracle.security.client.connect_string1 = PRODDB_TNS



let do configuration changes for other entries in wallet key:

[oracle@racnode01 tns_admin]$  mkstore -wrl /u01/app/oracle/db_wallet/wallet -modifyEntry oracle.security.client.username1 PRODDB_USER


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   



[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -viewEntry oracle.security.client.username1


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

oracle.security.client.username1 = PRODDB_USER



[oracle@racnode01 tns_admin]$  mkstore -wrl /u01/app/oracle/db_wallet/wallet -modifyEntry oracle.security.client.password1 proddbuser_pwd


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:  

 

[oracle@racnode01 tns_admin]$ mkstore -wrl /u01/app/oracle/db_wallet/wallet -viewEntry oracle.security.client.password1


Oracle Secret Store Tool Release 23.0.0.0.0 - Production

Version 23.0.0.0.0

Copyright (c) 2004, 2021, Oracle and/or its affiliates. All rights reserved.


Enter wallet password:   

oracle.security.client.password1 = proddbuser_pwd


Monday 11 January 2021

Gather ExaWatcher logs to troubleshoot performance problem or hang issue in Exadata Machine

ExaWatcher logs help to troubleshoot performance problems and  hang issue in Exadata Machine.

Get ExaWatcher logs for problematic period:
login as a root user
cd /opt/oracle.ExaWatcher/
./GetExaWatcherResults.sh --from 01/10/2021_01:00:00 --to 01/10/2021_03:00:00  
above command will create zip file under /opt/oracle.ExaWatcher/archive/ExtractedResults
GetExaWatcherResults.sh will give you a details about:
  • CPU utilization and details
  • IO Summary
  • Meminfo details
  • vmstat
  • netstat
  • diskinfo
  • more