ORA-17629 ORA-20079

Yesterday I received page for " ORA-17629: Cannot connect to the remote database server"  reported in Primary Database alert log. Fri Apr 10 06:47:41 2015 Errors in file /oracle/app/diag/rdbms/testdb/testdb/trace/testdb_ora_161991.trc: ORA-17627: ORA-17629: Cannot connect to the remote database server Errors in file /oracle/app/diag/rdbms/testdb/testdb/trace/testdb_ora_161991.trc: ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-17629: Cannot connect to … Continue reading ORA-17629 ORA-20079

set newname command made easier in 11gR2

From 11gR2 oracle introduced new options for "SET NEWNAME" command. 1.SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE 2.SET NEWNAME FOR TABLESPACE 3.SET NEWNAME FOR DATABASE The following variables are introduced for SET NEWNAME from 11gR2 :- %b The file name remains same as the original. For example, if a datafile is named D:\oracle\oradata\matrix\test.dbf, … Continue reading set newname command made easier in 11gR2

Duplicating Database without connecting to Target – 11gR2

From 11gR2, you can duplicate the database without connecting to the target database or recovery catalog which is termed as "Backup-Based Duplication Without a Target and a Recovery Catalog Connection". http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV435 OS - Windows Duplicate Database - ORCL Target Database - MATRIX 1. Backup the target database D:\scripts>rman target / Recovery Manager: Release 11.2.0.2.0 - … Continue reading Duplicating Database without connecting to Target – 11gR2

Shell Script for RMAN Backup

Few days back  i devoted my time in creating a shell script to take RMAN backup for a 2-node RAC database on Sun Solaris.Both the datafiles and the archive logfiles(for both the instances) are on a shared SAN box. Below is the script :- ORACLE_HOME=/projects/product/10.2.0/db_1 export ORACLE_HOME ORACLE_SID=test1 export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin export PATH set -x … Continue reading Shell Script for RMAN Backup