Home » Infrastructure » Windows » SQL Plus Login Error
SQL Plus Login Error [message #281764] Mon, 19 November 2007 04:55 Go to next message
krapvag
Messages: 3
Registered: November 2007
Junior Member
Hi,

We have a problem where attempting to connect to an Oracle database we get the error message:

ORA-01033: ORACLE initialization or shutdown in progress



I've tried the following solution

1- SQL> shutdown abort
O/P- ORACLE instance shut down.



2- SQL> start database step by step
O/P- SP2-0310: unable to open file "database.sql"



3- SQL> startup nomount
ORACLE instance started.



But everytime I attempt to login to SQLPlus I get the 01033 error message, and no login takes place


Any ideas?????
Re: SQL Plus Login Error [message #281770 is a reply to message #281764] Mon, 19 November 2007 05:06 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

startup nomount does not open database. invoke just
startup;

and then perform operation.
Re: SQL Plus Login Error [message #281771 is a reply to message #281764] Mon, 19 November 2007 05:06 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
ARe you on windows or linux?
If on windows,go to task manager and kill the oracle process amd then try to start the instance.
If on linux, type ps -a and kill all tthe oracle processes and then try.
Re: SQL Plus Login Error [message #281772 is a reply to message #281764] Mon, 19 November 2007 05:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

And about
Quote:

start database


Do you know actually what is the purpose of "start" command in SQL*PLUS?
Re: SQL Plus Login Error [message #281775 is a reply to message #281764] Mon, 19 November 2007 05:12 Go to previous messageGo to next message
krapvag
Messages: 3
Registered: November 2007
Junior Member
Yeah, there's a bit missing after the startup nomount command, but what I meant to say is that I cannot get past the login to run that

which service do I stop in the task manager? The problem is I know nothing about Oracle (dba is on holiday!!) so any help is greatfully received


Thanks
Re: SQL Plus Login Error [message #281776 is a reply to message #281764] Mon, 19 November 2007 05:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Copy and paste the screen messages about what you did and what come in your screen..
Re: SQL Plus Login Error [message #281778 is a reply to message #281764] Mon, 19 November 2007 05:18 Go to previous messageGo to next message
krapvag
Messages: 3
Registered: November 2007
Junior Member
c:\sqlplus /nolog
SQL> connect sys as sysdba
enter password:

ERROR: 01033 Oracle initialization or shutdown in progress

Re: SQL Plus Login Error [message #281780 is a reply to message #281764] Mon, 19 November 2007 05:19 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Click on the process option,search for oracle.exe and kill it.
After that start your instance, from the command prompt type
net start "yourservicename"
and then log in sqlplus
Re: SQL Plus Login Error [message #281812 is a reply to message #281778] Mon, 19 November 2007 06:44 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

go to services.msc window and stop oracle services and again start.

start --- > run --- > services.msc <<hit enter>>
then connect with sys user to sqlplus and startup your database.

Regards
Mohammed Taj
Previous Topic: Upgrade 10.2.0.2 to 10.2.0.3
Next Topic: Unattended install client 9i asks for MTS portnumber
Goto Forum:
  


Current Time: Thu Mar 28 17:13:48 CDT 2024