Oracle----静默安装

一、前期准备

/etc/hosts配置

iptables 关闭

selinux关闭

Networkmanager关闭/

配置yum

yum install

  1 compat-libcap1.x86_64
  2 binutils-2.17.50.0.6-14.el5.x86_64.rpm
  3 compat-libstdc++-33-3.2.3-61.x86_64.rpm
  4 elfutils-libelf-0.137-3.el5.x86_64.rpm
  5 elfutils-libelf-devel-0.137-3.el5.x86_64.rpm
  6 gcc-4.1.2-48.el5.x86_64.rpm
  7 glibc-devel-2.5-49.x86_64.rpm
  8 libgomp-4.4.0-6.el5.x86_64.rpm
  9 glibc-headers-2.5-49.x86_64.rpm
 10 kernel-headers-2.6.18-194.el5.x86_64.rpm
 11 gcc-c++-4.1.2-48.el5.x86_64.rpm
 12 libstdc++-devel-4.1.2-48.el5.x86_64.rpm
 13 glibc-2.5-49.x86_64.rpm
 14 glibc-common-2.5-49.x86_64.rpm
 15 ksh-20100202-1.el5.x86_64.rpm
 16 libaio-0.3.106-5.x86_64.rpm
 17 libaio-devel-0.3.106-5.x86_64.rpm
 18 libgcc-4.1.2-48.el5.x86_64.rpm
 19 libstdc++-4.1.2-48.el5.x86_64.rpm
 20 libstdc++-devel-4.1.2-48.el5.x86_64.rpm
 21 make-3.81-3.el5.x86_64.rpm
 22 sysstat-7.0.2-3.el5.x86_64.rpm
 23 unixODBC-2.2.11-7.1.x86_64.rpm
 24 unixODBC-devel-2.2.11-7.1.x86_64.rpm
 25 
 26 
 27 
 28 [root@New src]# vi /etc/security/limits.conf 
 29 
 30 oracle          soft    nproc           2047
 31  oracle          hard    nproc           65536
 32  oracle          soft    nofile          2047
 33  oracle          hard    nofile          65536
 34 
 35 
 36 
 37 vi /etc/sysctl.conf
 38 
 39 
 40 kernel.shmmni = 4096
 41  kernel.sem = 250 32000 100 128
 42  fs.aio-max-nr = 1048576
 43  fs.file-max = 6815744
 44  net.ipv4.ip_local_port_range = 9000 65500
 45  net.core.rmem_default =262144
 46  net.core.rmem_max = 4194304
 47  net.core.wmem_default = 262144
 48  net.core.wmem_max = 1048576
 49 
 50 
 51 
 52 
 53 PATH变量
 54 
 55 export ORACLE_BASE=/u01/app/oracle
 56 export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_home1
 57 export TEMP=/tmp
 58 export TEPDIR=/tmp
 59 export ORACLE_SID=ykyk
 60 export PATH=$ORACLE_HOME/bin:$PATH
 61 
 62 
 63 
 64 
 65 
 66 修改内核参数
 67 
 68 kernel.shmmni = 4096
 69  kernel.sem = 250 32000 100 128
 70  kernel.semopm = 100
 71 
 72 
 73  fs.aio-max-nr = 1048576
 74  fs.file-max = 6815744
 75 
 76 net.ipv4.ip_local_port_range = 9000 65500
 77  net.core.rmem_default = 262144
 78  net.core.rmem_max = 4194304
 79  net.core.wmem_default = 262144
 80  net.core.wmem_max = 1048576
 81
Heros

二、编辑配置文件

cd /usr/local/src/database/

cd response

[oracle@Ora response]$ cat db_install.rsp |grep -v ^# |grep  –v ^$ > myinstall.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=Ora.ykyk.com
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/test/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/test/app/oracle/product/11.2.0/db_home1
ORACLE_BASE=/test/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=
oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=

oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
                                               

