Shulou(Shulou.com)06/01 Report--

Installation environment: redhat5.5 VirtualBox4.3.12 oracle10g

In the virtual machine environment, redhat5.5-server with graphical interface is installed directly, so it is convenient to install oracle later.

First installation part

1. Package check before installation

Using iso CD mount as yum source to install

[rhel-server] name=local serverbaseurl= file:///mnt/cdrom/Server / / Mount CD file is yum source enabled=1gpgcheck=0gpgkey= file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

Install the following packages, 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

two。 Modify system parameters

Kernel parameter / etc/sysctl.conf

Kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144

Sysctl-p makes the parameter effective

Close seLinux / etc/selinux/config

SELINUX=disabled sets shell limit / etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536 for oracle users

Oracle10g only supports redhat-4, modify / etc/redhat-release

Redhat-4

3. Create Oracle user groups and directories

Groupadd-g 500 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 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. Decompression and installation

Unzip 10201_database_linux64.zip./runInstaller / / encountered no execution permission file chmod + x xxx

II. Start the process

1.oracle listener listener

Lsnrctl startlsnrctl stop/oracle/app/oracle/product/10.2/db_1/bin/tnslsnr LISTENER-inherit

2.oracle OEM start

Emctl start dbconsoleemctl stop dbconsole http://192.168.30.6:1158/em sys/pwd sysdba login

Startup of 3.isql*plus

Isqlplusctl startisqlplusctl stop

4. Database start and stop

[oracle@dbtest 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 >

3. Test scott/tiger

Unlock scott users and 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"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.