Monday, December 9, 2019

SP2-1546

Error

SP2-1546: Invalid option(s) for Pluggable database.

Cause

STARTUP PLUGGABLE DATABASE command was executed from a PDB.

Resolution

1. Execute the command from the root container.
or
2. Run STARTUP with no parameters to start the current PDB.

Example:

Startup from CDB$ROOT


SYS@XE>startup pluggable database pdb1 ;
SP2-1546: Invalid option(s) for Pluggable database.
SYS@XE>alter session set container=cdb$root
  2  ;

Session altered.

Elapsed: 00:00:00.07
SYS@XE>startup pluggable database pdb1 ;
Pluggable Database opened.


Startup using the STARTUP command from PDB


SYS@XE>show con_name

CON_NAME
------------------------------
PDB1
SYS@XE>startup pluggable database pdb1;
SP2-1546: Invalid option(s) for Pluggable database.
SYS@XE>startup
Pluggable Database opened.
SYS@XE>

No comments:

Post a Comment