OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » TNSNAMES Connection

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

TNSNAMES Connection [message #29271]

Mon, 23 February 2004 01:05

Kchitij
Messages: 13
Registered: October 2002

Junior Member

I want to know how do i connect using this information using TNSNAMES.ORA. Fast Response please...
LDTestDB.SAPIENT.COM =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = delmlearning)(PORT = 1521))

)

Report message to a moderator

Re: TNSNAMES Connection [message #29274 is a reply to message #29271]

Mon, 23 February 2004 01:40

Robby Williams
Messages: 1
Registered: February 2004

Junior Member

You can use following string in tnsnames.ora file :

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 000.000.000.000)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)

Apart from this u can use Oracle 8.i's Net8 Configuration Assisstant.

Report message to a moderator

Re: TNSNAMES Connection [message #29278 is a reply to message #29274]

Mon, 23 February 2004 02:00

Kchitij
Messages: 13
Registered: October 2002

Junior Member

This is what's there in my tnsnames.ora file. I am not able to connect from the command prompt.
I tried sqlplus scott/tiger@LDTestDB
But it gace the error TNS cud not resolve service name
PLease help me fast. I am not able to start off with the project because of this.
LDTestDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = delmlearning)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LDTestDB)
)
)

Report message to a moderator

Re: TNSNAMES Connection [message #29280 is a reply to message #29278]

Mon, 23 February 2004 02:13

Williams
Messages: 5
Registered: February 2004

Junior Member

Kchitij,
The connection string was a tested one. Make sure that the TNS service and the DataBase service are running. Also the classpaths are set properly in your environment variables.
You can use Net8 Configuration Utility also.

rgds.

Report message to a moderator

Re: TNSNAMES Connection [message #29293 is a reply to message #29278]

Mon, 23 February 2004 17:51

William
Messages: 17
Registered: September 2000

Junior Member

PS: put the host ip in the HOST parameter in this connection string.

LDTestDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <ip>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LDTestDB)
)
)

-Will.

Report message to a moderator

Previous Topic:	tnsnames.ora connectivity
Next Topic:	TNS problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:28:04 CST 2024