Visit our Google Group Way 2 SAP BASIS

Database is not available via /usr/sap/DV1/SYS/exe/run/R3tr

Moderators: BASIS24x7, Rashed

Database is not available via /usr/sap/DV1/SYS/exe/run/R3tr

Postby Lokeshwar »

Hi All

1) when I am executing startsap command getting the following error:

Starting SAP-Collector Daemon
------------------------------
04:44:25 18.03.2009 WARNING: Effective userid not root! Expect problems
***********************************************************************
* This is Saposcol Version COLL 20.76 02/02/20 46D - V3.1
* Usage: saposcol -l: Start OS Collector
* saposcol -k: Stop OS Collector
* saposcol -d: OS Collector Dialog Mode
* saposcol -s: OS Collector Status
* The OS Collector is already running .....
************************************************************************
saposcol already running

Checking SAP R/3 DV1 Database
------------------------------
Database is not available via /usr/sap/DV1/SYS/exe/run/R3trans -d -w
Starting SAP R/3 DV1 Database
------------------------------
Startup-Log is written to /home/dv1adm/startdb.log
Database startup failed!
See /home/dv1adm/startdb.log for details


2) The startdb.log details are as follows:

------------------------------ Wed Mar 18 05:15:57 CDT 2009
LOGFILE FOR STARTING SAP DB


------------------------------ Wed Mar 18 05:15:57 CDT 2009
checking required environment variables

DBNAME is >DV1<
DBROOT is >/sapdb/sapdb/DV1/db<

------------------------------ Wed Mar 18 05:15:57 CDT 2009
starting vserver

ERROR 10107: Socket address already in use, probably a vserver is running!

------------------------------ Wed Mar 18 05:15:57 CDT 2009
Connect to the database to check the database state:

R3trans: connect check finished with return code: 12
Database not available

------------------------------ Wed Mar 18 05:15:57 CDT 2009
starting database

Error! Connection failed to node enterprise for database DV1: database or server
nout found
Error! Connection failed to node enterprise for database DV1: database or server
nout found
Restart Database ...
Error! Connection failed to node enterprise for database DV1: database or server
nout found

------------------------------ Wed Mar 18 05:15:58 CDT 2009
Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12
*** ERROR: Restart of database failed
Notify Database Administrator.

------------------------------ Wed Mar 18 05:15:58 CDT 2009
/usr/sap/DV1/SYS/exe/run/startdb: Terminating with error code 2

3) Then i have executed R3trans -d then found the following:

enterprise:dv1adm 50% R3trans -d
This is R3trans version 6.05 (release 46D - 14.11.02 - 13:59:00).
2EETW000 function sql_info() in twsql.c not complete for DBMS NOT SET

2EETW169 no connect possible: "unknown DBMS NOT SET - n
ot supported by R3trans"
R3trans finished (0012).


4) The trans.log details are as follows:

enterprise:dv1adm 42% cat trans.log
4 ETW000 R3trans version 6.05 (release 46D - 14.11.02 - 13:59:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 date&time : 18.03.2009 - 04:17:07
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [developertrace,0] Wed Mar 18 04:17:07 2009 801 0.000801
4 ETW000 [developertrace,0] db_con_init called 92 0.000893
4 ETW000 [developertrace,0] create_con (con_name=R/3) 229 0.001122
4 ETW000 [developertrace,0] Loading DB library '/usr/sap/DV1/SYS/exe/run/dbadas
lib.so' ...
4 ETW000 219 0.001341
4 ETW000 [developertrace,0] load shared library (/usr/sap/DV1/SYS/exe/run/dbada
slib.so), hdl 0
4 ETW000 85949 0.087290
4 ETW000 [developertrace,0] Library '/usr/sap/DV1/SYS/exe/run/dbadaslib.so' loa
ded
4 ETW000 121 0.087411
4 ETW000 [developertrace,0] function DbSlExpFuns loaded from library /usr/sap/D
V1/SYS/exe/run/dbadaslib.so
4 ETW000 388 0.087799
4 ETW000 [developertrace,0] Version of library '/usr/sap/DV1/SYS/exe/run/dbadas
lib.so' is "46D.00", patchlevel (0.1373)
4 ETW000 755 0.088554
4 ETW000 [developertrace,0] function dsql_db_init loaded from library /usr/sap/
DV1/SYS/exe/run/dbadaslib.so
4 ETW000 127 0.088681
4 ETW000 [developertrace,0] function dbdd_exp_funs loaded from library /usr/sap
/DV1/SYS/exe/run/dbadaslib.so
4 ETW000 30674 0.119355
4 ETW000 [developertrace,0] New connection 0 created 86 0.119441
4 ETW000 [developertrace,0] INFO : SAP DB statement length = 28672
4 ETW000 416 0.119857
4 ETW000 [developertrace,0] INFO : SAP DB MAX_IN_CNT = 254
4 ETW000 190 0.120047
4 ETW000 [developertrace,0] db_con_connect (con_name=R/3) 144 0.120191
4 ETW000 [developertrace,0] find_con found the following connection for reuse:
4 ETW000 106 0.120297
4 ETW000 [developertrace,0] Begin DbSlConnect to database SAPDB
4 ETW000 602 0.120899
4 ETW000 [developertrace,0] DBADASLIB : version 46D.00, patch 1385
4 ETW000 94 0.120993
4 ETW000 [developertrace,0] SQLADIAG=ada_w8832.dia 3611 0.124604
4 ETW000 [developertrace,0] INFO : SQLOPT= -d DV1 -I 0 -t 0
4 ETW000 153 0.124757
4 ETW000 [developertrace,0] Precompiler Runtime : C-PreComp 7.1.4 Build 043-
000-059-170
4 ETW000 4047 0.128804
4 ETW000 [developertrace,0] Precompiler runtime is SAP DB 7.1.4.043
4 ETW000 188 0.128992
4 ETW000 [dbslada.,0] *** ERROR => Connect to database failed : sqlcode=-709 (C
ONNECT: (database not running))
4 ETW000 4007 0.132999
4 ETW000 [developertrace,0] Begin DbSlConnect to database SAPDB
4 ETW000 411 0.133410
4 ETW000 [developertrace,0] SQLADIAG=ada_w8832.dia 134 0.133544
4 ETW000 [developertrace,0] INFO : SQLOPT= (set by environment)
4 ETW000 106 0.133650
4 ETW000 [developertrace,0] INFO : SQLOPT= -d DV1 -I 0 -t 0
4 ETW000 101 0.133751
4 ETW000 [developertrace,0] Precompiler Runtime : C-PreComp 7.1.4 Build 043-
000-059-170
4 ETW000 127 0.133878
4 ETW000 [developertrace,0] Precompiler runtime is SAP DB 7.1.4.043
4 ETW000 176 0.134054
4 ETW000 [dbslada.,0] *** ERROR => Connect to database failed : sqlcode=-807 (C
ONNECTION DOWN ()
4 ETW000 275 0.134329
4 ETW000 [dblink ,627] ***LOG BY2=>sql error -807 performing CON
4 ETW000 314 0.134643
4 ETW000 [dblink ,627] ***LOG BY0=> 67 0.134710
2EETW000 function sql_info() in twsql.c not complete for DBMS NOT SET

2EETW169 no connect possible: "unknown DBMS NOT SET - n
ot supported by R3trans"


Regards,
Lokesh.
Lokeshwar
 
Posts: 1



Return to SAP DBA Forum

Who is online

Users browsing this forum: No registered users and 1 guest

Visit our Google Group Way 2 SAP BASIS
cron