REDHAT5 Install oracle10g start test

Installation environment: redhat5.5 VirtualBox4.3.12 oracle10g

In the virtual machine environment, the direct installation is with the graphical interface Redhat5.5-server, which facilitates later installation of Oracle

One installation section

1. Pre-installation package check

Install as a yum source with ISO CD mount

[Rhel-server]name=local serverbaseurl=file:///mnt/cdrom/server//Mount disc file for yum source enabled=1gpgcheck=0gpgkey=file:/// Etc/pki/rpm-gpg/rpm-gpg-key-redhat-release

Install the following package, note the version number and package dependencies

binutils-2*   elfutils-libelf-0*  elfutils-libelf-devel-0*   elfutils-libelf-devel-static-0*  setarch-2* make-3*  glibc-2*   glibc-devel-2*  glibc-common-2*  glibc-header-* libaio-0* libaio-devel-0*   compat-libstdc++-33-3*   kernel-headers-*  ksh-*  compat-gcc-34-3*  compat-gcc-34-c++-3*  libgcc-4*  libstdc++-4*   libstdc++-devel-4*    libgomp-4* gcc-4*  gcc-c++-4*   libxp-1*  libxt   openmotif22-*  compat-db-4*   sysstat-7*  unixODBC-2*   unixODBC-devel-2*rpm -q binutils elfutils-libelf elfutils-libelf-devel  elfutils-libelf-devel-static setarch make glibc glibc-devel glibc-common  Glibc-headers libaio libaio-devel compat-libstdc++-33 kernel-headers ksh compat-gcc-34 compat-gcc-34-c++ libgcc libstdc++  libstdc++-devel libgomp gcc gcc-c++ libxp libxt openmotif compat-db  Sysstat unixodbc unixodbc-devel

2. Modifying system parameters

Kernel parameter/etc/sysctl.conf

Kernel.shmall = 2097152 Kernel.shmmax = 2147483648 Kernel.shmmni = 4096 Kernel.sem = all 32000 Fs.file-max = 65536 Net.ipv4.ip_local_port_range = 1024x768 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_ default=262144 net.core.wmem_max=262144

Sysctl-p Making parameters Effective

Close Selinux/etc/selinux/config

Selinux=disabled

Set the Oracle user's shell LImit /etc/security/limits.conf

Oracle Soft Nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 65536

oracle10g only support to redhat-4, modify/etc/redhat-release

Redhat-4

3. Create an Oracle user group and directory

GROUPADD-G DBA groupadd-g 501 oinstall useradd-g oinstall-g dba-s/bin/bash-u 501 Oracle passwd Oracle MKDIR-P /oracle/app/oracle/product/10.2/db_1 chown-r oracle:oinstall/oracle chmod-r 775/oracle

4. Modify the Oracle user. Bash_profile

Export Oracle_base=/oracle/app/oracleexport oracle_home= $ORACLE _base/product/10.2/db_1export ORACLE_SID= Bi4dbexport path= $PATH: $ORACLE _home/binexport ld_library_path= $LD _library_path: $ORACLE _home/libclasspath= $ORACLE _HOME/JRE: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlibexport CLASSPATH

5. Unzip the installation

Unzip 10201_database_linux64.zip./runinstaller//encountered no Execute permission file chmod +x xxx

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/36/F0/wKioL1OrvZizbGewAAPp9zRiiGM358.jpg "style=" float: none; "title=" 1.jpg "alt=" Wkiol1orvzizbgewaapp9zriigm358.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/36/F1/wKiom1OrvceTOiL-AAIW7vrxLbM499.jpg "style=" float: none; "title=" 2.jpg "alt=" Wkiom1orvcetoil-aaiw7vrxlbm499.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/36/F0/wKioL1OrvZnxOMW5AAIGk_QiLc8768.jpg "style=" float: none; "title=" 3.jpg "alt=" Wkiol1orvznxomw5aaigk_qilc8768.jpg "/>

Second, the process started

1.oracle Listener Listener

Lsnrctl Startlsnrctl Stop/oracle/app/oracle/product/10.2/db_1/bin/tnslsnr Listener-inherit

2.oracle OEM Boot

Emctl start dbconsoleemctl stop dbconsolehttp://192.168.30.6:1158/em sys/pwd sysdba Login

3.isql*plus Start-up

Isqlplusctl Startisqlplusctl Stop

4. Database Start stop

[[email protected] 10201_database_linux64]$ sqlplussql*plus: release 10.2.0.1.0  - production on thu jun 26 14:54:36 2014copyright  (c)  1982,  2005, oracle.  all rights reserved. enter user-name: / as sysdbaconnected to:oracle database 10g  enterprise edition release 10.2.0.1.0 - 64bit productionwith the  partitioning, olap and data mining optionssql> shutdown immediate;       database closed. Database dismounted. Oracle instance shut down. Sql> startuporacle instance started. total system global area  444596224 bytesfixed size                   2021408 bytesvariable  size             138414048 bytesdatabase  buffers          297795584 bytesredo buffers                 6365184  Bytesdatabase mounted. database opened. Sql>

Third, Test Scott/tiger

Unlock Scott users, log in to test

Sql> Conn Scott; Enter password:error:ora-28000:the account is lockedsql> conn system; Enter password:connected.sql> sql> alter user Scott account unlock; User altered. Sql> Show user; USER is "SCOTT"

This article is from the "method is more than a problem" blog, please be sure to keep this source http://xubcing.blog.51cto.com/3502962/1431168