cancel
Showing results for 
Search instead for 
Did you mean: 

Environment variables after upgrade to Oracle 10g on WAS 620 based system

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Adriaan,

I found OSS note 949847 which describes what you said:

<i>The customer uses the Oracle 9.2 client software on UNIX platforms when

the SAP kernel is 640 / 46D_EXT.</i>

This note also describes how to install the latest 9.2 client in this environment.

Best regards,

Elmar.

Former Member
0 Kudos

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'"

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

Are you able to start SAP ? whats your Kenel version ? whats R3trans -d output

thanks

Prince Jose

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.