Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database Express Edition (XE) Release 11.2.0.2.0 (11gR2): spfilexe.ora is missing, get starte

4078415Sep 4 2019 — edited Sep 5 2019

Hello everyone! I am new here so I am sorry a lot in advance for any mistakes I will make in posting this question, but I am trying to solve this problem for already several days and feel pretty stuck. I have searched a lot on this forum but haven't found any solutions that would work in my situation.

I have Windows 10 Home, x64, last updated to version 1903. I (as administrator, with right-click and run as administrator) installed Oracle Database Express Edition (XE) Release 11.2.0.2.0 (11gR2) for Windows x64, had an issue with HTTPPORT being as %HTTPPORT% in the get started link, solved it by adding system variable HTTPPORT being equal to 8080 (so that final string looks like http://127.0.0.1:8080/apex/f?p=4950) but I still didn't manage to get anything on that page (in Chrome I got error ERR_CONNECTION_REFUSED). I tried to see solutions for that and some of them led me to seeing that I do not have spfilexe.ora file (the following led me to this conclusion)

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\10.2.0\server\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.

After this I downloaded and unzipped SQL Developer (19.2 for Windows x64 with JDK 8 included) and tried connect to Database, but this try failed with error

Status : Failure -Test failed: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I beg for help cause this is driving me insane, I have seen a lot of people installing it on same Windows without problems. I even tried to create another administrator account on this laptop but got same issue. I heard that it can be connected to some issues with rights in registry, but I didn't find any full explanation in already existing themes.

I would be very grateful for help!

Thank you

This post has been answered by 4078415 on Sep 5 2019
Jump to Answer
Comments
Post Details
Added on Sep 4 2019
5 comments
3,049 views