ORA-01033: ORACLE initialization or shutdown in progress

[du_rodrigues]

Personal, I do not know much of Oracle, I am using a Windows 2003 Server and Oracle 10G but I could analyze that the server problem is that it is not locating one of its database, when initializes only the listener is active and the following error occurs "Agent connection with the instance" status failed, details: ORA-01033: Oracle Initialization or Shutdown in Progress (DBD Error: OcisessionBegin.
But it happens that there is no backup of this database I would like to know how I can Do Oracle initialize again, and the file you are looking for should have been deleted?

Thank you for the help

[Fabão]

Hello friend, I'm not an expert in Oracle (yet), but no backup, it's hard to think about data recovery. What I would do in your case, would check the bank's Alert and try to get which file is corrupted and starting from this point to draw an alternative strategy to recover the base !!

[du_rodrigues]

Thank you very much for the help, but it happens that I already know the base that is corrupted, I do not need the backup I need to just know how that I raise the database service again only this

[Fabão]

If you connect to the bank as SYSDBA, run the Startup command. But it should not work because there are corrupted files !! Good luck!

[gilbertoca]

"Agent connection with the instance" Status failed, details: ORA-01033: Oracle Initialization or Shutdown in Progress (DBD Error: OcisessionBegin.



This msg is very clear! Probably someone tried to make a shutdown on the bench and took a lot, alias still continues.

Select all

 
gilberto@ti-des05:~> oerr ORA 01033 
01033, 00000, "ORACLE initialization or shutdown in progress" 
// *Cause: An attempt was made to log on while Oracle is being started up 
//         or shutdown. 
// *Action: Wait a few minutes. Then retry the operation. 
gilberto@ti-des05:~>      

Check the Active processes!

Gilberto

[felipemartinsss]

Does anyone know the solution to this problem?

Here, the Windows related service is normal.
But no one can connect.
When I try Startup Open he can not open, if I try to close, it closes. When entering the browser, I see that the instance is stopped as the agent. Listener is OK.

The problem seems to have been when I do the import of a very large file and that was interrupted during the process. Is there a way to return the state of the bank so far before this import operation?

The environment is: Windows Server 2003 and Oracle 10g 10.2.0.

Thanks!

[gilbertoca]

Does anyone know the solution to this problem?

Here, the Windows related service is normal.
But no one can connect.
When I try Startup Open he can not open, if I try to close, it closes.

Can you close it? I did not understand?

Logo by SQLPlus and try a sudden stop: Abort.

Select all

 
SQL> connect / as sysdba 
Connected. 
SQL> shutdown abort 
Instance ORACLE .. 
SQL> startup nomount 
Instance ORACLE .. 
SQL> alter database mount; 
SQL> alter database open; 

Caution: Use this as a last resort.

Gilberto

[diegoleite]

Friend because it is ruwindows .. try to serve and restart Oracle's services. If the listener servic does not start Check the host (IP or machine name) inside the listener.ora ...

How is the space on disk ??

SET ORACLE_SID = Instance name

SQLPLus "/ SYSDBA"

Startup Mount;
Mount you try to open it and see the exact error message

Alter Database Open;

[diegoleite]

Responding to the creature of the topic.

As our friend Gilberto posted ....

Shutdown Immediate;
Seine solve

Shutdown Abort;


For they probably gave a shutdow (simple);

[LoadingXp]

I'vê had problems in Windows environments.

Perform the activity below:

1 - Enter Services (Services) and see if the service is running (Runing)
2- Verify security auditing if the user who opens the Oracle on your machine is set to run lots jobs
Administrative Tools> Local Security Settings> Local Policies> User Rights Assignment> Logon Batch Job
See if the user is there. If you are not adding and restarting the server
3 - set in your environment which will call the SQL * plus to variable oracle_sid
4- Issue the echo% oracle_sid% command to see if it is set correctly .
5- Enter SQL * Plus (in the same session), with the command

Select all

sqlplus /nolog 
conn / as sysdba 
startup force; 

Ok ...? Send me then what rolled ..

Hugs.