R3trans -x returns sql 1019 on CONN

[Former Member]

I am running into issue of SAP connection to Oracle. R3trans -x returns error code 12.

Excepts from trans.log

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='PRS') 44 0.025779

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1019 639 0.026418

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1019'

I have looked at numerous notes. Currently I have opened a message with SAP, however if anyone ran into similar issue, please let me know how was it resolve.

Kind Regards,

TD

Other details:

SAP:

4.6D_EXT Kernel (Build 2265)

HPUX 11.31 IA64

DB: Oracle version 10.2.0.2 with interim patches applied as per SAP Note 871096

Errors from R3trans (trans.log)

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [developertra,00000] Fri Jun 8 11:35:34 2007 264 0.000264

4 ETW000 [developertra,00000] db_con_init called 16 0.000280

4 ETW000 [developertra,00000] create_con (con_name=R/3) 46 0.000326

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/PRS/SYS/exe/run/dboraslib.so' ...

4 ETW000 62 0.000388

4 ETW000 [developertra,00000] load shared library (/usr/sap/PRS/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 24463 0.024851

4 ETW000 [developertra,00000] Library '/usr/sap/PRS/SYS/exe/run/dboraslib.so' loaded

4 ETW000 24 0.024875

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/PRS/SYS/exe/run/dboraslib.so

4 ETW000 42 0.024917

4 ETW000 [developertra,00000] Version of library '/usr/sap/PRS/SYS/exe/run/dboraslib.so' is "46D.00", patchlevel (0.2186)

4 ETW000 149 0.025066

4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/PRS/SYS/exe/run/dboraslib.so

4 ETW000 28 0.025094

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/PRS/SYS/exe/run/dboraslib.so

4 ETW000 55 0.025149

4 ETW000 [developertra,00000] New connection 0 created 24 0.025173

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 34 0.025207

4 ETW000 [developertra,00000] find_con found the following connection for reuse:

4 ETW000 22 0.025229

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/PRS/102_64 from environment

4 ETW000 368 0.025597

4 ETW000 [developertra,00000] -->oci_initialize 47 0.025644

4 ETW000 [developertra,00000] Got ORACLE_SID=PRS from environment 20 0.025664

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 24 0.025688

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPPRS's password 16 0.025704

4 ETW000 [developertra,00000] Connecting as /@PRS on connection 0 ... 31 0.025735

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='PRS') 44 0.025779

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1019 639 0.026418

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1019'

4 ETW000 27 0.026445

4 ETW000 [developertra,00000] Try to connect with default password 14 0.026459

4 ETW000 [developertra,00000] Connecting as SAPPRS/<pwd>@PRS on connection 0 ...

ENV Variable for prsadm

HOME=/home/prsadm

PATH=/oracle/PRS/102_64/bin:.:/home/prsadm:/usr/sap/PRS/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/optn

LOGNAME=prsadm

TERM=vt100

SHELL=/usr/bin/csh

MAIL=/var/mail/prsadm

COLUMNS=132

LINES=24

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/openssl/man:/opn

TZ=EST5EDT

SAPSYSTEMNAME=PRS

DIR_LIBRARY=/usr/sap/PRS/SYS/exe/run

SHLIB_PATH=/usr/sap/PRS/SYS/exe/run:/oracle/client/92x_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PRS

dbs_ora_schema=SAPPRS

ORACLE_PSRV=PRS

ORACLE_SID=PRS

ORACLE_HOME=/oracle/PRS/102_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/PRS

ENV Variable for oraprs

HOME=/oracle/PRS

PATH=/oracle/PRS/102_64/bin:.:/oracle/PRS:/usr/sap/PRS/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/n

LOGNAME=oraprs

TERM=vt100

SHELL=/usr/bin/csh

MAIL=/var/mail/oraprs

COLUMNS=132

LINES=24

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/openssl/man:/opn

TZ=EST5EDT

SAPSYSTEMNAME=PRS

DIR_LIBRARY=/usr/sap/PRS/SYS/exe/run

SHLIB_PATH=/usr/sap/PRS/SYS/exe/run:/oracle/PRS/102_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PRS

