| ora01093 [message #55228] |
Sun, 12 January 2003 21:24  |
Gaurav
Messages: 20
Registered: February 2002
|
Junior Member |
|
|
I have personal oracle installed on my home PC.
I was trying to shutdown my database using shutdown normal option but it gave me an error ORA-01093
ie ALTER DATABASE CLOSE only permitted with no sessions connected
SQL> shutdown normal
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
i viewed the seesions from the v$session view and got the following output.
SQL> select sid,serial#,program,username from v$session;
SID SERIAL# PROGRAM
----- --------- -------------------------------------
1 1 ORACLE.EXE
2 1 ORACLE.EXE
3 1 ORACLE.EXE
4 1 ORACLE.EXE
5 1 ORACLE.EXE
6 1 ORACLE.EXE
7 141
8 141
11 9 SQLPLUSW.EXE
9 rows selected.
i can't kill the sessions because they are not user sessions.
Questions -
1) I have opened just an sqlplus session. What are these other sessions?
2) can i get rid of them or are they some system sessions?
3) how can i shutdown my database?
any help will be appreciated.
|
|
|
|
| Re: ora01093 [message #55233 is a reply to message #55228] |
Mon, 13 January 2003 06:24  |
Remi Visser
Messages: 44
Registered: December 2002
|
Member |
|
|
Hi
1
select type, sid, serial# from v$session
Will show if session is background or user session.
2
Just try (if background process then oracle will not allow to kill them)
3
use shutdown immediate
+ disconnects all sessions
+ rollsback outstanding transactions
+ requires no recovery
Good Luck
remi http://askremi.ora-0000.com/
|
|
|
|
| Re: ora01093 [message #55244 is a reply to message #55228] |
Mon, 13 January 2003 11:25 |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
i generally get this error message when i am not connected AS SYSDBA/AS SYSOPER.
sqlplus /nolog
SQL> connect sys as sysdba or connect / as sysdba
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
