Interesting Problem with Oracle

[Dave Chamberlin]

Where is the user connecting from and using what?

[Joseph C. Denman]

Ganesh,

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


...jcd...

[Ganesh Anekar]

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

[Eric Z]

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.

[Printaporn_1]

Hi,

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

[T G Manikandan]

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

[Ganesh Anekar]

Hi,

when I tried

tnsping TGM1

Its showing that :" Failed to resolve name"

Now how should i proceed?

Ganesh

[Dave Chamberlin]

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

[Simeon Fox]

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

Regards
SMF

[Arturo Castaneda]

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