tnsnames error

[sathya1212]

i installed oracle 8.1.5 on win NT........
it went through fine...........
i was also able to configure client..i.e i was able to connect to the db through sqlplus from a client machine....
but the problem is whenever i type svrmgrl...
i get an errot tns-12560.....protocol adapter error.........
could someone help me

[julian]

Originally posted by sathya1212
i installed oracle 8.1.5 on win NT........
it went through fine...........
i was also able to configure client..i.e i was able to connect to the db through sqlplus from a client machine....
but the problem is whenever i type svrmgrl...
i get an errot tns-12560.....protocol adapter error.........
could someone help me

Before you type on NT svrmgrl, type first SET ORACLE_SID=NAME, where NAME is your Oracle instance name. Then start svrmgrl.

[sathya1212]

TNANX..............
it worked.............
but,is it neccessary for me to it everytime.............

[ngwh]

i am curious why is this so? did u login as administrator ??
i thought in the win registery the SID shld be set already?

[julian]

Originally posted by sathya1212
TNANX..............
it worked.............
but,is it neccessary for me to it everytime.............

You are wellcome.

Not every time. How many instances do you run on that NT server?

[julian]

Originally posted by ngwh
i am curious why is this so? did u login as administrator ??
i thought in the win registery the SID shld be set already?

If you run more than one instance, you should set the proper one. In Unix you do it like that:

$ORACLE_SID=NAME
$export ORACLE_SID

confirmation:

$echo $ORACLE_SID

On NT you have SET before ORACLE_SID=NAME

Important: Be careful not to write SET ORACLE_SID = NAME.
Proper syntax is SET ORACLE_SID=NAME.

[sathya1212]

i have only one instance.........
but...i removed a old db which was running on 7.3.4
and installed the new one..............
but,before setting sid when i checked it by using set command
i found out that it was orcl..........i think thats why it was giving prob.....

[julian]

Originally posted by sathya1212
i think thats why it was giving prob.....

That's it!