Wednesday, January 30, 2008

How To List All The Named Events Set For A Database

Metalink

SQL> oradebug setmypid //This will set the current session's pid.

SQL> oradebug dump events 1 //This will dump the events information in the tracefile based on the level

SQL> oradebug tracefile_name //This will return the trace file generated for this event.

Friday, January 25, 2008

ASM and Clulster Manager (CSSD)

One interesting thing, which oracle installation docs keep in secret is Cluster Manager service, which is needed to run ASM instance.

in 10.1 it is installed by default (in 10.2 it is installed along with ASM instance creation, I believe)

How do you setup / remove / modify Cluster Synchronization Services Daemon (CSSD) ?

to uninstall: $ORACLE_HOME/bin/localconfig delete
to install: $ORACLE_HOME/bin/localconfig add

to start: /etc/init.d/init.cssd start
to stop: /etc/init.d/init.cssd stop

Monday, January 21, 2008

CONTROL_FILES

control_files parameter is a list of comma-separated strings! it's not a single string of comma-separated values, which would be more logical to my mind...

to change the control_files parameter:
alter system set control_files="/path/control01.ctl", "/path/control02.ctl", "/path/control03.ctl" scope=spfile;