938946 wrote:What is this "orcl" entry for?
# listener.ora Network Configuration File: C:\app\oracle\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
ADR_BASE_orcl = C:\app\oracle
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\oracle\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\11.2.0\dbhome_2\bin\oraclr11.dll")
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
LISTENER =I hope that "HOST = hostname" has been modified in this posting for public consumption, and in your actual file you have the actual name of the host system.
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
ADR_BASE_LISTENER = C:\app\oracle
938946 wrote:So was that entry in your listner.ora supposed to be part of the SID_LIST section? I'm suggesting that your listener.ora is malformed. If you simply delete it (rename it to listener.save), you should be able to restart your listener with no problems. It will come up with all default values, which should be fine. Within a couple of minutes of coming up, all running databases will have registered with it.
no another db not installed in home_1 but developer suite is installed but in different drive and home."orcl" is name of my database
and orcl db is running but listener is not running.why unable to start my listener using services.msc in windows and unable to create new listener using net configuration assistant (giving error as "could not create listener")