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

From: Kishor Sinha <kishorsinha_at_hotmail.com>
Date: 3 Oct 2001 16:33:22 -0700
Message-ID: <aa88db92.0110031533.7ed3f724@posting.google.com>

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

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

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

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 Received on Wed Oct 03 2001 - 18:33:22 CDT