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
Hi Stephen,
No imp wouldn't close or otherwise impact Oracle instance. I'd look at
init.ora . Someone could make changes there, effective at reboot time
Vadim
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Two things to check immediately:
(1) Is the Oracle service defined as started automatically in the services?
(2) If yes, is there any error reported in alert log of the database?
Import does not shut the database down.
HTH
Arup Nanda
- Original Message -
To: Multiple recipients of
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
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
INLINE
snip
Two things to check immediately:
(1) Is the Oracle service defined as started automatically in
the services?
Yes
(2) If yes, is there any error reported in alert log of the database?
Compared line-by-line the last three starts and they seem identical,
nothing unusual
in the
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
, 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