Category Archives: RAC

Intermittent ORA-12545 with oracle RAC database

Problem: Client suffers intermittent ORA-12545 “Connect failed because target host or object does not exist” trying to connect to oracle RAC database. Solution: Edit server side (not client side) listener.ora and tnsnames.ora files to have fully qualified hostnames. Thanks to … Continue reading

Posted in RAC, SQL*Net | Leave a comment

Database Resident Connection Pooling

(Update: Firewalls can prevent DRCP functioning correctly – details at end of this post) Database Resident Connection Pooling is new with 11g, and should be used for PHP applications. It will allow them to use the same type of connection pooling … Continue reading

Posted in RAC, SQL*Net | Leave a comment

RAC OCFS on 11gR2

http://learnwithme11g.wordpress.com/2010/03/19/11gr2-rac-shared-storage-preparationocfs-part2/ Also very good is http://www.oracledba.org/index.html /etc/init.d/o2cb enable (on both nodes) mkfs.ocfs2 -L “RAC8LUN” /dev/mapper/RAC8LUN1p1 mkfs.ocfs2 -L “RAC8Q” /dev/mapper/RAC8Qp1 vi /etc/fstab mkdir /CRS_DATA mkdir /ORA_DATA mount /dev/mapper/RAC8LUN1p1 mount /dev/mapper/RAC8Qp1        

Posted in RAC | Leave a comment

Recover RAC database

RAC has to be switched to non-cluster temporarily for the recovery. startup nomount alter system set cluster_database=false scope=spfile sid=’*’ ; shutdown immediate startup mount recover database alter database open ; alter system set cluster_database=true scope=spfile sid=’*’ ; shutdown immediate srvctl … Continue reading

Posted in RAC | Leave a comment

RAC alter database archivelog

Switch a RAC database into archivelog mode: alter system set log_archive_dest_1=’location=/ORA_DISK/redoarch/arch_’ scope=both sid=’*’ ; alter system set cluster_database=false scope=spfile sid=’mydb1′; srvctl stop database -d mydb startup mount alter database archivelog ; alter system set cluster_database=true scope=spfile sid=’mydb1′; shutdown immediate srvctl … Continue reading

Posted in RAC, Rman | Leave a comment

Using 10g datapump and scheduler to copy schemas

Update 13-Feb-07: Setting the datapump table_exists_action to replace does not overwrite views, sequences, plsql objects. They have to be dropped separately before datapump is called, see gotchas and code below. Update 02-Mar-07: dba_ views rather than all_ views have to … Continue reading

Posted in RAC, Scripts | 7 Comments