Please look at this imp command

2003-07-29 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
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).



RE: Please look at this imp command

2003-07-29 Thread Gorbounov,Vadim
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


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: Gorbounov,Vadim
  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).


Re: Please look at this imp command

2003-07-29 Thread Arup Nanda
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 list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 11:04 AM


 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: Arup Nanda
  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).


Re: Please look at this imp command

2003-07-29 Thread Daniel Fink
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).begin:vcard 
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard


RE: Please look at this imp command

2003-07-29 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
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).


RE: Please look at this imp command

2003-07-29 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
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 last start.  Anyway here is today's entries:

Tue Jul 29 03:44:39 2003
Thread 1 advanced to log sequence 73
  Current log# 1 seq# 73 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG
Tue Jul 29 03:45:00 2003
Thread 1 advanced to log sequence 74
  Current log# 2 seq# 74 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG
Tue Jul 29 03:45:31 2003
Thread 1 advanced to log sequence 75
  Current log# 3 seq# 75 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG
Dump file D:\oracle\admin\tpocs\bdump\tpocsALRT.LOG
Tue Jul 29 05:31:23 2003
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
  processes= 150
  timed_statistics = TRUE
  shared_pool_size = 50331648
  java_pool_size   = 33554432
  control_files= D:\oracle\oradata\tpocs\control01.ctl,
D:\oracle\oradata\tpocs\control02.ctl,
D:\oracle\oradata\tpocs\control03.ctl
  db_block_size= 4096
  db_cache_size= 33554432
  compatible   = 9.0.0
  fast_start_mttr_target   = 300
  undo_management  = AUTO
  undo_tablespace  = UNDOTBS
  remote_login_passwordfile= EXCLUSIVE
  db_domain= 
  instance_name= tpocs
  background_dump_dest = D:\oracle\admin\tpocs\bdump
  user_dump_dest   = D:\oracle\admin\tpocs\udump
  core_dump_dest   = D:\oracle\admin\tpocs\cdump
  sort_area_size   = 524288
  db_name  = tpocs
  open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Tue Jul 29 05:31:26 2003
/* OracleOEM */ ALTER DATABASE MOUNT
Tue Jul 29 05:31:31 2003
Successful mount of redo thread 1, with mount id 1877649006.
Tue Jul 29 05:31:31 2003
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Tue Jul 29 05:31:31 2003
/* OracleOEM */ ALTER DATABASE OPEN 
Tue Jul 29 05:31:32 2003
Beginning crash recovery of 1 threads
Tue Jul 29 05:31:33 2003
Started first pass scan
Tue Jul 29 05:31:33 2003
Completed first pass scan
Tue Jul 29 05:31:38 2003
Started recovery at
 Thread 1: logseq 74, block 202409, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG
Tue Jul 29 05:31:39 2003
Ended recovery at
 Thread 1: logseq 75, block 18467, scn 0.2938502
 3305 data blocks read, 3305 data blocks written, 20858 redo blocks read
Crash recovery completed successfully
Tue Jul 29 05:31:40 2003
Thread 1 advanced to log sequence 76
Thread 1 opened at log sequence 76
  Current log# 1 seq# 76 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG
Successful open of redo thread 1.
Tue Jul 29 05:31:40 2003
SMON: enabling cache recovery
Tue Jul 29 05:31:41 2003
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 29 05:31:41 2003
SMON: enabling tx recovery
Tue Jul 29 05:31:43 2003
replication_dependency_tracking turned off (no async multimaster
replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN 

 
 Import does not shut the database down.

I didn't think so.

I'm just wondering why when I rebooted the server the TPOCS instance did
start, it is like
It didn't grab the InitTpocs.ora ...perplexed (but understandable when
you are in the constant learn mode.

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).


RE: Please look at this imp command

2003-07-29 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
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).



RE: Please look at this imp command

2003-07-29 Thread Rachel Carmichael
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