I'm having a heck of a time figuring this one out.
I have Oracle8i Personal Ed. installed on NT 4.0 sp 6
I'm using SQL * Plus, and all I want to do is shut down the database..but it's not working right.
Here's the problem:
If I try to connect a user I get this error:
ORA-10190: shutdown in Progress - connection is not permitted
OK...so I do this:
Connect internal (I thought that anyone that was connected as sysdba would be able to shutdown the DB, but it keeps saying insufficient privs...even when i do connect sys as sysdba...any thoughts? am i wrong on my thought?)
shutdown abort
ORACLE Instance shut down
(If I shut down immediate, transactional, or normal I get the error: ORA-10190: shutdown in Progress - connection is not permitted)
NOW I do:
Startup - it starts
shutdown immediate - SQL*Plus hangs up....do a three finger salute...and see that SQL*Plus is Not Responding
I end task.
Ok...so now I reopen sql*plus
and again the only thing I can do is shutdown abort. I looked at the trace and alert files and the only error that I see is it's waiting for logins to complete. Ok..so WHO is logged in and HOW do i get them off? I'm the ONLY person who has access to this database (it's a practice DB in a practice environment...I'm studying for my third test...Backup and Recovery)...anyway...
I've done a shutdown abort, and startup then checked out v$session, and I've tried to kill sessions that were listed there, but they all said they were not user sessions.
SOOOO...
What am I missing here? I have been working on this problem for way to long...if I was a real DBA I think I'd be fired by now. Luckly I'm still learning and I'm in a practice environment!!
Any help would be EXTREMELY helpful.
Thanks!