Skip to Content
0
Former Member
Feb 19, 2009 at 07:45 PM

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

430 Views

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