ODMA restarting

From: Don Mattivi via OracleMonster.com <forum_at_OracleMonster.com>
Date: Sat, 15 Jan 2005 07:07:09 GMT
Message-ID: <516507931f054a309f3dc95fe7006063_at_OracleMonster.com>

I'm in the process of Migrating/Upgrading to Oracle Version 8.1.7:UNIX on a "Production" System. I made the mistake of selecting "Cancel" instead of "Finish" when completing the ODMA session. How can I either finish or restart the ODMA. I tried to restart ODMA but says user exits. a ps -eaf | grep on ora shows process running: usmdok03:oraprd 113> ps -eaf | grep ora

  oraprd  8534     1  0 21:36:17 ?         0:00 ora_lgwr_PRD
  oraprd  8538     1  0 21:36:17 ?         0:00 ora_smon_PRD
  oraprd  8800  7962  2 23:03:18 pts/0     0:00 ps -eaf
  oraprd  8801  7962  1 23:03:18 pts/0     0:00 grep ora
  oraprd  8536     1  0 21:36:17 ?         0:00 ora_ckpt_PRD
  oraprd  8449  8448  0 21:11:56 pts/3     0:00 -csh
  oraprd  8526     1  0 21:36:16 ?         0:00 ora_pmon_PRD
  oraprd  7962 22532  0 20:39:53 pts/0     0:00 -csh
  oraprd  8531     1  0 21:36:17 ?         0:00 ora_arch_PRD
  oraprd  8540     1  0 21:36:17 ?         0:00 ora_reco_PRD
  oraprd  8504  8449  0 21:35:59 pts/3     0:00 /bin/sh ./odma
  oraprd  8528     1  0 21:36:16 ?         0:00 ora_dbw0_PRD
  oraprd  8505  8504  0 21:35:59 pts/3     0:04 /oracle/PRD/817_64/JRE/bin/../bin/PA_RISC/native_threads/jre

Any Idea how to proceed, this is a "Production" DB?

I get the following if I try to see if DB is running; SVRMGR> connect / as sysdba
Connected.
SVRMGR> select * from v$database;
select * from v$database
*
ORA-01034: ORACLE not available
[Quoted] Help is surely needed.
Don Mattivi

-- 
Message posted via http://www.oraclemonster.com

Received on Sat Jan 15 2005 - 08:07:09 CET