Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South
and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't
make it this year, check out TidalScale at www.tidalscale.com. Be
sure to click on the Solutions link and look through the Oracle resources.
Starting and stopping the 12c multi-tenant database means something very different from what starting and stopping a database 11gR2 or earlier. What is true in CDB$ROOT is not true in a PDB.
You will note a substanital change in this page from all library pages on this subject since the library was started.
Now the container name is critical to understanding what to expect and the word database is dropped as it is a term rendered essentially meaningless by the new architecture.
The startup demos assume that you have just rebooted the server and that no shell scripts have been written that automatically perform a startup function.
Startup commands executed in CDB$ROOT only affect CDB$ROOT whereas shutdown commands affect all PDBS. Startup and shutdown commands executed wthin a PDB only affect that single PDB. Here's why:
STARTUP consists of three separate operations:
NOMOUNT: Read the initialization file which provides information defining the instance (memory structures) and the location of the control files.
MOUNT: Read the control file which proves information on the location of tablespace data and temp files.
OPEN: Open the datafiles for access
OPEN RESTRICTED: Open the datafiles for access but limit connections to only those with RESTRICTED SESSION privileges
When you perform a STARTUP it reads the spfile, there is only one for the entire CDB and one of the control files, which are all identical and for which there is only one set for the entire CDB.
It then opens for access only those tablespaces and datafiles associated with CDB$ROOT and PDB$SEED.
This makes sense as you wouldn't want a situation where you had 20 PDBs, only 5 of which you actually were using, and they were all opened by default.
To open PDBs you must use the ALTER PLUGGABLE DATABASE syntax shown below.
SHUTDOWN also contains differences from what is "expected" behaviour.
If you are in CDB$ROOT and you issue a shutdown you shutdown everything: CDB$ROOT, PDB$SEED, and every PDB you have created: Makes sense because you only have on instance with memory structures.
But if you are logged into a PDB the rules are very different. A PDB is just a collection of files and has no memory structures so no matter what you do: SHUTDOWN, SHUTDOWN IMMEDIATE, SHUTDOWN ABORT
what you actually do is change the status of that one PDB, and only that one PDB, to MOUNT state.
SQL> alter system checkpoint;
SQL> shutdown abort;
SQL> startup restrict;
SQL> shutdown immediate;
Oracle Services On Windows
net start OracleService<SID>
c:\windows\system32 net start oracleserviceorabase
net stop OracleService<SID>
c:\windows\system32 net stop oracleserviceorabase
c:\windows\system32 net help helpmsg
The syntax of this command is:
NET HELPMSG message#
NET HELPMSG displays information about Windows network messages (such as error, warning, and alert messages).
When you type NET HELPMSG and the 4-digit number of the Windows error (for example, NET2182), Windows tells you about the message and suggests action you can take to solve a problem.
message# Is the 4-digit number of the Windows message you need help with. You don't need to type NET as part of the message number.