dbs_ora_schema=SAPR3

ORACLE_PSRV=PRS

ORACLE_SID=PRS

ORACLE_HOME=/oracle/PRS/102_64

ORACLE_BASE=/oracle

ORA_NLS10=/oracle/PRS/102_64/nls/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/PRS

[markus_doehr2 · Accepted solution]

Do you have a $ORACLE_HOME/oracore directory?

Check Note 566051 - Error due to missing oracore directory

--

Markus

[Former Member · Accepted solution]

Yes, I have oracore

Here are the notes I have referred to...

80430: Installation of Oracle client software

303238: Installation of Oracle client software (4.6C, 4.6D)

539922: Installation of Oracle client software 9.2.X (6.20 UNICODE)

651797: Oracle client software in the UNIX cluster environment

521230: FAQ: Client software on UNIX

606359: FAQ: National Language Support (NLS)

819829: Oracle Database 10g: Instant Client 10.x on Unix

836517: Oracle database 10g: Preparation for SAP-upgrade

949847: SAP on Oracle 10g: Help for Error Analysis

886783: Oracle 9207 Client Software

191672: Connect problems in phase DBCHK_PRE with ORACLE

35515: Bad magic number for shared library

393620: Problems through incorrect ORA_NLS33

538849: UNIX: DLENOACCESS when loading dboraslib and libclntsh

[Former Member · Accepted solution]

Hi,

ORA-01019 unable to allocate memory in the user side

Cause: The user side memory allocator returned an error.

Action: Increase the size of the process heap or switch to the old set of calls.

Try to Patch ur kernel to the latest level or Increase ur virtual memory or the pblm with SGA

Regards

Umesh K

[Former Member · Accepted solution]

Hello Everyone

Thank you all for responding to the question. I have tried out all the suggestions before posting the thread and opened a message.

SAP Support has resolved the issue. The installation tool had created files with a different group for certain files. After dropping and recreating the dba group and reconfiguring the oracle home with this new group and permission, problem was resolved.

Thank you all

[Former Member]

hi,

sapnote no 400241 will be more usefull for ths issue.

with regards,

Harish Reddy

[fidel_vales]

Hi,

The note 400241 (Problems with ops$ or sapr3 connect to Oracle ) has nothing to do with the issue here (issue that is already closed) Can you explain? did you mean a different note?

Fidel

[Former Member]

Hello

I think you should launch the CHDBPASS utilities to (re)create the OPS$users.

Regards

François

[Former Member]

Hi

I think that SHLIB_PATH should point to /oracle/PRS/102_64/lib in prsadm env.

[Former Member]

Hi

I am sure its because of env variables. Please check whether you can access this directory /oracle/client/92x_64/ocommon/nls/admin/data

thanks

Prince

[Former Member]

Thanks for a response. The rights on /oracle/client/92x_64/ocommon/nls/admin/data is 777.

I have also downloaded oracle client OCL92064 (for 9.2.0.7) and installed it as specified in Note 886783 (section A and B-5).

[fidel_vales]

Hi,

Is this a database server or AS?

can you check the output of:

ldd /usr/sap/PRS/SYS/exe/run/dboraslib.so

[Former Member]

This is a DB server (Once Central Instace) DB + R/3 running on one host.

ldd dboraslib.so

libclntsh.so.9.0 => /oracle/client/92x_64/lib/libclntsh.so.9.0

libwtc9.so => /oracle/client/92x_64/lib/libwtc9.so

libc.so.1 => /usr/lib/hpux64/libc.so.1

libwtc9.so => /oracle/client/92x_64/lib/libwtc9.so

librt.so.1 => /usr/lib/hpux64/librt.so.1

libnss_dns.so.1 => /usr/lib/hpux64/libnss_dns.so.1

libdl.so.1 => /usr/lib/hpux64/libdl.so.1

libm.so.1 => /usr/lib/hpux64/libm.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libCsup.so.1 => /usr/lib/hpux64/libCsup.so.1

libunwind.so.1 => /usr/lib/hpux64/libunwind.so.1

libuca.so.1 => /usr/lib/hpux64/libuca.so.1