linux切换root用户
安装oracle需要的linux系统安装包
Is already installed 已经安装过了
添加组合用户
groupadd dba
groupadd oinstall
useradd oracle -d /home/oracle -g oinstall -G dba -m
passwd oracle
创建安装目录
mkdir -p /opt/oracle/product
mkdir -p /opt/oracle/product/11.2.0
mkdir -p /opt/oraInventorv
mkdir -p /opt/oracle/oradata
授予权限
chown -R oracle.oinstall /opt/oracle
chown -R oracle.oinstall /opt/oracle/oradata
chown -R oracle.oinstall /opt/oracle/product/11.2.0
chown -R oracle.dba /opt/oraInventory
chown oracle.dba /opt/oracle
配置.bash_profile文件
并使其生效
/
.bash_profile默认配置
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
替换成
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export ORACLE_OWNER=oracle
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:.:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
//
上传oracle安装包
unzip解压chmod +x install/.oui
chmod +x install/unzip
chmod +x runInstaller
安装oracle./runInstaller
配置监听
Netca
sqlplus /nolog
conn /as sysdba
创建用户名
create user dbuser1 identified by dbuser1;
赋予权限
grant connect,resource to dbuser1;
quit;
用创建的用户名登录
sqlplus dbuser1/dbuser1