Skip to Content
0
Former Member
Oct 24, 2014 at 12:18 PM

Problem with start of DB in distributed environment

299 Views

Hi all,

I hope someone can help me.

We have a problem with the startup of our sap instances when the database is running on another node.

The problem is, that the startdb doesn't find the remote database and start the database local on the node.

I have a flexframe infrastructure and all sap instances are single services like db, scs, ci, app

The Flexframe starts the services step by step in the correct sequence.

In the first step flexframe starts the database on the remote host correctly and

in the next step flexframe starts the ci.

In the protocols I find the successfull checks with R3Trans and TNSPING.

In the step "sapcontrol starts the instance" is implemented a wait of 10 seconds.

During this windows the startdb-script is running.

The tnsnames adapter resolves the alias correct.

After that step the function "check_db_running"

is running and this function starts the database local.

At the moment we stop the unconnected database-instance and the system works without any problems.

Here the protocols:

The startsap.trc has following infos:

}09:40:47 ## restore_path() done

EXEDIR=/usr/sap/SID/DVEBMGS00/exe

EXECMD=/usr/sap/SID/DVEBMGS00/exe/R3trans

}09:40:47 ## getExePath() done: 0

DBCONNECT_TEST=/usr/sap/SID/DVEBMGS00/exe/R3trans -d -w

...

}09:40:48 ## restore_path() done

Database is running

DB_RUNNING=1

JDB_RUNNING=

}09:40:48 ## set_db_running() done: 1

{09:40:48 ## set_sapjdbhost() start

....

}09:41:02 ## sapstartsrv_do() done: 0

starting SAP Instance DVEBMGS00

Startup-Log is written to /home_sap/sidadm/startsap_DVEBMGS00.log

/usr/sap/SID/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start

wait sleep 10 while instance is starting

Instance on host hostname started

}09:41:14 ## instance_do() done


_______________________________

STARTDB.LOG

------------------------------ Thu Oct 23 09:41:03 CEST 2014

checking V2 connect

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-OCT-2014 09:41:03

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:

/sapmnt/SID/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = xxxx)(PORT = x

)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SID)))

OK (0 msec)

tnsping: V2 connect to SID

------------------------------ Thu Oct 23 09:41:03 CEST 2014

Connect to the database to check the database state:

-------------------------------------------------------------

Thu Oct 23 09:41:03 CEST 2014

check if Oracle processes are running

database not available

There are no Oracle processes running -

Database is probably already stopped.

check_db_running: check finished with return code: 10

Database not available

____________

Has anybody an idea where is my problem?

Best regards

Peter