Oracle

IMPORTANT NOTE: The pages on this site assume that all steps documented are performed (unless specifically marked as optional). Other pages assume that the configuration from predecessor pages is in place. E.g. the page on the Oracle Listener assumes that the LISTENER_NAME environment variable is set in the .profile as documented on the Oracle Install page and the Data Guard documentation assumes that LOCAL_LISTENER has been set as recommended.

Check


SELECT name,

       open_mode,

       restricted

  FROM v$PDBS;

Startup


STARTUP

STARTUP NOMOUNT

STARTUP MOUNT

STARTUP RESTRICT

STARTUP UPGRADE

Startup a single PDB ...

assumes CDB is running and PDB is in MOUNT state

ALTER PLUGGABLE DATABASE mypdb OPEN;

ALTER PLUGGABLE DATABASE mypdb OPEN RESTRICTED;

ALTER PLUGGABLE DATABASE mypdb OPEN FORCE;

ALTER PLUGGABLE DATABASE mypdb OPEN UPGRADE;

Shutdown


SHUTDOWN NORMAL

SHUTDOWN IMMEDIATE

SHUTDOWN ABORT

These commands shutdown the instance. For multi-tenant this means the CDB and all PDBs.

Shutdown a single PDB...

ALTER SESSION SET CONTAINER=mypdb;

SHUTDOWN IMMEDIATE

or one of these...

ALTER PLUGGABLE DATABASE mypdb CLOSE;

ALTER PLUGGABLE DATABASE mypdb CLOSE IMMEDIATE;

mypdb will stay in mount status

Configuration Information Script

A script that pulls out useful configuration information about your database instance...

Bibliography