Shutdown Database

[s_radhak]

Hi,

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.

Please Help.

Thanks in advance.

Regards,
Radha.

[raghud]

try to connect to internal again without using sql*net .. Just like connect internal/oracle;

set ORACLE_SID=------
connect internal/oracle;
shutdown immediate ;

[Kishore]

It seems there is some other session active.

Shutdown immediate; if it does not work..

issue shutdown abort;

[s_radhak]

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.

Thank you.

[s_radhak]

Any Suggestions??

[yanert98]

I believe you are running MTS and you will need to establish a dedicated server connection for svrmgrl in order to perform a shutdown.

Try this:

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:

sales=
(description=
(address=(protocol=tcp)(host=sales-server)(port= 1521))
(connect_data=
(service_name=sales.us.acme.com)
(server=dedicated)))



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:

use_dedicated_server=on


I have used the sqlnet.ora parameter before and it works.
Good luck.

[s_radhak]

Thank you yanert98