on 01-10-2008 9:15 AM
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
hii jhon how did u answers this question
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bidwan Baruah, Thanks for you reply.
R3trans -d console output
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).
qa1adm>
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pinkel,
This installation done by my client, i don't much about it. But previously (even last week also) i started the system and worked fine.
Thanks & Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. Please paste the log file of R3trans -d.
2. The default work directory of saposcol is usr/sap/tmp or (if this does not exist) /tmp. So it tries to check that. Another option is create a directory say my_saposcol_dir in say /usr sap and create a file saposcol.pfl in say profile(/usr/sap/<SID>/SYS/profile) directory. This file should contain,
DIR_PERF = /usr/sap/my_saposcol_dir
and a blank line to end.
Then call
saposcol -l pf=/usr/sap/<SID>/SYS/profile/saposcol.pfl
Hi Guru's
Any update on this
Thanks & Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also check whether enviroment variables related to database are correctly maintain.
-Pinkle
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
R3trans is failing to connect the Orecle DB, also saposcol is failing to start but that's not critical.
Try to stop and start the DB and check that the DB is mounting properly, also restart the listener; then do and R3trans -d again.
Let me know what happen.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Juan / Pinkle, Thank you very much
i executed like below , still not starting
console outputs
SQL> select name,open_mode,log_mode from v$database;
NAME OPEN_MODE LOG_MODE
-
-
-
QA1 READ WRITE ARCHIVELOG
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
-
qa1adm> ORACLE_SID=QA1
qa1adm> export ORACLE_SID
qa1adm> echo $ORACLE_SID
QA1
qa1adm> sqlplus " / as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 10 05:11:00 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 616562688 bytes
Fixed Size 2030912 bytes
Variable Size 318767808 bytes
Database Buffers 293601280 bytes
Redo Buffers 2162688 bytes
Database mounted.
SQL>
SQL> alter database open;
Database altered.
SQL> select name,open_mode,log_mode from v$database;
NAME OPEN_MODE LOG_MODE
-
-
-
QA1 READ WRITE ARCHIVELOG
SQL>
-
oraqa1> lsnrctl status
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 10-JAN-2008 05:22:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sun280r-rtp14)(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 2 hr. 52 min. 27 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=sun280r-rtp14)(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...
The command completed successfully
oraqa1> lsnrctl stop
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 10-JAN-2008 05:23:08
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sun280r-rtp14)(PORT=1521)))
The command completed successfully
oraqa1>
-
oraqa1> lsnrctl status
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 10-JAN-2008 05:28:12
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sun280r-rtp14)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory
oraqa1> lsnrctl start
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 10-JAN-2008 05:28:18
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /oracle/QA1/102_64/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
System parameter file is /oracle/QA1/102_64/network/admin/listener.ora
Log messages written to /oracle/QA1/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sun280r-rtp14)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sun280r-rtp14)(PORT=1521)))
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
Start Date 10-JAN-2008 05:28:19
Uptime 0 days 0 hr. 0 min. 0 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=sun280r-rtp14)(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...
The command completed successfully
oraqa1>
-
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).
qa1adm>
-
qa1adm> env
DB_SID=QA1
DIR_LIBRARY=/usr/sap/QA1/SYS/exe/run
HOME=/home/qa1adm
HZ=100
JAVA_HOME=/usr/java
LD_LIBRARY_PATH=/usr/sap/QA1/SYS/exe/run:/oracle/client/10x_64/instantclient
LOGNAME=qa1adm
NLS_LANG=AMERICAN_AMERICA.WE8DEC
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/QA1/102_64
ORACLE_SID=QA1
PATH=/oracle/QA1/102_64/bin:/usr/java/bin:.:/home/qa1adm:/usr/sap/QA1/SYS/exe/run:/usr/bin::/usr/ccs/bin:/usr/ucb
PS1=
qa1adm>
SAPDATA_HOME=/oracle/QA1
SAPSYSTEMNAME=QA1
SHELL=/bin/sh
TERM=xterm
THREAD=NOPS
TNS_ADMIN=/usr/sap/QA1/SYS/profile/oracle
TZ=US/Eastern
dbms_type=ORA
dbs_ora_schema=SAPSR3
dbs_ora_tnsname=QA1
-
qa1adm> cd /usr/sap/QA1/SYS/exe/run
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
05:30:26 10.01.2008 ERROR: cannot open log file /usr/sap/tmp/dev_coll.tmp
05:30:26 10.01.2008 ERROR: Make sure directory /usr/sap/tmp exists or specify DIR_PERF
05:30:26 10.01.2008 ERROR: in profile and run saposcol pf=<profile>
saposcol already running
ABAP Database QA1 must be started on remote server
-
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).
qa1adm>
-
Thanks & Regards
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.