on 05-14-2009 2:22 PM
we have an app server that is not talking to CI+db(both on one machine) server. When i issued R3trans -d, the out put showed
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
4 ETW000 50 0.091779
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 8097 0.099876
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 50 0.099926
I am unsure where Client NLS settings is getting picked up from despite the env variable for NLS_LANG for both oraSId and SIDadm set to AMERICAN_AMERICA.WE8DEC
R/3 4.7 with oracle 9.2.0.6.0 on Sun Solaris 5.9
Any ideas
Regards
Kal
Hi..
check your env variable, it should be--
ORA_NLS33=/oracle/EWP/920_64/ocommon/nls/admin/data
if using 64 bit oracle.
I faced the same problem and it resolved.
Do step as follows--
1. Reboot the system.
2. check for above env variable.
3. now try to start SAP.
Regards
Abhimanyu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Still no saurabh. thanks for your inputs though.
Here is the complete trans.log for you
ETW000 R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 14.05.2009 - 14:59:19
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 14 14:59:19 2009 417 0.000417
4 ETW000 [dev trc ,00000] db_con_init called 31 0.000448
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 218 0.000666
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/AWI/SYS/exe/run/dboraslib.so' ...
4 ETW000 100 0.000766
4 ETW000 [dev trc ,00000] Thu May 14 14:59:20 2009 88068 0.088834
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/AWI/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 63 0.088897
4 ETW000 [dev trc ,00000] Library '/usr/sap/AWI/SYS/exe/run/dboraslib.so' loaded
4 ETW000 33 0.088930
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/AWI/SYS/exe/run/dboraslib.so
4 ETW000 60 0.088990
4 ETW000 [dev trc ,00000] Version of '/usr/sap/AWI/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.142)
4 ETW000 482 0.089472
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/AWI/SYS/exe/run/dboraslib.so
4 ETW000 44 0.089516
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/AWI/SYS/exe/run/dboraslib.so
4 ETW000 142 0.089658
4 ETW000 [dev trc ,00000] New connection 0 created 59 0.089717
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255,
occ = NO
4 ETW000 49 0.089766
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 79 0.089845
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 38 0.089883
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, o
cc = NO
4 ETW000 36 0.089919
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/AWI/920_64 from environment
4 ETW000 1173 0.091092
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 105 0.091197
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
4 ETW000 38 0.091235
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 8235 0.099470
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 38 0.099508
4 ETW000 [dev trc ,00000] Connecting as /@AWI on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
4 ETW000 38 0.099546
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 63 0.099609
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 10124f610 101256e20 1012567b8
4 ETW000 38 0.099647
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 107 0.099754
4 ETW000 [dev trc ,00000] Allocating server context handle 36 0.099790
4 ETW000 [dev trc ,00000] Attaching to DB Server AWI (con_hdl=0,svchp=1012566e8,svrhp=1012574e8)
4 ETW000 180 0.099970
4 ETW000 [dev trc ,00000] Assigning server context 1012574e8 to service context 1012566e8
4 ETW000 158555 0.258525
4 ETW000 [dev trc ,00000] Allocating user session handle 105 0.258630
More(55%)
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1012566e8,srvhp=1012574e8,usrhp=101260f30)
4 ETW000 56 0.258686
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 11667 0.270353
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1012574e8)
4 ETW000 38 0.270391
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1012566e8,srvhp=1012574e8)
4 ETW000 32 0.270423
4 ETW000 [dev trc ,00000] Deallocating server context handle 1012574e8 780 0.271203
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 111 0.271314
4 ETW000 [dev trc ,00000] Try to connect with default password 84 0.271398
4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@AWI on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
4 ETW000 39 0.271437
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 36 0.271473
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 10124f610 101256e20 1012567b8
4 ETW000 34 0.271507
4 ETW000 [dev trc ,00000] Allocating server context handle 23 0.271530
4 ETW000 [dev trc ,00000] Attaching to DB Server AWI (con_hdl=0,svchp=1012566e8,svrhp=1012574e8)
4 ETW000 53 0.271583
4 ETW000 [dev trc ,00000] Assigning server context 1012574e8 to service context 1012566e8
4 ETW000 68553 0.340136
4 ETW000 [dev trc ,00000] Assigning username to user session 101260f30 34 0.340170
4 ETW000 [dev trc ,00000] Assigning password to user session 101260f30 70 0.340240
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1012566e8,srvhp=1012574e8,usrhp=101260f30)
4 ETW000 44 0.340284
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 25026 0.365310
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1012574e8)
4 ETW000 36 0.365346
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1012566e8,srvhp=1012574e8)
4 ETW000 140 0.365486
4 ETW000 [dev trc ,00000] Deallocating server context handle 1012574e8 321 0.365807
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 52 0.365859
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dblink#2 @ 419]
4 ETW000 256 0.366115
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified [dblink#2 @ 419]
4 ETW000 35 0.366150
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'AWI'"
regrds
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please refer to following SAP note.
Note 592657 - ORA-12701/ORA-12705/ORA-12709
If still your problem persists, please provide complete trans.log
With Regards,
Saurabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
when i issued ldd dbsoraslib* in kernel directory..there is no output.
we are on oracle 9.2
and our LD_LIBRARY_PATH has no double reference..it has been set correctly.
I am think more in the lines of why is the client NLS_LANG showing US7ASCII when the parameter has been set to use NLS_LANG='AMERICAN_AMERICA.WE8DEC'
Any thoughts would be appreciated.
Regards
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.