Sqlplus startup – failure in processing system parameters

oraclesqlplus

I am trying to do the startup command

This is what I have done:

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

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:

C:\Program\11.2.0\DBhome_1\Database

I found a init.ora file in:

C:\Program\11.2.0\dbhome_1\dbs

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?

Best Answer

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

Related Question