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
ORA-00600:[kcbsor_2], [3], [2]
Recently we had a node crash of one node in 3-node 11.2.0.3 RAC database configuration.The alert log showed - Thu Apr 26 00:15:16 2012 Hex dump of (file 488, block 345039) in trace file /u01/oradiag/diag/rdbms/matrix_adc/matrix3/trace/matrix3_dbw1_16218.trc Corrupt block relative dba: 0x7a0543cf (file 488, block 345039) Bad header found during preparing block for write Data in bad … Continue reading ORA-00600:[kcbsor_2], [3], [2]
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
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
Learn. Share. Repeat. 