I increased the number of processes in the init.ora and wanted to restart the database. At command prompt gave sqlplus
then connected as system/manager@oracle1 as sysdba
and issued shutdown immediate
didnot get any response.then says instance terminated.
when i came out of sqlplus.
could not connect again........
1. Shutdown can be given only from svrmgrl (m) prompt.
2. you may have a tns problem (not a database one)
3. however you can go back (with the parameter you changed)
I tried from svrmgrl as well.
Since its ora8i, oracle recommends that we start using sqlplus.
Problem is solved now.
I restarted the server and shutdown and startup thru svrmgr.
svrmgr is the best way of doing these operations but oracle is changing everything.
Any way thanks a lot.
Bookmarks