Category Archives: RAC

Intermittent ORA-12545 with oracle RAC database

Posted on 9 May 2011 by Andrew Fraser

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

Posted on 23 April 2011 by Andrew Fraser

(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

Posted on 11 November 2010 by Andrew Fraser

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

Posted on 29 October 2010 by Andrew Fraser

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

Posted on 28 October 2010 by Andrew Fraser

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

Posted on 1 February 2007 by Andrew Fraser

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