I make an application in delphi 4 with my database in Oracle 8i, but when I running my aplication, after a week, my listener of my Database failed, and I have to restard my server. my server machine its plataform is Windows NT server 4.0 and all my clientes are Windons NT workstation 4.0
Can you Help me?, this mistake i have every week
Check the listener log file in %ORACLE_HOME%\NETWORK\LOG.
i checked but i don't know to mean this.
i send a new post its subject si Re. ORA - 12500
thanks
Hi,
Here is an explanation for ORA 12500
*Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.
Baliga
Ok, but the enviroment what does it mean?, i don't understand its.
do you think that it have an error, or its configuration is bad?
I Checked the listener.log but I don't know that means
TNSLSNR for 32-bit Windows: Version 2.3.4.0.0 - Production on 06-FEB-01 17:05:33
Copyright (c) Oracle Corporation 1994. All rights reserved.
System parameter file is d:\orant\network\admin\listener.ora
Log messages written to d:\orant\network\log\listener.log
Trace information written to d:\orant\network\trace\listener.trc
Trace level is currently 0
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
This Listener start 06-FEB and yestarday I Restart.
what do you mean about that?
Environment means
ORACLE_HOME
ORACLE_SID
TNS_ADMIN home etc.,
12500, 00000, "TNS:listener failed to start a dedicated server process"
// *Cause: The process of starting up a dedicated server process failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the operation.
// Verify that the ORACLE Server executable is present and has execute
// permissions enabled. Ensure that the ORACLE environment is specified
// correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
// called may not be installed on the local hard drive. Please check that
// the correct Protocol Adapter are successfully linked.
// If error persists, contact Oracle Customer Support.
I'm looking for a similary post with this error, and I found where anybody tell, that check the number of conections server or the Dispatcher, but I don't Know What's Dispatcher?
thank
How do I active the Trace ?
add TRACE_LEVEL_LISTENER = ADMIN
TRACE_DIRECTORY_LISTENER=my_directory
to your listener.ora and restart listener.
You can find trace file under my_directory.