topic Re: Interesting Problem with Oracle in Operating System - HP-UX

Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 14:45:33 GMT

Hi,

I am working D class HP9000 machine.

I am able to mount the database,able to start listener.

But when i try to connect with Database user with the tnsnames. It says "tns could not resolve service name"

I checked tnsnames.ora file ...the entries are there for same tnsname.

can somebody guide me ? how should i proceed?

Thanks
Ganesh

Re: Interesting Problem with Oracle

MANOJ SRIVASTAVA — Fri, 03 May 2002 14:50:59 GMT

Hi Ganesh

I think you are working on the new OS , how is the system able to resolve its name . Do a nslookup and nslookup I think there is some issue with your resolv.conf or nssswitch file , all you can do is to rename the resolve.conf if you entries are good in /etc/hosts.

Manoj Srivstava

Re: Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 14:58:50 GMT

hi manoj,

I checked nslookup for host and ip ..its working fine.

I am able to connect for database user without tnsname , but not with tnsname.

how should i do this?

ganesh

Re: Interesting Problem with Oracle

Helen French — Fri, 03 May 2002 15:04:21 GMT

Hi Ganesh:

Some options:

1) Check the permission of tnsnames.ora file
2) Make sure that your SID is in the tnsnames.ora file
3) Make sure that the listener knows that the SID is in the tnsnames.ora file.
4) If you are using NNM, then there can be a problem while resolving the names. Then you need to edit the file -/home/dba/oracle/product/8.0.6/network/admin/sqlnet.ora - and comment out this line:

NAMES.DEFAULT_DOMAIN

HTH,
Shiju

Re: Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 15:04:45 GMT

Dear Manoj,

can you tell me how should i check that on which IP,database is running as I have to IPs for one NIC in the same machine.

Is this tns error is related to that?

I checked group and and permissions for the unix user from which i was connecting to db ..all are correct.

please guide me.

ganesh

Re: Interesting Problem with Oracle

Wodisch — Fri, 03 May 2002 15:09:39 GMT

Hi,

my guess would be just the opposite: you don't have a "sqlnet.ora" file and hence all your TNSnames are too complicated (having some kind of ".something" appended).
So check, wether you have a "sqlnet.ora" in "$ORACLE_HOME/network/admin" or "/etc" ("/etc" wins if both exist!).

HTH,
Wodisch

Re: Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 15:16:58 GMT

Hi,

I check sqlnet.ora file

It is in $ORACLE_HOME\network\admin
but not in \etc

so what next?

ganesh

Re: Interesting Problem with Oracle

John Palmer — Fri, 03 May 2002 15:17:38 GMT

Also ensure that you only have one tnsnames.ora file.

I believe that Oracle searches for it as follows:

1. TNS_ADMIN environment variable.
2. $ORACLE_HOME/network/admin
3. /etc

Regards,
John

Re: Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 15:41:28 GMT

hi,

I ensured that in ENV variables

1.TNS_ADMIN is set to
$ORACLE_HOME/network/admin

2.what about etc? what shall i check for etc?

ganesh

Re: Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 15:45:52 GMT

hi,

I checked for tnsnames.ora file it is only in
$ORACLE_HOME/network/admin directory.

ganesh

Re: Interesting Problem with Oracle

Dave Chamberlin — Fri, 03 May 2002 16:02:35 GMT

Where is the user connecting from and using what?

Re: Interesting Problem with Oracle

Joseph C. Denman — Fri, 03 May 2002 16:09:30 GMT

Ganesh,

It might help if you post your tns entry. Also, what version of oracle are you using????

...jcd...

Re: Interesting Problem with Oracle

Ganesh Anekar — Fri, 03 May 2002 17:11:19 GMT

hi,

here is tnsnames.ora
======================================
#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = TGM1))
(CONNECT_DATA = (SID = extproc))
)

TGM1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host = hux9)(Port= 1521))
(CONNECT_DATA = (SID = TGM1))
)

TGM1_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /oracle/app/oracle/product/8.0.6)
(argv0 = oracleTGM1)
(args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(envs = 'ORACLE_HOME=/oracle/app/oracle/product/8.0.6,ORACLE_SID=TGM1')
)
)
=======================

Oracle i am using is 8.0.6

ganesh

Re: Interesting Problem with Oracle

Eric Z — Sun, 05 May 2002 20:37:33 GMT

One possible reason is that you have a domain name in your sqlnet.ora but do not have corresponsive TNS name.

Say, there is domain name called my_domain in SQLNET.ora. When Oracle client do the resolution, it automatically attaches a domain to the name you enter. As when you try "tnsping80 TGM1", actually Oracle will look for TGM1.my_domain.

Re: Interesting Problem with Oracle

Printaporn_1 — Mon, 06 May 2002 03:20:05 GMT

Hi,

Try
tnsping TPM1.world
does it work ?
if yes check sqlnet.ora
(if you not found it in /etc it could OK)

Re: Interesting Problem with Oracle

T G Manikandan — Mon, 06 May 2002 03:52:59 GMT

Hello,
remove the below entry from your file
This is optional (not required)
TGM1_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /oracle/app/oracle/product/8.0.6)
(argv0 = oracleTGM1)
(args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(envs = 'ORACLE_HOME=/oracle/app/oracle/product/8.0.6,ORACLE_SID=TGM1')
)

and try starting your listener.

lsnrctl stop
lsnrctl start
or
lsnrctl reload

If this is not working

use
$ORACLE_HOME/bin/netasst to configure your service names again.
Remove everything and configure your
extproc_connection_data
and TGP1 afresh.

Thanks
G Manikandan

Re: Interesting Problem with Oracle

Ganesh Anekar — Mon, 06 May 2002 16:35:20 GMT

Hi,

when I tried

tnsping TGM1

Its showing that :" Failed to resolve name"

Now how should i proceed?

Ganesh

Re: Interesting Problem with Oracle

Dave Chamberlin — Mon, 06 May 2002 21:16:05 GMT

How do you know that the listener is running? Have you done a ps -ef and grepped for your listener command?

Re: Interesting Problem with Oracle

Simeon Fox — Tue, 07 May 2002 10:51:01 GMT

Hi Ganesh, have you checked your listener.ora? You need an entry for TGM1 in the SID_LIST_LISTENER section.

Regards
SMF

Re: Interesting Problem with Oracle

Arturo Castaneda — Tue, 07 May 2002 13:11:34 GMT

Have you tried this?

lsnrctl stat

This will tell you what are the instances that your listener is working with, and you'll know if your listener is running.

what happens if you issue this:

echo $ORACLE_SID

if ORACLE_SID is different from TGM1

you should try

. oraenv

and whrite TGM1 when asked then press enter an try again with echo $ORACLE_SID