(ORA-12500) error message

[abcd]

Sometimes this errors appears when a user is working :
ORA-12500 Listener failed to start a dedicated server process
I tried to stop the listner and start again, the database work properly,,,
After some hours, the message appears again, and I stoped the listner and started again, the database work properly,,, and so on,,,
What is the problem ? How can I solve this problem ?


[Edited by abcd on 09-02-2001 at 07:07 AM]

[padmam]

Dear Friend, 2nd Sep 2001 17:04 hrs chennai

Welcome to dbasupport.com .I kindly request you to mention O/S and DB version in future.

I persume it should ne windows NT.Its where lot of Problem like this Occurs.With win2000 its still more.

Look at the folowing solution i traced from a simillar problem.


A. TNS-12500 on Microsoft Windows NT
B. Intermittent TNS-12500 Errors on Microsoft Windows NT


A. TNS-12500 on Microsoft Windows NT
-----------------------------------------
1. Please make sure that the userid that installed/started
oracle, and started the listener is administrator.

2. Go to the Control Panel by clicking on [START]-->
[Settings]---> [Control Panel] and then double click
on "Services". A window is displayed which
looks similar to this:

+---------------------------------------------------------+
| |
| Service Status Startup |
+---------------------------------------------------------+
|OracleNamesService80 Manual |
|OracleServiceORCL Started Auto |
|OracleStartORCL Started Auto |
|OracleTNSListener Started Auto |
|OracleTNSListener80 Manual |
|OracleWebAssistant Manual |
|pcANYWHERE Service Started Manual |
+---------------------------------------------------------+

Look at "OracleService" and "OracleStart". These two
services are followed by your SID name (in this case ORCL).
These services should be started. If they are not click
on the [START] button on the right side of the dialog box.

3. Verify the SID names shown with "OracleService" and
"OracleStart" in the Control Panel:Services are the same
SID names in the client's TNSNAMES.ORA and the server's
LISTENER.ORA files.

4. Make sure that the listener is logged on as the System
Account. You can check this by going into Control
Panel/Services highlight the OracleTNSListener then
click on Startup. The listener should be logged on as
the System Account. Once you make this change make
sure that you stop and start the listener.

5. Make sure that the tnsnames.ora file doesn't specify the
ORACLE_HOME parameter in the connect_data section. If it
does, remove it.

6. You may want to simply try restarting your instance.

B. Intermittent TNS-12500 Errors on Microsoft Windows NT
---------------------------------------------------------

1. Increase the amount of memory available to the system
either by removing unnecessary processes or increasing
the amount of physical memory.

2. Increasing the amount of swap space will also
temporarily help relieve the symptoms.

3. Disable OTRACE. OTRACE is a tracing feature that can
cause many problems. OTRACE is enabled by default.
To disable OTRACE:

a. Stop the Oracle database.
b. Go to the orant/otrace/admin directory.
c. Delete all files with a ‘.dat’ extension.
d. Restart the Oracle database.

4. The TNS-12500 can be a result of the 'processes'
parameter in the init.ora file being too low.

Cheers

Padmam

[padmam]

Hi, 2nd sep 2001 17:25 hrs chennai

On unix platform look at this link.

http://technet.oracle.com/support/bb...ontent/508.htm

I am sorry the problem is not only with win ,not even with unix ,even not with oracle but with all softwares.

Cheers

Padmam