cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Not able to start or stop database using startsap and stopsap command

Go to solution
Former Member

on ‎06-04-2008 2:03 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

fidel_vales
Employee
Employee
‎06-04-2008 2:38 PM
0 Kudos

Hi,

Probably you will have to rephrase this:

> I check the listener status from sidadm user its showing up.

because the error is:

> 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

so

1) how did you check the listener?

2) show/attach here the output of "lsnrctl status"

3) show/attach here the tnsnames.ora

Show replies
Show replies
Former Member
‎06-04-2008 3:15 PM
0 Kudos

Hi

Here is command for check the listener status which i used.

**************************************************************************************************************************************

vbiwprd:vbpadm 1> lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 04-JUN-2008 19:28:34

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=VBP.WORLD))

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production

Start Date 03-JUN-2008 18:15:50

Uptime 1 days 1 hr. 12 min. 43 sec

Trace Level off

Security ON: Local OS Authentication

SNMP ON

Listener Parameter File /oracle/VBP/102_64/network/admin/listener.ora

Listener Log File /oracle/VBP/102_64/network/log/listener.log

Listening Endpoints Summary...

**************************************************************************************************************************************

And here is tnsnames.ora file

**************************************************************************************************************************************

bash-3.00# cat /oracle/VBP/102_64/network/admin/tnsnames.ora

  1. tnsnames.ora Network Configuration File: /oracle/VBP/102_64/network/admin/tnsnames.ora

  2. Generated by Oracle configuration tools.

######################################################

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

######################################################

LISTENER_VBP.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = vbiwprd)(PORT = 1527))

VBP.WORLD =

(DESCRIPTION =

(sdu = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = vbiwprd)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = VBP)

(GLOBAL_NAME = VBP.WORLD)

)

)

VBP_STBY.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = vdbiwprd)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = VBP)

(GLOBAL_NAME = VBP.WORLD)

)

)

**************************************************************************************************************************************

Regards

Vishal

fidel_vales
Employee
Employee
‎06-04-2008 3:34 PM
0 Kudos

Hi,

your configuration does not match.

Your listener seems to be only checking for IPC connections:


vbiwprd:vbpadm 1> lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 04-JUN-2008 19:28:34

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=VBP.WORLD))
STATUS of the LISTENER

but your tnsnames is only configured for TCP connections:


LISTENER_VBP.WORLD =
  (ADDRESS = (COMMUNITY = SAP.WORLD) *(PROTOCOL = TCP)* (HOST = vbiwprd)(PORT = 1527))

VBP.WORLD =
        (DESCRIPTION =
                (sdu = 32768)
                (ADDRESS_LIST =
                        (ADDRESS =
                                (COMMUNITY = SAP.WORLD)
                                *(PROTOCOL = TCP)*
                                (HOST = vbiwprd)
                                (PORT = 1527)
                        )

Former Member
‎06-04-2008 3:43 PM
0 Kudos

Hi

Sorry the out put of lsnrctl status is not copied properly

it as follows

vbiwprd:vbpadm 1> lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 04-JUN-2008 20:12:34

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=VBP.WORLD))

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production

Start Date 03-JUN-2008 18:15:50

Uptime 1 days 1 hr. 56 min. 43 sec

Trace Level off

Security ON: Local OS Authentication

SNMP ON

Listener Parameter File /oracle/VBP/102_64/network/admin/listener.ora

Listener Log File /oracle/VBP/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VBP.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VBP)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vbiwprd)(PORT=1527)))

Services Summary...

Service "VBP" has 2 instance(s).

Instance "VBP", status UNKNOWN, has 1 handler(s) for this service...

Instance "VBP", status READY, has 1 handler(s) for this service...

Service "VBP.WORLD" has 1 instance(s).

Instance "VBP", status READY, has 1 handler(s) for this service...

Service "VBP_XPT" has 1 instance(s).

Instance "VBP", status READY, has 1 handler(s) for this service...

The command completed successfully

Regards

Vishal

fidel_vales
Employee
Employee
‎06-05-2008 9:11 AM
0 Kudos

Hi,

curious, configuration seems OK.

Can you tell the location of the tnsnames you posted here and the environment variables for the user that gets the error?

Former Member
‎06-09-2008 9:40 AM
0 Kudos

Hi

The problem of startsap and stopsap is solved.

Solution is When i start the listener from <sid>adm user and then i run startsap command then it will start the database also but if i start the listener from ora<sid> then i run startsap command from <sid>adm user then it will give error to start database in that case i have to start the database manually.

If any one know why this is happen please let me know.

Regards

Vishal

fidel_vales
Employee
Employee
‎06-09-2008 11:50 AM
0 Kudos

Hello

That seems to be a problem with the oracle binary authorizations.

check note 583861

Answers (2)

Answers (2)

Former Member
‎06-07-2008 11:18 AM
0 Kudos

Hi,

Also check what is the output of command R3trans -d.

If its finishing with return code 12... then look for the trans.log file in the location where you have executed R3trans -d.

Check and post if any effor is shown in the file.

Thanks and Regards,

Amit Jana.

Show replies
Show replies
Former Member
‎06-05-2008 5:28 PM
0 Kudos

Check your listener.ora file.

It should look like this.

################

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER_ABC1 = on

LISTENER_ABC1 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = ABC1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = ABC1)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = abc1db01)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER_ABC1 = 0

CONNECT_TIMEOUT_LISTENER_ABC1 = 10

TRACE_LEVEL_LISTENER_ABC1 = OFF

SID_LIST_LISTENER_ABC1 =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = ABC1)

(ORACLE_HOME = /oracle/ABC1/920_64)

)

)

Show replies
Show replies
Ask a Question