SyntaxFix

[linux] sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

PERMISSIONS: I want to stress the importance of permissions for "sqlplus".

  1. For any "Other" UNIX user other than the Owner/Group to be able to run sqlplus and access an ORACLE database , read/execute permissions are required (rx) for these 4 directories :

    $ORACLE_HOME/bin , $ORACLE_HOME/lib, $ORACLE_HOME/oracore, $ORACLE_HOME/sqlplus

  2. Environment. Set those properly:

    A. ORACLE_HOME (example: ORACLE_HOME=/u01/app/oranpgm/product/12.1.0/PRMNRDEV/)

    B. LD_LIBRARY_PATH (example: ORACLE_HOME=/u01/app/oranpgm/product/12.1.0/PRMNRDEV/lib)

    C. ORACLE_SID

    D. PATH

     export PATH="$ORACLE_HOME/bin:$PATH"

Examples related to linux

• grep's at sign caught as whitespace • How to prevent Google Colab from disconnecting? • "E: Unable to locate package python-pip" on Ubuntu 18.04 • How to upgrade Python version to 3.7? • Install Qt on Ubuntu • Get first line of a shell command's output • Cannot connect to the Docker daemon at unix:/var/run/docker.sock. Is the docker daemon running? • Run bash command on jenkins pipeline • How to uninstall an older PHP version from centOS7 • How to update-alternatives to Python 3 without breaking apt?

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to installation

• You don't have write permissions for the /Library/Ruby/Gems/2.3.0 directory. (mac user) • Conda version pip install -r requirements.txt --target ./lib • How to avoid the "Windows Defender SmartScreen prevented an unrecognized app from starting warning" • PackagesNotFoundError: The following packages are not available from current channels: • Tensorflow import error: No module named 'tensorflow' • Downgrade npm to an older version • Create Setup/MSI installer in Visual Studio 2017 • how to install tensorflow on anaconda python 3.6 • Application Installation Failed in Android Studio • How to install pip for Python 3.6 on Ubuntu 16.10?

Examples related to sqlplus

• When or Why to use a "SET DEFINE OFF" in Oracle Database • SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA • sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory • How do I resolve this "ORA-01109: database not open" error? • How to echo text during SQL script execution in SQLPLUS • PL/SQL ORA-01422: exact fetch returns more than requested number of rows • how to pass variable from shell script to sqlplus • Connect to Oracle DB using sqlplus • sqlplus how to find details of the currently connected database session • How to output oracle sql result into a file in windows?

Examples related to oracleclient

• sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory • Error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater when installs setup • How to know installed Oracle Client is 32 bit or 64 bit? • Why do I get java.lang.AbstractMethodError when trying to load a blob in the db? • The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception • The provider is not compatible with the version of Oracle client