./runInstaller -silent -responseFile /usr/local/src/database/response/myinstall.rsp

 

cd $ORACLE_HOME/dbs/

[oracle@Ora dbs]$ cat init.ora |grep -v ^# |grep -v ^$ > inittina.ora
[oracle@Ora dbs]$ vi inittina.ora

[oracle@Ora dbs]$ cat inittina.ora
db_name='tina'

processes = 300
audit_file_dest='$ORACLE_BASE/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='$ORACLE_BASE/flash_recovery_area'
db_recovery_file_dest_size=2G
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = ('$ORACLE_BASE/oradata/tina/ora_control01.ctl','$ORACLE_BASE/oradata/tina/ora_control02.ctl')
compatible ='11.2.0'
sga_max_size = 500M
sga_target = 300M

[oracle@Ora dbs]$ mkdir -p $ORACLE_BASE/oradata/tina/

[oracle@Ora dbs]$ mkdir -p $ORACLE_BASE/admin/orcl/adump
[oracle@Ora dbs]$ mkdir -p $ORACLE_BASE/flash_recovery_area

 

[oracle@Ora dbs]$ sqlplus / as sysdba

SQL> create spfile from pfile

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size      2229944 bytes
Variable Size    331352392 bytes
Database Buffers   184549376 bytes
Redo Buffers      3805184 bytes

[oracle@Ora dbs]$ vi create.sql

REATE DATABASE tina
        USER SYS IDENTIFIED BY oracle
        USER SYSTEM IDENTIFIED BY oracle
        LOGFILE GROUP 1 ('$ORACLE_BASE/oradata/tina/redo01.log') SIZE 300M BLOCKSIZE 512,
                GROUP 2 ('$ORACLE_BASE/oradata/tina/redo02.log') SIZE 300M BLOCKSIZE 512,
                GROUP 3 ('$ORACLE_BASE/oradata/tina/redo03.log') SIZE 300M BLOCKSIZE 512
        MAXLOGFILES 30
        MAXLOGMEMBERS 5
        MAXLOGHISTORY 1
        MAXDATAFILES 100
        CHARACTER SET AL32UTF8
        NATIONAL CHARACTER SET AL16UTF16
        EXTENT MANAGEMENT LOCAL
        DATAFILE '$ORACLE_BASE/oradata/tina/system01.dbf' SIZE 325M REUSE
        SYSAUX DATAFILE '$ORACLE_BASE/oradata/tina/sysaux01.dbf' SIZE 325M REUSE
        DEFAULT TABLESPACE users
                DATAFILE '$ORACLE_BASE/oradata/tina/users01.dbf'
                SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
        DEFAULT TEMPORARY TABLESPACE tempts1
                TEMPFILE '$ORACLE_BASE/oradata/tina/temp01.dbf'
                SIZE 20M REUSE
        UNDO TABLESPACE undotbs1
                DATAFILE '$ORACLE_BASE/oradata/tina/undotbs01.dbf'
                SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

 

 

[oracle@Ora dbs]$ sqlplus / as sysdba

 

SQL> @create

[oracle@Ora dbs]$ vi updatedb.sql

@?/rdbms/admin/catalog.sql ;
@?/rdbms/admin/catproc.sql ;
@?/rdbms/admin/catblock.sql ;
@?/rdbms/admin/catoctk.sql ;
@?/rdbms/admin/owminst.plb ;
@?/rdbms/admin/dbmspool.sql;
conn system/oracle
@?/sqlplus/admin/pupbld.sql;
@?/sqlplus/admin/help/hlpbld.sql helpus.sql;
conn / as sysdba;
shu immediate;
startup mount;
alter database archivelog;
alter database open;
@?/rdbms/admin/utlsampl.sql ;

SQL>@updatedb

posted on 2018-03-29 21:36  ykyk_dba  阅读(204)  评论(0)  编辑  收藏  举报

导航