I am not ablt to shutdown the database.
It gives me ORA-00106 error.
I am not very sure what to do.
There are no other sessions connected to the database.
When I look at the Alert log it has 2 more error messages.
ORA-1106 and ORA-1093.
Thanks in advance.
try to connect to internal again without using sql*net .. Just like connect internal/oracle;
shutdown immediate ;
It seems there is some other session active.
Shutdown immediate; if it does not work..
issue shutdown abort;
I tried Shutdown (Normal & Abort) through Server Manager connecting as user internal, but it gives me the error message:
ORA-00106: cannot startup/shutdown database when connected to a dispatcher
What should I do ? Please help.
I believe you are running MTS and you will need to establish a dedicated server connection for svrmgrl in order to perform a shutdown.
If the database is configured for MTS and a particular client requires a dedicated server, the client can be configured to use a dedicated server in one of the following ways:
A net service name can be configured with a connect descriptor that contains (SERVER=DEDICATED) in the CONNECT_DATA section. For example:
The client profile (sqlnet.ora file) can be configured with USE_DEDICATED_SERVER=ON. This adds (SERVER=DEDICATED) to the CONNECT_DATA section of the connect descriptors the client uses. For example:
I have used the sqlnet.ora parameter before and it works.