Oracle DBA

Az egyik használaton kívüli teszt szerverünket életre kellett lehelni. Igenám, csak közben elvették alóla a memóriát, összesen 2GB maradt.

We had to startup one of our test servers not being used. Meanwhile its memory has been reduced to only 2GB.

C:\Users\oracle>SET ORACLE_SID=TEST
C:\Users\oracle>SQLPLUS / AS SYSDBA

SQL*Plus: Release 10.2.0.4.0 - Production on Cs. J˙l. 28 08:21:32 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to an idle instance.

SQL> STARTUP
ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete

Persze, hogy csak spfile létezett, pfile nem, kellett egyet gyártani, hogy el tudjon indulni.

Of course there was only an spfile, no pfile, so we had to create one in order to let oracle start up.

initTEST.ora
db_name='TEST'
sga_target=750M
pga_aggregate_target=250M
processes = 150
audit_file_dest='c:\oracle\product\10.2.0\admin\TEST\adump '
audit_trail ='db'
db_block_size=8192
db_domain='fibernetrt.fibernet.hu'
db_recovery_file_dest='c:\oracle\product\10.2.0\flash_recovery_area'
db_recovery_file_dest_size=2G
background_dump_dest='c:\oracle\product\10.2.0\admin\TEST\bdump'
dispatchers='(PROTOCOL=TCP) (SERVICE=TEST)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDO_DATA'
# You may want to ensure that control files are created on separate physical
# devices
control_files = ("c:\oracle\product\10.2.0\oradata\test\CONTROL01.CTL","c:\oracle\product\10.2.0
\oradata\test\CONTROL02.CTL","c:\oracle\product\10.2.0\oradata\test\CONTROL03.CTL")
compatible ='10.2.0'

Próbáljuk ki!

Let's give it a try.

SQL> STARTUP PFILE='c:\oracle\product\10.2.0\db_1\database\initTEST.ORA'
ORACLE instance started.

Total System Global Area  788529152 bytes
Fixed Size                  2069000 bytes
Variable Size             201330168 bytes
Database Buffers          578813952 bytes
Redo Buffers                6316032 bytes
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version
10.2.0.0.0
ORA-00202: control file: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\CONTROL01.CTL'

Hoppá, az init.ora -ban cseréljük ki a compatible = '10.2.0' paramétert compatible = '10.2.0.3' -ra.

Oops, let's change compatible = '10.2.0' parameter to compatible = '10.2.0.3' in init.ora

SQL> shut abort
ORACLE instance shut down.
SQL> STARTUP PFILE='c:\oracle\product\10.2.0\db_1\database\initTEST.ORA'
ORACLE instance started.

Total System Global Area  788529152 bytes
Fixed Size                  2069000 bytes
Variable Size             201330168 bytes
Database Buffers          578813952 bytes
Redo Buffers                6316032 bytes
Database mounted.
Database opened.
SQL>

 Voila!