RedHat5 install Oracle11GR2

1. Verify installation and check whether there are missing packages # version of the required packages for uname-r or cat/proc/version2.6.9-34.EL or 2.6.18-8
The program file is saved in the/opt/data directory.
Linux 5: [root @ localhost ~] # Rpm-qa | grep binutils compat gcc glibc libaio libgcc libstdc make sysstat unixODBCbinutils-2.17.50.0.6-2.el5compat-libstdc ++-fuse ++-4.1.1-fuse ++-4.1.1libstdc ++-devel-4.1.1-52.e15make-3.81-1.1 // the following package needs install libaio-devel-0.3.106sysstat-7.0.0unixODBC-2.2.11unixODBC-devel-2.2.11
Install a non-existing package as follows: 1. Find the non-existing package and upload it as root to the root user directory 2.rpm-ivh *. rmp
2. Configure Linux to view available RAM and swap space for Oracle, and run the following command:
Grep MemTotal/proc/meminfogrep SwapTotal/proc/meminfoOracle 11g software also requires 1.2 GB of available disk space, while the database requires an additional GB of available disk space. The/tmp directory requires at least MB of available space. To check the available disk space on the system, run the following command: df-h: Create an Oracle group and user account and run the following command as the root user: [root @ localhost ~] # Groupaddoinstall [root @ localhost ~] # Groupadddba [root @ localhost ~] # Mkdir/opt/u01 [root @ localhost ~] # Mkdir/opt/oraInventory [root @ localhost ~] # Useradd-goinstall-G dba-d/opt/u01/oracle [root @ localhost ~] # Passwdoracle [root @ localhost ~] # Chmod-R 775/opt/u01/oracle configure Linux kernel parameters to get the maximum value from/proc/sys/fs/file-max: 113825 then fs. file-max = 512 * processes to get fs. file-max = 512*113825 = 58278400fs. file-max = 58278400 linux server 5: [root @ localhost ~] # Cat>/etc/sysctl. conf <EOFfs. file-max = 58278400kernel. shmmni = 4096kernel. sem = 250 32000 100. net. ipv4.ip _ local_port_range = 900065500net. core. rmem_default = 4192134net. core. rmem_max = 4192134net. core. wmem_default = 262144net. core. wmem_max = 262144EOF [root @ localhost ~] # Sysctl-p
To improve the performance of running software on linux, you must set the following shell limits for oracle users. Add the following row to the file/etc/security/limits. conf [root @ localhost ~] # Cat>/etc/security/limits. conf <EOForacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536EOF configure logon is loading limit document [root @ localhost ~] # Cat>/etc/pam. d/login <EOFsession required/lib/security/pam_limits.sosession required pam_limits.soEOF
According to the oracle user's default shell, change the default shellstart-up file as follows: if it is Bourne, Bash, or Kornshell, modify the environment variable/etc/profile file as follows: [root @ localhost ~] # Vi/etc/profileif [$ USER = "oracle"]; thenif [$ SHELL = "/bin/ksh"]; thenulimit-p 16384 ulimit-n 65536 elseulimit-u 16384-n 65536 fifioracle user environment variables
Log On As an oracle user and log on to. bash_profile or. profile (bash or ksh) to add downstream, # vi. bash_profileORACLE_BASE =/opt/u01ORACLE_HOME = $ ORACLE_BASE/oracleORACLE_SID = dbsvrPATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOMEORACLE_SID PATH

# LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib # export LC_CTYPE = en_US.UTF-8 # export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Run $ source. bash_profile to make the environment variable take effect.

