11G RAC Commands

11G RAC Commands

Description	Commands
SCAN STATUS Check config of scan	srvctl status scan srvctl config scan
Start Scan	$GRID_HOME/bin/srvctl start scan_listener
Relocate Scan	srvctl relocate scan -i 1 -n plwcdbuat01 -- (plwcdbuat01 is a new node name where u want to reallocate scan 1)
To list all the sub-modules	/u01/app/11.2.0/grid/bin/crsctl lsmodules crs /u01/app/11.2.0/grid/bin/crsctl lsmodules evm /u01/app/11.2.0/grid/bin/crsctl lsmodules css
Network issue	/u01/crs/oracle/product/11.2.0/crs/log/oraclebi2/agent/crsd/orarootagent_root
To check ocr file	ocrcheck
Grid Plug and play	cluvfy comp gpnp
nodes in the cluster	olsnodes -n -p -i
Start Cluster services on bi1	crsctl start cluster -n oraclebi1
Stop resource	crsctl stop resource ora.crsd
start resource	crsctl start resource ora.crsd crsctl start res ora.registry.acfs -n oracletest1
Stop diskgroups and ASM instance	srvctl stop diskgroup -g data srvctl stop diskgroup -g backup srvctl stop asm
To create a dependency between FRA diskgroup and a database.	$srvctl modify database -d <unique database_name> -a "DATA,FRA" $srvctl config database -d <unique database_name>
Add database	srvctl add database -d live -o $ORACLE_HOME srvctl add instance -d live -i live2 -n prod-rac02 srvctl enable database -d live srvctl enable instance -d live -i live2
srvctl help crsctl help	srvctl -h crvctl -h
Scan IP settings and Register Database	alter system set remote_listener='oraclei-scan.org.uk:1521' scope=both sid='*'; alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclei-vip)(PORT=1521))))' scope=both sid='ABC'; ALTER SYSTEM REGISTER;

hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh

jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj

ORA-00845 when AMM is configured

If you are installing Oracle 11g on a Linux system, note that Memory Size (SGA and PGA), which sets the initialization parameter MEMORY_TARGET or MEMORY_MAX_TARGET, cannot be greater than the shared memory filesystem (/dev/shm) on your operating system. To resolve the current error, increase the /dev/shm file size. For example: mount -t tmpfs shmfs -o size=7g /dev/shm Also, to make this change persistent across system restarts, add an entry in /etc/fstab similar to the following: shmfs /dev/shm tmpfs size=7g 0 2. This error may also occur if /dev/shm is not properly mounted. Make sure your df output is similar to the following: $ df -k Filesystem 1K-blocks Used Available Use% Mounted on ... shmfs 6291456 832356 5459100 14% /dev/shm 3. If configuring AMM is not possible due to lack of space on /dev/shm mount point, you can configure ASMM instead of AMM, i.e. set SGA_TARGET, SGA_MAX_SIZE and PGA_AGGREGATE_TARGET instead of MEMORY_TARGET.