on 01-26-2010 9:27 PM
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)
05.01.06 unsorported parameter now
#NAME.DEFAULT_ZONE = WORLD
05.01.06 set the default to 10
SQLNET.EXPIRE_TIME = 10
05.01.06 set to default
#TCP.NODELAY=YES
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
Issue was resolved as in listener.ora file, I commented entries for IPC protocol. After that listener started.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
(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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.