on 05-27-2010 6:32 PM
Hi All
My Development server was crashed due to hdd drive failure. Then I restored file system backup and the database backup. I tried to start sap it was giving me an error, but if I started db using sql prompt it started successfully. Please help me urgently....
R3trans.log
4 ETW000 R3trans version 6.13 (release 640 - 10.07.07 - 13:48:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 27.05.2010 - 05:18:57
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu May 27 05:18:57 2010 266 0.000266
4 ETW000 [dev trc ,00000] db_con_init called 43 0.000309
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 93 0.000402
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/GMD/SYS/exe/run/dboraslib.so' ...
4 ETW000 120 0.000522
4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find library 'libclntsh.so.9.0'. -> DLENOACCESS (0,Error 0)
4 ETW000 743 0.001265
4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/GMD/SYS/exe/run/dboraslib.so'
4 ETW000 52 0.001317
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/GMD/SYS/exe/run') or dbms_type ('ORA')"
startdb.log
-
Thu May 27 04:43:32 MDT 2010
LOGFILE FOR STARTING ORACLE
Trying to start GMD database ...
-
Thu May 27 04:43:32 MDT 2010
checking required environment variables
ORACLE_HOME is >/oracle/GMD/920_64<
ORACLE_SID is >GMD<
-
Thu May 27 04:43:32 MDT 2010
check initora
-
Thu May 27 04:43:32 MDT 2010
check initora
-
Thu May 27 04:43:32 MDT 2010
checking V2 connect
TNS Ping Utility for HPUX: Version 9.2.0.7.0 - Production on 27-MAY-2010 04:43:32
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/oracle/GMD/920_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = dev) (PORT = 1527))) (CONNECT_DATA = (SID = GMD) (GLOBAL_NAME = GMD.WORLD)))
OK (0 msec)
tnsping: V2 connect to GMD
-
Thu May 27 04:43:32 MDT 2010
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
-
Thu May 27 04:43:32 MDT 2010
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
-
Thu May 27 04:43:37 MDT 2010
starting database
SQL*Plus: Release 9.2.0.7.0 - Production on Thu May 27 04:43:37 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 1210010248 bytes
Fixed Size 727688 bytes
Variable Size 637534208 bytes
Database Buffers 570425344 bytes
Redo Buffers 1323008 bytes
Database mounted.
Database opened.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
-
Thu May 27 04:43:53 MDT 2010
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/GMD/SYS/exe/run/startdb: Terminating with error code 12
Duplicate thread
Read and Follow the Forum Rules
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.