cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans CONNECT failed with sql error '1019'

Former Member
0 Kudos

Hi,

I am having this error executing R3trans –d…

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 33 0.031892

4 ETW000 [developertra,00000] Connecting as /@HCP on connection 0 ... 42 0.031934

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='HCP') 61 0.031995

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

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

Could you please assist me with this?

Thanks,

Iqbal

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

Please tell us your Oracle version and your R3trans version.

Are you in the process of upgrading to 10g?

--

Markus

Former Member
0 Kudos

I was on 9.05 and did the upgrade to 10G.

R3 46C

markus_doehr2
Active Contributor
0 Kudos

Do you have ORA_NLS33 set? If yes, to where does it point?

--

Markus

Former Member
0 Kudos

sorry, here is the R3 version...

This is tp version 305.13.23 (release 46D) for ANY database

Former Member
0 Kudos

This is R3trans version 6.05 (release 46D - 27.03.05 - 14:30:00).

markus_doehr2
Active Contributor
0 Kudos

Ok - so is your ORA_NLS33 set?

Former Member
0 Kudos

here is the env

NLS_LANG=AMERICAN_AMERICA.WE8DEC

COLUMNS=164

ORACLE_BASE=/oracle

EDITOR=vi

LOGNAME=SIDadm

dbs_ora_tnsname=SID

ORACLE_SID=SID

ERASE=^H

PS1=$HOST:$LOGNAME $PWD $

HOST=hcgwdd3

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

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

DISPLAY=10.16.10.86:0.0

dbs_ora_schema=SAPR3

SHELL=/bin/sh

SAPDATA_HOME=/oracle/SID

HOME=/home/SIDadm

TERM=hpterm

ORACLE_HOME=/oracle/SID/102_64

PWD=/home/SIDadm

TZ=PST8PDT

dbms_type=ORA

SAPSYSTEMNAME=SID

LINES=52

hcgwdd3:SIDadm /home/SIDadm $

markus_doehr2
Active Contributor
0 Kudos

Try to set ORA_NLS33 to you Oracle 9.2.0.7 client nls, e. g.

/oracle/client/9207/ocommon/nls/admin/data

and try again with R3trans

--

Markus

Former Member
0 Kudos

I added

ORA_NLS33=/oracle/SID/920_64/ocommon/nls/admin/data

And that fixed it

Again thanks so much, you are really good.

As you can tell, I am a novice at this. I have never seen so many errors.

Iqbal

markus_doehr2
Active Contributor
0 Kudos

Good that I was able to help

So many errors? where? smile

--

Markus

Former Member
0 Kudos

Thanks and i am SURE you will be hearing from me soon, if you dont, please do have a good weekend.

regards,

Iqbal

Answers (0)