Oracle Error While Loading Shared Libraries Libnnz11.so
Linux The below error might be encountered while initializing the GGSCI prompt for Oracle GoldenGate. [oracle@ogg1 ogg]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory There are two ways to resolve this error. We can follow either ways. By setting the LD_LIBRARY_PATH in the environment By creating the soft links for the missing Library Files 1. Setting the LD_LIBRARY_PATH Edit the .bash_profile to the add the LD_LIBRARY_PATH vi .bash_profile export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib Save the file and execute the proflie . ./.bash_profile Note - profile names changes according to the Operating System we use. Here in this example, I have used OEL (Oracle Enterprise Linux) Check whether GGSCI Prompt is working [oracle@ogg1 ogg]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13 Operating system character set identified as UTF-8. Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved. GGSCI (ogg1.localdomain) 1> 2. Creating Soft Links for the missing Library Files Secondly, You can create a soft link for the Missing Library files under GoldenGate home. Go to the GoldenGate Home [oracle@ogg1 ~]$ cd /ogg Create the soft links., [oracle@ogg1 ogg]$ ln -s $ORACLE_HOME/lib/libnnz11.so libnnz11.so [oracle@ogg1 ogg]$ [oracle@ogg1 ogg]$ ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.so.11.1 Check whether GGSCI Prompt is working [oracle@ogg1 ogg]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13 Operating system character set identified as UTF-8. Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved. GGSCI (ogg1.localdomain) 1> Conclusion: Always setting the LD_LIBRARY_PATH is
when executing ggsci on Linux By Jay Lee on Nov 30, 2009 I came across the error like following when I executed ggsci on OEL:[oracle@jlee-oss ggsource1]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directorythose are libraries which are located in ORACLE_HOME. so, this can be easily solved using soft link. [oracle@jlee-oss ggsource1]$ ln -s /home/oracle/product/10.2.0/db_1/lib32/libnnz10.so libnnz10.soplus one more link as below.[oracle@jlee-oss ggsource1]$ ln -s /home/oracle/product/10.2.0/db_1/lib32/libclntsh.so.10.1 libclntsh.so.10.1When using 64bit, change the lib path (lib32 to http://www.oracle-scn.com/ggsci-error-while-loading-shared-libraries-libnnz11-so-cannot-open-shared-object-file-no-such-file-or-directory/ lib64) above to the appropriate one. happy replicating! Category: Goldengate Tags: none Permanent link to this entry « Stuck at Blank Scree... | Main | OracleVM Command... » Comments: Hi, I'm receiving this error but the symbolic link didn't help. The error is below: [appgg@f2c04 gg]$ ./ggsci ./ggsci: error while loading shared libraries: /ora01/F2C/F2CDEV1/db/tech_st/10.2.0/lib/libclntsh.so.10.1: cannot restore segment prot after reloc: https://blogs.oracle.com/jaylee/entry/libnnz10so_missing_when_execut Permission denied [appgg@f2c04 gg]$ the appgg user is the ORACLE_HOME owner. Posted by Paulo on March 04, 2010 at 03:01 AM PST # Hi, Paulo. I'm a bit late. Briefly speaking, it's because u're using SELinux. check on metalink 454196.1 or execute the following comands as a root. /usr/sbin/semanage fcontext -a -t textrel_shlib_t $ORACLE_HOME/lib/libnnz11.so /usr/sbin/semanage fcontext -a -t textrel_shlib_t $ORACLE_HOME/lib/libnque11.so /usr/sbin/semanage fcontext -a -t textrel_shlib_t $ORACLE_HOME/lib/libclntsh.so.11.1 Jay Posted by changjae.lee on March 07, 2010 at 06:34 PM PST # I think the environment variables are not set properly. Please set the Golden Gate variables before u try starting. Rakesh Posted by Rakesh on January 18, 2011 at 01:12 AM PST # Rakesh, yes. you are correct. I should have fixed this article a while before. Thanks. Posted by changjae.lee on January 18, 2011 at 09:14 AM PST # Post a Comment: Name: E-Mail: URL: Notify me by email of new comments Remember Information? Your Comment: HTML Syntax: NOT allowed About Solution & Technology Architect, Asia Pacific Search Enter search term: Search filtering requires JavaScript Recent Posts
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have http://dba.stackexchange.com/questions/12005/oracle11-2g-post-installation-problem-on-oracle-linux-kernel Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their oracle error database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle11.2g post-installation problem on Oracle Linux kernel up vote 3 down vote favorite 1 [question copied oracle error while from stackoverflow] After installation of Oracle 11.2g in silent mode on the Oracle Linux kernel, I have the following error: [u01/app/oracle/product/11/bin] $ sqlplus sqlplus error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory However, the shared object seems to be setup correctly: [/u01/app/oracle/product/11/lib] $ ls -lrt /u01/app/oracle/product/11/lib | grep sqlplus -rw-r--r--. 1 oracle oinstall 1475820 Aug 1 2009 libsqlplus.a -rwxr-xr-x. 1 oracle oinstall 1218075 Aug 1 2009 libsqlplus.so The user is oracle: [oracle ~]$ id oracle uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba) The environment variables are: [oracle ~]$ env USER=oracle LD_LIBRARY_PATH=/u01/app/oracle/product/11/lib ORACLE_SID=orcl ORACLE_BASE=/u01/app/oracle PATH=/usr/lib/qt-3.3/bin:/usr/local/bin :/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin: /home/oracle/bin :/u01/app/oracle/product/11/bin HOME=/home/oracle ORACLE_HOME=/u01/app/oracle/product/11 kernel version: 2.6.32-300.3.1.el6uek.i686 *UPDATE FOR ANSWER * [oracle@orcus lib]$ ldd /u01/app/oracle/product/11/bin/sqlplus linux-gate.so.1 => (0xb771f000) libsqlplus.so => /u01/app/oracle/product/11/lib/libsqlplus.so (0xb766e000) libclntsh.so.11.1 => not found libnnz11.so => /u01/app/oracle/product/11/lib/libnnz11.so (0xb7415000) libdl.so.2 => /lib/libdl.so.2 (0x4c5dc000) libm.so.6 => /lib/libm.so.6 (0x4c616000) libpthread.so.0 => /lib/libpthread.so.0 (0x4c5e3000) libnsl.so.1 => /lib/libnsl.so.1 (0x4caef000) libc.so.6 => /lib/libc.so.6 (0x4c44a000) /lib/ld-linux.so.2 (0x4c424000) libclntsh.so.11.1 => not found * after chmod /u01/app/oracle/product/11/lib/libclntsh* * $ ldd /u01/app/oracle/product/11/bin/sqlplus linux-gate.so.1 => (0xb7831000) libsqlplus.so => /u01/app/oracle/product/11/li