FW: Oracle Instances not starting up via services

Hi,
I send this mail on friday, but it seems me not arrived to the list. Michal

-----Original Message-----
From: Skurský Michal
Sent: Friday, July 18, 2003 11:32 AM
To: 'ORACLE-L_at_fatcity.com'
Subject: 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-----
From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Friday, July 18, 2003 2:59 AM
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