NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH NLS_LANG
-----------------------------------------------------------------------
9、复制安装包到一个目录,解压
/home/oracle/tools
chown -R oracle:oinstall /home/oracle/tools
-----------------------------------------------------------------------
10、检测需要的相关包
rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel
rpm -q glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make numactl-devel sysstat
(1)、用安装盘里面的软件包安装
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
rpm -ivh compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm
rpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpm
rpm -ivh ksh-20100621-16.el6.x86_64.rpm
rpm -ivh numactl-devel-2.0.7-3.el6.x86_64.rpm
(2)、yum在线安装
yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel
(如果安装了一个高版本的软件包，在检测的时候还是会提示缺少软件包，这里只要安装了，版本高一点无所谓，忽略吧)
-----------------------------------------------------------------------
11、开始安装
(可能会用到如下命令)
#xhost +
#export DISPLAY=:1.0 (export DISPLAY=:0.0)
#xdpyinfo
如果出现安装界面中文乱码
LANG=en_US.UTF-8
执行目录中的runInstall.sh
剩下的根据提示来(就不用截图了)
-----------------------------------------------------------------------
12、网络配置的用netmgr创建数据库服务 静态注册
(1)sqlnet.ora(开始的时候可能没有这个文件,只要能连上就行了)
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME, NIS)
ADR_BASE = /u01/oracle
(2)listener.ora(静态注册一般需要,netmgr)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /u01/oracle/product/11.2.0/db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.197)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/oracle
(3)tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.197)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
-----------------------------------------------------------------------
13、启动oracle
lsnrctl start
sqlplus / as sysdba (sqlplus sys/dreamsoft as sysdba)
startup mount
aletr database open
-----------------------------------------------------------------------
14、客户端连接oracle的时候可能会受到防火墙的影响(root用户下面)
关闭防火墙：
/etc/init.d/iptables stop
启动防火墙：
/etc/init.d/iptables start
永久关闭防火墙：
chkconfig --level 35 iptables off
service iptables stop
(这个问题很常见,tnsping 超时,ping没有问题,估计就是防火墙原因了)