Oracle RAC – Startup and shutdown of database 12c srvctl commands:
Where cdbrac1 is the database name, and cdbrac11, and cdbrac12 are the instance names # old pre-12c syntax srvctl stop […]
Where cdbrac1 is the database name, and cdbrac11, and cdbrac12 are the instance names # old pre-12c syntax srvctl stop […]
alter system archive log current; # RAC all threads on all instances switch – single instance obviously forces only thread
to $ORACLE_HOME/dbs by default on UNIX / Linux platforms create pfile from spfile; create spfile from pfile; create pfile from
For new installs load SSH keys into Memory before starting DBCA – to establish ssh equivalence In an Oracle RAC
Three – maximum number of RAC IP addresses that can be resolved to the Single Client Access Name (SCAN)
Initialization parameter that stops / prohibits inter-node parallel execution of SQL statements if needed to reduce interconnect traffic? PARALLEL_FORCE_LOCAL=true Session
# first read the readme and if the patch is an on-line patch – you don’t have to worry about
The SID prefix is the first 8 characters of the database name, but it can only contain the characters a-z,
Exadata – Offloading / Smart Scan One of the major features of Exadata is the ability to offload processing to