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
The SID prefix is the first 8 characters of the database name, but it can only contain the characters a-z,
Oracle Support Direct NFS Doc IDs – 762374.1 and 1464567.1 MOS Doc ID 1464567.1: Collecting The Required Information For Support
Establish SSH equivalence for RAC – do this on both side from the unix user you are installing from –
By default when you create a pluggable database / pdb a “USERS” tablespace is created if you don’t specify a
How to Rename a Pluggable Database Oracle 12c How to rename a container (pluggable database). Step-By-Step 0.) Optional –
These 3 views can help see what is currently going on: V$MEMORY_DYNAMIC_COMPONENTS – Current status of all memory components V$MEMORY_RESIZE_OPS
select sid, serial#, username from v$session where sid in (select blocking_session from v$session); BTW – it is probably wise to