"Combat" Silent installation-oracle 11.2.0.3 on CentOS 5.10

Found online silent installation of many articles, a mess, a variety! Let's get a literacy!

Install Oracle 11g_r2******************************************************************************1. System section under CentOS 5.10 * ------1. Installing the system--applicationsgraphicsgraphical internettext-based Internetoffce/productivityeditorssound and Video--base Systemadministration toolsbaselegacy software support:compat-libstdc-compat-db-x Window Systemsystem tools: Sysstat----Desktop Envirementsgnome desktop environment--development the default option after adding the following options development Libraries: Libstdc-development tools:gcc-legacy Software Development--languageschinese Support---serverftp serverlegacy network Server:rsh-server telnet-serverprinting supportserver Configure tools------2. Configure Xmanager connection to Linux---2.1 centos 6.5 1). Yum install XDm XDM2). VI/ETC/X11/XDM/XACCESS49 * #any host can get a login window3). Modify the/etc/gdm/custom.conf file. [XDMCP] ENABLE=TRUEDISPLAYSPERHOST=5PORT=177[SECURITY]ALLOWREMOTEROOT=TRUE4). Restarting the GPM service: the service gpm restartchkconfig gpm on confirmationGPM service Boot 5). Restart the GDM service/usr/sbin/gdm-restart---2.2 centos 5.10--1. Editing the configuration file Ls-al/usr/share/gdm/defaults.confchmod 644/ Usr/share/gdm/defaults.confvi/usr/share/gdm/defaults.conf/****/usr/share/gdm/defaults.conf and/etc/gdm/ custom.conf content Consistent, modify any one can ****/[xdmcp]enable=truedisplaysperhost=5port=177[security]allowremoteroot=truevi/usr/ share/gdm/defaults.conf214 row allowremoteroot=true263 row enable=true279 row displaysperhost=2284 row port=177--2. Restart GPM Service: Service gpm restartchkconfig gpm on confirm gpm service boot--2. Restart GDM Service/usr/sbin/gdm-restart-------1.3 Configure Yum Source cd/etc/ YUM.REPOS.DMV Centos-base.repo Centos-base.repo.oldwget Http://mirrors.163.com/.help/CentOS6-Base-163.repoyum Makecache Check for updatable RPM package #yum check-update Update all RPM packages #yum updateyum-y groupinstall ' development Libraries ' ***************** 2.oracle Mounting Section ************************************* 1, check whether the following packages are installed, if not installed to install first: MOUNT/DEV/CDROM/MNTCD/MNT/CENTOSRPM-UVH biNUTILS-2.*RPM-UVH COMPAT-LIBSTDC++-33*RPM-UVH COMPAT-LIBSTDC++-33*.I386.RPMRPM-UVH ELFUTILS-LIBELF*RPM-UVH gcc-4.*  RPM-UVH GCC-C++-4.*RPM-UVH GLIBC-2.*RPM-UVH GLIBC-COMMON-2.*RPM-UVH GLIBC-DEVEL-2.*RPM-UVH GLIBC-HEADERS-2.*RPM-UVH KSH*RPM-UVH LIBAIO-0.*RPM-UVH LIBAIO-DEVEL-0.*RPM-UVH libgomp-4.*rpm-uvh LIBGCC-4.*RPM-UVH libstdc++-4.*rpm-uvh Lib STDC++-DEVEL-4.*RPM-UVH MAKE-3.*RPM-UVH SYSSTAT-7.*RPM-UVH NUMACTL-DEVEL-*RPM-UVH UNIXODBC-2.*RPM-UVH unixodbc-devel-2.*---Using Yum installation unixODBC yum install UnixODBC yum install Elfutils-libelf-develyum install Pdksh Step 4: Configure the system [[ Email protected] ~]# grep memtotal/proc/meminfomemtotal:4946772 kb[[email protected] ~]# grep SwapTotal/ proc/meminfoswaptotal:12289716 kb[[email protected] ~]# df-hfilesystem Size used Avail Use% Mounted      On/dev/sda2 17G 2.8G 14G 18%//dev/sda1 1012M 40M 921M 5%/bootnone 891M             0 891M 0%/dev/shm/dev/hdc 192M 192M 0 100%/media/cdrom Second, parameter modification 1. Set the required IP2, modify the host file to add a fully qualified domain name to the/etc/hosts file, such as: Vi/etc/hosts192.168.5.199ocpyang.s Z.comocpyang3. Viewing modification Results Hostnamecat/etc/hosts | grep ' eval hostname ' 4, set core parameter 1, add the following line to the/etc/sysctl.conf file: #vi/etc/sysctl.conffs.suid_dumpable = 1FS.AIO-MAX-NR = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 2532755456 Kernel.shmmni = 4096# SEMAPHORES:SEMMSL, se Mmns, semopm, Semmnikernel.sem = 32000 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default= 4194304net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586net.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0KERNEL.SYSRQ = 0kernel.core_uses_ PID = 1net.ipv4.tcp_syncookies = 1KERNEL.MSGMNB = 65536 5, run the following command to change the core parameters: #/sbin/sysctl-p 6,/etc/security/ Add the following line to the limits.conf file: # vi/etc/security/limits.conforacle soft Nproc 2047oracle Hard Nproc 16 384oracle Soft Nofile 1024oracle hard nofile 65536oracle hard stack 102407, add the following line to the/etc/pam.d/login file: # VI/ETC/PAM.D /loginsession required Pam_limits.so8. Turn off SELinux mode of operation and Firewall # vi/etc/selinux/config# set SELinux to Disabledselinux=di sabled# Service iptables Stop three, create the following groups and users Groupadd oinstallgroupadd dbagroupadd operuseradd-g oinstall-g dba,oper-d/home/   Oracle ORACLEPASSWD Oracle IV, creating a directory to install Oracle Mkdir-p/u01mkdir-p/u01/app/oracle/product/11.2.0/db_1chown-r Oracle.oinstall/u01chmod-r 775/u01 Description: The/u01/app/oracle/product/11.2.0/db_1 directory is the location where the program files are placed. Setting environment variables for Oracle users log in with Oracle at the end of the:/home/oracle/.bash_profile file, note that the ORACLE_SID is replaced with its own instance name: # Vi/home/oracle/.bash_ Profile can also #su-oracle#vi. Bash_profile Add the following: # Oracle Settingstmp=/tmp;export tmptmpdir= $TMP; export Tmpdiroracle_ Base=/u01/app/oracle;export oracle_baseoracle_home= $ORACLE _base/product/11.2.0/db_1;export ORACLE_HOMEORACLE_SID =orcl;export oracle_sidoracle_term=xterm;export oracle_termpath=/usr/sbin: $PATH; export pathpath= $ORACLe_home/bin: $PATH, export pathexport nls_date_format= "Yyyy-mm-dd HH24:MI:SS" ld_library_path= $ORACLE _home/lib:/lib :/usr/lib;export ld_library_pathclasspath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib;export Classpath#ld_assume_kernel=2.4.1;export ld_assume_kernel#set languagenls_lang= "SIMPLIFIED CHINESE" _CHINA. Al32utf8export Nls_langeditor=viexport Editorif [$USER = "Oracle"]; thenif [$SHELL = "/bin/ksh"]; Thenulimit-p 16384ulimit-n 65536elseulimit-u 16384-n 65536fifialias oratrace= "Cat $ORACLE _base/diag/rdbms/$ORACLE _s ID/$ORACLE _sid/trace/alert_orcl.log "Alias oradata=" CD $ORACLE _base/oradata/$ORACLE _sid "Alias oranetwork=" CD $ Oracle_home/network/admin "VI, install $unzip 1.zip$unzip 2.zip$cd/soft/chown-r oracle:oinstall/soft/database$ cd database/ Cp-r/soft/database/response/home/oracle----Method 1:$./runinstaller-silent-debug-force from_location=/soft/database/ Stage/products.xml oracle.install.option=install_db_swonly oracle_hostname=ocpyang.sz.com UNIX_GROUP_NAme=oinstall inventory_location=/u01/app/orainventory SELECTED_LANGUAGES=EN,ZH_CN ORACLE_HOME=/u01/app/oracle/ Product/11.2.0/db_1 oracle_base=/u01/app/oracle Oracle.install.db.installedition=ee Oracle.install.db.eeoptionsselection=false ORACLE.INSTALL.DB.DBA_GROUP=DBA Oracle.install.db.oper_group=oper Oracle.install.db.config.starterdb.type=general_purpose Oracle.install.db.config.starterdb.memoryoption=false Oracle.install.db.config.starterdb.installexampleschemas=false Oracle.install.db.config.starterdb.enablesecuritysettings=true oracle.install.db.config.starterdb.control=db_ CONTROL Security_updates_via_myoraclesupport=false Decline_security_updates=true Oracle.installer.autoupdates.option=skip_updates---method 2:vi/home/oracle/ Ocp.rsporacle.install.responsefileversion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_ 0oracle.install.option=install_db_swonlyoracle_hostname=ocpyang.sz.comunix_group_name=oinstallinventory_ Location=/u01/app/orainventoryselected_languages=en,zh_cnoracle_home=/u01/app/oracle/product/11.2.0/db_1oracle_base=/u01/app/oracleoracle.install.db.installedition= eeoracle.install.db.eeoptionsselection=falseoracle.install.db.dba_group=dbaoracle.install.db.oper_group= operoracle.install.db.config.starterdb.type=general_purposeoracle.install.db.config.starterdb.memoryoption= falseoracle.install.db.config.starterdb.installexampleschemas= Falseoracle.install.db.config.starterdb.enablesecuritysettings=trueoracle.install.db.config.starterdb.control= db_controlsecurity_updates_via_myoraclesupport=falsedecline_security_updates= Trueoracle.installer.autoupdates.option=skip_updates./runinstaller-ignoresysprereqs-force-silent-responsefile/ Home/oracle/response/ocp.rsp[[email protected] ~]$ su-l rootpassword: #/u01/app/orainventory/orainstroot.sh #/ u01/app/oracle/product/11.2.0/db_1/root.sh vii. Silent Building and Silent configuration monitoring:---7.1 silent build library $ CAT/HOME/ORACLE/CREATEDB.RSP [general] Responsefile_version = "11.2.0" Operation_type = "CreateDatabase" [createdatabase]gdbname = "ORCL" SID = "ORCL" templatename = "General_purpose.dbc" Syspassword = "password" Systempassword = "password" Sysmanpassword = " Password "Dbsnmppassword =" password "datafiledestination ="/u01/app/oracle/oradata "Storagetype=fscharacterset =" ZHS16GBK "DatabaseType =" multipurpose "automaticmemorymanagement =" FALSE "$ dbca-silent-responsefile/home/oracle/ RESPONSE/CREATEDB.RSP Ps-ef | grep Ora_ | Grep-v grep | Wc-l----7.2 Silent configuration Listen $ $ORACLE _home/bin/netca/silent/responsefile/home/oracle/response/netca.rsp$ ll $ORACLE _home/ network/admin/*.ora$ lsnrctl status after the execution, the monitoring has been started eight, after installation configuration modify Oratab file, add the following line in the/etc/oratab file, vi/etc/orataborcl:/u01/ App/oracle/product/11.2.0/db_1:y Start and stop Oracle Enterprise Manager Database control: $ emctl start dbconsole$ emctl stop dbconsole start and stop isql*plus:$ isqlplusctl start$ Isqlplusctl stop starts and stops the listener: The listener accepts connection requests from the client and creates a database connection after validating the certificate. To use an OEM or isql*plus, you must first start the listener. $ lsnrctl start$ lsnrctl stop$cat/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora start and stop database: Startup: $ Sqlplussql> Startup off: $Sqlplussql> shutdown immediate Nine, set boot Oracle Auto-start step 1:# vi/etc/orataborcl:/u01/app/oracle/product/10.2.0/db_1:y/ The Etc/oratab format is: SID:ORACLE_HOME:AUTO sets the auto domain to Y (uppercase) so that Oracle's own dbstart and Dbshut can function step 2: Modify with Oracle user $oracle_ Home/bin/dbstart file $vi/u01/app/oracle/product/11.2.0/db_1/bin/dbstart82 line oracle_home_listner=$1 modified to Oracle_home_ listner= $ORACLE _home Step 3:root New ORACLE control file #vi/etc/init.d/oracle11gr2 content for ORACLE11GR2 script Step 4: Let Linux Service control # chmod 774/etc/ INIT.D/ORACLE11GR2 # chkconfig--add oracle11gr2 This boot will start randomly. You can also use the command at any time to start: #service oracle11gr2 start#service oracle11gr2 stop#service oracle11gr2 Restart 10, configuration: (Resolve listening failure, see file) after the installation is complete, The first boot is not a problem, but after restarting the computer, you must start the database manually or by script. 1, manually start the database: to execute Dbstart with the Oracle user, this command after I install the completion, there is an error, I will change the script, using a text editor to open Dbstart, 78 lines of vi/u01/app/oracle/product/ 11.2.0/db_1/bin/dbstart oracle_home_listner=/ade/vikrkuma_new/oracle change to your own path. ORACLE_HOME_LISTNER=/U01/APP/ORACLE/PRODUCT/10.2.0/DB_1/shut down the database with Dbshut. If you need to use Isqlplus to manage the database, start Isqlplus, Run command: Isqlplusctl start | Stop to use Web-based Enterprise Manager, you need to shipLine command: Emctl start | Stop Dbconsole-----12, Common SQL Global configuration file Vi/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/glogin.sql--dba add for Oraclealter session Set nls_date_format= ' Yyyy-mm-dd HH24:MI:SS '; Define _editor=viset serveroutput on size 1000000set trimspool onset long 5000set linesize 100set pagesize 9999column Plan _plus_exp format a80column global_name new_value gnameset termout off define gname=idlecolumn global_name New_value gnames Elect lower (user) | | '@' || substr (Global_name, 1,decode (dot, 0, Length (global_name), dot-1)) global_namefrom (select Global_name, InStr (Global_na Me, '. ') Dot from global_name); set time onset sqlprompt ' &gname> '----Chinese table settings create table t1 (SID number,sname Varchar2); I Nsert into T1 values (101, ' Suzhou '); insert into T1 values (102, ' Oracle Chinese Test ');

"Combat" Silent installation-oracle 11.2.0.3 on CentOS 5.10