Part 1: Installing Oracle
Start the General Oracle Installation program. Copy to/opt/database [root @ localhost data] chown-Roracle: oinstall database [root @ localhost opt] chown-Roracle: oinstall u01 [root @ localhost opt] chown-Roracle: the oinstall oraInventory must be installed on the GUI as an oracle user. If the startup level is 3, the resolution of the $ startx startup graphic interface must be 1024*768 or above $ cd database $. /runInstaller
Welcome to cancel the update selection (if the next flash occurs, adjust the resolution to 1024*768 or above)
Specify the List Directory and certificate. If you have been following the steps in this Guide, use the default value. Otherwise, edit the path of the List Directory to point to the correct directory. The operating system group name should be oinstall. If this is the first time Oracle is installed on this machine, you will receive a pop-up window prompting you to run the orainstRoot. sh script as a root user. Log on as a root user, change to the directory specified in the window, execute the script, and continue to specify the file location. If you have been following the steps in this Guide, use the default value. Otherwise, make sure that the source path and target path are correct before proceeding. Select the installation type to accept the default Enterprise Edition. Inspection of prerequisites related to a specific product if you have been following the steps in this Guide, all inspections should pass smoothly. If one or more checks fail, rectify the problem before continuing. Select the database configuration to accept the default values Create a starter database and General Purpose. Specify database configuration options and enter the global database name of the database. This name should contain ORACLE_SID and server domain name (for example, demo1.orademo.org, where demo1 is ORACLE_SID and orademo.org is a domain name ). When you enter a global database name, the SID box is automatically filled. Accept the default database character set. Select Create database with sampleschemas. Select Use Database Control for DatabaseManagement for the Database management option. Select FileSystem for the database file storage option, and enter the path name (/u02/oradata in this example) to be used for the database file ). Select Do not enable Automatedbackups for the backup and recovery options. Specify the database mode password and select Use the same password for all theaccounts. Select a password and enter it twice for confirmation. The summary displays the summary of installed products. Click Install. The installation of this screen goes through several phases of installing and linking Oracle software. When the installation process ends, a window is displayed, showing the configuration information. Write down the EnterpriseManager URL and click OK to close the window. A "Setup Privileges" window is displayed, prompting you to run the configuration script as the root user. Log on as a root user, switch to the directory indicated in this window, and then execute the root. sh script. This script prompts you to enter the location of the local bin directory. Press Enter to accept the default value. When the script is complete, return to the Setup Privileges window and click OK. (As shown below .) After the installation is complete, write down the URL shown in the summary and click Exit when preparing.
1. Change vi/etc/oratabdbsvr:/opt/u01/oracle: N to dbsvr:/opt/u01/oracle: Y
2. ORA-12514: TNS: The listener currently cannot identify the service issue requested in the connection descriptor resolved vi $ ORACLE_HOME/network/admin/listener. oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME =/opt/u01/oracle) (PROGRAM = extproc) (SID_DESC = (GLOBAL_DBNAME = dbsvr) (ORACLE_HOME =/opt/u01/oracle) (SID_NAME = dbsvr )))
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.14) (PORT = 1521 ))))

3. when you run $ ORACLE_HOME/bin/dbstart, an error is reported. Failed to auto-start Oracle NetListene using/ade/vikrkuma_new/oracle/bin/tnslsnr. Solution: Modify the dbstart file, find ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracle and change it to: ORACLE_HOME_LISTNER = $ ORACLE_HOMEoracle. the startup script explains the following three groups of numbers in the script: # chkconfig: 2345 8005, "Start mode", "Start sequence", and "close sequence"

#! /Bin/sh # Auther: ose # chkconfig: 345 99 # description: start or stop/u01oracle # oracle_envexport ORACLE_BASE =/optexportORACLE_HOME = $ ORACLE_BASE/oracleexportPATH = $ PATH: $ ORACLE_HOME/binexport ORACLE_SID = dbsvrexport ORACLE_TERM = vt100exportNLS_LANG = AMERICAN_AMERICA.ZHS16GBKoracle_user = oracle
# Procstart () {echo-n "starting oracle" su-"$ oracle_user" <EOOlsnrctl startsqlplus/nolog <EOSconnect/as container start dbconsoleisqlplusctl startEOO} stop () {echo-n "stoping oracle:" su-"$ oracle_user" <EOOsqlplus/nolog <EOSconnect/as container stopemctl stop dbconsoleisqlplusctl stopEOO} case "$1" instart) starttouch/var/lock/subsys/dbora; stop) stoprm-f/var/lock/subsys/dbora; status) status oracle; restart) stopsleep 3 start ;; *) echo "$0 {start | stop | status | restart}"; esac
Save the preceding file as dbora and copy it to/etc/rc. d/init. d. cp dbora/etc/rc. d/init. dchmod 755/etc/rc. d/init. d/db1_hkconfig -- add db1_hkconfig -- list | grep dboradbora 0: Disable 1: Disable 2: Enable 3: Enable 4: Enable 5: Enable 6: Disable
Part V introduction and supplement of some services

Main service start Modes

A: $ ORACLE_HOME/bin/dbstart | dbshut
B: $ ORACLE_HOME/bin/lsnrctl start | stop listener start | close.
C: $ ORACLE_HOME/bin/emctl start | stop dbconsole access http: // yourIP: 1158/em
D: $ ORACLE_HOME/bin/isqlplusctl start | stop access http: // yourIP: 5560/isqlplus
Connect/as sysdba; -- change HTTP/WEBDAV port from 8080 to 8081SQL> calldbms_xdb.cfg_update (updateXML (dbms_xdb.cfg_get (), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text ()', 8081)/-- change the FTP port from 2100 to 2111SQL> calldbms_xdb.cfg_update (updateXML (dbms_xdb.cfg_get (), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text ()', 2111)/SQL> commit; SQL> execdbms_xdb.pai_refresh;