4 Replies Latest reply on Apr 3, 2020 5:21 PM by yoonas

    Please help! SPfileXE.ora missing. Fresh install. Windows 8.1 Pro. Admin privs.

    4221857

      Hello,

       

      I have been stuck for many days. Please can you help me.

       

      I have done a full install of Oracle XE database.

       

      Despite using non-domain account, and Admin privs - the SPFileXE.ora file is missing? I think it's meant to be created during fresh install?

       

      So I get the following errors when I start db?

       

      What am I doing wrong?

       

      I need this database running, so I can run RCU application, and finish Oracle Forms/Report install for work.

       

      Thank you for suggestions?

       

      KEY LINES:

      1. ORA-01079: ORACLE database was not properly created, operation aborted

      2.  ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\server\app\oracle\product\11.2.0\server\dbs/spfileXE.ora'

       

      (I.E. there are files missing like spfileXE.ora????

      ++++++++++

      Microsoft Windows [Version 6.3.9600]

      (c) 2013 Microsoft Corporation. All rights reserved.

       

       

      C:\Windows\system32>sqlplus /nolog

       

       

      SQL*Plus: Release 11.2.0.2.0 Production on Tue Mar 31 10:30:43 2020

       

       

      Copyright (c) 1982, 2014, Oracle.  All rights reserved.

       

       

      SQL> startup pfile='C:\oraclexe\app\oracle\product\11.2.0\server\app\oracle\prod

      uct\11.2.0\server\config\scripts\init.ora'

      ORA-01031: insufficient privileges

      SQL> Connect system/password as sysdba

      Connected.

      SQL> startup pfile='C:\oraclexe\app\oracle\product\11.2.0\server\app\oracle\prod

      uct\11.2.0\server\config\scripts\init.ora'

      ORA-01081: cannot start already-running ORACLE - shut it down first

      SQL> SHUTDOWN

      ORA-01507: database not mounted

       

       

       

       

      ORACLE instance shut down.

      SQL> startup pfile='C:\oraclexe\app\oracle\product\11.2.0\server\app\oracle\prod

      uct\11.2.0\server\config\scripts\init.ora'

      ORACLE instance started.

       

       

      Total System Global Area 1068937216 bytes

      Fixed Size                  2260048 bytes

      Variable Size             616563632 bytes

      Database Buffers          444596224 bytes

      Redo Buffers                5517312 bytes

      ORA-01079: ORACLE database was not properly created, operation aborted

       

       

       

       

      SQL> create database;

      create database

      *

      ERROR at line 1:

      ORA-01501: CREATE DATABASE failed

      ORA-00200: control file could not be created

      ORA-00202: control file:

      'C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\APP\ORACLE\ORADATA\XE\CONTROL.DBF'

       

       

      ORA-27038: created file already exists

      OSD-04010: <create> option specified, file already exists

       

       

       

       

      SQL> create database;

      create database

      *

      ERROR at line 1:

      ORA-01501: CREATE DATABASE failed

      ORA-00200: control file could not be created

      ORA-00202: control file:

      'C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\APP\ORACLE\ORADATA\XE\CONTROL.DBF'

       

       

      ORA-27038: created file already exists

      OSD-04010: <create> option specified, file already exists

       

       

       

       

      SQL> startup pfile='C:\oraclexe\app\oracle\product\11.2.0\server\app\oracle\prod

      uct\11.2.0\server\config\scripts\init.ora'

      ORA-01081: cannot start already-running ORACLE - shut it down first

      SQL> create database TEST;

      create database TEST

      *

      ERROR at line 1:

      ORA-01501: CREATE DATABASE failed

      ORA-01504: database name 'TEST' does not match parameter db_name 'XE'

       

       

       

       

      SQL> show parameter control_files;

       

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      control_files                        string      C:\ORACLEXE\APP\ORACLE\PRODUCT

                                                       \11.2.0\SERVER\APP\ORACLE\ORAD

                                                       ATA\XE\CONTROL.DBF

      SQL> Connect system/password as sysdba

      Connected.

      SQL> SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE;

       

       

      INSTANCE_NAME    STATUS       DATABASE_STATUS

      ---------------- ------------ -----------------

      xe               STARTED      ACTIVE

       

       

      SQL> shutdown abort;

      ORACLE instance shut down.

      SQL> startup nomount;

      ORA-01078: failure in processing system parameters

      ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\serv

      er\app\oracle\product\11.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.

      SQL> startup pfile='C:\oraclexe\app\oracle\product\11.2.0\server\app\oracle\prod

      uct\11.2.0\server\config\scripts\init.ora'

      ORACLE instance started.

       

       

      Total System Global Area 1068937216 bytes

      Fixed Size                  2260048 bytes

      Variable Size             616563632 bytes

      Database Buffers          444596224 bytes

      Redo Buffers                5517312 bytes

      ORA-01079: ORACLE database was not properly created, operation aborted

       

       

       

       

      SQL>

      ++++++++++