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

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

RE: Oracle Instances not starting up via services

From: Turner, Adrian A SITI-ITPSIE <Adrian.Turner_at_shell.com>
Date: Fri, 18 Jul 2003 11:11:38 +0100
Message-Id: <25956.338429@fatcity.com>


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-----
From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] 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" <niall.litchfield_at_dial.pipex.com> Sent by: ml-errors_at_fatcity.com
 07/17/2003 04:14 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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: ml-errors_at_fatcity.com
> [mailto:ml-errors_at_fatcity.com]On :->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 <ncullen_at_catlogic.com> 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:jkstill_at_cybcon.com]
> :->> :->Sent: 16 July 2003 14:31
> :->> :->To: ORACLE-L_at_fatcity.com; 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: ncullen_at_catlogic.com
> :->>
> :->> 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: 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).
> :->
> :->
> :->__________________________________
> :->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: joseluis_delgado_at_yahoo.com
> :->
> :->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: 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.net
> --
> Author: Nuala Cullen
> INET: ncullen_at_catlogic.com
>
> 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: 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.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

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: 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.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

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
Received on Fri Jul 18 2003 - 05:11:38 CDT

Original text of this message

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