Re: (O8/NT) OEM & running jobs

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Tue, 02 Feb 1999 09:17:01 -0800
Message-ID: <36B7330D.C662FFDF@us.oracle.com>

Ken

Generally this message means the database is part way up i.e.. the instance is started but not mounted, or the database is mounted but not open, when the startup command is issued. You need to investigate why this is the case, and either:

Shut it down properly before issuing the startup command
If it should b part way up use the relevant alter database mount/open command.

HTH. Pete

Ken Rachynski wrote:

> Good day,
>
> I'm having some difficulty working with OEM and getting a database
> startup job to run properly. I'm using Seagate BackupExec to backup my
> database with its Oracle Agent which gets hot backups of my database.
> Once a week, I'd like to shut the database right down and get a cold
> backup of the system. To this end I have a job that runs a shutdown on
> my database. After my backup would have run, a second job is supposed to
> start the database back up again. Originally, I was running OEM from the
> database that I was shutting down, but realised the error of my ways
> when the agent crashed immediately after the database shut down. The
> startup job is now failing with ORA-01081: cannot start already-running
> ORACLE - shut it down first.
>
> Anybody a solution to this particular problem? Alternatively, I'll
> accept a different means of shutting my database down prior to backing
> up and restarting it afterwards.
>
> I'm using Oracle 8.0.4 on NT 4 (SP3).
>
> --
> Ken Rachynski
> Database Analyst
> krachyn_at_cadvision.com
> <http://www.cadvision.com/krachyn>
> ICQ: 3113514
--

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Feb 02 1999 - 11:17:01 CST