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.
|