DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle 11g r2 installation on OEL 5.5 - non rac non asm

  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Oracle 11g r2 installation on OEL 5.5 - non rac non asm

    Oracle 11g r2 installation on OEL 5.5 - one instanc only
    Posted: Jul 24, 2012 10:29 PM
    startup , ora01078 , lrm00109 , oracle , 11g , r2 , installation , in , oel , 55 [Edit]

    Click to edit this message... Edit Click to report abuse... Click to reply to this thread Reply
    startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora'

    Unfortunately I can not find initora11g.ora

    [oracle@localhost db_1] cd dbs
    [oracle@localhost dbs] ls
    hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora

    so create pfile from spfile='/home//oracle/product/11.2.0/db_1/dbs/spfileora11.ora will not work
    in oratab also - it showed sid as orcl but I changed into

    I have set oracle_sid = ora11g in .bash_profile as well

  2. #2
    Join Date
    Dec 2002
    Posts
    74
    Do you have /u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora file?. Your instance is not up so you can't run create pfile from spfile. You have to create pfile first then create spfile not other way around.

  3. #3
    Join Date
    Jul 2012
    Posts
    2

    Oracle 11g installation non-rac

    [oracle@localhost dbs]$ ls
    hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora

    I don't see initora11g.ora file - as shown above

  4. #4
    Join Date
    Dec 2002
    Posts
    74
    You can create one using sample init.ora.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width