Server Express Animator/Oracle Issues

From: Chris (ctaliercio_at_yahoo.com)
Date: 10/25/04 

Date: 25 Oct 2004 06:54:32 -0700

Hello all. I'm hoping someone else has experienced this problem and
can offer some assistance. I am in the process of upgrading from MF OC
4.2 to SE 2.2 SP1. My environment is HP-UX 11i, Oracle 9.2.0.4.

My problem is an unusual one. I have rebuilt the rtsora using the
$ORACLE_HOME/precomp/lib/ins_precomp.mk file. The runtime unit appears
to be functioning properly.

My next step was to start rebuilding my application. Previously we had
been using separate procob18 and cob commands to compile the programs,
however now I am using the following command line to compile:

cob -ug -a -v \
        -k ${FILENAME}.pco \
        -C"p(cobsql) cobsqltype==oracle end-cobsql endp" \
        -C IBMCOMP \
        -C NESTCALL

I have program A, which prompts for a user id/password then call
program B to connect to the database. After a successful connection,
control is returned to program A which then procedes with whatever
else the application requires.

Here is where things get odd: when I run these programs using the new
rtsora, everything is is great - the application runs exactly as it
has always run using OC 4.2. Now, when I try to animate the
application (using 'export COBSW=+1' and then 'rtsora progA') I get an
error code 12540 from Oracle when the connection is attempted.
According to Oracle, this error means "TNS: internal limit restriction
exceeded", with a cause of "Too many TNS connections open
simultaneously" and an action of "Wait for connections to close and
re-try." I am the only one using the test server where I am
experimenting with the upgrade process - so this doesn't make any
sense.

To make things even more bizarre, when I directly animate progB and
force the user id/passwd information into the appropriate variables,
the connection to Oracle succeeds.

I'm curious as to why:

1)Why would the results under animator be any different than when I am
running the application normally?

2) Why would the connection work directly, but not when inside of a
"called" program?

Sorry to be so long-winded, but I figured the more detail the better
in this scenario.

Any and all help is appreciated.

Thanks,
Chris

Relevant Pages

  • Re: Server Express Animator/Oracle Issues
    ... I am in the process of upgrading from MF OC ... > error code 12540 from Oracle when the connection is attempted. ... > experimenting with the upgrade process - so this doesn't make any ... routines before it reaches the call to program B. I found that if I ...
    (comp.lang.cobol)
  • JDBC
    ... I am new to Java language, I have an application developed under Java ... 2.0, which has a connection to Oracle 7.3.1, now we are upgrading to ... Oracle 9i. ...
    (comp.lang.java.programmer)
  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.framework.adonet)