ORA-03114 Errors

[appnair]

A little bit of setup is necessary here.
Webserver has a CGI directory holding Opentext's livelink.exe application.It connects to an Oracle DB server
thru a 9.2.0.1.0 client or at least that is what sqlplusw reports.I am an Oracle novice,I am the application admin for livelink.The livelink application uses the instance to
get necessary info back and forth as is necessary.Now here is my qn.
I login to the cgi application.We have AD authentication so that my network creds are passed on to the application.Livelink sends this info to the underlying DB and sees if my user record exists in its table(we call it KUAF) and returns success/failure.If it is a success then until I kill my Browser session I should never be made to re-authenticate.If I leave the app lying for say 10 minutes
I will be made to re-authenticate.My best defense is logs on my app at this point

****************************************************************************************************************
06/13/2005 10:37:10 [3658342553]  0000025004: Oracle error: (0) --> ORA-03114: not connected to ORACLE
06/13/2005 10:37:10 [3658349081]  0000025005: Oracle error: (0) --> ORA-01001: invalid cursor
06/13/2005 10:37:10 [3658349282]  0000025006: KSqlCursor::Open(2000,'select a.ID,a.OwnerID,a.Type,a.Name,a.UserData,b.*,c.OwnerID GroupOwnerID,c.Type GroupType,c.Name GroupName,c.UserData GroupUserData from KUAF a,KUAFUser b,KUAF c where a.Type=:A1 and a.SpaceID=0 and a.Name=:A2 and a.ID=b.UserID and b.GroupID=c.ID') -->'Could not prepare cursor.'
06/13/2005 10:37:10 [3658349398]  0000025007: KSql::Execute(...) --> 'Error executing an Sql statement.',0 records,[sec: 0 msec: 16]
06/13/2005 10:37:10 [3658349521]  0000025008: KConnect::ErrLog --> [10106,5],'Invalid username/password specified.'
06/13/2005 10:37:10 [3658349622]  0000025009: KUAFUser::Get(nairkn) --> 'Invalid username/password specified.'
06/13/2005 10:37:11 [3658652202]  0000025010: CAPI.Log: Mon Jun 13 10:37:11 2005 - 7486093	Func='LL.Login'	Timing:	0.359 0.348 0.359

Some more 
06/13/2005 10:41:22 [3909580408]  0000025054: Oracle error: (0) --> ORA-01041: internal error. hostdef extension doesn't exist

Now here is how I am making the app stay alive.I have scheduled job that hits livelink's cgi every three minutes so other people can login without fail.The client sqlnet.ora and DBserver both has been made with SQLNET.EXPIRE_TIME =60 that did not help either.I confirmed there is no firewall between my windows/IIS server and the Oracle DB server .It is just an Intranet app.

So gurus out there help is needed.Are there trace files that you can employ to see what is going on between my app and the oracle instance ?




Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[lewisp]

How does your application connect to Oracle and what username does it use to connect? The clue to your problem is in the log - 'Invalid username/password specified.'

Does the SQL from your log above work when you run it standalone in SQLPlus? Do you use the same user to connect through your application as you use to connect to SQLPlus?

 

[appnair]

No that is a misleader.The application connects to oracle in the backend using a generic user/pwd account.What I am talking about is the connection after the period of inactivity.You saw my trace log of "select somestuff from kuaf".The application *assumes" that once connected to Oracle it can re-ssue commands to the DB anytime without checking whether or not they are logged in.The invalid username/password " is a translated error because it never could do any transaction with the DB.when the user refreshes the browser a couple of times mysteriously the livelink to oracle transaction becomes active once again and all is well

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937