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>
++++++++++