about installing Oracle times under Linux error: Out of memory problem analysis explanation

I. Description

During Oracle installation, you may experience an out of memory error due to insufficient system memory. We can solve it by adding memory.

And if it's a different situation: for example, I have two Oracle server installed on the host, where oracle12c is mounted in the/u01/app/oracle directory and oracle11g installed in the/u02/app/oracle directory.

First I install oracle12c when I give more memory, causing the rear install oracle11g times wrong: Out of the memory. How do I adjust the oracle12c memory at this time?

Second, adjust the memory

Method One: Adjust the parameters in the configuration file by modifying them

1. Use the Oracle User login oracle12c installation directory to locate the Inita4orcl.ora file

Vi/u01/app/oracle/dbs/inita4orcl.ora

a4orcl.__data_transfer_cache_size=0 a4orcl.__db_cache_size=7784628224 a4orcl.__java_pool_size
=100663296 a4orcl.__large_pool_size=167772160 a4orcl.__oracle_base= '/u01/app ' #ORACLE_BASE set from environment
a4orcl.__pga_aggregate_target=3388997632 a4orcl.__sga_target=10099884032 a4orcl.__shared_io_pool_size=536870912 a4orcl.__shared_pool_size=1476395008 a4orcl.__streams_pool_size=0 *.audit_file_dest= '/u01/app/admin/a4orcl/ Adump ' *.audit_trail= ' db ' *.compatible= ' 12.1.0.2.0 ' *.control_files= '/u01/app/oradata/a4orcl/control01.ctl ', '/u01 /app/fast_recovery_area/a4orcl/control02.ctl ' *.db_block_size=8192 *.db_domain= ' *.db_name= ' A4ORCL ' *.db_recovery _file_dest= '/u01/app/fast_recovery_area ' *.db_recovery_file_dest_size=4560m *.diagnostic_dest= '/u01/app ' *. Dispatchers= ' (protocol=tcp) (service=a4orclxdb) ' *.open_cursors=300 *.pga_aggregate_target=3207m *.processes=300 *. Remote_login_passwordfile= ' EXCLUSIVE ' *.sga_target=9623m *.undo_tablespace= ' UNDOTBS1 ' 

Modify the value of the Sga_target, which is modified to 6144m, that is 6 g

2. Log in to the ORACLE12C database and execute the following command

Create SPFile from Pfile;

3. Restart the database

Shutdown immediate;

Startup

Method Two: Adjust from the command line

1. Log in to the ORACLE12C database and execute the following command

Alter system set sga_target= ' 6144m ' scope=spfile;

Alter system set sga_max_size= ' 6144m ' scope=spfile;

2. Restart the database

Shutdown immediate;

Startup

Iii. notes on Pfile and SPFile

In this case: Pfile is Inita4orcl.ora

Pfile and SPFile are important files for the database, and the database uses SPFile first.

SPFile is a binary file, can not be directly modified;

Pfile is a text file that can be modified, so these two files can be generated according to each other;

For example, the value of memory in the current SPFile file is 9623M, and the system uses it preferentially. But it cannot be modified directly.

I can generate spfile by modifying the Pfile and then by pfile the file. So spfile not change over?

#由spfile生成pfile

Create Pfile from SPFile;

#由pfile生成spfile

Create SPFile from Pfile;