unable to connect to oracle

[Former Member]

hi all,

We are instaling SAP 4.6 c ,completed instaling database and now data base is up and running ,but we are unable to connect to data base ,below is the R3trans log....

platform : solaris10

oracle: 817

client : 920

SID: PRD

-

---

4 ETW000 R3trans version 6.05 (release 46D - 30.09.03 - 16:30:42).

4 ETW000 ===============================================

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 date&time : 15.10.2008 - 03:17:54

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

4 ETW000 [developertrace,0] Wed Oct 15 03:17:54 2008 239 0.000239

4 ETW000 [developertrace,0] db_con_init called 41 0.000280

4 ETW000 [developertrace,0] create_con (con_name=R/3) 99 0.000379

4 ETW000 [developertrace,0] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ...

4 ETW000 165 0.000544

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

4 ETW000 25165 0.025709

4 ETW000 [developertrace,0] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded

4 ETW000 37 0.025746

4 ETW000 [developertrace,0] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 120 0.025866

4 ETW000 [developertrace,0] Version of library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "46D.00", patchlevel (0.1663)

4 ETW000 396 0.026262

4 ETW000 [developertrace,0] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 33 0.026295

4 ETW000 [developertrace,0] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 72 0.026367

4 ETW000 [developertrace,0] New connection 0 created 27 0.026394

4 ETW000 [developertrace,0] db_con_connect (con_name=R/3) 83 0.026477

4 ETW000 [developertrace,0] find_con found the following connection for reuse:

4 ETW000 42 0.026519

4 ETW000 [developertrace,0] Got ORACLE_HOME=/oracle/PRD/817_64 from environment

4 ETW000 1126 0.027645

4 ETW000 [developertrace,0] -->oci_initialize 50 0.027695

4 ETW000 [developertrace,0] Got TNS_ADMIN=/oracle/PRD/817_64/network/admin from environment

4 ETW000 36 0.027731

4 ETW000 [developertrace,0] Got ORACLE_SID=PRD from environment

4 ETW000 21 0.027752

4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 23 0.027775

4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password

4 ETW000 21 0.027796

4 ETW000 [developertrace,0] Connecting as /@PRD on connection 0 ...

4 ETW000 21 0.027817

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='PRD')

4 ETW000 86 0.027903

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

4 ETW000 1610 0.029513

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

4 ETW000 46 0.029559

4 ETW000 [developertrace,0] Try to connect with default password

4 ETW000 22 0.029581

4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@PRD on connection 0 ...

4 ETW000 23 0.029604

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='PRD')

4 ETW000 20 0.029624

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

4 ETW000 72 0.029696

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

4 ETW000 25 0.029721

4 ETW000 [developertrace,0] Got TNS_ADMIN=/oracle/PRD/817_64/network/admin from environment

4 ETW000 74 0.029795

4 ETW000 [developertrace,0] Got ORACLE_SID=PRD from environment

4 ETW000 21 0.029816

4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 20 0.029836

4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password

4 ETW000 20 0.029856

4 ETW000 [developertrace,0] Connecting as /@PRD on connection 0 ...

4 ETW000 19 0.029875

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='PRD')

4 ETW000 28 0.029903

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

4 ETW000 59 0.029962

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

4 ETW000 23 0.029985

4 ETW000 [developertrace,0] Try to connect with default password

4 ETW000 19 0.030004

4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@PRD on connection 0 ...

4 ETW000 20 0.030024

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='PRD')

4 ETW000 20 0.030044

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

4 ETW000 52 0.030096

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

4 ETW000 30 0.030126

4 ETW000 [dblink ,627] ***LOG BY2=>sql error 1019 performing CON

4 ETW000 86 0.030212

4 ETW000 [dblink ,627] ***LOG BY0=> 15 0.030227

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

-

---

i suspect the problem is with env

geecc:prdadm> env

DB_SID=PRD

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

HOME=/export/home/prdadm

HZ=100

LOGNAME=prdadm

MAIL=/var/mail/prdadm

NLS_LANG=AMERICAN_AMERICA.WE8DEC

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/PRD/817_64

ORACLE_PSRV=PRD

ORACLE_SID=PRD

ORA_NLS33=/oracle/PRD/817_64/ocommon/nls/admin/data

PATH=/usr/sap/PRD/SYS/exe/run:/usr/bin:/usr/local/sbin:/usr/ccs/bin:/usr/ucb

PS1=geecc:prdadm>

SAPDATA_HOME=/oracle/PRD

SAPSYSTEMNAME=PRD

SHELL=/bin/sh

TERM=vt100

TNS_ADMIN=/oracle/PRD/817_64/network/admin

TZ=US/Eastern

dbms_type=ORA

dbs_ora_schema=SAPR3

dbs_ora_tnsname=PRD

env for oraprd

geecc:oraprd 1% env

HOME=/oracle/PRD

PATH=/oracle/PRD/817_64/bin:/oracle/PRD:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

LOGNAME=oraprd

HZ=100

TERM=vt100

SHELL=/usr/bin/csh

MAIL=/var/mail/oraprd

TZ=US/Eastern

PWD=/oracle/PRD/saptrace/background

USER=oraprd

SAPSYSTEMNAME=PRD

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

LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/PRD/817_64/lib64:/sapmnt/PRD/exe:/oracle/PRD/817_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PRD

dbs_ora_schema=SAPR3

ORACLE_PSRV=PRD

ORACLE_SID=PRD

ORACLE_HOME=/oracle/PRD/817_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/PRD/817_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/PRD

JAVA_HOME=/usr/jdk/instances/1.1.8

DB_SID=PRD

TNS_ADMIN=/oracle/PRD/817_64/network/admin

-

---

Thanks,

Srikanth.

i

[markus_doehr2]

We are instaling SAP 4.6 c ,completed instaling database and now data base is up and running ,but we are unable to connect to data base ,below is the R3trans log....

platform : solaris10

oracle: 817

client : 920

SID: PRD

This doesn´t work. You can´t use a client version higher than the database version. On top, Oracle 8.1.7 is LONG out of support and is not supported under Solaris 10.

Get a new installation CD set with Oracle 10g for 4.6c (Oracle 9.2 is also out of support).

Markus

[Former Member]

Hello,

1.Check whether oracle listener is up and running

2.At SQL level try to connect DB

SAPR3/<pwd>@PRD and see whether the DB is up and running

[stefan_koehler]

Hello Srikanth,

the problem is the following:

> 4 ETW000 http://dboci.c ,0 *** ERROR => OCI-call 'olog' failed: rc = 1019

Please check the following sapnote and compare it with your system: #121004

Regards

Stefan