以root身份登录到系统,新增组和用户:
#groupadd oinstall
#groupadd dba
#useradd -g oinstall -G dba oracle
#passwd oracle
创建安装目录
#mkdir -p /opt/oracle
#chown -R oracle:oinstall /opt/oracle
#chmod -R 775 /opt/oracle
以oracle身份登录到系统
并修改.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/db_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export ORACLE_SID=DEV
export PATH=$PATH:$ORACLE_HOME/bin
配置oracle侦听器
参考文件如下:
# listener.ora Network Configuration File: /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.60)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /opt/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC = (SID_NAME=DEV))
)
启动oracle服务,并测试
$ dbstart $ORACLE_HOME
$ sqlplus / as sysdba
SQL> select sysdate from dual;