Skip to Content
0
Former Member
Jan 10, 2008 at 09:15 AM

SAP System not starting

68 Views

Hi to everybody, Please, Need help

SAP System not starting, getting the below messages

qa1adm> startsap

Checking QA1 Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


open logfile '/usr/sap/tmp/dev_coll.tmp' failed... use stderri

03:03:45 10.01.2008 ERROR: cannot open log file /usr/sap/tmp/dev_coll.tmp

03:03:45 10.01.2008 ERROR: Make sure directory /usr/sap/tmp exists or specify DIR_PERF

03:03:45 10.01.2008 ERROR: in profile and run saposcol pf=<profile>

saposcol already running

ABAP Database QA1 must be started on remote server

Database (Oracle) is online

SQL> select name,open_mode,log_mode from v$database;

NAME OPEN_MODE LOG_MODE

-


-


QA1 READ WRITE ARCHIVELOG

SQL>

R3trans –d

qa1adm> R3trans -d

This is R3trans version 6.14 (release 700 - 11.01.07 - 17:32:00).

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

R3trans finished (0012).

Listener status

qa1adm> lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 10-JAN-2008 03:45:13

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sym280r-sym14)(PORT=1521)))

STATUS of the LISTENER

-


Alias LISTENER

Version TNSLSNR for Solaris: Version 10.2.0.2.0 - Production

Start Date 07-JAN-2008 02:30:24

Uptime 3 days 1 hr. 14 min. 49 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/QA1/102_64/network/admin/listener.ora

Listener Log File /oracle/QA1/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sym280r-sym14)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "QA1" has 1 instance(s).

Instance "QA1", status READY, has 1 handler(s) for this service...

Service "QA1_XPT" has 1 instance(s).

Instance "QA1", status READY, has 1 handler(s) for this service...

The command completed successfully

-


Please need the help

Thanks and Regards

Bhaskar