Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 went to check and found out that "initoracl.ora" doesn't exist inside the 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\<oracle_base>]
 specific directory does not exist
 additional error information
 <OS 123> the filename, directory name, or volume syntax is incorrect.

What should I do?

share|improve this question

migrated from Jan 25 '14 at 17:26

This question came from our site for professional and enthusiast programmers.

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 '14 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 '14 at 13:58
What is %ORACLE_HOME% set to? Is your database definitely called ORCL? Are you certain a database has even been created? –  Phil Jan 26 '14 at 5:40

2 Answers 2

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)'
share|improve this answer

You can manually create the init.ora file. Only 2 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.

share|improve this answer
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 at 6:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.