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 <Stephen.Wolfe_at_macdill.af.mil>
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
> 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).
>
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: wisernet100_at_yahoo.com
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).
Received on Tue Jul 29 2003 - 20:24:23 CDT