OraFAQ Forum: Networking and Gateways » connect remote database without providing SID

Home » RDBMS Server » Networking and Gateways » connect remote database without providing SID (ORALCE 8.0.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect remote database without providing SID [message #450210]

Mon, 05 April 2010 14:12

awesome75
Messages: 1
Registered: April 2010
Location: FAIRFAX

Junior Member

Hi
i need to connect to a remote database located on a different server using sqlplus without using database name in connect string.

e.g. if mydb1 (located on another database server on network)

sqlplus username/password

is it possible? i am able to do this on local database but not on the remote database

Report message to a moderator

Re: connect remote database without providing SID [message #450214 is a reply to message #450210]

Mon, 05 April 2010 14:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is it possible?
NO

sqlplus username/password@TNS_alias

Report message to a moderator

Re: connect remote database without providing SID [message #450215 is a reply to message #450210]

Mon, 05 April 2010 14:18

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes you can connect, just read the documentation:
SQL*Plus® User's Guide and Reference

Regards
Michel

[Updated on: Mon, 05 April 2010 14:19]

Report message to a moderator

Re: connect remote database without providing SID [message #450217 is a reply to message #450215]

Mon, 05 April 2010 14:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

OK, I had forgotten about TWO_TASK
I'm getting old & senile.

When you get older, the memory is the 2nd faculty that fails & I don't remember which is the 1st

Report message to a moderator

Re: connect remote database without providing SID [message #450218 is a reply to message #450217]

Mon, 05 April 2010 14:36

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can also use Easy Connect Naming

Regards
Michel

Report message to a moderator

Re: connect remote database without providing SID [message #450220 is a reply to message #450210]

Mon, 05 April 2010 14:37

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

2 useful topics in AskTom:
How to connect SQLPlus without tnsnames.ora
TWO_TASK environment variable on windows

Regards
Michel

[Updated on: Mon, 05 April 2010 14:38]

Report message to a moderator

Re: connect remote database without providing SID [message #450221 is a reply to message #450218]

Mon, 05 April 2010 14:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Michel Cadot wrote on Mon, 05 April 2010 12:36

Easy Connect Naming

Did Easy Connect exist for V8.0.5?

Report message to a moderator

Re: connect remote database without providing SID [message #450259 is a reply to message #450221]

Tue, 06 April 2010 01:16

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Doh! didn't see the version.
Of course, it doesn't, was introduced in 10.1

Regards
Michel

Report message to a moderator

Previous Topic:	oracle connection
Next Topic:	Instalation-Product-Specific Prerequisite Checks Window

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 21:51:07 CST 2025