RE: Please look at this imp command

I'm embarrassed ...

Shutdown immediate via SQL*Plus after verifying all users have disconnected.

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: Wolfe Stephen S GS-11 6 MDSS/SGSI
> Sent: Tuesday, July 29, 2003 1:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
-- 
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).