on 11-05-2013 6:57 AM
Hi Guru's
we did a clone of our production system and changed the SID and hostname in ENV,profiles,oracle listner and tnsnames files and we were able to start our database but unable to start the sap and R3trans -d getting error as attached below
4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 04.11.2013 - 20:05:17
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -xd
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Mon Nov 4 20:05:17 2013 71 0.000071
4 ETW000 [ dev trc,00000] db_con_init called 16 0.000087
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 40 0.000127
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 28 0.000155
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 17 0.000172
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/GL3/SYS/exe/run/dboraslib.o' ... 36 0.000208
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/GL3/SYS/exe/run/dboraslib.o"), hdl 0
4 ETW000 13493 0.013701
4 ETW000 [ dev trc,00000] Library '/usr/sap/GL3/SYS/exe/run/dboraslib.o' loaded 21 0.013722
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 28 0.013750
4 ETW000 [ dev trc,00000] Version of '/usr/sap/GL3/SYS/exe/run/dboraslib.o' is "720.00", patchlevel (0.327)
4 ETW000 364 0.014114
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 26 0.014140
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 60 0.014200
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 28 0.014228
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 29 0.014257
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 27 0.014284
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/GL3/SYS/exe/run/dboraslib.o
4 ETW000 28 0.014312
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 51 0.014363
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 21 0.014384
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 28 0.014412
4 ETW000 [ dev trc,00000] New connection 0 created 17 0.014429
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 43 0.014472
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 40 0.014512
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 25 0.014537
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 25 0.014562
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 16 0.014578
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 33 0.014611
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')
4 ETW000 82 0.014693
4 ETW000 [ dev trc,00000] Register application info. 372 0.015065
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 291112, UNICODE[2])
4 ETW000 226 0.015291
4 ETW000 [ dev trc,00000] Installed Oracle client patches: 42 0.015333
4 ETW000 [ dev trc,00000] # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT
4 ETW000 28 0.015361
4 ETW000 [ dev trc,00000] # Patch Description: Created on 28 Dec 2011, 01:17:39 hrs PST8PDT 27 0.015388
4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET 30 0.015418
4 ETW000 [ dev trc,00000] Default connection: tnsname ='GL3' 29 0.015447
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 31 0.015478
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR 5226 0.020704
4 ETW000 [ dev trc,00000] OCIErrorGet() failed with rc=-2 24 0.020728
4 ETW000 [ dev trc,00000] -> no further error details available 19 0.020747
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned -1 (for default NLS handle)
4 ETW000 37 0.020784
4 ETW000 [ dev trc,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrBt
4 ETW000 34 0.020818
4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 0000NULL 0000NULL 0000NULL
4 ETW000 33 0.020851
4 ETW000 [ dev trc,00000] set_ocica() -> OCI return code -1 20 0.020871
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=-1, 99=DBSL_ERR_DB 23 0.020894
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -1 performing CON 40 0.020934
4 ETW000 [ dblink ,00000] ***LOG BY0=>OCI returned error code -1. 38 0.020972
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 39 0.021011
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 22 0.021033
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 20 0.021053
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 36 0.021089
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 21 0.021110
4 ETW000 [ dev trc,00000] -> 'OCI_112, 11.2.0.3.0, V1, default build' 22 0.021132
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'GL3'"
Hi All,
My issue was resolved by making changes in my ENV varaible,and reset user system
and Thanks for the response
Regards
Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Make sure the tnsnames.ora file located at TNS_ADMIN location is configured correclty.
It is mostly /usr/sap/SID/SYS/profile/oracle
Also check the Oracle instant client files are accessible and available.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
See if following links helps you to resolve the problem.
[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=443867]
[http://www.dbmotive.com/oracle_error_codes.php?type=ORA&errcode=12154]
BR,
Prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check the below note.
1860519 - SAP fails to connect to the database
1800071 - ORA-12545 when connecting to the database in Fail Safe environments
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
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.