Oracle DB

Setup sqlplus for AWD

Download and unzip instanceclient packages unzip instantclient-tools-linux- instantclient-basiclite-linux- instantclient-odbc-linux- instantclient-odbc-linux- instantclient-sqlplus-linux- Update profile.d/ file for profile TNS_ADMIN=/usr/lib/oracle/19.6/client/walletORACLE_HOME=/usr/lib/oracle/19.6/client/export TNS_ADMIN ORACLE_HOMEexport LD_LIBRARY_PATH=”$ORACLE_HOME”PATH=$PATH:${ORACLE_HOME}/binexport PATH Download wallet, unzip it and store in secure location . add priviledge only for user who will need Read More

Find oracle patch version

Easy way to find patch version is use opatch application Example: $ORACLE_HOME/OPatch/opatch lsinventory example of output /export/home/oracle> [oracle@atlantisoracle ~]$ opatch lsinventory Oracle Interim Patch Installer version Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /export/home/oracle/app/11gr2 Central Read More