1、连接上相应的linux主机,进入到等待输入shell指令的linux命令行状态下。
2、在命令行下输入shell指令:whereis oracle。
3、最后,按下回车键执行shell指令,此时会看到数据库oracle的具体位置被打印了出来。
再装一个 是再装一个实例吗?如果需要在同一个软件下再安装一个实例,需要有SID、四个dump目录、spfile/pfile、控制文件 这样一个新的空实例就可以创建了
其实linux可以直接克隆过去,但是需要改些配置文件、、
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
你要查看的是具体的哪些配置?