| Closing the database [message #165227] |
Wed, 29 March 2006 00:23  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I connected to the database as SYS(no other users are accessing the database,currently it's the only connection made to the database) & tried to close the database,but it shows the following error,
SQL> alter database close;
alter database close
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
What i've to do to close the database?
Please anyone answer clear this doubt.
|
|
|
|
|
|
| Re: Closing the database [message #165258 is a reply to message #165227] |
Wed, 29 March 2006 01:45  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
hi,
to perform this action check v$session and make sure no other sessions are there except only one 'sys' user if it is there kill those session.and now you use the command
>alter database close
it will work..
|
|
|
|
| Re: Closing the database [message #165910 is a reply to message #165227] |
Mon, 03 April 2006 04:57 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
>sqlplus
>username: sys / as sysdba
>password: xxxx
sqlplus> shutdown immediate
or
sqlplus> shutdown abort
sqlplus> exit
>lsnrctl stop
you can not back up a database unless you can get it to shudown without the abort clause, I *think*.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
