oracle client on linux & db on nt

Hi all


I have 2 databases servers both oracle 8i .
Ora1 on WinNT
Ora2 on Linux

I am creating a connecttion from wint nt to Ora2(i.e linux db) via
sql*plus tool . I am able to connect successfully. I have configured
the tnsnames.ora with the appropriate service name for linux db server.

Now i am trying to use the sqlplus utility of linux to connect to
winnt database. I have configured
the tnsnames.ora with the appropriate service name for winnt db server.

But sqlplus of linux just doesnt seem to recognize the service name
of winnt .
error ora-12154 : Tns:could not resolve service name.

i can ping the winnt machine from linux without any problems.

Is there any configuration i have to make for using an oracle client
application in linux & oracle db server on winnt. Why is not detecting
the oracle db on winnt


Regards
Sushant

Quote:

---

Originally posted by zulu99
i can ping the winnt machine from linux without any problems.

---

Are you able to tnsping successfully also ? Guess not! You may have to check your tnsnames.ora on the linux box.

Yes , tnsping also does not work.
I have checked tnsnames.ora file in the linux box. It has a
proper entry. i tried using sid=testdb instead of service name
but to no vail

compare the tnsnames.ora on the win box with that on the linux box and make necessary changes (see in bold below) in the later.

Quote:

---

TST.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tst)
)
)

---

Check the docs for more info...Configuring the Local Naming Method

http://download-west.oracle.com/docs...gcf.htm#448222

HTH.

Hi


name of nt box(ip:200.200.200.60) is utidbsvr & name of linux box is oralin(ip:200.200.200.81)


from linux when i say
ping utidbsvr (does not work)
but ping 200.200.200.60 works


from nt when i say

ping oralin (does not work)
but ping 200.200.200.81 works

so i have corresponding ip adderess in the host part
in tnsnames.ora

Checked tnsnames.ora. seems to be fine , hope its not some
problem because of conflicting os

Regards
Sushant

Hi

You should say tnsping tnsname to check wheather your tnsnames.ora file is okay

Also have a look at sqlnet.ora on the machine acting as client. If it contains something like
NAMES.DEFAULT_DOMAIN = STUPID.CH
then this is appended to a connection string if that does not explicitly include a domain (i.e. has a dot in it) before it is looked up in tnsnames.ora. Failure to find SID.STUPID.CH gives an ORA-12154 too.

Quote:

---

Originally posted by zulu99
...hope its not some problem because of conflicting os

---

NO WAY!

You can use the ip instead of the hostname in tnsnames.ora. That is okay.

Have you checked your sqlnet.ora as DaPi says?

BTW, you can check if you able to connect to db on linux using tnsnames.ora from the linux box itself.

HTH.

Quote:

---

Originally posted by ggnanaraj
you can check if you able to connect to db on linux using tnsnames.ora from the linux box itself.

---

YES - guess that is the first thing we should have suggested!

Hi

I can connect without using the tnsname to the linux box from
linux client but when i use the tnsname as host string , it fails
& gives the tnsnames error

Can you post the contents of tnsnames.ora here?

Sorry

I have removed the entry from sqlnet.ora & now linux client connects to linux box db using the tnsnames entry .

now my linux box sqlnet.ora has only 1 entry

names.directory.path=(tnsnames,onames,hostname)

tnsnames.ora content in linux box

============
win nt db connect entry
============
testdb=
(description=
(address_list=
(address =(protocol=tcp)(host=200.200.200.60)(port=1521)
)
)
(connect_data=
(service_name=testdb)
)
)


============
linux db connect entry
============
oralin=
(description=
(address_list=
(address =(protocol=tcp)(host=200.200.200.81)(port=1521)
)
)
(connect_data=
(service_name=oralin)
)

Hi

It worked . I dont whether its the right thing to do.

in linux tnsnames.ora
I just appended the tnsnames entry for oracle nt db
with the global_name of linux.


like this
testdb.us.oracle.com =
description =(.............


Thanks for all the help