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 9i on windows Advance Server is not starting Automatic

RE: Oracle 9i on windows Advance Server is not starting Automatic

From: Praveen Sahni <Praveen.Sahni_at_kshema.com>
Date: Tue, 05 Mar 2002 19:58:26 -0800
Message-ID: <F001.004203D9.20020305195826@fatcity.com> 





The services are set to start automatically and version for the Oracle is


(Oracle Standard Edition 9.0.1) on windows and we open a tar with oracle


india suppport but no help as of now.



we have reinstalled Operating system (Windows Advance Server with service
pack II) and Oracle Standard Edition 9.0.1
but same error.



Oracle SID autostart is set TRUE in Windows Registry.
I've forgot to mention one more thing.


whenever we restart the system oradim.log shows ORA-01078.
Then if we tried to login using system/manager, it gives ORA-01034 and
ORA-27101



Oracle is being installed on the cluster environment having two nodes with
same 


configuaration.


Windows Advanced server is installed on both systems.
we have installed Oracle software (Oracle Standard Edition 9.0.1) on both
the 


systems and created database from an active cluster Node.
I switched off the second node whenever I am restarting the system so that
only 


node will be active always.


I have reinstalled oracle and created the database through dbca.
I am getting the same error messages this time also.
I have searched for the similar postings in metalink and tried the following

1.Increase/decreasing the size of SGA
2.commented the dispatchers= (MTS option) in init.ora
3.commented SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora


oracle_sid and oracle_home are set properly.
Registry entry for Oracle SID PFILE was pointing to 
e:\oracle\ora91\DATABASE\init<SID>.ora when I created database using dbca.
When this doesn't worked out, I changed it to 
d:\oracle\admin\<SID>\pfile\init.ora where the init.ora is actually present.



Apart from ORA-01078 I am not getting any other errors/logs.



Oracle service is starting automatically but the database is not starting.
If I manually restart the service/ startup using SQL*PLUS database comes up 
normally and works fine.



Are there any previleges required from OS? (ORA_DBA account is present with 
Administrator as its member)


I am loging in as Administrator. How to check whether the user has required 
previleges/not?



We have created a small DB on the Node (not involving cluster)  and its work
fine.



Please let me know where the problem can be.



Thanks in advance 



Praveen



-----Original Message-----


Sent: Wednesday, March 06, 2002 3:13 AM


To: Multiple recipients of list ORACLE-L
Automatically





How was the service created?  Is it set to automatically start?


 


                    Jared.Still

                    @radisys.com         To:     Multiple recipients of list
ORACLE-L      
                    Sent by: root        <ORACLE-L_at_fatcity.com>

                                         cc:

                                         Subject:     Re: Oracle 9i on
windows Advance     
                    03/05/2002           Server is not starting
Automatically              
                    01:08 PM

                    Please

                    respond to

                    ORACLE-L

 

 









It might be possible for someone to help you if
you include the relevent OS info ( version and service packs )
and the oracle version.







Praveen Sahni <Praveen.Sahni_at_kshema.com>
Sent by: root_at_fatcity.com


03/04/02 11:13 PM


Please respond to ORACLE-L



        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:
        Subject:        Oracle 9i on windows Advance Server is not starting


Automatically




We have a small problem.



Oracle has been installed on Windows Advanced Server.
Other software on the system include Microsoft Cluster Server.
Oracle software has been installed on the local drive (E:) using silent
installation.


Database has been installed on Shared Disk (RAID) (D:) using scripts.
I have created SID, password (using ORADIM and ORAPWD utility) and SPFILE.



My problem is, whenever I restart the system Oracle is not connecting
until


I restart the Oracle service in Windows Service window.



connect System/manager gives the following error
ORA-01034 ORACLE not available


ORA-27101 SHARED MEMORY REALM DOES NOT EXISTS.


Database on cluster is not start automatically. Only service shows started
but DB is not mounted.On restarting from services panel it mounts and
Opens.



Please let me know if any of us has faced this problem.



Please let me know if we need some more information.



Thanks in advance


Praveen






--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Praveen Sahni
  INET: Praveen.Sahni_at_kshema.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:
  INET: Jared.Still_at_radisys.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: 
  INET: tday6_at_csc.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: Praveen Sahni
  INET: Praveen.Sahni_at_kshema.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).


Received on Tue Mar 05 2002 - 21:58:26 CST












Original text of this message













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