RE: Please look at this imp command

I'm starting to gather that -- that the reboot did it.

Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora.

The users have been using the application for the last four hours without
any issues, so, what is the graceful way of shutting down the database, via,
EM and do a close?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
> -----Original Message-----
> From: Daniel Fink [mailto:daniel.fink_at_sun.com]
> Sent: Tuesday, July 29, 2003 1:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Please look at this imp command
>
>
> Stephen,
>
> From your email, here are the steps as I understand them:
> 1) run imp command
> 2) reboot the server (NT/Win2k?)
> 3) check database and find it is not open
>
> The reboot closed the database (and probably not gracefully).
> When the server restarted, the service may have started, but
> the database was not opened. I know there are registry
> settings to control this, but I don't know them off the top
> of my head. I am sure someone on the list can provide them.
>
> The bottom line...imp did not close the database, the server
> reboot did.
>
> Daniel Fink
>
>
> Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
> >
> > imp tpocs/******@tpocs
> > file=c:\Latest_Reference_Files\pharm_jul_2003.dmp
> > log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs
> > touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608
> >
> > Scenario:
> >
> > I ran this command (as instructed by the tier III tech),
> got a couple
> > of warnings but it did import 28K plus rows into arc_ndc. Before I
> > ran the command at the command NT command level, I
> truncated arc_ndc
> > via SQL*Plus.
> >
> > After the command completed I rebooted the server, there was no
> > direction to do this, I just did it for good measure
> figuring I would
> > get a clean oracle instance going. When the server finished the
> > reboot, oracle wasn't up -- or I should say the database wasn't
> > opened. I had to open the database as SYSDBA.
> >
> > Did the imp command close the database? I don't see any
> directive to
> > do so, but being new maybe there is something I don't understand.
> >
> > Thanks for your help and patience.
> >
> > v/r
> >
> > Stephen S. Wolfe, GS-11, DAFC
> > Data Services Manager
> > stephen.wolfe_at_macdill.af.mil
> > (813) 827-9974 DSN 651-9974
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
> > INET: Stephen.Wolfe_at_macdill.af.mil
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may
> also send
> > the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: Stephen.Wolfe_at_macdill.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).