-
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
-
Re: oracle client on linux & db on nt
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.
-
client on linux
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.
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.
-
oracle client
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
Last edited by hrishy; 04-24-2003 at 08:21 AM.
-
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.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Re: oracle client
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.
-
Re: Re: oracle client
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!
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
oracle client on linux
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|