Re: tnsnames.ora

From: Artur Karazniewicz <artur.karazniewicz[N0SPAM>
Date: Fri, 08 Apr 2005 12:49:52 +0200
Message-Id: <42566081$0$1409$f69f905@mamut2.aster.pl>

Miori wrote:

This is for >=9i

> format 1:
> testdb =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = testdb)
> )
> )

This is for Oracle < 9i

> format 2:
> testdb =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(Host = myhost)(Port = 1521))
> )
> (CONNECT_DATA =
> (SID = test)
> (GLOBAL_NAME = testdb.mydomain)
> )
> )

Artur Received on Fri Apr 08 2005 - 05:49:52 CDT