don't be... this means you are doing something we strongly advocate on this list... reading the manuals and learning.
--- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > 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). > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
