PowerEdge6850安裝Oracle10g

1、刪除/etc/orainst.loc /etc/oratab；

2、修改/etc/sysctl.conf （核心引數），加入

net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

執行#sysctl -p 立即生效

3、unzip 10201_database_linux32.zip;

4、#xhost local:oracle

5、su oracle

source /home/oracle/.bash_profile --立即生效環境變數

6、./runInstaller

[@more@]

刪除/etc/oraInst.loc /etc/oratab
#vi /etc/sysctl.conf
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
#sysctl -p
#xhost local:oracle
#su oracle
$source ./home/oracle/.bash_profile
$./runInstaller

--檢視job引數

SQL> show parameter job_queue_process

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 0

SQL> alter system set job_queue_processes=10;

System altered

SQL> show parameter job_queue_process

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10

alter tablespace USERS add datafile '/home/oracle/oracle/product/10.2.0/oradata/pdsbb/users03.dbf' size 2048M;
alter tablespace TEMP add tempfile '/home/oracle/oracle/product/10.2.0/oradata/pdsbb/temp02.dbf' size 1024M;