Problems bringing Oracle instance Online

Question

I have configured AutoStart Oracle instances with Oracle 10g on Solaris 9. When we bring the resource group online, the oraproc log gives a message ORA-01033. RG restarts after evry 3 minutes and the Oracle process becomes unresponsive for 10-15 seconds giving the error ORA-03135 in the oraproc log.

Any suggestions please.

madejskij · Answer

HiI have similar problem.I configured Oracle 10g instance in AutoStart 5.3 SP1 whith oracle module 3.1.4. on Solaris 10 SPARC.Proxy process is not responding, and OS_SIDDB_Oracle process dying.This is repeated every 6-8 minutes. Something like oracle processes die, but still running and I can login to database.Restart AS agents doesn't help.Thanks for any help.I checked ORA error codes... it is the same problem.RegardsMadejMessage was edited by: madejwi

amediratta · Answer

Seems slightly different from my problem. In my case, all processes start but with a error in the log and then every three minutes, we send OCI calls every three minutes and get error in first 5-6 attempts bu then it starts working.

Just working with Oracle support to get through this.

madejskij · Answer

Hi,I have resolved my problem.It was connection problem - bad login/passwordI had bad user and pssword in confguration.And now working fine.Check the DBA user, must have SYSDBA privs.regadrs

amediratta · Answer

I am getting the OCI errors and only for first few attempts when I bring the RG online.

Replication Manager

Problems bringing Oracle instance Online

Was this post helpful?