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