Getting error 1019 in R3trans -x

[Former Member]

Folks,

I am getting following message when doing R3trans -d.

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

4 ETW000 [developertra,00000] Connecting as /@DEV on connection 0 ... 54 0.060549

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='DEV') 66 0.060615

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

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

4 ETW000 69 0.066535

4 ETW000 [developertra,00000] Try to connect with default password 29 0.066564

We have done oracle upgrade from 9.2 to 10.2.0.2

env of SIDadm

_=/usr/bin/env

THREAD=NOPS

ORACLE_PSRV=DEV

SSH_TTY=/dev/pts/1

PATH=/oracle/DEV/102_64/bin:/usr/sap/DEV/SYS/exe/run:/usr/bin:/usr/ucb:/etc:.:/usr/ccs/bin

NLS_LANG=AMERICAN_AMERICA.WE8DEC

DMS_PATH=/opt/CA/SharedComponents/dmscript

ORACLE_BASE=/oracle

EDITOR=vi

LOGNAME=devadm

MAIL=/var/mail//devadm

dbs_ora_tnsname=DEV

ORACLE_SID=DEV

PS1=cap-dev-sap1:devadm>

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

ORA_NLS=/oracle/DEV/920_64/ocommon/NLS_723/admin/data

USER=devadm

dbs_ora_schema=SAPR3

SHELL=/bin/ksh

SAPDATA_HOME=/oracle/DEV

ORA_NLS32=/oracle/DEV/920_64/ocommon/NLS_733/admin/data

ORA_NLS33=/oracle/TST/102_64/nls/data

HOME=/export/home/devadm

TERM=vt100

LD_LIBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/oracle/DEV/102_64/lib64

ORACLE_HOME=/oracle/DEV/102_64

PWD=/export/home/devadm

TZ=GB

dbms_type=ORA

SAPSYSTEMNAME=DEV

Cheers,

-Sunil

[Former Member · Accepted solution]

Hello,

You have an issue with the client.

The fist question would be to know what is your kernel version, this is necessary to know the client to be used.

This:

LD_LIBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/oracle/DEV/102_64/lib64

is <u>wrong</u>.

The recommendation is to add the path to the oracle instantclient NOT the path to the $ORACLE_HOME

This:

ORA_NLS33=/oracle/TST/102_64/nls/data

is also <u>WRONG</u>

As you mentioned that you upgraded Oracle ( no mention to SAP ) I have to assume that you have a kernel that uses 9i client.

ORA_NLS33 is used by this client an you have changed it to point to the Oracle 10g software wich is incorrect.

Have you followed properly the 10g upgrade guide?

I recommend the following

1) install the oracle client 9.2.0.7 or 9.2.0.8 ( required if you use a kernel < 700 )

2) adjust the environent variables as indicated on the notes

1017418 Installing Oracle 9208 Client software on UNIX

or

886783 Installing Oracle 9207 Client Software on UNIX

and

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

ORA_NLS10 does NOT have to be set for <sid>adm

[Former Member]

Hello Sunil,

Please check OSS notes:

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

Note 566051 - Error due to missing oracore directory

Also please check the thread:

This looks closely related to your issue though it is for mutiple SAP instance on one host scenario. In that case it suggests OSS note 964783 .

Regards.

Ruchit.

Message was edited by:

Ruchit Khushu

[Former Member]

Hello Ruchit,

I do not think so this problem is becuase of OPS$.

oracore directory is available and our is only single server (no Application server)

our is single SID oracle installation.

Cheers,

-Sunil

[Former Member]

Hi Sunil,

Check this OSS note 830578 for env. variables.

Additionally the oracle upgrade guide suggests that following enviormnment variables should not be set:

ORA_NLS

ORA_NLS32

ORA_NLS33

Instead the following should be set :

ORA_NLS10 with value $ORACLE_HOME/nls/data

Regards.

Ruchit.