Re: how to trace OCIStmtExecute failed ORA-00028: your session has been killed

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Thu, 13 Dec 2007 19:25:19 -0800

I put sqlnet expire_time =60 but it didnt help so I opened a SR and they
advised me to
to set this event .28 trace name errorstack forever, level 10' . which I did
and waiting for tomorrow to see how it goes tonight .


On Dec 13, 2007 8:42 AM, Jared Still <jkstill@xxxxxxxxx> wrote:

> if  "audit_sys_operations=TRUE" is set, you may want to look at the audit
> files.
>
>
> On Dec 11, 2007 6:10 PM, Prasad <p4cldba@xxxxxxxxx> wrote:
> > All,
> >
> > I am getting lot of messages as such
> >
> > OciDataSource::executeStatement OCIStmtExecute failed ORA-00028: your
> > session has been killed
> >
> > in the client side .and I tried looking around to see if there is any
> alter
> > system from database or any cron jobs but could not .
> >
> >  when I did a pfiles on the initiator process on the client host  I see
> that
> > there are open socket
> >
> > 58: S_IFSOCK mode:0666 dev:303,0 ino:15888 uid:0 gid:0 size:0
> >       O_RDWR FD_CLOEXEC
> >         sockname: AF_INET 172.16.4.135  port: 59939
> >         peername: AF_INET 172.16.4.140  port: 1521
> >
> > but i do not see any separate unix process/child process  for these
>  socket
> > connection.   but the db host has a separate process for all these open
> > sockets coming  from the client server.
> >
> > Can someone please direct me how to start the trace here  or any
> direction
> > to resolve this .
> >
> > thanks in advance
> >
> > thanks
> > -prasad
> >
> >
> >
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

Other related posts: