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: 

ORA-12560: TNS:protocol adapter error error while using BR*tools

Go to solution
Former Member

on ‎02-19-2009 7:45 PM

0 Kudos

Hi,

I am trying to use BRtools to display instance status (option 6 within Instance Management menu). We are running on Oracle 10g and SAP 4.6c (BRtools version 7.0 patch 13). SAP is running on Windows 2003 cluster environment.

I checked lsnrctl status with following output..

LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 19-FEB-200

:06

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

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=172.20.0.

PORT=1527))

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 10.2.0.2.0

ction

Start Date 07-FEB-2009 19:51:03

Uptime 11 days 19 hr. 42 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\oracle\PR1\102\network\admin\listener.ora

Listener Log File C:\oracle\PR1\102\network\log\listener.log

Listening Endpoints Summary...

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

The listener supports no services

The command completed successfully

BRspace error reads as below

BR1001I BRSPACE 7.00 (13)

BR1002I Start of BRSPACE processing: sdzysjut.dbw 2009-02-19 15.35.43

BR0280I BRSPACE time stamp: 2009-02-19 15.35.44

BR0301E SQL error -12560 at location BrDbaConnect-2

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance PR1 failed

BR0700E Fatal errors occurred - terminating processing...

Could you please let me know if I need to make any changes to current configuration to make it work.

I appreciate all your help,

Thanks,

Jitendra

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎02-22-2009 11:29 AM
0 Kudos

Hello,

just to be sure: are you using 32 or 64 Bit brtools (you mentioned that the system was migrated)?. I have seen errors like these when trying to use 32 Bit executables against a 64 Bit database.

Best Regards,

Michael

Show replies
Show replies
Former Member
‎02-22-2009 2:24 PM
0 Kudos

It started working after I made changes to windows environment variable LOCAL=<SID>. Thanks for all your help.

Edited by: Jitendra Kulkarni on Feb 22, 2009 3:25 PM

Answers (2)

Answers (2)

Former Member
‎02-22-2009 2:30 PM
0 Kudos

Made changes to Listener.ora file and set the environment LOCAL=<SID>

Show replies
Show replies
Former Member
‎02-24-2009 11:38 AM
0 Kudos

What changes you did in listener.ora file...

did you change the port or else any thing..

please ...suggest..

Former Member
‎02-24-2009 2:04 PM
0 Kudos

I didn't change the port. Earlier following section was missing. You can find the latest contents in my earlier reply which also contains following section after I made changes to listener file.

Fsldbprd =

(ADDRESS_LIST=

(ADDRESS=

(PROTOCOL=IPC)

(KEY=PR1)

)

(ADDRESS=

(PROTOCOL=IPC)

(KEY=PR1.WORLD)

)

(ADDRESS=

(COMMUNITY=SAP.WORLD)

(PROTOCOL=TCP)

(Host=xxx.xx.x.xxx)

(Port=1527)

)

)

Former Member
‎02-19-2009 9:07 PM
0 Kudos

Hello Jitendra,

there is a problem with listener file that you have configured

make sure u have mentioned the SID of your SAP system in the file.

Please check else post the lisener file

Rohit

Show replies
Show replies
Former Member
‎02-19-2009 10:06 PM
0 Kudos

Hi Rohit,

Here are my listener file contents

LISTENER =

(ADDRESS_LIST=

(ADDRESS=

(PROTOCOL=IPC)

(KEY=PR1)

)

(ADDRESS=

(PROTOCOL=IPC)

(KEY=PR1.WORLD)

)

(ADDRESS=

(COMMUNITY=SAP.WORLD)

(PROTOCOL=TCP)

(Host=xxx.xx.x.xxx)

(Port=1527)

)

)

SID_LIST_LISTENER =

(SID_LIST=

(SID_DESC=

(SDU=32768)

(SID_NAME=PR1)

(ORACLE_HOME=C:\oracle\PR1\102)

)

)

