From: "Nick" Newsgroups: comp.databases.oracle.server,comp.databases.oracle Subject: Restarting Oracle after shutting down UNIX without shutting down Oracle first Lines: 35 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: Date: Wed, 8 Aug 2001 13:53:46 +0100 NNTP-Posting-Host: 212.56.93.106 X-Complaints-To: abuse@plus.net.uk X-Trace: wards 997275727 212.56.93.106 (Wed, 08 Aug 2001 14:02:07 BST) NNTP-Posting-Date: Wed, 08 Aug 2001 14:02:07 BST Organization: Customer of PlusNet Hello I have been given the task of getting an Oracle database started after the UNIX server was shutdown without shutting down Oracle first. I have no DBA experience with Oracle at all, and come from an MS background so all this is new to me. Anyway, the documentation suggests that I do the following: sqlplus /nolog connect username/password as sysdba STARTUP database_name However, I always get an error when using the connect command to connect as sysdba. The error is ORA-01031L insufficient privileges. I have used the sys username and password that I have been given and still get this error. In fact I get the same error even if I put in a junk username/password that does not exist. I know this could suggest that the sys password may be incorrect, however I am told that it is correct, and since it does not tell me that the password is incorrect, it may be that I need to choose some other kind of username rather than sys for example. Please can anyone help me get going on this? I am basically trying to get Oracle up and running as it was before the server was shutdown, so any assistance will be greatly appreciated. Thank you Nick