"IKerr." <i.b.kerr.n.o-spam_at_leeds.ac.uk> wrote:
>Hi,
>
>I had a w2k crash which needed a partial re-install. I have also
>re-installed Oracle 9 & Oracle DS. This is on a local desktop machine.
>Towards the very end of the install there was a glitch (possibly because I
>didn't know how to answer some net setup questions ?). Now when I try and
>startup my old db I get
>
>ORA-12541: TNS: no listener
>
>I have searched on the newsgroups and tried this
>
>c:\> lsnrctl
>
>and then:
>
>LSNRCTL> start
>Starting tnslsnr: please wait...
>TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
>System parameter file is C:\orant\network\admin\listener.ora
>Log messages written to C:\orant\network\log\listener.log
>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521))
>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))
>STATUS of the LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Prod
>tion
>Start Date 12-MAR-2003 12:01:29
>Uptime 0 days 0 hr. 0 min. 2 sec
>Trace Level off
>Security OFF
>SNMP OFF
>Listener Parameter File C:\orant\network\admin\listener.ora
>Listener Log File C:\orant\network\log\listener.log
>Listening Endpoints Summary...
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
>Services Summary...
>Service "PLSExtProc" has 1 instance(s).
>Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
>Service "myGlobal" has 1 instance(s).
>Instance "myGlobal", status UNKNOWN, has 1 handler(s) for this service...
>The command completed successfully
>LSNRCTL>
>
>When I try to logon to the db in Enterprise Manager Console (standalone). I
>get:
>
>ORA-12500: TNS listener failed to start a dedicated server process.
>
>C:\orant\network\log\listener.log
>
>shows
>
>TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-MAR-2003
>12:08:44
>Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>System parameter file is C:\orant\network\admin\listener.ora
>Log messages written to C:\orant\network\log\listener.log
>Trace information written to C:\orant\network\trace\listener.trc
>Trace level is currently 0
>Started with pid=1276
>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
>TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
>12-MAR-2003 12:08:46 *
>(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Me))(COMMAND=status)(ARGUMENTS=64)
>(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
>12-MAR-2003 12:09:13 *
>(CONNECT_DATA=(SERVICE_NAME=myglobal)(CID=(PROGRAM=C:\Program
>Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=myhost)(USER=Me))) *
>(ADDRESS=(PROTOCOL=tcp)(HOST=**.*.***.***)(PORT=1638)) * establish *
>myglobal * 12500
>TNS-12500: TNS:listener failed to start a dedicated server process
>TNS-12560: TNS:protocol adapter error
>TNS-00530: Protocol adapter error
>32-bit Windows Error: 2: No such file or directory
>
>What file/directory is this referring to & is that the problem or a red
>herring ?
>Where it referrs to HOST=**.*.***.*** - that is the IP of my cable modem -
>why ???
>Also, in the listener.ora & tnsnames.ora there are two entries that I don't
>understand:
>
># LISTENER.ORA Network Configuration File:
>C:\orant\network\admin\listener.ora
># Generated by Oracle configuration tools.
>LISTENER =
>(DESCRIPTION_LIST =
>(DESCRIPTION =
>(ADDRESS_LIST =
>(ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(PORT = 1521))
>)
>)
>)
>SID_LIST_LISTENER =
>(SID_LIST =
>(SID_DESC =
>(SID_NAME = PLSExtProc)
>(ORACLE_HOME = C:\orant)
>(PROGRAM = extproc)
>)
>(SID_DESC =
>(GLOBAL_DBNAME = myGlobal)
>(ORACLE_HOME = C:\orant)
>(SID_NAME = myGlobal)
>)
>)
>
># TNSNAMES.ORA Network Configuration File:
>C:\orant\network\admin\tnsnames.ora
># Generated by Oracle configuration tools.
>MYGLOBAL =
>(DESCRIPTION =
>(ADDRESS_LIST =
>(ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(PORT = 1521))
>)
>(CONNECT_DATA =
>(SERVICE_NAME = myglobal)
>)
>)
>INST1_HTTP =
>(DESCRIPTION =
>(ADDRESS_LIST =
>(ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(PORT = 1521))
>)
>(CONNECT_DATA =
>(SERVER = SHARED)
>(SERVICE_NAME = MODOSE)
>(PRESENTATION = http://HRService)
>)
>)
>EXTPROC_CONNECTION_DATA =
>(DESCRIPTION =
>(ADDRESS_LIST =
>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>)
>(CONNECT_DATA =
>(SID = PLSExtProc)
>(PRESENTATION = RO)
>)
>)
>
>What are "PLSExtProc" & "INST1_HTTP" ?
>Can any kind soul help a newbie out ?
>
>thanks
>
>Iain
>
>
>
How are you starting up the instance's service ( the one ORADIM built) ...Manually or as an automatic service...
After the service starts ( does it actually start? ), do you set your ORACLE_SID before connecting to run the startup
commands?
When are the errors generated?
.
Received on Fri Mar 14 2003 - 09:06:47 CST
