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