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