Help with TNS 12500: listener could not...

[jnair]

Hi all,

The situation:
1. Ora 806 server *64 bit* version running on a server, on this same m/c, ora listener operating on the tnsnames from the DNS.
2. The same server which hosts the ora server running a *32 bit* third party software that makes OCI calls to an Ora DB, and writes to/reads from this DB.
3. Several of the operations that the 3P s/w makes goes on Okay, but at some point it gives out the following error message:
>[THREAD 4370] - Error call oci API [OCIStmtFetch]:fetch
ORA-12500: TNS:listener failed to start a dedicated server process
[12500]
>[THREAD 4370] - Fetch failed

I try running a perl script using DBI at this same point of time, and the following error message:
DBI->connect(host=localhost;sid=HA;port=1521) failed: ORA-12500: TNS:listener failed to start adedicated server process (DBD ERROR: OCIServerAttach) at stop_record.pl line 26

Could this be a problem of the bit version mismatch? Or becuase of the way the ora client is running? Or is it more likely to be internal to the 3P software?

Please help. Any input would be greatly appreciated.

Thank you very much in advance.

regards,
J.

 

[rishiu]

I don;t Think it is a problem of the bit version mismatch
Or becuase of the way the ora client is running.

I can only suggest
Check for sufficient permissions on the listener and
may be some OS kernel parameters.

 

[jnair]

hi,

rishiu, thanks for the reply.

Which kernel parameters do I need to check? Also, is there a max limit on the number of OCI connections allowed to a DB? Where is this set?

There is a long time delay before one of the records written by the 3P s/w can be read by other OCI connections. Could this be due to a lock?

Thank you in advance.

regards,
J.