Skip to Content
0
Former Member
Dec 03, 2008 at 01:08 PM

sap starting probelm

41 Views

hi all

iam startsap i got following problem with r3trans.the error is

cat startdb.log | less

-


Wed Dec 3 17:13:46 IST 2008

LOGFILE FOR STARTING ORACLE

Trying to start KDV database ...

-


Wed Dec 3 17:13:46 IST 2008

checking required environment variables

ORACLE_HOME is >/oracle/KDV/102_64<

ORACLE_SID is >KDV<

-


Wed Dec 3 17:13:46 IST 2008

check initora

-


Wed Dec 3 17:13:46 IST 2008

check initora

-


Wed Dec 3 17:13:46 IST 2008

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 03-DEC-2008 17:13:46

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

Used parameter files:

/usr/sap/KDV/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 = KARVY-DEV) (

PORT = 1527))) (CONNECT_DATA = (SID = KDV) (GLOBAL_NAME = KDV.WORLD)))

OK (10 msec)

tnsping: V2 connect to KDV

-


Wed Dec 3 17:13:46 IST 2008

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Wed Dec 3 17:13:46 IST 2008

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Wed Dec 3 17:13:46 IST 2008

Starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 3 17:13:46 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2332033024 bytes

Fixed Size 2022504 bytes

Variable Size 1174406040 bytes

Database Buffers 1140850688 bytes

Redo Buffers 14753792 bytes

Database mounted.

Database opened.

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

With the Partitioning and Data Mining options

-


Wed Dec 3 17:13:56 IST 2008

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/KDV/SYS/exe/run/startdb: Terminating with error code 12