-
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.
-
try to connect to internal again without using sql*net .. Just like connect internal/oracle;
set ORACLE_SID=------
connect internal/oracle;
shutdown immediate ;
Raghu
-
It seems there is some other session active.
Shutdown immediate; if it does not work..
issue shutdown abort;
Thanks
Kishore Kumar
-
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.
-
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|