Oracle XE 11g (windows 8) I can't connect to the Database (idle instance)

oracle, oracle11g

Solution

I've got that pain too.

To install Oracle XE you should login as local admin - NOT domain account. This https://community.oracle.com/thread/2361291 made me happy :)

Problem

Hi I have problem with idle instance When I trying: ``` sqlplus / as sysdba ``` I get result: `Connected to an idle instance.` And when I try startup I get: ``` ORA-01078: failure in processing system parameters ORA-01565 error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora ORA-27041: unable to open file ORA-04002: unable to open file O/S-Error: (OS 2) File not found; ``` My system is Windows 8. Do you any idea how to solve it? SOLUTION: I have to startup using command: ``` startup pfile='<path to file>/init.ora' ``` and change all paths in init.ora where was ``` <ORACLE_BASE> ``` Thx for help

Original source