OraFAQ Forum: Networking and Gateways » is this enough to build up my tnsnames.ora ?

Home » RDBMS Server » Networking and Gateways » is this enough to build up my tnsnames.ora ?

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

is this enough to build up my tnsnames.ora ? [message #248171]

Thu, 28 June 2007 03:59

r2d2dev
Messages: 75
Registered: May 2005
Location: bxl

Member

hi all,

we have a small component that has to retrieve data from an oracle 10 database.

we tested here in the company with oracle 10 XE.
to connect to the database, we had to configure a tnsnames.ora file with this line:

Quote:

DODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.x.x.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XE)
)
)

now, in a few weeks we have to test the connection at the client, with the real oracle 10 database.
so i asked the client already if he could provide me with the real entry in tnsnames.ora.

Quote:

this is what he answered:
dbname: dodb
IP 1xx.1x.0.2x
port 1521
user dodb_xx
password dodb_xx

is this enough????
at first sight i would say that the SERVICE_NAME is missing, isn't it???????
(or should I just type the dbname there?)

Report message to a moderator

Re: is this enough to build up my tnsnames.ora ? [message #248181 is a reply to message #248171]

Thu, 28 June 2007 04:12

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

Senior Member
Account Moderator

Yes, connect_data is missing.
May be another thing than service_name.

Regards
Michel

Report message to a moderator

Re: is this enough to build up my tnsnames.ora ? [message #248183 is a reply to message #248181]

Thu, 28 June 2007 04:15

r2d2dev
Messages: 75
Registered: May 2005
Location: bxl

Member

but at several places i read that the service name may be the same as the database name....
is this correct or not?

or is service_name and database_name something else?

[Updated on: Thu, 28 June 2007 04:28]

Report message to a moderator