Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.vmunix.org!news.telebyte.nl!newshub1.home.nl!home.nl!not-for-mail From: Frank Newsgroups: comp.databases.oracle.server Subject: Re: ORA-01034: ORACLE not available Date: Mon, 07 Jul 2003 21:19:49 +0200 Organization: @Home Benelux Lines: 28 Message-ID: <3F09C7D5.6030000@netscape.net> References: <3427760c.0307070652.508b1295@posting.google.com> NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news4.tilbu1.nb.home.nl 1057605324 4129 217.121.193.81 (7 Jul 2003 19:15:24 GMT) X-Complaints-To: abuse@home.nl NNTP-Posting-Date: Mon, 7 Jul 2003 19:15:24 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237083 Kristof Coucke wrote: > Hi all, > > I've just did an upgrade from oracle 8.1.7 Patch 4 to Oracle 9.2. > First I did the upgrade of the Oracle soft, rebooted, and use the > database configuration assistant to upgrade my DB. > > Now, when I restart my server, the database service (yes, it's > windows) is started, but the instance isn't up and running. > > If I use the Oracle Enterprise Manager Console, I can mount and open > the database. > But, as you can see, this is not very handy to do this every time. > Does anyone have a clue what the problem could be? > > Any help would be greatly appreciated! > > Thanks, > > Kristof. oradim -edit -sid -start auto (or something similar). oradim without any arguments pops up the documentation (yes! all thirty odd lines of it!) -- Regards, Frank van Bortel