Skip to Content
0
Former Member
Jun 24, 2009 at 10:00 PM

Oracle database not getting Up after patch upgrade

165 Views

Hi,

I have upgraded my oracle database from 10.0.2.1 to 10.0.2.4. after this databse is not coming up. I am able to start/stop listner but while starting SAP it is not able to start databse. Pasting error log below.

-


Wed Jun 24 14:56:45 PDT 2009

LOGFILE FOR STARTING ORACLE

Trying to start CRD database ...

-


Wed Jun 24 14:56:45 PDT 2009

checking required environment variables

ORACLE_HOME is >/oracle/CRD/102_64<

ORACLE_SID is >CRD<

-


Wed Jun 24 14:56:45 PDT 2009

check initora

-


Wed Jun 24 14:56:45 PDT 2009

check initora

-


Wed Jun 24 14:56:45 PDT 2009

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 24-JUN-2009 14:56:45

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

/usr/sap/CRD/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = CRM) (PORT = 1527))) (CONNECT_DATA = (SID =

CRD) (GLOBAL_NAME = CRD.WORLD)))

OK (0 msec)

tnsping: V2 connect to CRD

-


Wed Jun 24 14:56:45 PDT 2009

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Wed Jun 24 14:56:45 PDT 2009

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Wed Jun 24 14:56:45 PDT 2009

starting database

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 24 14:56:45 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size 2083560 bytes

Variable Size 620758296 bytes

Database Buffers 587202560 bytes

Redo Buffers 14692352 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

-


Wed Jun 24 14:56:53 PDT 2009

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

  • ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/CRD/SYS/exe/run/startdb: Terminating with error code 12

thanks,

Bhanu