Redhat5 安装oracle10g 启动测试
安装环境： redhat5.5 VirtualBox4.3.12oracle10g在虚拟机环境下，直接安装的是带图形界面redhat5.5-server，便于后来方面安装oracle
一 安装部分
1. 安装前的包检查
采用iso光盘挂载作为 yum源安装
name=local server
baseurl=file:///mnt/cdrom/Server //挂载光盘文件为yum源
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release 安装如下的包，注意版本号和包依赖
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*libXtopenmotif22-*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.修改系统参数
内核参数/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 使参数生效
关闭seLinux /etc/selinux/config
SELINUX=disabled设置oracle用户的shell limit /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536 oracle10g 只支持到了redhat-4， 修改/etc/redhat-release
redhat-4 3. 创建Oracle用户组 及目录
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. 修改oracle用户 .bash_profile
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1
export ORACLE_SID=bi4db
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export CLASSPATH 5.解压安装
unzip 10201_database_linux64.zip
./runInstaller// 遇到没有执行权限文件 chmod +x xxx
二、进程启动
1.oracle监听器listener
lsnrctl start
lsnrctl stop
/oracle/app/oracle/product/10.2/db_1/bin/tnslsnr LISTENER -inherit 2.oracle OEM启动
emctl start dbconsole
emctl stop dbconsole
http://192.168.30.6:1158/emsys/pwd sysdba登陆 3.isql*plus的启动
isqlplusctl start
isqlplusctl stop 4. 数据库启动停止
$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 26 14:54:36 2014
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area444596224 bytes
Fixed Size 2021408 bytes
Variable Size 138414048 bytes
Database Buffers 297795584 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
SQL> 三、测试scott/tiger
解锁scott用户，登陆测试
SQL> conn scott;
Enter password:
ERROR:
ORA-28000: the account is locked
SQL> conn system;
Enter password:
Connected.
SQL>
SQL> alter user scott account unlock;
User altered.
SQL> show user;
USER is "SCOTT"
页:
[1]