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