listener hung

[Steve Bear_1]

Yogeeraj-
no, lsnrctl>start just sat there, nothing in the listener.log and trace.
LSNRCTL> start
Starting /apps/oracle/product/7.3.2.2/bin/tnslsnr: please wait...

Graham--
no we havent tried yet reverting the IP address.

logging a TAR at metalink to see what they recommend.

Thanks,

[T G Manikandan]

What does your sqlnet.ora file have.

[Steve Bear_1]

$cat sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES)

[T G Manikandan]

Can you attach your listener.ora,tnsnames.ora,sqlnet.ora files

[T G Manikandan]

Must be silly but do you have multiple ORACLE installations.
Is the ORACLE_HOME pointing to the right path and are the right network configuration files updated.
$ORACLE_HOME/network/admin

[Steve Bear_1]

$cat listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= db01)
)
(ADDRESS =
(PROTOCOL = TCP)
(HOST = db01)
(PORT = 1526)
)
)
LOG_DIRECTORY_LISTENER = /apps/oracle/product/7.3.2.2/network/log
LOG_FILE_LISTENER = sqlnetv2
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dw01)
(ORACLE_HOME=/apps/oracle/product/7.3.2.2)
)
)
TRACE_LEVEL_LISTENER = ADMIN

$more tnsnames.ora
live =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = db01)
(PORT = 1526)
)
)
(CONNECT_DATA =
(SID = dw01)
)
)

[Steve Bear_1]

no, just one ORACLE_HOME

[T G Manikandan]

Can you change db01 and give the ip-address instead of hostname.

please check that.

Can you do a

#nslookup db01

REvert

[Steve Bear_1]

did try though, but no luck.

[T G Manikandan]

What is the output of ..
#nslookup db01
#nslookup