on 06-13-2007 10:21 AM
Hi,
Can anyone help?
I am having trouble with the environment variables following the upgrade to Oracel 10g. Keep getting ORA-12705 errors and none of the previous posts really help.
Would someone who did a similiar upgrade be so kind as to p<b>ost their environment variables as set for for their sidadm and orasid users</b>? (HP-UX prefered, but and Unix will do).
I only require the outputs of the "env" command, not the .dbenv or .sapenv files.
Many thanks!!!
Adriaan
Hi,
I solved this by myself.
I had to include the following parameters in my .dbenv files (which also changes sidadm environment):
ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data
BR_ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data
Seems like the main issue is the fact that WAS6.20 needs to be shown to the oracle 9 client although you have oracle 10g installed.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I cannot start SAP. When I do a 'startsap' it reports back as saying it could not start anything but it does actually start the database.
When I then do a 'stopsap' it tells me the database is not running although it is.
WAS/Basis 6.20, kernel is 6.40.
R3trans -d output
4 ETW000 R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 13.06.2007 - 11:50:05
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] Wed Jun 13 11:50:05 2007 266 0.000266
4 ETW000 [dev trc ,00000] db_con_init called 17 0.000283
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 86 0.000369
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/BWS/SYS/exe/run/dboraslib.so' ...
4 ETW000 80 0.000449
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/BWS/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 36047 0.036496
4 ETW000 [dev trc ,00000] Library '/usr/sap/BWS/SYS/exe/run/dboraslib.so' loaded
4 ETW000 29 0.036525
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/BWS/SYS/exe/run/db
oraslib.so
4 ETW000 102 0.036627
4 ETW000 [dev trc ,00000] Version of '/usr/sap/BWS/SYS/exe/run/dboraslib.so' is "640.00", patc
hlevel (0.172)
4 ETW000 222 0.036849
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/BWS/SYS/exe/run/d
boraslib.so
4 ETW000 28 0.036877
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/BWS/SYS/exe/run/
dboraslib.so
4 ETW000 67 0.036944
4 ETW000 [dev trc ,00000] New connection 0 created 47 0.036991
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 56 0.037047
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 55 0.037102
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 22 0.037124
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 21 0.037145
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/BWS/102_64 from environment
4 ETW000 466 0.037611
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 73 0.037684
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
4 ETW000 22 0.037706
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 3960 0.041666
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPBWP's password 61 0.041727
4 ETW000 [dev trc ,00000] Connecting as /@BWS on connection 0 (nls_hdl 0) ... (dbsl 640 230207
)
4 ETW000 23 0.041750
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C
EnvHp ErrHp ErrHpBatch
4 ETW000 32 0.041782
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 6000
000000c3b510 6000000000c42d40 6000000000c426d8
4 ETW000 22 0.041804
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 42 0.041846
4 ETW000 [dev trc ,00000] Allocating server context handle 25 0.041871
4 ETW000 [dev trc ,00000] Attaching to DB Server BWS (con_hdl=0,svchp=6000000000c42608,srvhp=6
000000000c43418)
4 ETW000 60 0.041931
4 ETW000 [dev trc ,00000] Assigning server context 6000000000c43418 to service context 6000000
000c42608
4 ETW000 128641 0.170572
4 ETW000 [dev trc ,00000] Allocating user session handle 109 0.170681
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=6000000000c42608,srvhp=600000
0000c43418,usrhp=6000000000c4ce80)
4 ETW000 35 0.170716
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 12363 0.183079
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=6000000000c43418)
4 ETW000 20 0.183099
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=6000000000c42608,srvhp=600
0000000c43418)
4 ETW000 23 0.183122
4 ETW000 [dev trc ,00000] Deallocating server context handle 6000000000c43418
4 ETW000 755 0.183877
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 130 0.184007
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 27 0.184034
4 ETW000 [dev trc ,00000] Try to connect with default password 17 0.184051
4 ETW000 [dev trc ,00000] Connecting as SAPBWP/<pwd>@BWS on connection 0 (nls_hdl 0) ... (dbsl
640 230207)
4 ETW000 26 0.184077
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C
EnvHp ErrHp ErrHpBatch
4 ETW000 21 0.184098
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 6000
000000c3b510 6000000000c42d40 6000000000c426d8
4 ETW000 22 0.184120
4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.184134
4 ETW000 [dev trc ,00000] Attaching to DB Server BWS (con_hdl=0,svchp=6000000000c42608,srvhp=6
000000000c43418)
4 ETW000 36 0.184170
4 ETW000 [dev trc ,00000] Assigning server context 6000000000c43418 to service context 6000000
000c42608
4 ETW000 132364 0.316534
4 ETW000 [dev trc ,00000] Assigning username to user session 6000000000c4ce80
4 ETW000 26 0.316560
4 ETW000 [dev trc ,00000] Assigning password to user session 6000000000c4ce80
4 ETW000 100 0.316660
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=6000000000c42608,srvhp=600000
0000c43418,usrhp=6000000000c4ce80)
4 ETW000 22 0.316682
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 116779 0.433461
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=6000000000c43418)
4 ETW000 21 0.433482
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=6000000000c42608,srvhp=600
0000000c43418)
4 ETW000 21 0.433503
4 ETW000 [dev trc ,00000] Deallocating server context handle 6000000000c43418
4 ETW000 278 0.433781
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 29 0.433810
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 13 0.433823
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dblink#2 @ 419]
4 ETW000 170 0.433993
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid envir
onment specified [dblink#2 @ 419]
4 ETW000 20 0.434013
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'BWS'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Here are my variables. Any advise or idea what could be wrong?
Manty thanks,
bwsadm:
PATH=/oracle/BWS/102_64/bin:.:/home/bwsadm:/usr/sap/BWS/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sec_mgmt/bastille/bin:/opt/resmon/bin:/opt/gnome/bin:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/mozilla:/opt/Netscape:/opt/mx/bin:/opt/prm/bin:/opt/sec_mgmt/spc/bin:/usr/bin/X11:/opt/upgrade/bin:/opt/wlm/bin:/opt/graphics/common/bin:/opt/ignite/bin:/opt/OV/bin/OpC:/opt/OV/bin:/opt/hpnpl//bin:/opt/ssh/bin:/opt/cfg2html:/usr/contrib/bin/X11
LOGNAME=bwsadm
SHELL=/bin/csh
TERM=xterm
COLUMNS=100
LINES=39
MANPATH=/opt/ipf/man:/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/mx/share/man:/opt/sec_mgmt/share/man:/usr/dt/share/man:/opt/samba/man:/opt/gnome/man:/opt/perf/man/%L:/opt/perf/man:/opt/wbem/share/man:/opt/prm/man/%L:/opt/prm/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/wlm/share/man/%L:/opt/wlm/share/man:/opt/graphics/common/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/hpnpl//man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/perl/man:/opt/VRTS/man:/opt/hpsmc/shc/man:/opt/resmon/share/man/%L:/opt/resmon/share/man
TZ=GMT0BST
SAPSYSTEMNAME=BWS
DIR_LIBRARY=/usr/sap/BWS/SYS/exe/run
SHLIB_PATH=/usr/sap/BWS/SYS/exe/run:/oracle/client/10x_64/instantclient
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=BWS
dbs_ora_schema=SAPBWP
ORACLE_SID=BWS
DB_SID=BWS
ORACLE_HOME=/oracle/BWS/102_64
ORACLE_BASE=/oracle
TNS_ADMIN=/oracle/BWS/102_64/network/admin
ADD=/oracle/client/10x_64/instantclient
NLS_LANG=AMERICAN_AMERICA.WE8DEC
SAPDATA_HOME=/oracle/BWS
orabws:
HOME=/oracle/BWS
PATH=/oracle/BWS/102_64/bin:.:/oracle/BWS:/usr/sap/BWS/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sec_mgmt/bastille/bin:/opt/resmon/bin:/opt/gnome/bin:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/mozilla:/opt/Netscape:/opt/mx/bin:/opt/prm/bin:/opt/sec_mgmt/spc/bin:/usr/bin/X11:/opt/upgrade/bin:/opt/wlm/bin:/opt/graphics/common/bin:/opt/ignite/bin:/opt/OV/bin/OpC:/opt/OV/bin:/opt/hpnpl//bin:/opt/ssh/bin:/opt/cfg2html:/usr/contrib/bin/X11
LOGNAME=orabws
SHELL=/bin/csh
TERM=xterm
COLUMNS=100
LINES=39
MANPATH=/opt/ipf/man:/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/mx/share/man:/opt/sec_mgmt/share/man:/usr/dt/share/man:/opt/samba/man:/opt/gnome/man:/opt/perf/man/%L:/opt/perf/man:/opt/wbem/share/man:/opt/prm/man/%L:/opt/prm/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/wlm/share/man/%L:/opt/wlm/share/man:/opt/graphics/common/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/hpnpl//man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/perl/man:/opt/VRTS/man:/opt/hpsmc/shc/man:/opt/resmon/share/man/%L:/opt/resmon/share/man
TZ=GMT0BST
SAPSYSTEMNAME=BWS
DIR_LIBRARY=/usr/sap/BWS/SYS/exe/run
SHLIB_PATH=/usr/sap/BWS/SYS/exe/run:/oracle/BWS/102_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=BWS
dbs_ora_schema=SAPBWP
ORACLE_SID=BWS
DB_SID=BWS
ORACLE_HOME=/oracle/BWS/102_64
ORACLE_BASE=/oracle
ADD=/oracle/BWS/102_64/lib
NLS_LANG=AMERICAN_AMERICA.WE8DEC
SAPDATA_HOME=/oracle/BWS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As per Sap's Oracle Upgrade documentation (see it at <i>service.sap.com/instguides -Other Documentation -Database -Upgrades -Oracle</i>),
you must add the <b>ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data</b> variable to your SIDadm environment,
and <b>ORA_NLS10=$ORACLE_HOME/nls/data</b> to your oraSID.
Best Regards,
JC Llanes.
Hi Adrian,
I think it's easiest if you copy&paste your env outputs. Here are many people who can help you if you provide this info.
Best Regards,
JC Llanes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.