Skip to content

Instantly share code, notes, and snippets.

@redknitin
Created October 5, 2015 06:32
Show Gist options
  • Select an option

  • Save redknitin/b1335a23928ae0bea65e to your computer and use it in GitHub Desktop.

Select an option

Save redknitin/b1335a23928ae0bea65e to your computer and use it in GitHub Desktop.
Oracle 12c commands
Oracle 12c commands
To open pluggable databases:
ALTER PLUGGABLE DATABASE ALL OPEN;
(sometimes the pluggable database says that it is in an initializing state and requires this to be run from the container database)
To get the port for the enterprise manager (usually the port is 5500 and the URL us http://localhost:5500/em ):
select dbms_xdb_config.gethttpsport() from dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment