Database Oracle10202, memory 4G, adjust the database sga_target, initially sga_target is 160 M, ready to adjust it to 2147483648, the results of the error ORA-27102, after multiple experiments, it is found that the database is started when sga_target is equal to MB.
1. Generate pfile and modify pfile
[Oracle @ CCN-BJ-4-573 dbs] $ vi initorcl. ora
Orcl. _ db_cache_size = 50331648
Orcl. _ Java _pool_size = 4194304
Orcl. _ large_pool_size = 4194304
Orcl. _ shared_pool_size = 100663296
Orcl. _ streams_pool_size = 0
*. Audit_file_dest = '/data/cache1/QQdatabase/product/10.2.0/db_1/admin/orcl/adump'
*. Background_dump_dest = '/data/cache1/QQdatabase/product/10.2.0/db_1/admin/orcl/bdump'
*. Compatible = '10. 2.0.1.0'
*. Control_files = '/data/cache1/QQdatabase/product/10.2.0/oradata/orcl/control01.ctl', '/data/cache1/QQdatabase/product/10.2.0/oradata/orcl/control02.ctl ', '/data/cache1/QQdatabase/product/10.2.0/oradata/orcl/control03.ctl'
*. Core_dump_dest = '/data/cache1/QQdatabase/product/10.2.0/db_1/admin/orcl/cdump'
*. Db_block_size = 8192
*. Db_domain =''
*. Db_file_multiblock_read_count = 16
*. Db_name = 'orcl'
*. Db_recovery_file_dest = '/data/cache1/QQdatabase/product/10.2.0/db_1/flash_recovery_area'
*. Db_recovery_file_dest_size = 2147483648
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = orclXDB )'
*. Job_queue_processes = 10
*. Open_cursors = 300
*. Pga_aggregate_target = 413138944
*. Processses = 150
*. Remote_login_passwordfile = 'clusive'
*. Sga_target = 2147483648
*. Undo_management = 'auto'
*. Undo_tablespace = 'undotbs1'
*. User_dump_dest = '/data/cache1/QQdatabase/product/10.2.0/db_1/admin/orcl/udump'
~
~
~
"Initorcl. ora" 27L, 1227C written
2. Database startup Error
[Oracle @ CCN-BJ-4-573 dbs] $ sqlplus "/as sysdba"
SQL * Plus: Release 10.2.0.1.0-Production on Fri Sep 21 14:44:30 2007
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27102: out of memory
Linux Error: 28: No space left on device
SQL> exit
Disconnected
[Content navigation] |
Page 1st: solutions to ORA-27102 errors in oracle databases in Linux |
Page 2nd: solutions to ORA-27102 errors in oracle databases in Linux |