ORA-01033 error

[tom]

Well, one day I installed Oracle 9i on my machine, and at first everything was going well. Only one day I scanned the machine had stayed half 'heavy' and I decided to disable all Oracle's processes that started when it just carried it. Now, even after you have turned these processes for automatic, when I try to connect via SQL-Plus me the error is returned:

Select all

ORA-01033: ORACLE initialization or shutdown in progress

The system is Win XP Professional.

grateful for any help ...

[dr_gori]

This happens here tb when the server is restarted. It takes a few minutes until Oracle "rise" ... but then connects a good one.

Have you tried to run all the services manually to see if you connect?

[tom]

Hello Friend! Thank you for the answer. I made several attempts, but I think it's worth a try again a little more systematically, then. Look, there's a detail that is making me curious. Here at work we have 8i, and I know when the bank falls, we have to start it with the following commands:
svrmgrl -> Connect Internal -> Startup.

It was one of the first things I tried to do on my machine (where I am having the problem), but the DOS is not recognizing the SVRMGRL as a valid command.

When I installed Oracle, I followed only the steps of the default installation (Next, Next and Finish), after that I did not move in anything else - out the stroke of having taken the automatic initialization of the processes - Did something miss?

[dr_gori]

In my house, with Windows XP Pro, I have installed Oracle 817.
I created a script to start the bank that performs the following commands:

Select all

net start oracleorathomastnslistener 
net start oracleserviceTFG

Just running these 2 services, the bank is standing !!!
(ie the Listener and Oracle himself)

What services are you running there?

[tom]

Here's the list that appears to me in Msconfig:

Select all

- OracleMTSRecoveryService 
- OracleOraHome92Agent 
- OracleOraHome92ClientCache 
- OracleOraHome92HTTPServer 
- OracleOraHome92PagingServer 
- OracleOraHome92SNMPPeerEncapsulator 
- OracleOraHome92SNMPPeerMasterAgent 
- OracleOraHome92TNSListener 
- OracleServiceMEUBANCO

And here I go for some rounds !!!

[dr_gori]

Because you do not try to start only the main 2:

Select all

- OracleOraHome92TNSListener  
- OracleServiceMEUBANCO

[tom]

Okay, colleague. I did this, I went to dinner to take a while, I came back and nothing. I tried to reverse the order of services, and yet nothing. I Czech the services, the system says they are running, but no success. Still the same error. Any other tips?

[edu_oracle]

Dude, it's the following:

1 - At one moment you said that when Oracle 8i falls you had to take it with commands like startup ...... is usually on Linux, right?

porque If it is in Windows, remove everything from the initialize (Msconfig).

Go to Administrative Tools - Services

Change all Oracle services to Manual (I do this normally and it works ... it's much better, allows you manage your bd more closely) ... if you want to continue as automatic can leave tb ..... but be aware of memory at this time ..... and as glufke said leave just what you will need .... . That is, for this you will have to stop all services and start it again.

understood man?


Detail: These instructions have been for Windows ..... for Linux you can develop scripts to rotate at OS initialization.

[tom]

Okay, Eduardo. This makes sense to me. I mentioned these commands because the difference in procedures caught my attention. Now the case is that even following these instructions that were passed to me I still can not access my bank. X file case ???

[edu_oracle]

Dude, this machine is the server ... right?
Did you ever restart it?

It is very strange this error ..... mainly because it is in Windows.

Problem: BD is not being accessed and indicates that it is in the air .... Is that it?

[tom]

Yes, it really is. In yesterday's tests, I verified that the two processes that Matheus indicated as being essential are running, but I can not connect. At first he said something about waiting a few minutes, yesterday I noticed that after a half hour there was no news. I will only emphasize that the machine is not server because there is no network, but I confirm: the operating system is Windows XP Professional, and the bank is Oracle 9i.

Grate all by interest ...

[edu_oracle]

But man, I have this same configuration and how to solve these problems are the ones I described ... understood?


There must be some Windows process that is in conflict with Oracle ....

See the task manager if you do not have no task of Oracle raised .... if you see that your options have exhausted a clean machine and reinstall the oracle again .... but only do it after you see that there is nowhere to go .... sure we have learned a lot from mistakes.

[tom]

I'm with you and I do not open, Eduardo. If you want to continue accompanying this topic, I think tonight I will do some more attempts. I have a situation to report that I detected when I tried to use Enterprise Manager, but it was so drunk from the business I ended up nor documenting ... Anyway, I agree with you in everything I said, I just do not know what especially means "Clean Machine "...

[tom]

Hello. It follows reports of now just:

I opened the Enterprise Manager Console. On the login screen I left marked option "Activate Independent". The console opens, with an Explorer where I see a folder "Databases".
I clicked on the existing node and surge mebank. I clicked on the MyBank node and now I see another login screen requesting "connection information to the database," I passed the SYS user, with the password, and chose connect as SYSDBA.
Then arise new nodes, the first is "instance", within it is "configuration". Clicking on Configuration I now see a window with some information, there is a "General" tab, where the state of the instance appears as "mounted". Then I select "Open", click Apply and then receive the error:

Select all

"ORA-01113: o arquivo 10 precisa da recuperação de mídia 
ORA-01110: 10 do arquivo de dados 'c:\oracle\oradata\meubanco\xdb01.dbf'"

Details that draw attention:

- That same message was found in an oradim.log file I found in C: \ oracle \ ora92 \ database

- along with this XDB01.dbf file there are other 9 .dbf, all being updated every day that I try to connect, with the exception of this
XDB01, which continues with the date of 06/27/04. There are also three redo (01, 02 and 03) .log with this same date.

- A fact surely relevant is that one day (which I can not confirm, but it may have been this 06/27/04), my machine restarted 2 times in a matter of minutes - perhaps a Oscillation in the mains, which is not common here.

So now I'm thinking: could this file have been corrupted? Is this the cause of the problem? There will be a means of recovering it,
considering that I do not have backup?

The Oracle installation is very recent - 19/06/04, I was going to start messing now ...

I still grateful because they are sharing their knowledge With me, any news will be postanto here.

[edu_oracle]

Dude, in your place I (not having backup) I would reinstall Oracle again.

We are sure we are talking about corrupted files ... do not doubt it.

mainly because these installations are focused on studies, is not it?

But go get used to ideas from the old backups saw face .....

[tom]

Beauty, Eduardo. I only have to thank you and Matheus for attention. I'll start over everything and this time I intend to do as big people.
Thanks Even, we still get along on these forums of life

[edu_oracle]

Pow man, rest assured .... rrsrsrs

In this forum we have a link for discursions about the jdeveloper .... Oracle tool for Java.

Anything posts here your doubt ....


Thanks.

[MuLtAnI]

He says the following

Select all

ORA-01033 ORACLE initialization or shutdown in progress 
Cause: An attempt was made to log on while Oracle is being started or shut 
down. 
Action: Wait a few minutes. Then retry the operation.

[edu_oracle]

By the message ... BD is not defining if the process is from Start or Shut Dow ... Did you?

As if you had lost .... Do you want a tip to understand better?

Take this error and put it on Google ..... you will learn from your mistakes .... there is no better course .... rsrs

[Hahu]

Hi galera, td good..y..hoje day 09/10/06 I had this error, so I realized in my case was a memory problem, I had a bad thing occupying space, so I ended up deleting some files and td runcturn Again .. I'm here my post..a big abs for all ... Thanks: Wink: