This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Oct 8, 2013 10:59 AM by jgarry RSS

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

TheHades0210 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points