Brian Yan <by999_at_hotmail.com> wrote in message
<823tia$r4g$1_at_nnrp1.deja.com>...
> I had the same experience when we were HP-UX 10.20, Oracle 7.3.4.4 and
> MTS was on. We switched MTS off to get around this problem.
>
However, multi-threaded-server is not set up in the system:
SVRMGR> show parameter MTS
NAME TYPE VALUE
----------------------------------- ------- ------------------------------
mts_dispatchers string
mts_listener_address string (address=(protocol=ipc)(key=%s
mts_max_dispatchers integer 0
mts_max_servers integer 0
mts_multiple_listeners boolean FALSE
mts_servers integer 0
mts_service string ijk
SVRMGR>
> In article <3844cd93_at_news.lhsgroup.com>,
> "Cheong" <ccheong_at_my.lhsgroup.com> wrote:
> > Hi:
> >
> > Surely someone has come across or known about this oracle error.
> >
> > I telnet into an HP-UX 10.20 running oracle 7.3.2.2.0, invoke sqlplus,
> > connect to the database, and execute a "big" select statement.
> >
> > After some 15 minutes, I get:
> >
> > SQL> SELECT TM1.TMCODE, 1, to_date('13-NOV-1999','DD-MON-YYYY'), 'P',
> > TM1.SPCODE, TM1.SNCODE,
> > 2 TM1.SRVIND, TM1.ECHIND, TM1.AMTIND, TM1.FRQIND, TM1.SUBSCRIPT,
> > TM1.ACCESSFEE, TM1.EVENT,
> > 3 TM1.PROIND, TM1.ADVIND, TM1.SUSIND, TM1.SUBGLCODE, TM1.ACCGLCODE,
> > TM1.USGGLCODE, TM1.SUBJCID,
> > 4 TM1.ACCJCID, TM1.USGJCID, TM1.SUBSERV_CATCODE, TM1.SUBSERV_CODE,
> > TM1.SUBSERV_TYPE, TM1.ACCSERV_CATCODE,
> > 5 TM1.ACCSERV_CODE, TM1.ACCSERV_TYPE, TM1.USGSERV_CATCODE,
> > TM1.USGSERV_CODE, TM1.USGSERV_TYPE, TM1.CSIND,
> > 6 TM1.CLCODE, TM2.EGCODE, TM1.DEPOSIT, 1 FROM MPULKTM1 TM1,
> MPULKTM2 TM2
> > 7 WHERE TM1.TMCODE = 123 AND TM1.TMCODE = TM2.TMCODE(+) AND
> TM1.SPCODE =
> > TM2.SPCODE(+) AND TM1.SNCODE = TM2.SNCODE(+)
> > 8 AND 'U' = TM2.USGIND(+);
> >
> > ERROR:
> > ORA-03113: end-of-file on communication channel
> >
> > SQL>
> > SQL> select *
> > 2 from v$database;
> > from v$database
> > *
> > ERROR at line 2:
> > ORA-03114: not connected to ORACLE
> >
> > What might be the cause? And what is the best approach to handle this
> > problem?
> >
> > Any suggestion is very much appreciated.
> >
> > Thank you and have a good day.
> >
> > Regards,
> > Cheong
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 01 1999 - 21:39:03 CST
