Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g5ENf4N11426 for ; Fri, 14 Jun 2002 19:41:04 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA48382; Fri, 14 Jun 2002 08:39:42 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0047E2A8; Fri, 14 Jun 2002 08:04:54 -0800 Message-ID: Date: Fri, 14 Jun 2002 08:04:54 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Seefelt, Beth" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Seefelt, Beth" Subject: RE: 9i R2 not automatically starting up after upgrade Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by naude.co.za id g5ENf4N11426 The database should start when you start the service if the registry entry ORA__AUTOSTART is set to TRUE. When you upgraded the database, did the ORA__* registry keys get moved into the new HKLM\Software\Oracle\HOMEx key, and removed from the old one? ORA-27101 can indicate its trying to start from the wrong ORACLE_HOME. Beth -----Original Message----- [mailto:Robert.Yexley@wpafb.af.mil] Sent: Friday, June 14, 2002 10:44 AM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ <)))>< -----Original Message----- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleService ---> Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -----Original Message----- [mailto:Robert.Yexley@wpafb.af.mil] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is "ORA-27101: shared memory realm does not exist". If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || robert.yexley@wpafb.af.mil || <)))>< */ <> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: theodoros@edams.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: Robert.Yexley@wpafb.af.mil Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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.com -- Author: Seefelt, Beth INET: Beth.Seefelt@TetleyUSA.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).