OraFAQ Forum: Networking and Gateways » Database Connection

Home » RDBMS Server » Networking and Gateways » Database Connection (10.2.0.4)

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

Database Connection [message #465676]

Thu, 15 July 2010 03:55

grpatwari
Messages: 288
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.

Report message to a moderator

Re: Database Connection [message #465679 is a reply to message #465676]

Thu, 15 July 2010 04:04

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

BAM240T_EARTH

is different from Quote:

BA240T_EARTH

sriram

Smile

Report message to a moderator

Re: Database Connection [message #465680 is a reply to message #465679]

Thu, 15 July 2010 04:06

grpatwari
Messages: 288
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

Report message to a moderator

Re: Database Connection [message #465681 is a reply to message #465680]

Thu, 15 July 2010 04:10

John Watson
Messages: 8962
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.

Report message to a moderator

Re: Database Connection [message #465682 is a reply to message #465680]

Thu, 15 July 2010 04:11

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.

Report message to a moderator

Re: Database Connection [message #465721 is a reply to message #465676]

Thu, 15 July 2010 07:11

grpatwari
Messages: 288
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

Report message to a moderator

Re: Database Connection [message #465754 is a reply to message #465721]

Thu, 15 July 2010 09:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Database Connection [message #465884 is a reply to message #465676]

Thu, 15 July 2010 22:10

grpatwari
Messages: 288
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.

Report message to a moderator

Re: Database Connection [message #465889 is a reply to message #465884]

Thu, 15 July 2010 22:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: Database Connection [message #465893 is a reply to message #465884]

Thu, 15 July 2010 22:32

grpatwari
Messages: 288
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?

Report message to a moderator

Re: Database Connection [message #465894 is a reply to message #465893]

Thu, 15 July 2010 22:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Database Connection [message #465896 is a reply to message #465676]

Thu, 15 July 2010 22:42

grpatwari
Messages: 288
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.

Report message to a moderator

Re: Database Connection [message #465898 is a reply to message #465896]

Thu, 15 July 2010 22:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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!

Report message to a moderator

Re: Database Connection [message #465950 is a reply to message #465676]

Fri, 16 July 2010 01:58

grpatwari
Messages: 288
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.

Report message to a moderator

Re: Database Connection [message #465951 is a reply to message #465950]

Fri, 16 July 2010 02:02

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.

Report message to a moderator

Re: Database Connection [message #466039 is a reply to message #465950]

Fri, 16 July 2010 09:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to solve this error.
You choose to not answer my questions, then I choose to not answer yours

Report message to a moderator

Re: Database Connection [message #466215 is a reply to message #466039]

Sun, 18 July 2010 01:13

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.

Report message to a moderator

Previous Topic:	MS Access to Oracle DB
Next Topic:	Connect Remotely Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:51:06 CST 2025