Hi all
I have a problem after upgrading Oracle from 9.0.8 to 10.0.2.0.2. Upgrade phase wnt fine, Oracle is up, Listener is up, Oracle Client10 is used. Oracle is running on SAP System. So when checking R3trans -d i got follwoing:
this is from trans.log:
4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 27.06.2008 - 08:32:47
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] Fri Jun 27 08:32:47 2008 589 0.000589
4 ETW000 [dev trc ,00000] db_con_init called 45 0.000634
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 208 0.000842
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/D21/SYS/exe/run/dboraslib.so' ...
4 ETW000 150 0.000992
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/D21/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 70278 0.071270
4 ETW000 [dev trc ,00000] Library '/usr/sap/D21/SYS/exe/run/dboraslib.so' loaded
4 ETW000 113 0.071383
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/D21/SYS/exe/run/dboraslib.so
4 ETW000 83 0.071466
4 ETW000 [dev trc ,00000] Version of '/usr/sap/D21/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.220)
4 ETW000 991 0.072457
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/D21/SYS/exe/run/dboraslib.so
4 ETW000 58 0.072515
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/D21/SYS/exe/run/dboraslib.so
4 ETW000 168 0.072683
4 ETW000 [dev trc ,00000] New connection 0 created 118 0.072801
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 98 0.072899
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 99 0.072998
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 48 0.073046
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, occ = NO
4 ETW000 48 0.073094
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/D21/102_64 from environment
4 ETW000 1380 0.074474
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 194 0.074668
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
4 ETW000 75 0.074743
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 8516 0.083259
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDAT's password 124 0.083383
4 ETW000 [dev trc ,00000] Connecting as /@D21 on connection 0 (nls_hdl 0) ... (dbsl 640 070208)
4 ETW000 73 0.083456
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 68 0.083524
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 1012d7d00 1012df540 1012deed8
4 ETW000 84 0.083608
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 135 0.083743
4 ETW000 [dev trc ,00000] Allocating server context handle 67 0.083810
4 ETW000 [dev trc ,00000] Attaching to DB Server D21 (con_hdl=0,svchp=1012dee08,srvhp=1012dfc08)
4 ETW000 236 0.084046
4 ETW000 [dev trc ,00000] Assigning server context 1012dfc08 to service context 1012dee08
4 ETW000 147141 0.231187
4 ETW000 [dev trc ,00000] Allocating user session handle 145 0.231332
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1012dee08,srvhp=1012dfc08,usrhp=1012e9e58)
4 ETW000 81 0.231413
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 7664 0.239077
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1012dfc08)
4 ETW000 51 0.239128
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1012dee08,srvhp=1012dfc08)
4 ETW000 47 0.239175
4 ETW000 [dev trc ,00000] Deallocating server context handle 1012dfc08 1015 0.240190
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 167 0.240357
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 59 0.240416
4 ETW000 [dev trc ,00000] Try to connect with default password 133 0.240549
4 ETW000 [dev trc ,00000] Connecting as SAPDAT/<pwd>@D21 on connection 0 (nls_hdl 0) ... (dbsl 640 070208)
4 ETW000 75 0.240624
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 51 0.240675
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 1012d7d00 1012df540 1012deed8
4 ETW000 47 0.240722
4 ETW000 [dev trc ,00000] Allocating server context handle 32 0.240754
4 ETW000 [dev trc ,00000] Attaching to DB Server D21 (con_hdl=0,svchp=1012dee08,srvhp=1012dfc08)
4 ETW000 77 0.240831
4 ETW000 [dev trc ,00000] Fri Jun 27 08:32:48 2008 122893 0.363724
4 ETW000 [dev trc ,00000] Assigning server context 1012dfc08 to service context 1012dee08
4 ETW000 79 0.363803
4 ETW000 [dev trc ,00000] Assigning username to user session 1012e9e58 41 0.363844
4 ETW000 [dev trc ,00000] Assigning password to user session 1012e9e58 81 0.363925
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1012dee08,srvhp=1012dfc08,usrhp=1012e9e58)
4 ETW000 58 0.363983
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 14205 0.378188
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1012dfc08)
4 ETW000 151 0.378339
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1012dee08,srvhp=1012dfc08)
4 ETW000 57 0.378396
4 ETW000 [dev trc ,00000] Deallocating server context handle 1012dfc08 503 0.378899
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 73 0.378972
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 30 0.379002
4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12705 performing CON [dblink#3 @ 428]
4 ETW000 299 0.379301
4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#3 @ 428]
4 ETW000 49 0.379350
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'D21'"
It seems that for some reason it uses US7ASCII but I have not changed enviroment variables. That means that all variables are like below:
setenv NLS_LANG AMERICAN_AMERICA.WE8DEC
When doing echo $ORA_NLS10 is says
/oracle/D21/102_64/nls/data
It seems to be an issue with NLS ?? ORA_NLS33 is unset!
So ther should be no old variables that causes this.
Any input I realy appreciate :-).
Thanx //Pelle
I am very confused ....