on 10-15-2008 7:01 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.