Database not running

[Former Member]

Hi All,

I have an BW 3.5 system here. Its NW04 on oracle 9.2.0.6 and on AIX platform

Now the server is not starting up.

Our bakup team completed a online backup

Then they started a offline backup. and the offline backup terminated with errors:-

BR0301E SQL error -1089 at location BrDbConnect-2

ORA-01089: immediate shutdown in progress - no operations are permitted

BR0310E Connect to database instance BP1 failed

Now the server is not coming up. DB is not running

R3trans -d gives return code 12

When I am trying to start the db with "startup mount" command on sqlplus, it gives the following errot:-

ORA-01031: insufficient privileges

Kindly help

Regards

Tajinder

[Former Member · Accepted solution]

>ORA-01089: immediate shutdown in progress - no operations are permitted

i think you are again stopping / starting the database when the starting/stopping is already in progress. please retry your command again after few minutes

Cheers,

-Sunil

[Former Member]

Hi,

There is little confusion here,

"Our bakup team completed a online backup

Then they started a offline backup" why would system go down when the back is in progress, very unusual since backup activitiwes got nothing to do with oracle shutdown and startup.

Have there been any other activities planned during backup process going on.

How is your oracle file system, is there enough space available.

What mode did you set when taking offline backup...

Obviously R3trans doesnot work when DB is down, try starting the DB using ORA<SID> user, and see what it says,......

Post the oracle logs here for further analysis.

Regards,

Raju.

[Former Member]

Dear All,

Sorry for delay in replying.

alertlog.SID was not opening because it went too large.

Tail alertlog.sid was just showing that oracle instance starting.

So what I did was that i did shutdown immediate and the startup force.

And it started.

I was using oracle user only.

I restarted SQL and it allowed me to startup.

I guess shutdown was in operation so it was not allowing me to startup.

Yes there was no activity planned other than backups.

I couldnt figure out what went wrong. There were only backups going on. Online Backup was completed and Offline started.

I am now checking the logs and stuff and will see if i can find anything

Any clue on what would have went wrong.What all log files should I check?

Regards,

Tajinder

[Former Member]

Hi

Closing the thread

[Former Member]

hi Tajinder Pal Si...

database is not starting means did u do anything in Os level of /oracle directory

startup mount option is used for only database creation time only

login with / as sysdba try startup option in sql prompt

[Former Member]

Hi

ORA-01031: insufficient privileges.

Sounds like you do not have the Operating system privileges. Have you logged in as the correct

oracle user?

On some sites it is the user oracle but with SAP I am used to something like ora<SID>.

Where sid is the saps sid for example

oraprd would be the oracle user for a sap PRD system e.g. production.

A quick way to find out the users on your system Unix would be to access the passwd file in /etc.

e.g. cat /etc/passwd

Should work with AIX but as always all disclaimers

[Former Member]

HI

If you are logging as the correct oracle user and things still arn't working why not post your telnet command so we can see what you are doing.

Also check out

http://www.adp-gmbh.ch/ora/err/ora_01031.html

http://it.toolbox.com/blogs/david/ora01031-insufficient-privileges-upon-instance-startup-13759

regards

Stephen George

[Former Member]

You should check if you have any filesystem full, for instance /ORACLE or /ORACLE/<SID>/saparch or ORAARCH. You should also check the CPU usage, and see if ORACLE is playing dead or doing anything.

Have you check alert_SID.log?

can you send the "tail -20 alert_SID.log" ?

If you cannot find any find, and certain of some risks a "shutdown abort". But only when you don't have more resources.

Regards