HP3000-L Archives

January 1999, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Patrick Fourny <[log in to unmask]>
Reply To:
Patrick Fourny <[log in to unmask]>
Date:
Thu, 14 Jan 1999 13:17:47 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (141 lines)
You can have this type of problem with the listener, if your system
is low on contiguous disc sectors. You can check that by issuing
a "DISCFREE A" command at the MPE prompt. On the listing
produced, for each disc you will find a line labeled:

        LARGEST FREE AREA:              nnnn

where nnnn is the largest contiguous free space available.
If this value is too small, sometimes the listener can going
dead.

Patrick

> -----Original Message-----
> From: IT - Finn Iversen Clausen [SMTP:[log in to unmask]]
> Sent: 14 January 1999 11:38
> To:   'Patrick Fourny'
> Subject:      SV: Oracle 7.3.2.3.0.
> 
> Tanks for Your reply.
> 
> Could You get a little more concrete about contig. sectors (listener
> process
> going dead)?
> 
> Best regards
> Finn I Clausen
> Møller & Co. A/S, Denmark
> 
> > -----Oprindelig meddelelse-----
> > Fra:        Patrick Fourny [SMTP:[log in to unmask]]
> > Sendt:      14. januar 1999 11:19
> > Til:        [log in to unmask]
> > Cc: 'IT - Finn Iversen Clausen'
> > Emne:       RE: Oracle 7.3.2.3.0.
> > 
> > Hi,
> > 
> > we are currently running the same version of Oracle on our system
> and
> > don't have any problems using "STARTUP" and "SHUTDOWN" commands
> > via batch files. An example of this follows with its output:
> > 
> > !JOB ORA7SHUT,USERNAME.ACCTNAME;HIPRI;OUTCLASS=,5
> > !SETVAR oracle_home "/SYS/ORACLE"
> > !SETVAR oracle_sid "732"
> > !SVRMGRL
> > CONNECT INTERNAL
> > SHUTDOWN
> > EXIT
> > !EOD
> > !EOJ
> > 
> > JOB ORA7SHUT,MANAGER.SYS,PUB.
> > Priority = DS; HIPRI; Time = UNLIMITED seconds.
> > Job number = #j655.
> > THU, JAN 14, 1999, 11:02 AM.
> > HP3000  Release: C.55.00   User Version: C.55.00
> > MPE/iX  HP31900 C.05.08  Copyright Hewlett-Packard 1987.
> > All rights reserved.
> > :SETVAR oracle_home "/SYS/ORACLE"
> > :SETVAR oracle_sid "732"
> > :SVRMGRL
> > 
> > 
> > Oracle Server Manager Release 2.3.2.0.0 - Production
> > 
> > Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
> > 
> > Oracle7 Server Release 7.3.2.3.0 - Production Release
> > With the distributed, replication, parallel query and Spatial Data
> > options
> > PL/SQL Release 2.3.2.3.0 - Production
> > 
> > SVRMGR> Connected.
> > SVRMGR> Database closed.
> > Database dismounted.
> > ORACLE instance shut down.
> > SVRMGR> Server Manager complete.
> > 
> > :EOJ
> > CPU sec. = 8.  elapsed min. = 1.  THU, JAN 14, 1999, 11:02 AM.
> > 
> > For the listener process going dead, check your contig. sectors with
> > "DISCFREE A". The largest free area should be big enough to allow
> > a new connection to be created (due to the fork() call made by the
> > listener).
> > 
> > Regards,
> > 
> >  _|_|_|_|_|  _|_|_|_|_|        / \         P. Fourny
> >  _|      _|  _|      _|       /| |\        System Engineer
> >  _|      _|  _|             \  | |  /      AC Automation Center
> SA/NV
> >  _|_|_|_|_|  _|          ----\     /--     Keiberg Business Park
> >  _|      _|  _|          ----/     \--     Brussels Airport Area 
> >  _|      _|  _|      _|     /  / \  \      Excelsiorlaan 85
> >  _|      _|  _|_|_|_|_|       /| |\        B-1930 Zaventem 
> > 
> > 
> > > -----Original Message-----
> > > From:     IT - Finn Iversen Clausen [SMTP:[log in to unmask]]
> > > Sent:     13 January 1999 22:43
> > > To:       [log in to unmask]
> > > Subject:  Oracle 7.3.2.3.0.
> > > 
> > > Hei there - Denmark is calling.
> > > 
> > > We are using our 995/400 as an DB-server with Oracle version
> 7.3.2.3.0
> > > (Win95 clients).
> > > 
> > > Everything is running Ok, when keeping "fingers off", but we are
> not
> > > able to
> > > control our OracleDB via batchjobs, ie. "STARTUP" and "SHUTDOWN"
> for
> > > backup-purposes (error messages like "END OF COMMUNICATION
> CHANNEL"
> > > occurs).
> > > Issuing the commands from a MPE-session works OK, but who wants to
> get
> > > an
> > > IBM-like OracleDB-administrator working late hours (MPE is build
> for
> > > working
> > > 24-hours a day - i'm not).
> > > 
> > > Also very often we have problems with our Oracle network listener
> > > "going
> > > dead" (client says "LOST CONTACT"). Seems to relate to often start
> /
> > > shutdown of DB and listener. Only way arround is shutting down the
> > > HP3000.
> > > 
> > > Anyone having experience with Oracle on MPE?
> > > 
> > > Best regards
> > > Finn I Clausen
> > > Møller & Co. A/S, Denmark.

ATOM RSS1 RSS2