[ ZeRo8 @ 04.07.2007. 23:40 ] @
Imam Debian Server (3.1 sarge) i na njemu sam instalirao oracle. Pokrecem sledece: Code: # lsnrctl start # /etc/init.d/oracle-xe start # sqlplus /nolog # connect sys as sysdba # startup ----> dobijam sledecu gresku: Code: ORA-27102: out of memory Linux Error: 28: No space left on device ----> onda sam probao sledece Code: # connect sys as sysdba # startup mount pfile='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/init.ora' -----> dobio sledece Code: 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: Code: 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) |