Fsldbprd =

(ADDRESS_LIST=

(ADDRESS=

(PROTOCOL=IPC)

(KEY=PR1)

)

(ADDRESS=

(PROTOCOL=IPC)

(KEY=PR1.WORLD)

)

(ADDRESS=

(COMMUNITY=SAP.WORLD)

(PROTOCOL=TCP)

(Host=xxx.xx.x.xxx)

(Port=1527)

)

)

SID_LIST_Fsldbprd =

(SID_LIST=

(SID_DESC=

(SDU=32768)

(SID_NAME=PR1)

(ORACLE_HOME=C:\oracle\PR1\102)

)

)

TRACE_LEVEL_LISTENER = OFF

CONNECT_TIMEOUT_LISTENER = 10

STARTUP_WAIT_TIME_LISTENER = 0

And here is the output of lsnrctl status command after making above changes

STATUS of the LISTENER

-

Alias Fsldbprd

Version TNSLSNR for 64-bit Windows: Version 10.2.0.2.0 -

ction

Start Date 19-FEB-2009 19:39:12

Uptime 0 days 0 hr. 14 min. 16 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\oracle\PR1\102\network\admin\listener.ora

Listener Log File C:\oracle\PR1\102\network\log\fsldbprd.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\PR1ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\PR1.WORLDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=1527)))

Services Summary...

Service "PR1" has 2 instance(s).

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

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

Service "PR1_XPT" has 1 instance(s).

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

The command completed successfully

In Cluster admin Oracle listener name is defined as Fsldbprd.

Please let me know if you need any additional information and thanks for looking into this issue.

Regards,

Jitendra

Edited by: Jitendra Kulkarni on Feb 20, 2009 1:03 AM

Former Member
‎02-20-2009 11:40 AM
0 Kudos

Hi,

1. Can you connect to database with sqlplus? If not start the database manually.

2. Check the environment variable ORACLE_SID set to your SID.

3. Check IP address for host in tnsnames.ora.

Hope this helps.

Manoj

Former Member
‎02-20-2009 11:55 AM
0 Kudos

Hi,

Sqlplus works fine. Oracle_sid environment is also set. The problem is only with BRtools. Recently system was migrated from 32-bit to 64-bit (oracle9i to 10g). Now both database and SAP are running on a new hardware and BRtool has never worked since it was migrated over.

Again many options within BR*tools do work such as display of database parameters etc. Do you think it is related to any missing environment variables on windows. This is the cluster environment. I didn't notice any issues within SAP environment and also on Oracle side. In fact I am using sqlplus to manage tablespace etc since brtools isn't working.

Thanks,

Jitendra

former_member204746
Active Contributor
‎02-20-2009 3:28 PM
0 Kudos

can you connect with this?

sqlplus /@PR1 as sysdba

Former Member
‎02-20-2009 7:18 PM
0 Kudos

Hi,

Yes I could connect with /@PR1 as sysdba and carry out SQL commands successfully.

Thanks,

Jitendra

former_member204746
Active Contributor
‎02-20-2009 7:26 PM
0 Kudos

provide output of this command:

lsnrctl status

Former Member
‎02-20-2009 7:39 PM
0 Kudos

LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 20-FEB-2009 15:29

:40

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PR1))

STATUS of the LISTENER

-

Alias Fsldbprd

Version TNSLSNR for 64-bit Windows: Version 10.2.0.2.0 - Produ

ction

Start Date 19-FEB-2009 19:39:12

Uptime 0 days 19 hr. 50 min. 28 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\oracle\PR1\102\network\admin\listener.ora

Listener Log File C:\oracle\PR1\102\network\log\fsldbprd.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\PR1ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\PR1.WORLDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.0.133)(PORT=1527)))

Services Summary...

Service "PR1" has 2 instance(s).

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

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

Service "PR1_XPT" has 1 instance(s).

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

The command completed successfully

Ask a Question