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 [EMAIL PROTECTED] (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 > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > > > > -----Original Message----- > > From: Daniel Fink [mailto:[EMAIL PROTECTED] > > 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/[EMAIL PROTECTED] > > > 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 > > > [EMAIL PROTECTED] > > > (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).