Why is there no control file like control01.ctl to restore and mount the Oracle database?

Question

Oracle

Good afternoon,
Installed Oracle XE 11g on Ubuntu x64. SSH access.
I'm trying to run:

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size		    2233344 bytes
Variable Size		  616565760 bytes
Database Buffers	  444596224 bytes
Redo Buffers		    5541888 bytes
ORA-00205: error in identifying control file, check alert log for more info

The alert log displays:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...

I searched several sites, all advice boils down to copying an existing file:

Restore the control file that is missing for your database by copying an existing control file.
cp /u01/app/oracle/oradata/<тут SID>/control01.ctl /u01/app/oracle/oradata/<тут SID>/control02.ctl

The problem is that my /u01/app/oracle/oradata// contains only dbf files:

# ls
control.dbf  sysaux.dbf  system.dbf  temp.dbf  undotbs1.dbf  users.dbf

Question: Where can I get the file I need so that Oracle can mount the database?

SQL> show parameter control_files

NAME				                    TYPE                                 
------------------------------------ --------------------------------- 
control_files			                  string	            

VALUE
------------------------------
/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1, /u01/app/oracle/product/11.2.0/xe/dbs/ora_control2

The init.ora file (I create spfile from it):

db_name='XE'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/XE/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
#db_recovery_file_dest='/u01/app/oracle/flash_recovery_area/XE' закомментировал, т.к. отсутствует
#db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=XE)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'

Environment variables:

ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
ORACLE_SID=XE
NLS_LANG=RUSSIAN_RUSSIA.AL32UTF8
ORACLE_BASE=/u01/app/oracle
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib
PATH=/u01/app/oracle/product/11.2.0/xe/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games

Answer 1

A cursory Google showed that the Control File is created along with the database. Why it was not created - I would look at the permissions on the folders.
Here is a detailed description of how to create a file from scratch (if it is damaged and you do not have a backup) - docs.oracle.com/cd/B28359_01/server.111/b28310/con...

Answer 2

Is "/u01/app/oracle/product/11.2.0/xe/dbs/" ora_control1 present here?

Answer 3

Although thread is over 3 years old, people still make the same mistakes. So
1) NEVER use an UNCERTIFIED operating system to install Oracle products. Once again, NEVER USE AN UNCERTIFIED OS . Particularly UBUNTU.
2) Forget about Oracle XE for learning. Use Enterprise Edition.
[ dbpilot.net ]
[ dbpilot.net/about ]