Home » RDBMS Server » Networking and Gateways » is this enough to build up my tnsnames.ora ?
is this enough to build up my tnsnames.ora ? [message #248171] Thu, 28 June 2007 03:59 Go to next message
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?)
Re: is this enough to build up my tnsnames.ora ? [message #248181 is a reply to message #248171] Thu, 28 June 2007 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, connect_data is missing.
May be another thing than service_name.

Regards
Michel
Re: is this enough to build up my tnsnames.ora ? [message #248183 is a reply to message #248181] Thu, 28 June 2007 04:15 Go to previous messageGo to next message
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

Re: is this enough to build up my tnsnames.ora ? [message #248196 is a reply to message #248183] Thu, 28 June 2007 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the service name may be the same as the database name

It may but it must not.
It is what you want.

Regards
Michel
Re: is this enough to build up my tnsnames.ora ? [message #250234 is a reply to message #248196] Mon, 09 July 2007 04:04 Go to previous message
pra_dbaquery
Messages: 6
Registered: June 2007
Location: Jamnagar
Junior Member
Dear,

Here your db name is your service_name. so as per detail given in this your service_name is DODB database name.
Previous Topic: I cannot start the Listener
Next Topic: create table xx_da as select * from table@2nd database not work
Goto Forum:
  


Current Time: Sat Dec 03 10:08:25 CST 2016

Total time taken to generate the page: 0.12235 seconds