Home » RDBMS Server » Networking and Gateways » Database Connection (10.2.0.4)
Database Connection [message #465676] Thu, 15 July 2010 03:55 Go to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I have one query related to database connection from server to client.

I have one database in the server and I want to connect from client.

I set the tnsnames in client system as follows.

BAM240T_EARTH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.154.119.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = BAM_240T.ipdc.com)
)
)

The database name is : BAM_240T.ipdc.com

Sqlnet.ora entry is

NAMES.DIRECTORY_PATH= (TNSNAMES)

NAMES.DEFAULT_DOMAIN= ipdc.com

When I connect to server I m getting the following error.

$ tnsping BA240T_EARTH

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 15:45:35

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

Please advise.

Re: Database Connection [message #465679 is a reply to message #465676] Thu, 15 July 2010 04:04 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
BAM240T_EARTH
is different from Quote:
BA240T_EARTH


sriram Smile
Re: Database Connection [message #465680 is a reply to message #465679] Thu, 15 July 2010 04:06 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I have given the same but result is same.

$ tnsping BAM240T_EARTH

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 16:08:49

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name
Re: Database Connection [message #465681 is a reply to message #465680] Thu, 15 July 2010 04:10 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
The effect of including the line
NAMES.DEFAULT_DOMAIN= ipdc.com

in your sqlnet.ora file is that this
tnsping BA240T_EARTH

is re-written to this
tnsping BA240T_EARTH.ipdc.com

which does not resolve. I have never seen any purpose to DEFAULT_DOMAIN, I believe it causes nothing but confusion. I would be interested if anyone can see much point to it.
Re: Database Connection [message #465682 is a reply to message #465680] Thu, 15 July 2010 04:11 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Try :
If you have a sqlnet.ora, look at for the setting NAMES.DEFAULT_DOMAIN. If it is set, then all entries in your tnsnames.ora must have a matching domain suffix.
Re: Database Connection [message #465721 is a reply to message #465676] Thu, 15 July 2010 07:11 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I have same suffix in tnsnames.ora which has in NAMES.DEFAULT_DOMAIN. I tried for the below solutions but I am getting same error.

$ tnsping BAM240T_EARTH.ipdc.com

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 18:54:36

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name
Re: Database Connection [message #465754 is a reply to message #465721] Thu, 15 July 2010 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
03505, 00000, "Failed to resolve name"
// *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
//          an Oracle Names server, or a native naming service.
// *Action: Verify that you entered the service name correctly.  You may need
//          to ensure that the name was entered correctly into the network
//          configuration.
Re: Database Connection [message #465884 is a reply to message #465676] Thu, 15 July 2010 22:10 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I have entry in tnsnames.ora file and let me know is there any setting in sqlnet.ora file.
Re: Database Connection [message #465889 is a reply to message #465884] Thu, 15 July 2010 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
>I have entry in tnsnames.ora file
does not mean it is correct.

>and let me know is there any setting in sqlnet.ora file.
sqlnet.ora content NOT required to make a SQL*Net connection.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Database Connection [message #465893 is a reply to message #465884] Thu, 15 July 2010 22:32 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I have same entry in my windows environment and I am able to connect thru PL/SQL developer.

Why is the problem in linux environment with the same entry?
Re: Database Connection [message #465894 is a reply to message #465893] Thu, 15 July 2010 22:32 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.
Re: Database Connection [message #465896 is a reply to message #465676] Thu, 15 July 2010 22:42 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
Swan,

Sorry for the inconvenience.

I explain clearly with the situation.

I have two linux systems and installed oracle server in both the systems and in the same network. I have one more machine which is installed oracle client in windows environment. We are able to access those linux machines through putty (is the tool which we can connect to linux system).

I have database in first server and I want to connect from second server. I have kept the tns entry which I am using in windows system. I have used tnsping in second server and it is giving the error.

$ tnsping BAM240T_EARTH.ipdc.com

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 18:54:36

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

This is the exact problem.
Re: Database Connection [message #465898 is a reply to message #465896] Thu, 15 July 2010 22:50 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
On each of the two unix system open a terminal window while logged onto OS as user "oracle" or which ever OS user who owns Oracle sofware

COPY the lines below

date
env | sort
id
lsnrctl status
lsnrctl service
uname -a
cat /etc/hosts
cat $ORACLE_HOME/network/admin/tnsnames.ora
ls -l $ORACLE_HOME/dbs
date

PASTE the lines above into the TERMINAL window on both systems
COPY commands & results, then PASTE all back here
just do EXACTLY as directed, PLEASE!
Re: Database Connection [message #465950 is a reply to message #465676] Fri, 16 July 2010 01:58 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
Thnq very much Swan.

I have changed the tnsnames.ora file and I am able to rectify the problem which I got earlier but I am getting another error saying that 'TNS-12535: TNS:operation timed out'.

[oracle@captest1 admin]$ tnsping BAM_240T.ipdc.com

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 16-JUL-2010 12:52:38

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = earth)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = BAM_240T.ipdc.com)))
TNS-12535: TNS:operation timed out


How to solve this error.
Re: Database Connection [message #465951 is a reply to message #465950] Fri, 16 July 2010 02:02 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
TNS-12535: TNS:operation timed out 
Cause: The requested operation could not be completed within the 
time out period.
 
Action: Look at the documentation on the secondary errors for 
possible remedy. See SQLNET.LOG to find secondary error if not 
provided explicitly. Turn on tracing to gather more information. 


Re: Database Connection [message #466039 is a reply to message #465950] Fri, 16 July 2010 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
>How to solve this error.
You choose to not answer my questions, then I choose to not answer yours
Re: Database Connection [message #466215 is a reply to message #466039] Sun, 18 July 2010 01:13 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
BlackSwan wrote on Fri, 16 July 2010 09:56
>How to solve this error.
You choose to not answer my questions, then I choose to not answer yours


@grpatwari

As BlackSwan Says Please follow the steps he has given you so that we can HELP you.
Previous Topic: MS Access to Oracle DB
Next Topic: Connect Remotely Database
Goto Forum:
  


Current Time: Sun Sep 21 01:56:54 CDT 2014

Total time taken to generate the page: 0.09021 seconds