listener running but can't connect

From: Angel R. Deras <angel.deras_at_verizon.net>
Date: Sat, 23 Mar 2002 07:58:06 GMT
Message-ID: <3C9C3643.AA14963F_at_verizon.net>

Hi Gurus,

I need your help. I hurt the Sr. DBA's feeling by doing an oracle install which he apparently had set his heart on doing himself.

He deinstalled/installed the instance, which was working with no problems previously. The database is for Openview and this app expects a listener service named "ov_net". All sql*net files seem to be OK (I have the same files on another environment, except for hostname, SID differences.); however, I am unable to establish a connection to the database when I specify the service name: "sqlplus user/passwd_at_ov_net". If I don't include the service name, I am able to connect. The database is running and I can do queries through "svrmgrl". I have included below the different sql*net files, netstat, "ipcs" and "lsnrctl status" output.

The configuration is the same in the other environment and all is well. What could be wrong?

thanks in advance,

ard

---

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=OPCD)) STATUS of the LISTENER

---

Alias LISTENER
Version TNSLSNR for HPUX: Version 8.1.6.0.0 - Production Start Date 21-MAR-2002 20:38:57
Uptime 0 days 1 hr. 3 min. 1 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /etc/listener.ora Listener Log File /OpC/oracle/8.1.6/network/log/listener.log Services Summary...
OPCD has 2 service handler(s)
The command completed successfully

# netstat -a|grep listener

tcp 0 0 dhovw1.53247 dhovw1.listener ESTABLISHED tcp 0 0 *.listener *.* LISTEN
tcp 0 0 dhovw1.listener dhovw1.53247 ESTABLISHED
#
# ps -ef|grep ora

oracle 10027 1 0 20:13:21 ? 0:00 ora_smon_OPCD
oracle 10023 1 0 20:13:21 ? 0:00 ora_lgwr_OPCD
oracle 10021 1 0 20:13:21 ? 0:00 ora_dbw0_OPCD
oracle 10029 1 0 20:13:21 ? 0:00 ora_reco_OPCD
oracle 10025 1 0 20:13:21 ? 0:00 ora_ckpt_OPCD
oracle 10019 1 0 20:13:20 ? 0:00 ora_pmon_OPCD
oracle 10276 1 0 20:38:57 ? 0:00 /OpC/oracle/8.1.6/bin/tnslsnr LISTENER

-inherit
root 10694 20537 1 21:44:29 pts/te 0:00 grep ora
#

# ipcs |grep ora

m 16901 0x044a4a60 --rw-r----- oracle dba s 1048089 0x05375a16 --ra-r----- oracle dba
#

# cat *.ora
###########
# FILENAME: listener.ora
# DATE....: Jan 7 1999
# NETWORK.: openview
# NODE....: Server
# SERVICE.: LISTENER
# COMMENT.: For use with HP OpenView IT/Operations
###########

LISTENER =

(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= OPCD)

)

(ADDRESS =
(PROTOCOL = TCP)
(HOST = dhovw1)
(PORT = 1521)

)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10

LOG_DIRECTORY_LISTENER = /OpC/oracle/8.1.6/network/log
LOG_FILE_LISTENER = listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

(SID_NAME=OPCD)
(ORACLE_HOME=/OpC/oracle/8.1.6/)
)
)
TRACE_LEVEL_LISTENER = OFF
###########
# FILENAME: sqlnet.ora
# DATE....: Jan 7 1999
# NETWORK.: openview
# NODE....: Client + Server
# SERVICE.: C_OPENVIEW_COMMUNITY
# COMMENT.: For use with HP OpenView IT/Operations
###########

TRACE_LEVEL_CLIENT = OFF
TRACE_DIRECTORY_CLIENT = /OpC/oracle/8.1.6/network/log
TRACE_DIRECTORY_CLIENT = /OpC/oracle/8.1.6/network/log

###########
# FILENAME: tnsnames.ora
# DATE....: Jan 7 1999
# NETWORK.: openview
# NODE....: Client
# SERVICE.: C_OPENVIEW_COMMUNITY
# COMMENT.: For use with HP OpenView IT/Operations
###########

ov_net =

(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(KEY =OPCD))
(ADDRESS =
(COMMUNITY=OPENVIEW_COMMUNITY)
(PROTOCOL=TCP)
(HOST=dhovw1)
(PORT=1521)

)
)
(CONNECT_DATA=
(SID=OPCD)
)
)
###########
# FILENAME: tnsnav.ora
# DATE....: Jan 7 1999
# NETWORK.: openview
# NODE....: Client
# SERVICE.: C_OPENVIEW_COMMUNITY
# COMMENT.: For use with HP OpenView IT/Operations
###########

LOCAL_COMMUNITIES =
(COMMUNITY_LIST =
(COMMUNITY = OPENVIEW_COMMUNITY)
)
#
Received on Sat Mar 23 2002 - 08:58:06 CET