on 09-05-2014 10:20 AM
Hello gurus,
I upgraded oracle 10.2 to 11.3g on a SAP ECC runing on HP-UX.
After that, the user <sidadm> is not able to start database and sap.
When I do startsap it returns the following message.
/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed.
Can you please help me.
Best regards
Ernesto Mandlate
Check oracle_home and in listner.ora.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mr. Divyanshu
I have checked the listener.ora. The oracle_home is there.
....
STARTUP_WAIT_TIME_LISTENER = 0
ADR_BASE_listener.ora=/oracle/SID/saptrace
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = SID)
(ORACLE_HOME = /oracle/SID/112_64)
....
Best regard
Ernesto Mandlate
HI Ernesto,
Two options -
1st goto orasid and start your database -
sqlplus / as sysdba
shutdown immediate
startup
Now goto sidadm and startsap
2nd -
goto orasid and start your database -
sqlplus / as sysdba
shutdown immediate
Now goto sidadm and startsap
In both cases startdb.log is generated, share it with us.
Also your kernel version.
Regards,
Divyanshu
What is the output of R3trans -d ?
Have you modified the environment variable of the sidadm and orasid users with the new values ?
Are you using the new version of the Oracle instant client ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Reagan,
Please find bellow the trans.log.
I have to check about environment variable of sidadm andb orasid.
Yes, I am using the reccommeded version of Oracle Instant Client according the oracle upgrade guide.
4 ETW000 R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 05.09.2014 - 12:40:51
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Fri Sep 5 12:40:51 2014 214 0.000214
4 ETW000 [ dev trc,00000] db_con_init called 16 0.000230
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 89 0.000319
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 16 0.000335
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 10 0.000345
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/DSV/SYS/exe/run/dboraslib.so' ... 43 0.000388
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/DSV/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 31940 0.032328
4 ETW000 [ dev trc,00000] Library '/usr/sap/DSV/SYS/exe/run/dboraslib.so' loaded 14 0.032342
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 29 0.032371
4 ETW000 [ dev trc,00000] Version of '/usr/sap/DSV/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.522)
4 ETW000 282 0.032653
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 22 0.032675
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 40 0.032715
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 33 0.032748
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 23 0.032771
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 23 0.032794
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so
4 ETW000 23 0.032817
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 33 0.032850
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 12 0.032862
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 12 0.032874
4 ETW000 [ dev trc,00000] New connection 0 created 11 0.032885
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco
= NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 37 0.032922
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 13 0.032935
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 10 0.032945
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 16 0.032961
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 9 0.032970
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco =
NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 19 0.032989
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')
4 ETW000 57 0.033046
4 ETW000 [ dev trc,00000] Register application info. 278 0.033324
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 030114, non-unicode)
4 ETW000 88 0.033412
4 ETW000 [ dev trc,00000] Installed Oracle client patches: 23 0.033435
4 ETW000 [ dev trc,00000] # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT
4 ETW000 17 0.033452
4 ETW000 [ dev trc,00000] # Patch Description: Created on 2 Jan 2012, 04:56:08 hrs PST8PDT 15 0.033467
4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET 16 0.033483
4 ETW000 [ dev trc,00000] Default connection: tnsname ='DSV' 17 0.033500
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='WE8DEC', nchar='AL16UTF16', nls=-1),uc_ln=1
4 ETW000 27 0.033527
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=0=OCI_DEFAULT) returned 0 (for default NLS handle)
4 ETW000 9090 0.042617
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=013e3e48) 100 0.042717
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=013e4ee8) 17 0.042734
4 ETW000 [ dev trc,00000] NLS env. settings: lang=414D45524943414E 89 0.042823
4 ETW000 [ dev trc,00000] terr=414D4552494341 13 0.042836
4 ETW000 [ dev trc,00000] char=574538444543 13 0.042849
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.WE8DEC'
4 ETW000 17 0.042866
4 ETW000 [ dev trc,00000] charset='WE8DEC', ncharset='AL16UTF16', UNI_ASC=FALSE 11 0.042877
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 26 0.042903
4 ETW000 [ dev trc,00000] Connecting as /@DSV on connection 0 (nls 0) ... (dbsl 720 030114, non-unicode)
4 ETW000 18 0.042921
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=013e4e08) 85 0.043006
4 ETW000 [ dev trc,00000] Allocating server context handle 22 0.043028
4 ETW000 [ dev trc,00000] Attaching to database server DSV (con=0, svchp=013e4e08, srvhp=013e5dd0)
4 ETW000 34 0.043062
4 ETW000 [ dev trc,00000] Assigning server context 013e5dd0 to service context 013e4e08 81359 0.124421
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=01474150) 92 0.124513
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/', svc=013e4e08, srv=013e5dd0, usr=01474150)
4 ETW000 20 0.124533
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 4624 0.129157
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 60 0.129217
4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 15 0.129232
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 HPUX-ia64 Error: 2: No such file or directory
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=013e5dd0) 25 0.129257
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=013e4e08,srvhp=013e5dd0) detached 343 0.129600
4 ETW000 [ dev trc,00000] Free server handle srvhp=013e5dd0 of con=0 13 0.129613
4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '1034' 75 0.129688
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1034) 14 0.129702
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 1034 12 0.129714
4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not availabl 11 0.129725
4 ETW000 [ dev trc,00000] ORA-27101: shared memory realm does not exist 13 0.129738
4 ETW000 HPUX-ia64 Error: 2: No such file or directory
4 ETW000 [ dev trc,00000] ocica() -> SQL error code 1034,1034 18 0.129756
4 ETW000 [ dev trc,00000] SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=1034. 25 0.129781
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 11 0.129792
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1034 performing CON 100 0.129892
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01034: ORACLE not available 16 0.129908
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 HPUX-ia64 Error: 2: No such file or directory
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 35 0.129943
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 12 0.129955
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 21 0.129976
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 43 0.130019
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 13 0.130032
4 ETW000 [ dev trc,00000] -> 'OCI_102, 11.2.0.3.0, V1, default build' 12 0.130044
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DSV'"
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.