Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Instances not starting up via services

Oracle Instances not starting up via services

From: Nuala Cullen <ncullen_at_catlogic.com>
Date: Wed, 16 Jul 2003 11:24:42 +0100
Message-Id: <25937.337990@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0001_01C34B8C.DAE7B9F0
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi All,

I have inherited a couple of databases on one of the servers here. The server was taken down for hardware repairs during the week and when it came back up the databases did not start. (They are set to start automatically via the services)

I have done some research via the internet and I deleted and recreated the service via the ORADIM utility.

But this has n't fixed it. I have to manually go into and start the databases (explicitly stating where the init.ora file is)

I am getting this error message when I go in via SQLPLUS /NOLOG (connected as internal)

Startup
error message LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora

If I do a startup pfile=c:\oracle\ora81\database\initwms.ora it starts as normal.

I've checked that the oracle home is defined as c:\oracle\ora81 so I am beginning to suspect it has something to do with the oracle sid. In registry the ora_wms_pfile location is set to c:\oracle\ora8\database\initwms.ora

We have 4 different instances on this box and none of them will start automatically.
Oracle version 8.1.7 running on a Windows Server 2000 box

Any help appreciated,

Thanks,

N.

------=_NextPart_000_0001_01C34B8C.DAE7B9F0
Content-Type: application/ms-tnef;

        name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;

        filename="winmail.dat"

eJ8+IisKAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANMHBwAQAAsAGAAAAAMAFwEB A5AGANAHAAAmAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAALgAAAE9yYWNsZSBJbnN0YW5jZXMgbm90IHN0YXJ0aW5nIHVwIHZpYSBzZXJ2aWNlcwAAAAIB cQABAAAAFgAAAAHDS4R4MIhFGyAPRkISh4j1Cxmuz88AAAIBHQwBAAAAGgAAAFNNVFA6TkNVTExF TkBDQVRMT0dJQy5DT00AAAALAAEOAAAAAEAABg4A4BxfhEvDAQIBCg4BAAAAGAAAAAAAAABrjssX nAZpSKunHW2gIukmwoAAAAMAFA4BAAAACwAfDgEAAAACAQkQAQAAAJ4DAACaAwAAnAUAAExaRnWJ 7/tYAwAKAHJjcGcxMjUGMgD4C2BuZzYxNZ4zAfcCpAPjAgBjaArAYHNldDAgBxMCgH0lCoF2CJB3 awuAZDR9DGBjAFALAwu2CrEKgEhiaRFgbGwsE8QTxEmiIBDwdmUgC4BoBnGidAmAIGEgBaB1C1BB FaBvZiBkYQGRYV8RIAQgAiAXsRbTdBXgID0RIHIVkBEQFWAEkGUuZCBUGHcgdxdwGFBh5msJ8BcQ b3cDoAIQBcBtEPFkGjAJcCAJcAqwaV0Y8WQIcQ8gGFN3CeBrfxZQEoAaIBXgA6AWEBZwYfUHgCAX YGMdUBagGFMXKKRkaRZAbm8FQHMBkOsAIBlgKBmBeRZQG8ERIW0YUG8gVBZQdSGwAMB0+w3gB0Bs IRASIBZgGGYN4N0HkCkUnx8hF/JzA3Ab0v8RIArAEOAjFwuAFiAEoCGB/x1yFVABABbAFiMdgQlw BQAPJjAWIiNpIxdPUkFELElNHsAioGwWEHkufSQ6QiJQGFEEABVhBCBu4icFQGZpeBYxFhAZYNcV VSGxA4F1ItNnIcAnEY8hwB1yIeQfDChleAtQ/w3gFhAi8SBhIqAcsR2xG8H/JtQtwQWwFmAtYBbB BAAkLf8eQC8gETAyIyyTBJADYAXA+QeBc2E1MB2kFVAvMyMTQFNRTFBMVQXwL2BOT0xPRyDABaBu fRgAYxYjBCAnFAdAJCtTDyByFqATxDYMTFJNLeAwMDEwOR4hA6AgInxvcBqhCrEeQScxM5QnSiUz YWMWwF9oJcElOi8XJi8zEj82AJBkJX8zUiQ7FwAn4S+RIFQe0XDBM6I9YzpcXD9EREM+OABQAPAX NURAMxJ3bf5zM1MeASBjBCAs8gWwAMDybCuLSScVkRDgBZAakP8pQhcwGFM/RBVgJcIssQEBPwuA OWRELyWhJ9E1AWJlnmcLgAMAHLIhwXVzPfD/OUAd8iziJbIskU3EQvED8O8YYEnKQWErhUkDoAlw TXBdIGByIRAYYkoCX0YxX/1DwyAJAB4wIqAXwSyxIXVvS75FP0ZEJDpXSmEVgjS/H9EBIBkxAjAV sSBhbiPx9xeyLJMG4HgdYyAgGAc1EN8D8BRgId8i4SuFT0okGNJBU/I4LjEuNxvgdfdNlBfBFmBX EnEa4AZDGfLPAdA9AFpSJDpBbiEQFeDibB7gYXBwKMEHMBYhpxSLGYAAcGtzFItOK4sLE8QR4QBm sAAAAwAJWQMAAAALAAGACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMALoAIIAYAAAAAAMAA AAAAAABGAAAAAFKFAAAnagEACwA7gAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAD2ACCAG AAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAPoAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAA AwA/gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAFeACCAGAAAAAADAAAAAAAAARgAAAABU hQAAAQAAAAQAAAA5LjAACwBYgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAFmACCAGAAAA AADAAAAAAAAARgAAAAABhQAAAAAAAB4AcYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAA AAAAAAAeAHKACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgBzgAggBgAAAAAA wAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAIB+A8BAAAAEAAAAGuOyxecBmlIq6cdbaAi6SYC AfoPAQAAABAAAABrjssXnAZpSKunHW2gIukmAgH7DwEAAABYAAAAAAAAADihuxAF5RAaobsIACsq VsIAAG1zcHN0LmRsbAAAAAAATklUQfm/uAEAqgA32W4AAABVOlxwcm9maWxlXFBlcnNvbmFsIEZv bGRlcnMoMSkucHN0AAMA/g8FAAAAAwANNP03AAACAX8AAQAAADEAAAAwMDAwMDAwMDZCOEVDQjE3 OUMwNjY5NDhBQkE3MUQ2REEwMjJFOTI2QzRDMzk4MDAAAAAAAwAGECWW0RADAAcQpgMAAAMAEBAA AAAAAwAREAEAAAAeAAgQAQAAAGUAAABISUFMTCxJSEFWRUlOSEVSSVRFREFDT1VQTEVPRkRBVEFC QVNFU09OT05FT0ZUSEVTRVJWRVJTSEVSRVRIRVNFUlZFUldBU1RBS0VORE9XTkZPUkhBUkRXQVJF Received on Wed Jul 16 2003 - 05:24:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US