Listener not starting after DNS and Gateway entries update

[manish_singh13]

Hi,

Due to non-connectivity of SAP Router our unix/network team has changed the Public IP's Gateway and DNS entries on our Unix Server.

After that our SAP Instance Listener service is not starting due to which SAP is also down. Kindly let me know what can be done to resolve this. Ours is local installation

Below are the relevant entries:

Output of TNSPING:

Used parameter files:

/oracle/SCD/102_64/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

LISTENER.ORA

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = SCD.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = SCD)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ABCD)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = ON

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = SCD)

(ORACLE_HOME = /oracle/SCD/102_64)

)

)

TNSNAMES.ORA

SCD.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ABCD)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SERVICE_NAME = SCD)

(SID = SCD)

(GLOBAL_NAME = SCD.WORLD)

)

)

SQLNET.ORA

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = 16

NAMES.DEFAULT_DOMAIN = WORLD

NAMES.DIRECTORY_PATH = (TNSNAMES)

1. 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

1. 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

1. 05.01.06 set to default

#TCP.NODELAY=YES

1. 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

Below is the output while starting listener

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

System parameter file is /oracle/SCD/102_64/network/admin/listener.ora

Log messages written to /oracle/SCD/102_64/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SCD.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SCD)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ABCD)(PORT=1527))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

HPUX Error: 2: No such file or directory

Listener failed to start. See the error message(s) above...

listener.log contains same entries.

Regards,

Manish Singh

[manish_singh13]

Issue was resolved as in listener.ora file, I commented entries for IPC protocol. After that listener started.

[JPReyes]

(HOST = ABCD) (PORT = 1527)...
TNS-12545: Connect failed because target host or object does not exist

first question will be can you ping host ABCD?, can you telnet ABCD on port 1527?

If not then you know what the problem is...

Regards

Juan