Knowledge Management

Question:
HI all..
We have SAP 4.6B with NT 4.0 with Spkg 6.0 as OS with Oracle version 8.0.6.0. I am facing a typical problem. We are planning to change IP address of entire network and as a test case we are doing it first in the devp server. The server is provided with two network adapters and it is teamed. The current IP address is 200.200.200.xxx and we are planning to change to 192.168.200.xxx. As per the note no 403708 we have made required modifications but when we restart the system the TNSLISTENER is not getting loaded. But when we revert back the IP address and checked, then it is working fine. The following error message I am getting in listener.log file
NSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 23-JUL-2003 14:02:04
(c) Copyright 1999 Oracle Corporation. All rights reserved.
System parameter file is H:\orant\NET80\admin\listener.ora
Log messages written to H:\orant\NET80\log\listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\GT1.WORLDipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\GT1ipc))
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=gt1dev)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 50: Unknown error
Then I replaced the hostname with IPaddress in listener.ora and the following error message I am getting.
NSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 22-JUL-20
03 18:46:44
(c) Copyright 1999 Oracle Corporation. All rights reserved.
System parameter file is H:\orant\NET80\admin\listener.ora
Log messages written to H:\orant\NET80\log\listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\GT1.WORLDipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\GT1ipc))
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTO
COL=TCP)(HOST=192.168.200.5)(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
32-bit Windows Error:49: Unknown error
Again I changed the port no from 1527 to 1521 and tried . Even then same error message I am getting.
As per note no 384839 I have uninstall SPX protocol thru oracle installer. Now TCP/IP protocol is only available.
Please help me sort out this issue
Regards
Dinesh
Answer:
hi,
Try replacing the old Listener.ora with a newly created file with the new entries..
If this doesn't work...Create a new listener service alltogether..and check out if its working..Also add the new ip address and its hostname in the hosts file..
rgds
nainesh
Answer:
Dear Mr.Nainesh,
I have recreated the listener using oracle net8 assistant and the following error I am getting. The hosts file already contains the new IP.
TNSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 24-JUL-2003 14:38:01
(c) Copyright 1999 Oracle Corporation. All rights reserved.
System parameter file is H:\orant\NET80\admin\listener.ora
Log messages written to H:\orant\NET80\log\listener.log
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.5)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 50: Unknown error
Please advise.
Regards
Dinesh
Answer:
hi,
Please post the listener.ora and also the log file...
rgds
nainesh
Answer:
Dear Mr. Nainesh,
This is the listener.ora parameter.
# H:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:H:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.5)(PORT = 1521))
This is the error I am getting in listener.log
TNSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 24-JUL-2003 15:37:41
(c) Copyright 1999 Oracle Corporation. All rights reserved.
System parameter file is H:\orant\NET80\admin\listener.ora
Log messages written to H:\orant\NET80\log\listener.log
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.5)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 50: Unknown error
Please help me to sort out the issue.
Regards
Dinesh
Answer:
This is the listener.ora parameter.
# H:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:H:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.5)(PORT = 1521))
Please post the complete listener.ora file....Where are the entries for your DB SId....SID_LIST_LISTENER...
It should be somthing like this...
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.5)(PORT = 1527))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\ora8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = )
(ORACLE_HOME =d:\ora8i)
(SID_NAME = ORCL)
)
)
Answer:
Dear Mr.Nainesh
Here is the latest listener.ora
H:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:H:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = GT1.WORLD))
(ADDRESS = (PROTOCOL = IPC)(KEY = GT1))
(ADDRESS = (PROTOCOL = TCP)(HOST = gt1dev)(PORT = 1527))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = GT1)
(ORACLE_HOME = H:\orant)
)
)
THis is the latest listener.log
NSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 25-JUL-2003 11:34:25
(c) Copyright 1999 Oracle Corporation. All rights reserved.
System parameter file is H:\orant\NET80\admin\listener.ora
Log messages written to H:\orant\NET80\log\listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\GT1.WORLDipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\GT1ipc))
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=gt1dev)(PORT=1527)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 50: Unknown error
Please help me to solve this problem
Regards
Dinesh
Answer:
hi,
Your listener file seems to be okay...The problem could be at your network level settings...Check those thoroughly...
One more alternative is to trace the listener....You can do that by..
adding these lines to the listener.ora file
TRACE_LEVEL_LISTENER = USER OR ADMIN #(ADVANCED LEVEL)
TRACE_FILE_LISTENER = <FILENAME> i.e TEST
TRACE_DIRECTORY_LISTENER = <PATH WHERE THE TRACE FILE SHOULD BE STORE>
Check out the output....maybe u will get some lead..
Since you are saying that once to change the IP back to the original one the listener works fine.....i think u should double check all the network settings on the Server....IP..subnet..gateway etc...
rgds
nainesh