Pokrecem sledece:
# lsnrctl start
# /etc/init.d/oracle-xe start
# sqlplus /nolog
# connect sys as sysdba
# startup
----> dobijam sledecu gresku:
ORA-27102: out of memory
Linux Error: 28: No space left on device
----> onda sam probao sledece
# connect sys as sysdba
# startup mount pfile='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/init.ora'
-----> dobio sledece
ORACLE instance started.
Total System Global Area 121634816 bytes
Fixed Size 1257356 bytes
Variable Size 91226228 bytes
Database Buffers 26214400 bytes
Redo Buffers 2936832 bytes
ORA-00205: error in identifying control file, check alert log for more info
-----> u log fajlu stoji sledece:
Thu Jul 5 00:38:02 2007
Starting ORACLE instance (normal)
Thu Jul 5 00:38:02 2007
System parameter db_block_buffers enabled without VLM on.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /usr/lib/oracle/xe/app/oracle/product/10
.2.0/server/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 62914560
control_files = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/control
.dbf
db_block_buffers = 3200
log_buffer = 2891264
log_checkpoint_interval = 10000
db_files = 80
db_file_multiblock_read_count= 8
global_names = TRUE
parallel_max_servers = 0
max_dump_file_size = 10240
db_name = XE
Obsolete system parameters with specified values:
oracle_trace_enable
End of obsolete system parameter listing
PMON started with pid=2, OS id=1881
PSP0 started with pid=3, OS id=1885
MMAN started with pid=4, OS id=1887
DBW0 started with pid=5, OS id=1889
LGWR started with pid=6, OS id=1892
CKPT started with pid=7, OS id=1899
SMON started with pid=8, OS id=1901
RECO started with pid=9, OS id=1908
MMON started with pid=10, OS id=1910
MMNL started with pid=11, OS id=1912
Thu Jul 5 00:38:03 2007
Oracle Data Guard is not available in this edition of Oracle.
Thu Jul 5 00:38:03 2007
ALTER DATABASE MOUNT
Thu Jul 5 00:38:03 2007
ORA-00202: control file: '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/control.db
f'
ORA-27047: unable to read the header block of file
Linux Error: 17: File exists
Additional information: 1
Thu Jul 5 00:38:03 2007
ORA-205 signalled during: ALTER DATABASE MOUNT...
U cemu je problem?
ps. kontrolni fajl je prazan (control.dbf)