fix backspace in corn shell

export TERM=vt220
stty erase ^?

How to cleanup the FGA log table?

SQL> truncate table fga_log$;

SQL> delete from fga_log$ where timestamp# < sysdate-14;

How to Determine The Lock Type and Mode from an Enqueue Wait

Doc ID: Note:413934.1

WAIT #1: nam='enqueue' ela= 3007866 p1=1414332419 p2=30152 p3=0

The P1 value is 1414332419 which in hex is 544D0003, the first four digits are: 54 and 4D.
54 hex = "T" in ASCII
4D hex = "M" in ASCII
So, this is a "TM" lock type.

The last digit is the lock mode that is being requested. The modes are:

• 0 - none
• 1 - null (NULL)
• 2 - row-S (SS)
• 3 - row-X (SX)
• 4 - share (S)
• 5 - S/Row-X (SSX)
• 6 - exclusive (X)

library cache pins/locks

Note:169139.1 - on investigating library cache pin/locks situations

Oracle Clusterware installation fails on Linux

when running root.sh, the following error is returned:

Failed to upgrade Oracle Cluster Registry configuration

Solution:

Note:465001.1
If using any form of multipathing (EMC PowerPath, MPIO, device-mapper-multipath, etc.) to access Clusterware devices, be sure to obtain and apply Oracle 10.2.0 CRS patch for Bug 4679769 when installing the Oracle Clusterware (Step 5).


After applying the patch, installation was successful.

configure ssh for rac installation

1. create the keys

/usr/bin/ssh-keygen -t dsa
/usr/bin/ssh-keygen -t rsa

2. copy the public keys into authorized_keys

3. run
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add

CLUVFY

to run the prerequisites check for oracle clusterware, download the latest cluvfy.

1. unzip into /home/oracle/cvu
2. setup the environment

export CV_HOME=/home/oracle/cvu
export CV_JDKHOME=/home/oracle/cvu/jdk/jre

3. run

./cluvfy stage -pre crsinst -n hostname -orainv dba -r 10gR2

(don't forget to specify the -r version)

TAR + gzip + remove files

tar --remove-files -czf datafiles.tar.gz *

LIST BACKUP

to list backups taken at a certain point in time:

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.

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

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;