DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, October 2, 2017

ORA-00106: cannot startup/shutdown database when connected to a dispatcher

We have two solution for this.

1. Connect locally that is without service name.
set ORACLE_SID=<your sid>
set ORACLE_HOME=...
sqlplus "/ as sysdba"
or sqlplus "sys as sysdba"

2. Define an entry in the tnsnames.ora with (SERVER=DEDICATED) in the CONNECT_DATA section and connect using this name.

No comments: