ORA-12500 on AIX 4, Oracle 7.1.6.2.0- Please HELP

ORA-12500 on AIX 4, Oracle 7.1.6.2.0- Please HELP

Post by Kishor Sin » Fri, 05 Oct 2001 08:33:22



Can someone help ,

I am trying to configure oranet on AIX 4 oracle 7.1.6.2.0.
Listener starts OK, pls see the status:
LSNRCTL> stat
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.50.20)(PORT=1522))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000:
Version 2.1.6.1n
Start Date                03-OCT-01 12:13:17
Uptime                    0 days 0 hr. 14 min. 39 sec
Trace Level               off
Security                  OFF
Listener Parameter File   /home/oracle/network/admin/listener.ora
Listener Log File         /home/oracle/network/log/listener.log
Services Summary...
  icor          has 1 service handlers
The command completed successfully

Have installed forms 6 and configured net config on PC running win98
and tnsping80 is successful.

C:\orawin95\NET80\ADMIN>tnsping80 icor

TNS Ping Utility for 32-bit Windows: Version 8.0.6.0.0 - Production on
03-OCT-01
 12:47:23

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact
(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=192.168.
50.20)(Port=1522))
OK (260 msec)

BUT, when I try to connect using Forms get the message

ORA-12500 TNS:listener  failed to start a dedicated server process

The listener log has the following enrty:
$ pg listener.log

TNSLSNR for IBM/AIX RISC System/6000: Version 2.1.6.1.0 - Production
on 03-OCT-0
1 12:13:17

Copyright (c) Oracle Corporation 1994.  All rights reserved.

System parameter file is /home/oracle/network/admin/listener.ora
Log messages written to /home/oracle/network/log/listener.log
Trace information written to /home/oracle/network/trace/listener.trc
Trace level is currently 0

Listening on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=192.
168.50.20)(PORT=1522)))
TIMESTAMP ** EVENT [** SID] ** RETURN CODE
03-OCT-01 12:13:17 ** status ** 0
03-OCT-01 12:13:41 ** status ** 0
03-OCT-01 12:13:44 ** services ** 0
03-OCT-01 12:14:05 ** version ** 0
System parameter file is /home/oracle/network/admin/listener.ora
Log messages written to /home/oracle/network/log/listener.log
Trace information written to /home/oracle/network/trace/listener.trc
Trace level is currently 0
03-OCT-01 12:14:42 ** reload ** 0
03-OCT-01 12:14:46 ** version ** 0
03-OCT-01 12:14:50 ** status ** 0
03-OCT-01 12:14:53 ** services ** 0
03-OCT-01 12:15:55 ** services ** 0
03-OCT-01 12:16:03 ** status ** 0
03-OCT-01 12:17:22 ** version ** 0
03-OCT-01 12:18:19 ** establish ** ICOR ** 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12538: TNS:no such protocol adapter
03-OCT-01 12:18:49 ** establish ** ICOR ** 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12538: TNS:no such protocol adapter
03-OCT-01 12:19:27 ** ping ** 0

I have tried with changing listeners to PORT 1521,1522 and 1526 but
has the same problem.

Can someone help me please??

Kishor

 
 
 

1. ORA-12500 ....Please help

Hello there. I am an Aix System Administrator who knows very litle about
Oracle. But in our environment we have Oracle 7.3.3.6 installed in an
RS/6000 running AIX 4.2.1. We have this system talking to another RS/6000
with Baan 4 through SQL-NET.

Here is my problem: We have around 120 users logging into the Baan-AIX box
and making requests to the Oracle system (on the other box). Once in a
while, 2 to 3 times a week, when a user tries to do some work they get the
following message:

ORA-12500: TNS:listener failed to start a dedicated server process

This error is also logged in Baan log files. Our Oracle DBA says that there
is no problem with the listener and that this should be a Baan error or an
Operating system error.

Do anyone out there could tell me why we are getting this error sometimes??
Now more often than before....

Any help will be appreciated

If this is not the right newsgroup, please let me know which one is the
right.

Thanks,

Beatriz De Stefano

2. hide a table

3. HELP Please! ora-12500

4. Exception at Connect to Sybase / TCP_NODELAY

5. Please help with ORA-12500

6. R83 on 486

7. Help Please ! ora-12500 error

8. Browse

9. Y2k - Ora 8.04 - ORA-12500

10. ORA-12203, ORA-12500 , Connect failed.

11. HELP:ORA-12500 TNS: listener failed to start dedicated server process

12. ORA-12500 Help!!!