sqlplus: error while loading shared libraries tipsOracle Database Tips by Donald BurlesonApril 26, 2015Question: I tried to install Oracle but DBCA aborted. I then tried to open SQL*plus it showing this error:sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directoryHow do I fix this sqlplus: error while loading shared libraries error Answer: Your problem was that you did not carefully following the pre-install checklist. The installer will very rarely fail, if you follow the directions. Start by reviewing the installer logs and see why it aborted.
sqlplus or sqlplus64 tools are used to connect and manage Oracle Databases. sqlplus64 is 64 bit version of the sqlplus. After installating these tools successfully when we try to run sqlplus command we may get an shared object file or library error.
We can understand that shared library libsqlplus.so can not be found in the defined library path. Library path is stored in bash environment variable LD_LIBRARY_PATH . So first we will check this environment variable.
$ cd \\Oracle\\11.2\\database\\BIN$ dir /s /b oraclient11.dllC:\\Oracle\\11.2\\database\\BIN\\oraclient11.dll$ rem temporarily rename the Oracle RDBMS Client Library for testing$ ren oraclient11.dll oraclient11.dll.save$ rem this will raise error 57 since a required library could not be loaded during initialization$ sqlplus.exe /nologError 57 initializing SQL*PlusError loading message shared library$ rem be sure to change back!$ ren oraclient11.dll.save oraclient11.dll
Set the operating system shared library path environment variable to the directory from Step 1. For example, on Linux or UNIX, set LD_LIBRARY_PATH to instantclient_12_2. On Windows, set PATH to the instantclient_12_2 directory.
The process to regenerate the data shared library and the zip and RPM files changed in Oracle Database 12c Release 1 (12.1). Separate make file targets are used to create the data shared libraries, zip, and RPM files either individually or all at once. In previous releases, one target, ilibociei, was provided to build the data shared libraries, zip, and RPM files. Now ilibociei builds only the zip and RPM files. Regeneration of data shared libraries requires both a compiler and linker, which may not be available on all installations. The sections that follow show the make file target used to regenerate data shared libraries, zip, and RPM files.
The regenerated Instant Client binaries contain only the Instant Client files installed in the Oracle Client Administrator Home from which the regeneration is done. Therefore, error messages, character set encodings, and time zone files that are present in the regeneration environment are the only ones that are packaged in the data shared libraries. Error messages, character set encodings, and time zone files depend on which national languages were selected for the installation of the Oracle Client Administrator Home.
The ORACLE_HOME environment variable no longer determines the location of NLS, CORE, and error message files. An OCI-only application should not require ORACLE_HOME to be set. However, if it is set, it does not affect OCI. OCI always obtains its data from the Data Shared Library. If the Data Shared Library is not available, only then is ORACLE_HOME used and a full client installation is assumed. Though ORACLE_HOME is not required to be set, if it is set, then it must be set to a valid operating system path name that identifies a directory.
The Instant Client Light (English) version of Instant Client further reduces the disk space requirements of the client installation. The size of the library has been reduced by removing error message files for languages other than English and leaving only a few supported character set definitions out of around 250.
This Instant Client Light version is geared toward applications that use either US7ASCII, WE8DEC, WE8ISO8859P1, WE8MSWIN1252, or a Unicode character set. There is no restriction on the LANGUAGE and the TERRITORY fields of the NLS_LANG setting, so the Instant Client Light operates with any language and territory settings. Because only English error messages are provided with the Instant Client Light, error messages generated on the client side, such as Net connection errors, are always reported in English, even if NLS_LANG is set to a language other than AMERICAN. Error messages generated by the database side, such as syntax errors in SQL statements, are in the selected language provided the appropriate translated message files are installed in the Oracle home of the database instance.
While executing a SQL query to access an ST_Geometry function against an Oracle 10g database with an ArcGIS geodatabase at 10.1 Service Pack 1 Quality Improvement Patch and later, running on a Linux/UNIX operating system, the following error is returned:SQL> select sde.st_point(0,0,0) from dual; select sde.st_point(0,0,0) from dual * ERROR at line 1: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extproc: fatal: libclntsh.so.11.1: open failed: No such file or directory ORA-06512: at \"SDE.ST_GEOMETRY_SHAPELIB_PKG\", line 12 ORA-06512: at \"SDE.ST_POINT\", line 176This issue is resolved with the Oracle-specific shape library included in the ArcGIS 10.2.1 Utility Patch 2 and at ArcGIS 10.3.
The ST_Geometry library files for ArcGIS 10.1 Service Pack 1 Quality Improvement Patch and later do not support the Oracle 10g library for Linux/UNIX operating systems. This is due to particular builds of the ST_Geometry library file expecting the Oracle 11g client library (libclntsh.so.11.1).The ldd command, to list dynamic dependencies of executable files or shared objects, can be used to check the expected client library file as shown below:MyOracleHost% cd $SDEHOME/libMyOracleHost% ldd libst_shapelib.so libclntsh.so.11.1 => (file not found) libCrun.so.1 => /usr/lib/64/libCrun.so.1 libc.so.1 => /lib/64/libc.so.1 libm.so.2 => /lib/64/libm.so.2 /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2 /platform/SUNW,SPARC-Enterprise/lib/sparcv9/libc_psr.so.1
The problem is related to library loading libnsl.so.1, I tried to found it on my machine (with a find command), all was ok , the library seems to be here.Then when retrying to install, still encountering this issue after many attempts, so I made an update of the library:
The GoldenGate (188.8.131.52.X) installation on the source was successful, however, on the target side after I unzipped the GoldenGate binaries and executed ggsci I received the nasty error message below:
Problem Symptoms:* error message in the PC and WWW server logs. (See below.) * unable to execute s+ to any library; it says \"permission\" denied* util o/3/1 does not show the log./exlibris/aleph/a20_1/aleph/exe/www_server_main: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory.* The aleph_startup log shows that each of the servers failed with a message like this:starting ncip_server.../exlibris/aleph/a20_1/aleph/exe/rts32: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directoryAnd, starting library batch queues.../exlibris/aleph/a20_1/aleph/exe/rts32: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directorystarting library update doc daemon.../exlibris/aleph/a20_1/aleph/exe/rts32: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory... Likewise, the other daemons.Cause:permissions in /exlibris/app/oracle/product/dbaResolution:1. Change permissions in /exlibris/app/oracle/product/dba2. Run aleph_shutdown3. Run aleph_startup
sqlplus Shared Library Error. sqlplus command shared library error full definition is like below. Keep in mind that for 64 bit version it will be sqlplus64. sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory. sqlplus Shared Library Error.
Error loading message shared library The reason for this error is your machine being out of memory. The OS is trying to assaign memory to start sqlplus process and there is not enough memory to do that . Try to close some memory intensive applications and retry sqlplus and if there is enough memory this time, it will connect.
Uploading from the data file /d01/r12/apps/apps_st/appl/bom/12.0.0/patch/115/import/US/bomprg.ldtAltering database NLS_LANGUAGE environment to AMERICANDumping from LCT/LDT files (/d01/r12/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2), /d01/r12/apps/apps_st/appl/bom/12.0.0/patch/115/import/US/bomprg.ldt) to staging tablesDumping LCT file /d01/r12/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2) into FND_SEED_STAGE_CONFIGDumping LDT file /d01/r12/apps/apps_st/appl/bom/12.0.0/patch/115/import/US/bomprg.ldt into FND_SEED_STAGE_ENTITYA database error occurred:ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
I haven't tried to replace it with printf or echo because it already worked on makepkg without any change, but I agree that it looks like a bug in yay (the error message looks like it's mixing something, perhaps yay itself overrides the pĺain routine). 153554b96e