RE: Oracle Instances not starting up via services
Hi, my experience: 1. It is not possible to start instance through Terminal Services - svrmgrl produces ORA-12560 error. Terminal Services are not true terminal. I use Netmeeting - sharing desktop feature. 2. To start instance automaticaly after reboot I add local user NT Autority\system to the ORA_DBA user group 3. On Metalink is another recommendation - in SQLNET.ORA change QLNET.AUTHENTICATION_SERVICES= none - but than you have to type password when connecting as SYS. Michal -Original Message- Sent: Friday, July 18, 2003 2:59 AM To: Multiple recipients of list ORACLE-L So, how are you starting up instances via Terminal Services? I haven't tried to make that work yet. Though I do get highly annoyed with myself when I forget I'm in termserver and not pcanywhere, and can't start a database. Jared Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 04:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Instances not starting up via services I didn't see the original message, but I'll get cannot open '%oracle_home%/database/init%oracle_sid%.ora everytime if using terminal services to start the instance. Is this via a ts session or actually at the console? Er, Obviously I never forget to type pfile=. Though. Me, I'm professional runs away and hides Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nuala Cullen Sent: 17 July 2003 12:24 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Instances not starting up via services Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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
RE: Oracle Instances not starting up via services
You cant start up services when logged in using MTSC and connect internal (bequeath) because you are running in a different memory space to the server code. You have to do it on the console unless you are connecting sysdba via the listener. Cheers, Adrian -Original Message- Sent: 18 July 2003 01:59 To: Multiple recipients of list ORACLE-L So, how are you starting up instances via Terminal Services? I haven't tried to make that work yet. Though I do get highly annoyed with myself when I forget I'm in termserver and not pcanywhere, and can't start a database. Jared Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 04:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Instances not starting up via services I didn't see the original message, but I'll get cannot open '%oracle_home%/database/init%oracle_sid%.ora everytime if using terminal services to start the instance. Is this via a ts session or actually at the console? Er, Obviously I never forget to type pfile=. Though. Me, I'm professional runs away and hides Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nuala Cullen Sent: 17 July 2003 12:24 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Instances not starting up via services Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services
Re: Oracle Instances not starting up via services
Niall, Could you please be more detail in step by step for this is my first time to meet my Oracle power off! Thanks! Don Niall Litchfield wrote: Connect through the listener/tnsnames will work, then startup pfile=. Its just the bequeath protocol that doesn't work. Or net start oracleserviceblah if the instance is set to autostart with the service. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 18 July 2003 01:59 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Instances not starting up via services So, how are you starting up instances via Terminal Services? I haven't tried to make that work yet. Though I do get highly annoyed with myself when I forget I'm in termserver and not pcanywhere, and can't start a database. Jared Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 04:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Instances not starting up via services I didn't see the original message, but I'll get cannot open '%oracle_home%/database/init%oracle_sid%.ora everytime if using terminal services to start the instance. Is this via a ts session or actually at the console? Er, Obviously I never forget to type pfile=. Though. Me, I'm professional runs away and hides Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nuala Cullen Sent: 17 July 2003 12:24 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Instances not starting up via services Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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
RE: Oracle Instances not starting up via services
Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services-- 858-538-5051 :- http://www.fatcity.com :- San Diego, California-- Mailing list and web :- hosting services :- :-- :- To REMOVE yourself from this mailing list, send an :- E-Mail message :- to: [EMAIL PROTECTED] (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). :- :- :-__ :-Do you Yahoo!? :-SBC Yahoo! DSL - Now only $29.95 per month! :-http://sbc.yahoo.com :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Jose Luis Delgado :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (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.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: Oracle Instances not starting up via services
Hi Nuala...! I'm almost sure that your problem is with environment variables... they usually are taken from the registry or defined on my_pc's properties... That's why I would like to know that values... can you send them to the list? HTH JL --- Nuala Cullen [EMAIL PROTECTED] wrote: Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services-- 858-538-5051 :- http://www.fatcity.com :- San Diego, California-- Mailing list and web :- hosting services :- :-- :- To REMOVE yourself from this mailing list, send an :- E-Mail message :- to: [EMAIL PROTECTED] (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). :- :- :-__ :-Do you Yahoo!? :-SBC Yahoo! DSL - Now only $29.95 per month! :-http://sbc.yahoo.com :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Jose Luis Delgado :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail
RE: Oracle Instances not starting up via services
I didn't see the original message, but I'll get cannot open '%oracle_home%/database/init%oracle_sid%.ora everytime if using terminal services to start the instance. Is this via a ts session or actually at the console? Er, Obviously I never forget to type pfile=. Though. Me, I'm professional runs away and hides Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nuala Cullen Sent: 17 July 2003 12:24 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Instances not starting up via services Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services-- 858-538-5051 :- http://www.fatcity.com :- San Diego, California-- Mailing list and web :- hosting services :- : -- :- To REMOVE yourself from this mailing list, send an :- E-Mail message :- to: [EMAIL PROTECTED] (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). :- :- :-__ :-Do you Yahoo!? :-SBC Yahoo! DSL - Now only $29.95 per month! :-http://sbc.yahoo.com :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Jose Luis Delgado :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services
RE: Oracle Instances not starting up via services
So, how are you starting up instances via Terminal Services? I haven't tried to make that work yet. Though I do get highly annoyed with myself when I forget I'm in termserver and not pcanywhere, and can't start a database. Jared Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 04:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Instances not starting up via services I didn't see the original message, but I'll get cannot open '%oracle_home%/database/init%oracle_sid%.ora everytime if using terminal services to start the instance. Is this via a ts session or actually at the console? Er, Obviously I never forget to type pfile=. Though. Me, I'm professional runs away and hides Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nuala Cullen Sent: 17 July 2003 12:24 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Instances not starting up via services Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- 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. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services-- 858-538-5051 :- http://www.fatcity.com :- San Diego, California-- Mailing list and web :- hosting services :- : -- :- To REMOVE yourself from this mailing list, send an :- E-Mail message :- to: [EMAIL PROTECTED] (note EXACT spelling of :- 'ListGuru
RE: Oracle Instances not starting up via services
Hi, Reading your mail, your registry setting for ora_wms_pfile is set to c:\oracle\ora8\database\initwms.ora, but your oracle home is c:\oracle\ora81, not sure if this is just a typo, but it may help you. Cheers Lee -Original Message- Sent: 16 July 2003 12:24 To: Multiple recipients of list ORACLE-L 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. This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee Cullip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Oracle Instances not starting up via services
Sorry Lee - it's a typo!! Thanks though for pointing it out to me. N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Lee Cullip :-Sent: 16 July 2003 14:10 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Hi, :-Reading your mail, your registry setting for ora_wms_pfile is set to :-c:\oracle\ora8\database\initwms.ora, but your oracle home is :-c:\oracle\ora81, not sure if this is just a typo, but it may :-help you. :- :-Cheers :-Lee :- :--Original Message- :-Sent: 16 July 2003 12:24 :-To: Multiple recipients of list ORACLE-L :- :- :- :-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. :- :- :- :- :-_ :-___ :- :-This e-mail message (including any attachment) is intended :-only for the personal :-use of the recipient(s) named above. This message is :-confidential and may be :-legally privileged. If you are not an intended recipient, :-you may not review, copy or :-distribute this message. If you have received this :-communication in error, please notify :-us immediately by e-mail and delete the original message. :- :-Any views or opinions expressed in this message are those of :-the author only. :-Furthermore, this message (including any attachment) does :-not create any legally :-binding rights or obligations whatsoever, which may only be :-created by the exchange :-of hard copy documents signed by a duly authorised :-representative of Hutchison :-3G UK Limited. :-_ :-___ :- :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Lee Cullip :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (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.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Oracle Instances not starting up via services
Check the registry entry ORA_SID_PFILE. Try hardcoding the entire path rather than use variables. ie. ORA_WMS_PFILE would be set to c:\oracle\ora81\database\initwms.ora. Be sure ORA_WMS_AUTOSTART is set to TRUE. Jared On Wednesday 16 July 2003 04:24, Nuala Cullen wrote: 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Oracle Instances not starting up via services
Hi Jared, Thanks for the advice, I checked out the registry settings ORA_WMS_PFILE is set to c:\oracle\ora81\database\initwms.ora. ORA_WMS_AUTOSTART is set to TRUE. I'm a bit confused what you mean by using variables. I think you mean not to use %oracle_home% etc but the error message: LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora is as it appeared on the screen. N. :--Original Message- :-From: Jared Still [mailto:[EMAIL PROTECTED] :-Sent: 16 July 2003 14:31 :-To: [EMAIL PROTECTED]; Nuala Cullen :-Subject: Re: Oracle Instances not starting up via services :- :- :- :-Check the registry entry ORA_SID_PFILE. Try hardcoding :-the entire path rather than use variables. :- :-ie. ORA_WMS_PFILE would be set to :-c:\oracle\ora81\database\initwms.ora. :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :-Jared :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen wrote: :- 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. :- :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Oracle Instances not starting up via services
what about ora_wms_autostart ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:24 AM 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Oracle Instances not starting up via services
Nice try but it is set to TRUE already. :-( N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-AK :-Sent: 16 July 2003 16:54 :-To: Multiple recipients of list ORACLE-L :-Subject: Re: Oracle Instances not starting up via services :- :- :-what about ora_wms_autostart ? :- :--ak :- :-- Original Message - :-To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] :-Sent: Wednesday, July 16, 2003 4:24 AM :- :- :- :- 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. :- :- :- :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: AK :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (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.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Oracle Instances not starting up via services
Nuala... 1.- can you send your environment variables? (my_pc - properties - advanced - environment variables) 2.- can you send your Oracle registry values? JL --- Nuala Cullen [EMAIL PROTECTED] wrote: Hi Jared, Thanks for the advice, I checked out the registry settings ORA_WMS_PFILE is set to c:\oracle\ora81\database\initwms.ora. ORA_WMS_AUTOSTART is set to TRUE. I'm a bit confused what you mean by using variables. I think you mean not to use %oracle_home% etc but the error message: LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora is as it appeared on the screen. N. :--Original Message- :-From: Jared Still [mailto:[EMAIL PROTECTED] :-Sent: 16 July 2003 14:31 :-To: [EMAIL PROTECTED]; Nuala Cullen :-Subject: Re: Oracle Instances not starting up via services :- :- :- :-Check the registry entry ORA_SID_PFILE. Try hardcoding :-the entire path rather than use variables. :- :-ie. ORA_WMS_PFILE would be set to :-c:\oracle\ora81\database\initwms.ora. :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :-Jared :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen wrote: :- 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. :- :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).