Not able to start or stop database using startsap and stopsap command
Hi when i run the command startsap or stopsap with sidadm user in BIW server it will not stop the database or not start the database through the script .
Then i have to manually start or stop the database using orasid user.
I check the listener status from sidadm user its showing up.
Log of startdb.log and stopdb.log is as follows.
Startdb.log
**************************************************************************************************************
bash-3.00# cat startdb.log
-
Tue Jun 3 17:51:50 IST 2008
LOGFILE FOR STARTING ORACLE
Trying to start VBP database ...
-
Tue Jun 3 17:51:50 IST 2008
checking required environment variables
ORACLE_HOME is >/oracle/VBP/102_64<
ORACLE_SID is >VBP<
-
Tue Jun 3 17:51:50 IST 2008
check initora
-
Tue Jun 3 17:51:50 IST 2008
check initora
-
Tue Jun 3 17:51:50 IST 2008
checking V2 connect
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 03-JUN-2008 17:51:50
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/VBP/102_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (sdu = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (
HOST = vbiwprd) (PORT = 1527))) (CONNECT_DATA = (SID = VBP) (GLOBAL_NAME = VBP.WORLD)))
TNS-12541: TNS:no listener
V2 connect is not available. Terminating
/usr/sap/VBP/SYS/exe/run/startdb: Terminating with error code 14
*******************************************************************************************************************************************************
Stopdb.log
********************************************************************************************************************************************************
bash-3.00# cat stopdb.log
-
Tue Jun 3 17:24:20 IST 2008
LOGFILE FOR STOPPING ORACLE
Trying to stop VBP database ...
-
Tue Jun 3 17:24:20 IST 2008
checking required environment variables
ORACLE_HOME is >/oracle/VBP/102_64<
ORACLE_SID is >VBP<
-
Tue Jun 3 17:24:20 IST 2008
Connect to the database to check the database state:
R3trans check finished with return code: 12
There is no database connect possible -
Database is probably already stopped.
-
Tue Jun 3 17:24:20 IST 2008
checking V2 connect
**************************************************************************************************************************************************
If any one have any ideea what should i check for this please tell me
Regards
Vishal