RE: 9i R2 not automatically starting up after upgrade

That was the problem. I checked out that registry entry, and then looked in the directory that it was pointing to, and there was no init.ora file in that directory. I looked at the one that was in my previous ORACLE_HOME, copied and pasted it into the directory in the new ORACLE_HOME (the one that the registry entry was pointing to) and rebooted, and now it works fine. Evidently for some reason or other, the init<sid>.ora file didn't get copied over into the new ORACLE_HOME during the upgrade. Thanks for the advice.

_YEX_
<)))><

-----Original Message-----
Sent: Friday, June 14, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

The parameter to look in the registry is

ORA_ORA9I_PFILE and points to the parameter file.

Make sure that it is located there.

Regards

-----Original Message-----
Sent: Friday, June 14, 2002 6:16 PM
To: 'ORACLE-L_at_fatcity.com'

Check whether the service finds your init<sid>.ora file.

The parameter in the registry might point to a different location for the service.

You can find the parameter file and copy paste it to the location that the service is looking for it.

I hope that this will help.

Regards
Theodoros

-----Original Message-----
[mailto:Robert.Yexley_at_wpafb.af.mil]
Sent: Friday, June 14, 2002 5:44 PM
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<SID> ---> 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_at_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_at_wpafb.af.mil
|| <)))><

*/

 <<Robert D. Yexley (E-mail).vcf>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Theodoros Demosthenous
  INET: theodoros_at_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_at_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_at_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_at_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: Theodoros Demosthenous
  INET: theodoros_at_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_at_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_at_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_at_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).