Multiple Homes and Instances Oracle Database Bash Profile

# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs export CATALINA_HOME=/home/oracle/apache-tomcat PATH=/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/bin/bash:$CATALINA_HOME/bin. export PATH EDITOR=vi export EDITOR=vi if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # … Continue reading Multiple Homes and Instances Oracle Database Bash Profile

Multiple Oracle Databases and Homes on Same Listener

On my test server I have got 2 ORACLE_HOMES 12cR1 (12.1.0.2) and 12cR2 (12.2.0.1) My listener.ora file on my server looks something like below SID_LIST_LISTENER_12CR2 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora12cr2) (ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1) (SID_NAME = ora12cr2) ) ) LISTENER_12CR2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.196)(PORT = … Continue reading Multiple Oracle Databases and Homes on Same Listener

Configuring Oracle Wallet for Multiple RAC Databases sharing same Oracle Home

1 ) Set the environment variable also via srvctl @ oracle user. export ORACLE_UNQNAME='$ORACLE_HOME/bin/srvctl config database |grep -w ${ORACLE_SID%?}' srvctl setenv database -d secdev -T "ORACLE_UNQNAME=secdev" 2) Create wallet directory on both nodes @ oracle user. mkdir -p /u01/app/oracle/WALLETS/secdev 3) Configure sqlnet.ora as follows on both nodes @ oracle user. If the databases share the … Continue reading Configuring Oracle Wallet for Multiple RAC Databases sharing same Oracle Home

Remove Whitespace Perl

Remove all whitespace from file perl -lape 's/\s+//sg' INPUT.TXT > OUTPUT.TXT Remove whitespace more than one space perl -wlpe '~ s/ +/ /g' INPUT.TXT > OUTPUT.TXT Remove whitespace more than one space and replace with '_' character perl -wlpe '~ s/ +/_/g' INPUT.TXT > OUTPUT.TXT

Multiple Standby Databases Dataguard Oracle

We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases.  The most important part is to consider the dataguard parameters, the rest is a normal dataguard creation. The important parameters are as below : db_file_name_convert log_archive_config log_archive_dest_1 log_archive_dest_2 log_archive_dest_3 LOG_ARCHIVE_DEST_STATE_1 LOG_ARCHIVE_DEST_STATE_2 LOG_ARCHIVE_DEST_STATE_3 log_file_name_convert remote_login_passwordfile STANDBY_FILE_MANAGEMENT fal_client fal_server … Continue reading Multiple Standby Databases Dataguard Oracle