如何查看dm数据库环境变量配置是否成功

1.检查系统包安装情况

rpm -qa|grep binutils

rpm -ivh sysstat-7.0.2.rpm

rpm -ivh binutils-2.17.50.0.6-14.el5.*.rpm

rpm -ivh compat-libstdc++-33-3.2.3-61.*.rpm

rpm -ivh elfutils-libelf-0.137-3.el5.*.rpm

rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm

rpm -ivh elfutils-libelf-devel-0.137-3.el5.x86_64.rpm elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm

rpm -ivh gcc-4.1.2-48.el5.*.rpm

rpm -ivh gcc-c++-4.1.2-48.el5.*.rpm

rpm -ivh glibc-2.5-49.*.rpm

rpm -ivh glibc-common-2.5-49.*.rpm

rpm -ivh glibc-devel-2.5-49.*.rpm

rpm -ivh libaio-0.3.106-5.*.rpm

rpm -ivh libaio-devel-0.3.106-5.*.rpm

rpm -ivh libgcc-4.1.2-48.el5.*.rpm

rpm -ivh libstdc++-4.1.2-48.el5.*.rpm

rpm -ivh libstdc++-devel-4.1.2-48.el5.*.rpm

rpm -ivh make-3.81-3.el5.*.rpm

rpm -ivh sysstat-7.0.2-3.el5.*.rpm

rpm -ivh unixODBC-2.2.11-7.1.*.rpm

rpm -ivh unixODBC-devel-2.2.11-7.1.*.rpm

rpm -ivh libXp-1.0.0-8.1.el5.*.rpm

rpm -ivh libXau-devel-1.0.1-3.1.*.rpm

rpm -ivh libXp-devel-1.0.0-8.1.el5.*.rpm

2.修改网络配置

vi /etc/sysconfig/network-scripts/ifcfg-eth0

----------------------------

DEVICE=eth0

BOOTPROTO=none

HWADDR=00:0c:29:d4:f5:b4

ONBOOT=yes

TYPE=Ethernet

USERCTL=yes

IPV6INIT=no

PEERDNS=yes

NETMASK=255.255.255.0

IPADDR=192.168.91.100

GATEWAY=192.168.91.1

----------------------------

vi /etc/hosts

-----------------------------

127.0.0.1 localhost.localdomain localhost

192.168.91.100 RHL5

-----------------------------

3.添加oracle用户

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

passwd oracle

4.添加初始化参数

vi /etc/sysctl.conf

sysctl -p

-----------------------------

fs.aio-max-nr = 1048576

fs.file-max = 6815744

#kernel.shmall = 2097152

#kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

-----------------------------

5.关闭强制访问控制，避免路由访问失败

vi /etc/selinux/config

-----------------------

SELINUX=disabled

-----------------------

6.设置oracle软硬件进程数

vi /etc/security/limits.conf

-----------------------

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

-----------------------

7.全局进程，线程配置

vi /etc/profile

----------------------

if [$USER = 'oracle']then

ulimit -u 16384

ulimit -n 65536

fi

----------------------

8.创建oracle根目录，并设置目录权限

mkdir /u01/app/oracle -p

chown -R oracle:oinstall /u01

chmod -R 755 /u01

9.设置oracle用户环境变量

su - oracle

vi .bash_profile

----------------------

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2/db_1

export ORACLE_SID=oracle11g

export NLS_LANG=american_america.zhs16gbk

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin

umask 022

----------------------

让其生效

. ./.bash_profile

检验是否设置成功

echo $ORACLE_HOME

1、连接上相应的linux主机，进入到等待输入shell指令的linux命令行状态下。

2、在命令行下输入shell指令：whereis oracle。

3、最后，按下回车键执行shell指令，此时会看到数据库oracle的具体位置被打印了出来。

设置环境变量(修改PATH和TNS_ADMIN环境变量):

对于NLS_LANG环境变量, 最好设置成和数据库端一致, 首先从数据库端查询字符集信息:

如图，以system普通用户登陆就好，进去后新建一个SQL WINDOW，输入

SQL>select userenv('language') nls_lang from dual

我的电脑结果为

NLS_LANG

----------------------------------------------------

AMERICAN_AMERICA.ZHS16GBK

右击"我的电脑" - "属性" - "高级" - "环境变量" - "系统环境变量":(win8.1系统，自己上网查怎么找出高级中的系统变量)

1>.选择"Path" - 点击"编辑", 把 "D:\app\orcl\product\instantclient_12_1" 加入

2>.点击"新建", 变量名设置为"TNS_ADMIN", 变量值设置为"D:\app\orcl\product\instantclient_12_1", 点击"确定"

3>.点击"新建", 变量名设置为"NLS_LANG", 变量值设置为"AMERICAN_AMERICA.ZHS16GBK", 点击"确定"

最后点击"确定"退出.

这样就全部结束了。

---