Error in start SAP system

[Former Member]

Hi!

I have a SAP R/3 Enterprise 4.7 on oracle 10.2 (win 2003 server 64 bit). I turn off the machine for maintenance.

When I restart the machine the SAP instance not start. Then i start manually the service "OracleSVT102TNSListener" and I can make the logon but the instance is not star correctly (the icon is not green but yellow)!!!

In the following Lines there are the errors log(transaction SM21):

09:13:10 MS E10 Buffer SCSA Generated with Length 4096

09:13:10 MS Q01 Start Msg Server, 1 times since system startup. PID 1704

09:13:10 DP Q00 Start SAP System, SAPSYSTEM 00, Dispatcher PID 1612

09:13:15 DP GZZ > 1 possible network problems detected - check tracefile

09:13:16 DP Q0K Connection to message server (on testsapr3) established

09:13:16 WRK 00 Q0Q Start Workproc 0, PID 364

09:13:16 WRK 00 Q0Q Start Workproc 3, PID 788

09:13:16 WRK 00 Q0Q Start Workproc 1, PID 520

09:13:16 WRK 00 Q0Q Start Workproc 6, PID 524

09:13:16 WRK 00 Q0Q Start Workproc 7, PID 1564

09:13:16 WRK 00 Q0Q Start Workproc 4, PID 1812

09:13:16 WRK 00 Q0Q Start Workproc 5, PID 624

09:13:16 DP Q1C MsgServer Hardware ID Was Determined

09:13:16 WRK 00 Q0Q Start Workproc 2, PID 628

09:13:16 RD S00 SAP Gateway Started (PID: 208)

09:13:19 DIA 00 BY2 Database error 12541 at CON

09:13:19 BTC 05 BY2 Database error 12541 at CON

09:13:19 BTC 04 BY2 Database error 12541 at CON

09:13:19 UPD 02 BY2 Database error 12541 at CON

09:13:19 ENQ 03 BY2 Database error 12541 at CON

09:13:19 DIA 00 BY0 > ORA-12541: TNS:no listener

09:13:19 BTC 05 BY0 > ORA-12541: TNS:no listener

09:13:19 UPD 02 BY0 > ORA-12541: TNS:no listener

09:13:19 BTC 04 BY0 > ORA-12541: TNS:no listener

09:13:19 ENQ 03 BY0 > ORA-12541: TNS:no listener

09:13:19 BTC 05 BY2 Database error 12541 at CON

09:13:19 DIA 00 BY2 Database error 12541 at CON

09:13:19 UPD 02 BY2 Database error 12541 at CON

09:13:19 BTC 04 BY2 Database error 12541 at CON

09:13:19 ENQ 03 BY2 Database error 12541 at CON

09:13:19 BTC 05 BY0 > ORA-12541: TNS:no listener

09:13:19 UPD 02 BY0 > ORA-12541: TNS:no listener

09:13:19 DIA 00 BY0 > ORA-12541: TNS:no listener

09:13:19 BTC 04 BY0 > ORA-12541: TNS:no listener

09:13:19 ENQ 03 BY0 > ORA-12541: TNS:no listener

09:13:19 BTC 05 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 DIA 00 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 UPD 02 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 BTC 04 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 ENQ 03 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 ENQ 03 Q02 Stop Workproc 3, PID 788

09:13:19 BTC 04 Q02 Stop Workproc 4, PID 1812

09:13:19 UPD 02 Q02 Stop Workproc 2, PID 628

09:13:19 DIA 00 Q02 Stop Workproc 0, PID 364

09:13:19 BTC 05 Q02 Stop Workproc 5, PID 624

09:13:19 UP2 07 BY2 Database error 12541 at CON

09:13:19 SPO 06 BY2 Database error 12541 at CON

09:13:19 UP2 07 BY0 > ORA-12541: TNS:no listener

09:13:19 UP2 07 BY2 Database error 12541 at CON

09:13:19 SPO 06 BY0 > ORA-12541: TNS:no listener

09:13:19 SPO 06 BY2 Database error 12541 at CON

09:13:19 UP2 07 BY0 > ORA-12541: TNS:no listener

09:13:19 DIA 01 BY2 Database error 12541 at CON

09:13:19 SPO 06 BY0 > ORA-12541: TNS:no listener

09:13:19 DIA 01 BY0 > ORA-12541: TNS:no listener

09:13:19 DIA 01 BY2 Database error 12541 at CON

09:13:19 DIA 01 BY0 > ORA-12541: TNS:no listener

09:13:19 UP2 07 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 SPO 06 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 DIA 01 R19 Initialization DB-Connect Failed, Return Code 000256

09:13:19 UP2 07 Q02 Stop Workproc 7, PID 1564

09:13:19 SPO 06 Q02 Stop Workproc 6, PID 524

09:13:19 DIA 01 Q02 Stop Workproc 1, PID 520

09:14:11 RD S30 SAP gateway was closed

09:14:12 DP Q0M Message server disconnected

09:14:12 DP Q05 Stop SAP System, Dispatcher PID 16

[Former Member]

Hi Marco,

Check that the following service are in Automatic and of course started.

I guess SVT is your SID

OracleSVT102TNSListener

OracleServiceSVT

SAPSVT_xx

SAPOSCOL (not mandatory)

If so check if the connection is OK wit hthe database

lsnrctl status

tnsping SVT

These test should be OK

sqlplus "/as sysdba"

If you receive the msg "connect to an idel instance" --> start the database with "startup"

Then try again to start SAP

If the issue persist , send more details

Workprocess logs (get this details from the MMC ) or in usr/sap/SID/DVEBMSGSxx/work

Cheers

Yacine

[Former Member]

hi,

oracle service also check the SAPSERVICE and SAPOSCOL is running.

then try

regards

ajai

[Former Member]

Yes these service running..

When the machine is off there was a bakcup offline scheduled... maybe I stopped the backup...

[former_member204746]

<b>check if listener is running:</b>

lsnrctl status

<b>check if your DB is up:</b>

sqlplus "/ as sysdba"

startup

<b>check if you can connect to DB:</b>

r3trans -d