GouthamAnand
asked on
oracle Idle instance
Hi,
I installed oracle express edition. But when I connect as
sqlplus / as sysdba
its showing as connected to "Idle instance."
When I type startup its showing below error
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\pr oduct\11.2 .0\serv
er\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>
Can you please help how can I resolve this issue.
Thanks
I installed oracle express edition. But when I connect as
sqlplus / as sysdba
its showing as connected to "Idle instance."
When I type startup its showing below error
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\pr
er\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>
Can you please help how can I resolve this issue.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
Go to "C:\oraclexe\app\oracle\pr
If not then create the pfile from spfile and startup the database .
Sample to create the pfile:
SQL> create pfile from spfile='C:\oraclexe\app\or