cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-12560: TNS:protocol adapter error

Former Member
0 Kudos

Hi,

We are facing issues when trying to connect BRTOOLS.

The database and system are Up and running fine

the error we are facing is

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance XXX failed

BR0280I BRCONNECT time stamp: 2008-01-31 01.15.34

BR0301E SQL error -12560 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance XXX failed.

Regards

Ram

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

Look at your ORACLE_HOME and ORACLE_SID environnnment variable.

If you have another oracle software installed check if the PATH variable not contained the two oracle directory.

Brtools ay use tnsname and sqlnet of the second home.

You can also try to update brtools with the latest version.

Hope that helps you,

Regards

Former Member
0 Kudos

Hi,

I have checked the Environment variables are they are set correctly.and in the path there are no Old oracle version paths exists.

DB tools and kernel are the latest available.

i am able to connect to database and the only problem is that i am not able to use BRTOOLS.

Regards

Ram

Former Member
0 Kudos

Hi,

we have resolved the issue by adding the environmet variable LOCAL=sid.

hope this helps for others.

0 Kudos

Hi,

thanks for the info.

But in that case, you should add some missing information:

1) you were using windows

2) You were using a Windows Terminal Server to access the system and execute BR* tools

This is documented in note 441518