cancel
Showing results for 
Search instead for 
Did you mean: 

SAP System not starting

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

hii jhon how did u answers this question

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Guru's

Any update on this

Thanks & Regards

Former Member
0 Kudos

Hi John,

Why dbs_ora_schema=SAPSR3 ?

Shouldn't it be SAPQA1?

-Pinkle

Former Member
0 Kudos

Also check whether enviroment variables related to database are correctly maintain.

-Pinkle

JPReyes
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Have you tried to connect to oracle via listener like sqlplus system/manager@QA1 ?

We had similar problem when we upgraded 9i to 10g, SAP 4.6C is still using client 9 and that was the problem it was not able to connect via client 10.