Accessing The remote DB Directly

[amolik]

I am on Linux Machine and have to access Database 'gdb' on NT machine. Every time I have to enter $ sqlplus scott/tiger@gdb. Is there any way I can configure it so that I don't have to enter a complete sqlplus scott/tiger@gdb. I tried $ oracle_sid=gdb (export oracle_sid) and then entered 'sqlplus scott/tiger' but it didnt connect to remote DB. Can't I set oracle_sid to a remote DB.

Amol

[ovidius]

I think is possible sqlplus to not use the oracle_sid in connect string. So...

[pando]

export TWO_TASK=RMEOTEDB

then you can do sqlplus scott/tiger

but this works between unix/linux databases I am not sure if it would work with remote nt database, should but I am not 100% sure because I rarely work with NT

[amolik]

Should I do $ oracle_sid=gdb before going for export TWO_TASK=gdb ?

Amol

[amolik]

Oh Pando .. Thats really worked ( Even for NT ). Thank You very much
Ignore my earlier Question.

Just let me know How can I make it permanent? Currently it works only for the teminal which is currently opened. Do I have to modify .bash_profile for it.

Amol