Where cdbrac1 is the database name, and cdbrac11, and cdbrac12 are the instance names # old pre-12c syntax srvctl stop database -d cdbrac1 -o immediate # new 12c syntax srvctl stop database -db cdbrac1 -stopoption immediate # new 12c syntax status of instance and db srvctl status database -db cdbrac1 # old pre-12c normal start …
Oracle RAC – Startup and shutdown of database 12c srvctl commands: Read More »
alter system archive log current; # RAC all threads on all instances switch – single instance obviously forces only thread that exists
to $ORACLE_HOME/dbs by default on UNIX / Linux platforms create pfile from spfile; create spfile from pfile; create pfile from memory; create spfile from memory; create pfile=’/u01/app/oracle/product/12.2.0.1/db_1/initPROD.bak’ from memory;
For new installs load SSH keys into Memory before starting DBCA – to establish ssh equivalence In an Oracle RAC environment, you must load SSH keys into memory for the terminal session where you start DBCA. If you do not do this, then you receive user equivalency errors when you attempt to start DBCA. If …
Oracle RAC – For New Installs Load SSH Keys Into Memory Before Starting DBCA Read More »
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 or System modifiable. New parameter as of 11gR2. Defaults to false.
ocrconfig -showbackup auto
# first read the readme and if the patch is an on-line patch – you don’t have to worry about the rest of this blog – online patches don’t require any outage at all – there will also be a “online” sub dir in the unzipped patch # now for the vast majority of patches …
The SID prefix is the first 8 characters of the database name, but it can only contain the characters a-z, A-Z, and 0-9. Special characters are omitted. For a RAC database, the instance number format is generated differently for a policy-managed instance than for an admin-managed instance. For policy-managed database instances, the format is name_# …
Oracle RAC derived instance names for policy and admin managed instances Read More »
Exadata – Offloading / Smart Scan One of the major features of Exadata is the ability to offload processing to a CellServer also referred to as Smart Scan. Generally offloading/SmartScan is accomplished with three sub-features: Column Projection – filtering out on the cell server side only the columns that are specified in the SQL statement. …