Preferred method to stop and start oracle listener in RAC enivronment: srvctl config listener -n nodename srvctl stop listener -n nodename srvctl start listener -n nodename
Read More srvctl start listener -n nodenameI used the steps below to apply patchset 11.2.0.3 to an existing 11.2.0.2 2-node RAC cluster on linux RHEL 5.8 64 bit. Note that GRID_HOME and DB_HOME locations will both be changed as part of this patchset. 0) Download and unzip software from My Oracle Support into e.g. /unzipped Main patch is 7 large zipfiles, […]
Read More Patch upgrade Oracle RAC 11.2.0.2 to 11.2.0.3 on linuxProblem: 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 David Yahalom for flagging this – it doesn’t appear to be covered in metalink/my oracle […]
Read More Intermittent ORA-12545 with oracle RAC database(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 that java applications have had for a long time – largely equalising performance differences with […]
Read More Database Resident Connection Poolinghttp://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
Read More RAC OCFS on 11gR2RAC 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 start database -d mydb
Read More Recover RAC databaseSwitch a RAC database into archivelog mode: srvctl stop database -d dbname startup mount –only one instance alter database archivelog alter database open srvctl start database -d dbname –this will start the remaining instances on the cluster And switch it into noarchivelog mode: srvctl stop database -d dbname startup mount –only one instance alter database […]
Read More RAC alter database archivelogUpdate 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 be used to identify what objects to drop prior to datapump, for reasons explained in […]
Read More Using 10g datapump and scheduler to copy schemas