I'm using Windows XP as my Oracle database server. Today there was a change in the IP address if the database server.
I want start my database instance's listener again. Windows XP prompst that:
OracleOraDb11g_home1TNSListenerMZOA_LISTENER service on the local computer started and stopped. Some services stop automatically if they do not have anything to do.
(ps:MZOA is the name of my db instance)
listener.ora to reflect the new IP.
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. ADR_BASE_MZOA_LISTENER = D:\app\Administrator MZOA_LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =CHINA-F781B4F30)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521)) #caution:192.168.1.100 is my new ip (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.100)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) SID_LIST_MZOA_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (SID_NAME =mzoa) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) ) )
Unfortunately when I want start the listener, Windows still shows the above prompt. And I donn't know how to do.