RE: Help Needed: DBI (no error string)

From: Hariharan (hariharan_at_mdanywhere.com)
Date: 01/02/04

  • Next message: Jeff Urlwin: "RE: Help - multiple Oracle versions" 
    To: "Michael Nhan" <mnhan@watson.wustl.edu>
Date: Fri, 2 Jan 2004 13:22:55 -0500

    Hi Micheal,
              Thanks. i presently dont have control over the server will have to
    ask the DBA to do the same. I will try and put the trace to sqlnet level to
    isoloate the error. Thanks agian for the help.

    Regards
    Hariharan Jayaraman.

    -----Original Message-----
    From: Michael Nhan [mailto:mnhan@watson.wustl.edu]
    Sent: Friday, January 02, 2004 1:11 PM
    To: Hariharan
    Cc:
    Subject: RE: Help Needed: DBI (no error string)

    > Date: Fri, 2 Jan 2004 12:22:19 -0500
    > From: Hariharan <hariharan@mdanywhere.com>
    > To: Michael Nhan <mnhan@watson.wustl.edu>
    > Cc: dbi-users@perl.org
    > Subject: RE: Help Needed: DBI (no error string)
    >
    > Hi,
    > Thanks for reply. Swap space of the machine that i am running the
    > application or on the server ,the Oracle Docs says that it is due to some
    > error on the server. Also i am able to connect to the server through the
    > client always.
    ORA-03113 is when a session loose contact with its shadow process.
    Sometime this is due to not enough swap space on the server. It can also
    be caused by network problems. Can you check the dump dest to see if
    there were any trc files created by the terminated session. ORA-3113 can
    be accompany by other ORA errors that can help track down the cause of the
    problem. You can also turn on tracing in dbi and at the sqlnet level to
    see where and when its dying if it continues consistently.

    >
    > Thanks for letting me know abt the oracle 9i client issue. One question
    > though when i compile DBD:Oracle it is not able to detect the oracle
    version
    > when i do perl Makefile.PL.
    Hmm, that is strange. The oracle s/w on the client, is it a client
    install or full install? It looks at a couple of place for the version
    and then attempts to guess the version from the install directory. if
    you look in the Makefile.PL you can see where its trying to decipher the
    database version.

    Michael

  • Next message: Jeff Urlwin: "RE: Help - multiple Oracle versions"

    Relevant Pages

    • Re: problem connecting to db.
      ... the server and the client are at the same machine (the process is ... The VB6 client and the server are on the same machine, ... Oracle server software using one, and the Oracle client using the ... Look at the services on the server to verify that the Oracle Listener ...
      (comp.databases.oracle.misc)
    • Re: problem connecting to db.
      ... Have you checked the listener log file on the database server? ... client is correct, and that the connection string that you are ... the Oracle client would be looking for a server ...
      (comp.databases.oracle.misc)
    • Re: ODBC-error ORA-12535: TNS:operation timed out when trying to connect to Oracle 9.2.0
      ... I'm trying to connect to an Oracle 9.2 database via TCP from Microsoft ... Microsoft Windows Server 2003 SP1 ... Try with SQL*Plus on your client! ...
      (comp.databases.oracle.misc)
    • Re: SQL Server 2005 and Oracle Instant Client 10.2.0.3
      ... The Oracle installer doesn't always ... Microsoft Office SharePoint Server 2007: ... Having some problems with the Oracle Instant Client 10.2.0.3 and SQL ... "Oracle client and networking components were not found. ...
      (microsoft.public.sqlserver.connect)
    • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
      ... else's server for testing some SELECT statements I'm writing for them. ... I just want a free client because I don't own the Oracle license. ... How do I get a free Oracle client installed, if possible, so I can test some SQL statements. ... There is no documentation with that download. ...
      (comp.databases.oracle.tools)