OCI - CALL ' OCISessionBegin' failed rc = 1033

[Former Member]

Hi ,

I am trying to install 4.7 E on windows 2003 server with oracle 8i .

On the step of R3 Database Load - I get an error .

The log intially say sql error - 01017 . But i resolved that now after re-starting the setup i get this error .

Any suggestions to resolve this .

[Former Member]

Hi Siddesh ,

That issue is kinda solved now because in the log i can see that its connecting to Oracle however it gives this new error :

the error message that NLS_LANG in environment is "AMERICAN_AMERICA.WE8DEC" and db value is "AMERICAN_AMERICA.WE8ISO8859P1"

I have changed this setting in envoirment variables and system registry as well ... but again its throwing the same error .

Any suggestion Sir .

[former_member185954]

Hi Harsh,

Check where your ORANLS33 environment pointing, hope you have the correct NLS files.

Regards,

Siddhesh

[Former Member]

Hi Siddesh ,

My ORANLS33 environment path is - /oracle/ora81/ocommon/nls/admin/data and the nls files should be ok .... i don know .

[Former Member]

Hi Siddesh ,

My NLS files correct because i can run SAPDBA without any issues however while running the installation it again throws the same error .

[former_member185954]

Hi Harsh,

What error is it giving you now ?

Can you post that error ?

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[Former Member]

Hi Siddesh ,

Please find the sapview log below .

E:\usr\sap\TEK\SYS\exe\run/R3load.exe: START OF LOG: 20070119155338

E:\usr\sap\TEK\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#5 $ SAP

E:\usr\sap\TEK\SYS\exe\run/R3load.exe: version R6.20/V1.2

E:\usr\sap\TEK\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\SAPinst ORACLE KERNEL/SAPVIEW.cmd -l C:\SAPinst ORACLE KERNEL/SAPVIEW.log -stop_on_error

DbSl Trace: Got ORACLE_HOME=E:\oracle\ora81 from environment

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Logon as OPS$-user to get SAPTEK's password

DbSl Trace: Connecting as /@TEK on connection 0 ...

DbSl Trace: Attaching to DB Server TEK (con_hdl=0,svchp=011FE800,svrhp=011FE60C)

DbSl Trace: Starting user session (con_hdl=0,svchp=011FE800,srvhp=011FE60C,usrhp=0123F184)

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1017

DbSl Trace: CONNECT failed with sql error '1017'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPTEK/<pwd>@TEK on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=011FE800,srvhp=011FE60C,usrhp=0123F184)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8ISO8859P1

DbSl Trace: NLS_LANG not set appropriately (DB installation requires AMERICAN_AMERICA.WE8ISO8859P1) ==> connection refused

(DB) ERROR: db_connect rc = 256

DbSl Trace: Already connected to TEK

(DB) ERROR: DbSlErrorMsg rc = 29

E:\usr\sap\TEK\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\TEK\SYS\exe\run/R3load.exe: END OF LOG: 20070119155338

[former_member185954]

Hi,

I get the issue now.. (i think). The oracle client picks up wrong settings of NLS_LANG from environment variables and in case of windows also from Registry.

Check your <sid>adm and ora<sid> user environment variables, I am sure one of them (especially <sid>adm) has incorrect NLS_LANG.

On unix, the <sid>adm user home directory has files called .dbenv_<hostname>.ksh/csh and similarly in ora<sid> user home directory.

In Windows you should login as <sid>adm check Environment variable settings for NLS_LANG.

Regards,

Siddhesh

[Former Member]

Hi Siddhesh ,

My sid<adm> that is TEKADM has NLS_LANG is correct and verified again. I don know how to check orasid user enviroment variables .

[former_member185954]

Hi,

Here is how to check environment variables in Windows:

http://support.microsoft.com/kb/100843

Regards,

Siddhesh

[Former Member]

Hi Siddhesh ,

I have checked all the settings including the registry however no result .Still the same error with same log .

[former_member185954]

I also see you are getting Ora 1017, this points to invalid userid/password.

Please check the following note

SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

PS: I would generally start with a clean install.

Regards,

Siddhesh

[andreas_herzog]

hi, <b>oracle 8i is NOT supported on windows 2003</b>....use oracle 9i - or even better 10g...

GreetZ, AH

[Former Member]

Thanks a million for the answer .

Sir i wanna ask one more thing is Oracle 9i compatible with SAP 4.7 E .

And i have installed windows 2000 advanced on my computer but 98 % of times it keep throwing blue screen errors and installation of SAP is very sleepy .

Any suggestions SIR .

[andreas_herzog]

hi,

yup, r/3 47 runs with oracle 9i...but keep in mind that oracle 9i will be desupported by the 30th of june this year...

win2k is supported to run r/3 47...the blue screens surely have another explanation - any logs or stop messages you could post?

GreetZ, AH

[Former Member]

Hi sir ,

Now i am installing 4.7 E on windows 2000 server SP 1 with oracle 8.1 which was provided with sap dvd`s . On the process of Load balancing i am again getting the error - OCI - CALL ' OCISessionBegin' failed rc = 01092 .

Please Help Sir .

[former_member185954]

Hi Harsh,

Please check this note and see if your Environment settings are okay.

Note 556232 - Environment settings for R/3/Oracle on Windows

Regards,

Siddhesh

[Former Member]

Hi Siddesh ,

Thanks a lot for the answer . Please tell me where to find this Note . I`ve searched in this website however there were no results found .

[former_member185954]

Hi,

http://service.sap.com/notes, you can find SAP Notes here.

Regards,

siddhesh