1 2 Previous Next 17 Replies Latest reply: Oct 8, 2013 12:59 PM by jgarry RSS

    ORA-01034: ORACLE not available ORA-01078: failure in processing system

    TheHades0210
      Aloha!

      I have just created an instance on oracle 11g R2, i shutdown the newly created instance. Starting up again, i was prompted by:

      SQL> startup mount
      ORA-01078: failure in processing system parameters
      LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorc01.ora'
      SQL>

      also i tried to logged in as: [oracle@ole5 SBAtemp]$ sqlplus / as sysdba
      and try to shutdown database, im receiving this prompt.

      SQL> shutdown immediate
      SP2-0717: illegal SHUTDOWN option
      SQL> shutdown immediate;
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory
      SQL>

      Thanks for the help in advance.


      Regards,
      Hades
        • 1. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
          asifkabirdba
          SQL> startup mount
          ORA-01078: failure in processing system parameters
          LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorc01.ora'


          Your instance can't find the pfile. Check the correct SID of your instance. Name of the pfile will be init<SID>.ora , locate your pfile and export the correct ORACLE_HOME and ORACLE_SID and try with the command.


          SQL > startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/init<SID>.ora';


          Regards
          Asif Kabir
          • 2. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
            839439
            TheHades0210 wrote:
            Aloha!

            I have just created an instance on oracle 11g R2, i shutdown the newly created instance. Starting up again, i was prompted by:

            SQL> startup mount
            ORA-01078: failure in processing system parameters
            LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorc01.ora'
            SQL>

            also i tried to logged in as: [oracle@ole5 SBAtemp]$ sqlplus / as sysdba
            and try to shutdown database, im receiving this prompt.

            SQL> shutdown immediate
            SP2-0717: illegal SHUTDOWN option
            SQL> shutdown immediate;
            ORA-01034: ORACLE not available
            ORA-27101: shared memory realm does not exist
            Linux Error: 2: No such file or directory
            SQL>

            Thanks for the help in advance.


            Regards,
            Hades
            { LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorc01.ora'}
            Not able to read the intialisation parameter file.

            Check your spfile in $ORACLE_HOME/dbs/spfile<SID>.ora is available or not
            or you can start database with pfile as

            SQL> startup pfile=<location of pfile>

            let me know .

            --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
            • 3. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
              TheHades0210
              Hi,

              I've check the /u01/...dbs/ directory and found none .ora file. Aside from the mentioned directory, is there another directory where i can find initorc01.ora file? How about "ORA-01034: ORACLE not available"?

              Hades,
              • 4. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                TheHades0210
                Hi,

                I've check the /u01/...dbs/ directory and found none .ora file. Aside from the mentioned directory, is there another directory where i can find initorc01.ora file? How about "ORA-01034: ORACLE not available"?

                Hades,
                • 5. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                  TheHades0210
                  Hi,

                  I've check the /u01/...dbs/ directory and found none .ora file. Aside from the mentioned directory, is there another directory where i can find initorc01.ora file? How about "ORA-01034: ORACLE not available"?

                  Hades,
                  • 6. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                    839439
                    TheHades0210 wrote:
                    Hi,

                    I've check the /u01/...dbs/ directory and found none .ora file. Aside from the mentioned directory, is there another directory where i can find initorc01.ora file? How about "ORA-01034: ORACLE not available"?

                    Hades,
                    you can find pfile in $ORACLE_BASE/admin/<SID>/pfile/init<SID>.ora

                    and startup with pfile

                    --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                    • 7. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                      TheHades0210
                      Hi,

                      Can i copy the content of file 'init.ora' on '/u01/app/oracle/admin/ora01/pfile' and create a 'initorc01.ora' on /u01/.../dbs/'?

                      file content is:

                      ##############################################################################
                      # Copyright (c) 1991, 2001, 2002 by Oracle Corporation
                      ##############################################################################

                      ###########################################
                      # Cache and I/O
                      ###########################################
                      db_block_size=8192

                      ###########################################
                      # Cursors and Library Cache
                      ###########################################
                      open_cursors=300

                      ###########################################
                      # Database Identification
                      ###########################################
                      db_domain=""
                      db_name=ora01

                      ###########################################
                      # File Configuration
                      ###########################################
                      control_files=("/u01/app/oracle/oradata/ora01/control01.ctl", "/u01/app/oracle/oradata/ora01/control02.ctl")

                      ###########################################
                      # Miscellaneous
                      ###########################################
                      compatible=11.2.0.0.0
                      diagnostic_dest=/u01/app/oracle

                      ###########################################
                      # Processes and Sessions
                      ###########################################
                      processes=150

                      ###########################################
                      # SGA Memory
                      ###########################################
                      sga_target=274726912

                      ###########################################
                      # Security and Auditing
                      ###########################################
                      audit_file_dest=/u01/app/oracle/admin/ora01/adump
                      audit_trail=db
                      remote_login_passwordfile=EXCLUSIVE

                      ###########################################
                      # Shared Server
                      ###########################################
                      dispatchers="(PROTOCOL=TCP) (SERVICE=ora01XDB)"

                      ###########################################
                      # Sort, Hash Joins, Bitmap Indexes
                      ###########################################
                      pga_aggregate_target=91226112

                      ###########################################
                      # System Managed Undo and Rollback Segments
                      ###########################################
                      undo_tablespace=UNDOTBS1


                      Thanks,
                      Hades
                      • 8. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                        839439
                        If wish you can......
                        I recommend you to start the database with this pfile as

                        SQL> startup pfile='/u01/app/oracle/admin/ora01/pfile/orc01.ora' nomount

                        SQL> create spfile from pfile='/u01/app/oracle/admin/ora01/pfile/orc01.ora' ;

                        SQL> shut immediate

                        SQL> startup

                        Now your spfile will be created in $ORACLE_HOME/dbs/spfileorc01.ora'


                        Hope this help you :)

                        --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
                        • 9. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                          TheHades0210
                          Aloha,


                          It seems that i created the spfile, but please have a look if i missed something.

                          SQL> startup pfile='/u01/app/oracle/admin/ora01/pfile/init.ora.8232011114659'
                          nomount;
                          ORACLE instance started.

                          Total System Global Area 276197376 bytes
                          Fixed Size 1335980 bytes
                          Variable Size 96472404 bytes
                          Database Buffers 171966464 bytes
                          Redo Buffers 6422528 bytes
                          ORA-01102: cannot mount database in EXCLUSIVE mode


                          SQL> SP2-0042: unknown command "nomount" - rest of line ignored.
                          SQL> exit
                          Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                          With the Partitioning, OLAP, Data Mining and Real Application Testing options
                          [oracle@ole5 SBAtemp]$ oraenv
                          ORACLE_SID = [orc01] ?
                          ORACLE_HOME = [home/oracle] ?
                          The Oracle base for ORACLE_HOME=/home/oracle is /u01/app/oracle
                          [oracle@ole5 SBAtemp]$ sqlplus / as sysdba

                          SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 26 14:43:57 2011

                          Copyright (c) 1982, 2009, Oracle. All rights reserved.


                          Connected to:
                          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                          With the Partitioning, OLAP, Data Mining and Real Application Testing options

                          SQL> create spfile from pfile='/u01/app/oracle/admin/ora01/pfile/init.ora.8232011114659';

                          File created.

                          SQL> shutdown immediate
                          ORA-01507: database not mounted


                          ORACLE instance shut down.
                          SQL> startup mount;
                          ORACLE instance started.

                          Total System Global Area 276197376 bytes
                          Fixed Size 1335980 bytes
                          Variable Size 96472404 bytes
                          Database Buffers 171966464 bytes
                          Redo Buffers 6422528 bytes
                          ORA-01102: cannot mount database in EXCLUSIVE mode

                          SQL>

                          Thanks,
                          Hades
                          • 10. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                            839439
                            A database is started in EXCLUSIVE mode by default. Therefore, the
                            ORA-01102 error is misleading and may have occurred due to one of the
                            following reasons:

                            - there is still an "sgadef<sid>.dbf" file in the "ORACLE_HOME/dbs"
                            directory
                            - the processes for Oracle (pmon, smon, lgwr and dbwr) still exist
                            - shared memory segments and semaphores still exist even though the
                            database has been shutdown
                            - there is a "ORACLE_HOME/dbs/lk<sid>" file

                            The "lk<sid>" and "sgadef<sid>.dbf" files are used for locking shared memory.
                            It seems that even though no memory is allocated, Oracle thinks memory is
                            still locked. By removing the "sgadef" and "lk" files you remove any knowledge
                            oracle has of shared memory that is in use. Now the database can start.

                            POSSIBLE SOLUTION:
                            Verify that the database was shutdown cleanly by doing the following:

                            1. Verify that there is not a "sgadef<sid>.dbf" file in the directory
                            "ORACLE_HOME/dbs".

                            % ls $ORACLE_HOME/dbs/sgadef<sid>.dbf

                            If this file does exist, remove it.

                            % rm $ORACLE_HOME/dbs/sgadef<sid>.dbf

                            2. Verify that there are no background processes owned by "oracle"

                            % ps -ef | grep ora_ | grep $ORACLE_SID

                            If background processes exist, remove them by using the Unix
                            command "kill". For example:

                            % kill -9 <Process_ID_Number>

                            3. Verify that no shared memory segments and semaphores that are owned
                            by "oracle" still exist

                            % ipcs -b

                            If there are shared memory segments and semaphores owned by "oracle",
                            remove the shared memory segments

                            % ipcrm -m <Shared_Memory_ID_Number>

                            and remove the semaphores

                            % ipcrm -s <Semaphore_ID_Number>

                            NOTE: The example shown above assumes that you only have one
                            database on this machine. If you have more than one
                            database, you will need to shutdown all other databases
                            before proceeding with Step 4.

                            4. Verify that the "$ORACLE_HOME/dbs/lk<sid>" file does not exist

                            5. Startup the instance

                            for check the below link

                            http://www.orafaq.com/forum/t/40030/0/
                            ORA-01102: cannot mount database in EXCLUSIVE mode


                            Hope this help you ...

                            --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                            • 11. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                              TheHades0210
                              Aloha!

                              I can now access the database, tru sqlplus but when i connect form a client machine to the server i have this error:

                              ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

                              This came from oracle net manager.

                              Thanks a lot.
                              Hades
                              • 12. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                                839439
                                TheHades0210 wrote:
                                Aloha!

                                I can now access the database, tru sqlplus but when i connect form a client machine to the server i have this error:

                                ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

                                This came from oracle net manager.

                                Thanks a lot.
                                Hades
                                Check the tnsping and paste its output...

                                Add the service name in tnsnames.ora file

                                SAMPLE:

                                ORCL =
                                (DESCRIPTION =
                                (ADDRESS_LIST =
                                (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1910))
                                )
                                (CONNECT_DATA =
                                (SERVICE_NAME = orcl)
                                )
                                )

                                Check the listener services and reload it. i.e;

                                $lsnrctl stop
                                $lsnrctl start


                                Hope this help you :)

                                --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                                • 13. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                                  TheHades0210
                                  Aloha,

                                  As requested:

                                  C:\>tnsping ole5_orc01_loc

                                  TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-SEP-2
                                  011 17:17:49

                                  Copyright (c) 1997, 2005, Oracle. All rights reserved.

                                  Used parameter files:
                                  D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


                                  Used TNSNAMES adapter to resolve the alias
                                  Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
                                  (HOST = 172.16.0.19)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orc01)))
                                  OK (10 msec)

                                  C:\>

                                  that is on a remote machine.but every time i run a test on net manager its unsuccessful due to this error:

                                  Initializing first test to use userid: scott, password: tiger
                                  Attempting to connect using userid: scott
                                  The test did not succeed.
                                  ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

                                  Thanks,
                                  hades
                                  • 14. Re: ORA-01034: ORACLE not available ORA-01078: failure in processing system
                                    TheHades0210
                                    Aloha,

                                    When i stop and start the listener i found this:


                                    [oracle@ole5 SBAtemp]$ lsnrctl stop orc01

                                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-SEP-2011 17:21:15

                                    Copyright (c) 1991, 2009, Oracle. All rights reserved.

                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ole5.rs2asia.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.rs2asia.com)))
                                    The command completed successfully
                                    [oracle@ole5 SBAtemp]$ lsnrctl start orc01

                                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-SEP-2011 17:21:37

                                    Copyright (c) 1991, 2009, Oracle. All rights reserved.

                                    Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

                                    TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                                    System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
                                    Log messages written to /u01/app/oracle/diag/tnslsnr/ole5/orc01/alert/log.xml
                                    TNS-01151: Missing listener name, orc01, in LISTENER.ORA

                                    Listener failed to start. See the error message(s) above...

                                    [oracle@ole5 SBAtemp]$

                                    If this could be the reason, how can i address this?

                                    Thanks a lot,
                                    Hades
                                    1 2 Previous Next