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