Home » Server Options » RAC & Failsafe » Verify Standalone database not starting Database (oracle 10g fail safe ver 3.4.2 windows 2003 sp2)
Verify Standalone database not starting Database [message #398035] Tue, 14 April 2009 23:59 Go to next message
airother
Messages: 27
Registered: February 2006
Junior Member
Hi,

Normal database is starting. when i do sqlplus / as sysdba and issue startup
it will start.

verify standalone database will work is database is started.

if i shutdown the database (service is started) then i ran verify standalone database
it will ask me confirmation to start database and then it fails to start database.

18 18:57:34 >> FS-10347: Checking the state of database LNTDB01
19 18:57:36 ORACLE not available
ORA-27101: shared memory realm does not exist

FS-10349: Database instance LNTDB01 is not alive. Do you want to stop and restart the database instance? > Yes
20 18:57:36 >> FS-10350: Starting database LNTDB01
21 18:57:40 ** ERROR : FS-10032: Failed to start the database LNTDB01
22 18:57:40 ** ERROR : FS-10389: Database LNTDB01 is not available
23 18:57:40 ** ERROR : FS-10160: Failed to verify standalone Oracle database LNTDB01
24 18:57:40 ** ERROR : FS-10795: The Oracle Database resource provider failed to validate resource LNTDB01
25 18:57:40 ** ERROR : FS-10890: Oracle Services for MSCS failed during the
verify Standalone operation
Re: Verify Standalone database not starting Database [message #398037 is a reply to message #398035] Wed, 15 April 2009 00:04 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Database Version please (4 digit)

Babu
Re: Verify Standalone database not starting Database [message #398046 is a reply to message #398037] Wed, 15 April 2009 00:27 Go to previous messageGo to next message
airother
Messages: 27
Registered: February 2006
Junior Member
DB version :10.2.0.4
Re: Verify Standalone database not starting Database [message #398054 is a reply to message #398046] Wed, 15 April 2009 00:56 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>o start database and then it fails to start database.

Why it's failing ?? Did you set proper environment variables? (Like ORACLE_SID and ORACLE_HOME)

Previously it's working ?? Did you change any database parameter??

Babu
Re: Verify Standalone database not starting Database [message #398056 is a reply to message #398054] Wed, 15 April 2009 01:00 Go to previous messageGo to next message
airother
Messages: 27
Registered: February 2006
Junior Member
Yes oracle_sid,Oracle_home is environment variables is configured .

If i start database verify standalnoe database is success.

but if i stop database and service. then if i try verify standalone database. it asks confirmation to start database if i say is service will start but instance will not attach.

instance also has to start when verify standalone database is checked.

\
Re: Verify Standalone database not starting Database [message #398058 is a reply to message #398056] Wed, 15 April 2009 01:10 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Post your alert logfile.

Your Oracle Releated Services starting automatically or manually??

If it's manual then set auto.

>> standalone database

Standalone database running locally or remote ??

Babu
Re: Verify Standalone database not starting Database [message #398059 is a reply to message #398058] Wed, 15 April 2009 01:16 Go to previous message
airother
Messages: 27
Registered: February 2006
Junior Member
running local

if u set to auto mode fail safe automatically turn to manual.


Previous Topic: ASMDISK DiskGroup Free Space Issue
Next Topic: RAC install white papers
Goto Forum:
  


Current Time: Thu Nov 21 12:02:00 CST 2024