Vryjdfkk

I connected as sysdba and tried below:

SQL> startup;



ORA-01506: missing or illegal database name



SQL>

I tried multiple scenarios changing the Oracle_home and path variables but no luck.

These are my env variables:

c:>echo %ORACLE_HOME%

C:oraclexeapporacleproduct11.2.0server



c:>echo %ORACLE_SID%

XE



c:>path

PATH=C:oraclexeapporacleproduct11.2.0server;C:oraclexeapporacleproduct

11.2.0serverbin;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:Wi

ndowsSystem32WindowsPowerShellv1.0;C:Program Files (x86)ATI TechnologiesA

TI.ACECore-Static;C:instantclient-basic-windows.x64-11.2.0.4.0instantclient_1

1_2;C:UsersDINESHAppDataLocalProgramsPythonPython37Scripts;C:UsersDIN

ESHAppDataLocalProgramsPythonPython37

Also, I tried to restart the services manually but no luck.

The Content of initXE.ora is:

*.SPFILE='C:oraclexeapporacleproduct11.2.0serverdbs/spfileXE.ora',*.db_name='XE'

I tried:

SQL> create pfile='C:tempinitXE.ora' from spfile;



File created.



SQL> create spfile from pfile='C:tempinitXE.ora';



File created.



SQL> startup;

ORACLE instance started.



Total System Global Area  217157632 bytes

Fixed Size                  2251776 bytes

Variable Size             159384576 bytes

Database Buffers           50331648 bytes

Redo Buffers                5189632 bytes

ORA-00205: error in identifying control file, check alert log for more info

Still getting an error.

$ oerr ora 1506

01506, 00000, "missing or illegal database name"

// *Cause:  No db_name INIT.ORA aprameter was specified.

// *Action:  The database name must be given in the db_name

//          INIT.ORA parameter.

Your ORACLE_SID is XE.
When you issue startup, your process looks for a file %ORACLE_HOME%databasespfileXE.ora, or if it does not exist, then %ORACLE_HOME%databaseinitXE.ora.

You get the above error when the db_name parameter is missing from them.

You can edit initXE.ora with any text editor and add the missing parameter: *.db_name='XE'.
spfile should not be edited directly, first create pfile from it:

create pfile='C:tempinitXE.ora' from spfile;

Add the missing parameter to `C:tempinitXE.ora', then create the spfile from it:

create spfile from pfile='C:tempinitXE.ora';

After that, try startup again.

ORA-00205: error in identifying control file, check alert log for more info

That is a completely different error, meaning the files defined in the parameter control_files are inaccessible.

control file parameter is missing in your initXE.ora file.

Search for control file locations (control01.ctl and control02.ctl) in oracle base directory.create new ora file myXE.ora(any name is fine) with just two lines

*.db_name='XE'

*.control_files='C:some_directorycontrol01.ctl','C:some_directorycontrol02.ctl'

next start database with pfile

startup mount pfile='c:tempmyXE.ora

If no errros from above step

alter database open;

create spfile from memory;

If above steps did not resolves your issues meaning either control files missing or corrupted you need to recreate control files from alert logs.