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: <DBarbour_at_austin.isd.tenet.edu>
Date: Wed, 06 Mar 2002 10:38:37 -0800
Message-ID: <F001.00420FC7.20020306103837@fatcity.com> 






Just a thought - You can't install over Terminal Services Client.  You must
be at a console.  If you use Terminal Services, the install will appear to
complete properly, but the database will never work properly.  Ran into
this on my first W2K install.  Don't know if this helps, but you're
description of the functionality difficulties and errors messages is eerily
reminiscent of the problems I encountered.




David A. Barbour


Oracle DBA, OCP


AISD



512-414-1002



                                                                                                                     
                    Praveen Sahni                                                                                    
                    <Praveen.Sahni_at_k       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    shema.com>             cc:                                                                       
                    Sent by:               Subject:     RE: Oracle 9i on windows Advance Server is not starting      
                    root_at_fatcity.com        Automatic                                                                
                                                                                                                     
                                                                                                                     
                    03/05/2002 09:58                                                                                 
                    PM                                                                                               
                    Please respond                                                                                   
                    to ORACLE-L                                                                                      
                                                                                                                     
                                                                                                                     








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).






-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: 


  INET: DBarbour_at_austin.isd.tenet.edu


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 Wed Mar 06 2002 - 12:38:37 CST












Original text of this message













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