Build High Availability Network
What is Oracle Autonomous Database Self-driving: Automate database provisioning, tuning, and scaling Self-securing: Automate data protection and security Self-repairing: Automate failure detection, failover, and repair Simple just connect, create table and use. With Autonomous DB all DBa tasks will be Read More
Download and unzip instanceclient packages unzip instantclient-tools-linux-19.6.0.0.0dbru.zipunzip instantclient-basiclite-linux-19.6.0.0.0dbru.zipunzip instantclient-odbc-linux-19.6.0.0.0dbru.zipunzip instantclient-odbc-linux-19.6.0.0.0dbru.zipunzip instantclient-sqlplus-linux-19.6.0.0.0dbru.zipunzip instantclient-tools-linux-19.6.0.0.0dbru.zip Update profile.d/custom.sh 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
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 11.2.0.3.15 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /export/home/oracle/app/11gr2 Central Read More