I am trying to do the startup command

This is what I have done:

set oracle_sid=ORCL
sqlplus /nolog
SQL> conn /as sysdba

It shows this error message:

failure in processing system parameters
could not open parameter file "C:\Program\11.2.0\DBhome_1\Database\initorcl.ora"

I checked and found out that "initoracl.ora" doesn't exist inside this path:


I found a init.ora file in:


I tried doing this command:

startup pfile="C:\Program\11.2.0\dbhome_1\dbs\init.ora"

It shows this error:

invalid value given for the diagnostic_dest init.ora parameter
the specified ADR Base Directory does not existed [C:\program\11.2.0\dbhome_1\database\]
specific directory does not exist
additional error information
the filename, directory name, or volume syntax is incorrect.

What should I do?

  • How was the database created? Has it started before? Does the initorcl.ora exist somewhere else, or do you have a valid spfile?
    – Alex Poole
    Jan 25, 2014 at 12:42
  • I checked. there's no initorcl.ora or spfile. I am really sure how to create a database or whether a database is created as I am using this software the first time. where do I get this initorcl.ora file from?
    – user3213758
    Jan 25, 2014 at 13:58
  • 1
    What is %ORACLE_HOME% set to? Is your database definitely called ORCL? Are you certain a database has even been created?
    – Philᵀᴹ
    Jan 26, 2014 at 5:40

3 Answers 3


Set the ORACLE_SID and ORACLE_HOME variables properly. They must be in upper case letters.

Second, share the content of directory. ORACLE_HOME/dbs


You can manually create the init.ora file. Only two parameters are required - db_name and db_block_size.

Then run:

startup pfile='c:\program\11.2.0\dbhome_1\dbs\init.ora'

If you have a valid spfile then run:

create pfile from spfile 

You should be able to startup your database.

  • Apperently the OP has no spfile. But even if he has one, why should he create a pfile? And why should he configure the init.ora file of the dbs directory to startup the database? All in all I think the user will not have much fun with Oracle software if he does not create a database.
    – miracle173
    Jul 29, 2015 at 6:45

There is 2 way to solve the problem.

One way is that, there might be another *.ora file (e.g spfileyourdbname.ora). If there is, just do the same thing as you did:

    SQL> startup pfile = 'C:\Program\11.2.0\dbhome_1\dbs\spfileyourdbname.ora'

Or Another way is, just copy the below codes, change the relevant directories and parameters, and save in the required directory (e.g $ORACLE_HOME/dbs/) as 'spfileyourdbname.ora'. Then just do the same thing:

    SQL> startup pfile = 'C:\Program\11.2.0\dbhome_1\dbs\spfileyourdbname.ora'

'mydb' is the name of your database [SID].

Codes to copy:

    mydb.__oracle_base='/home/yeyintkoko/app/oracle'#ORACLE_BASE set from environment
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=mydbXDB)'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.