如何安装oracle10g1g

您所在的位置: &
如何在Ubuntu10.04下安装Oracle 11g?
如何在Ubuntu10.04下安装Oracle 11g?
Ubuntu是一个由全球化的专业开发团队建造的操作系统。它包含了所有您需要的应用程序:浏览器、Office套件、多媒体程序、即时消息等。Ubuntu是一个Windows和Office的开源替代品。下面教大家在Ubuntu 10.04 下安装Oracle 11g的方法。
Ubuntu是一个由全球化的专业开发团队建造的操作系统。它包含了所有您需要的应用程序:浏览器、Office套件、多媒体程序、即时消息等。Ubuntu是一个Windows和Office的开源替代品。下面教大家在Ubuntu 10.04 下安装Oracle 11g的方法。
Ubuntu10.04下安装Oracle11g步骤:
安装方法见
解决中文乱码问题,在jre目录下字体目录中建立&fallback&目录,然后copy或者link你喜欢的字体至目录下.
2.安装必要的软件包
11g所需要的软件包并不多,只要安装build-essential,rpm,libaio,ksh,libtool,libstdc++5
sudoapt-getinstallrpmlibaio1kshlibtoollibstdc++5build-essential&
3.设置目录结构和符号链接
sudoln-s/usr/bin/awk/bin/awk &&sudoln-s/usr/bin/rpm/bin/rpm &&sudoln-s/usr/bin/basename/bin/basename &&sudomkdir/etc/rc.d &&foriin0123456;doln-s/etc/rc$i.d/etc/rc.d/rc$i.d;done&
在&/opt&目录下建立两个目录&/opt/oracle11g/server&,&/opt/oracle11g/oradata&,&server&用于存放11g的程序文件,&oradata&用于存放数据库文件。其中luyaowei是你系统登录的用户名
sudomkdir/opt/oracle11g &&sudomkdir/opt/oracle11g/server &&sudomkdir/opt/oracle11g/oradata &&sudochownluyaowei/opt &&sudochownluyaowei/opt/oracle11g &&sudochownluyaowei/opt/oracle11g/server &&sudochownluyaowei/opt/oracle11g/oradata&
4.设置系统参数
修改/etc/sysctl.conf文件,在末尾添加下面内容
sudogedit/etc/sysctl.conf&
添加的内容
fs.aio-max-nr=1048576&&fs.file-max=6815744&&kernel.shmall=2097152&&kernel.shmmax=&&kernel.shmmni=4096&&kernel.sem=28&&net.ipv4.ip_local_port_range=&&net.core.rmem_default=262144&&net.core.rmem_max=4194304&&net.core.wmem_default=262144&&net.core.wmem_max=1048586&
修改/etc/security/limits.conf
sudogedit/etc/security/limits.conf&
添加内容如下
luyaoweisoftnproc2047 &&luyaoweihardnproc16384 &&luyaoweisoftnofile1024 &&luyaoweihardnofile65536 &&修改/etc/pam.d/login,加入如下内容: &&sudogedit/etc/pam.d/login&
添加内容如下
sessionrequired/lib/security/pam_limits.so &&sessionrequiredpam_limits.so&
sudosysctl-p&
修改profile文件
cdhttp://blog.csdn.net/luyaowei/archive//5608974.aspx &&sudogedit.profile&
添加下面代码,其中luyaowei为你的用户名,orcl是你的数据库
exportORACLE_BASE=&/opt/oracle11g&&&exportORACLE_HOME=&/opt/oracle11g/server&&&exportORACLE_SID=&orcl&&&exportORACLE_OWNER=&luyaowei&&&exportORACLE_UNQNAME=orcl&&exportNLS_LANG=&Simplifiedchinese_china.al32utf8&&
可以按照默认方式安装下去,安装完成后要以root身份运行/opt/oraInventory/orainstRoot.sh和/opt/oracle11g/server/root.sh两个代码,至此基本安装成功。
希望本文介绍的在Ubuntu10.04下安装Oracle 11g的方法能够对读者有所帮助,更多还有待于读者去探索和学习。
【编辑推荐】
【责任编辑: TEL:(010)】
关于&&的更多文章
日前,由51CTO传媒举办的2013年云计算架构师峰会圆满落幕,小编
日前,由51CTO传媒举办的2013年云计算架构师峰会圆满
北京时间10月18日,Ubuntu 13.10(代号为Saucy Salama
回顾PC漫长的发展史,如果让你想一个关键词,我相信很
《网管员必读―服务器与数据存储》全面、系统地介绍了在中、高级网络管理和网络工程实施中两个重要方面的主流技术和应用:硬件服
51CTO旗下网站Linunx下安装Oracle11gR2 - 推酷
Linunx下安装Oracle11gR2
本文档参考Oracle官方文档以及老相Oracle视频。
建议Oracle安装过程在Xmanager的图形界面以及终端下完成,因为后期oracle安装过程中的弹出框会使用到图形界面。
一、安装Xmanager
参考文档:
1.安装gdm包
[root@wing ~]# yum install -y gdm
2.打开/etc/inittab ,到最后一行,查看是否为 id:5:initdefault
[root@wing ~]# vi /etc/inittab
3.编辑/etc/gdm/customer.conf文件
vi /etc/gdm/customer.conf
我的/etc/gdm/customer.conf文件内容如下
# GDM configuration storage
[security]
AllowRemoteRoot=true
4.在防火墙中开启177端口
编辑/etc/sysconfig/iptables文件:
vi /etc/sysconfig/iptables
在-A INPUT -m state –state NEW -m tcp -p tcp –dport 22 -j ACCEPT后面添加两行如下内容:
-A INPUT -m state --state NEW -m tcp -p tcp --dport
-A INPUT -m state --state NEW -m udp -p udp --dport 177 -j ACCEPT
5.重新启动linux
linux重启后,进入Xmanager里面的Xbrowser里面,即可看到你希望看到的那台linux。
二、安装Oracle之前的准备
1.以root用户登录进入Linux中
2.检查硬件要求
最小内存1G
推荐内存2G
grep MemTotal /proc/meminfo
是物理内存的2倍
grep SwapTotal /proc/meminfo
生产环境中需要至少10G
df -k /tmp/
操作系统位数
操作系统空间
软件至少需要4.7G
数据文件磁盘至少需要1.7G
df -h disk_name
3.检查软件要求
操作系统内核
# On Oracle Linux 4 and Red Hat Enterprise Linux 42.6.9 or later# On Oracle Linux 5 Update 2 with Red Hat Compatible Kernel2.6.18 or later# On Oracle Linux 5 Update 5 with Red Hat Compatible Kernel2.6.18 or later# On Oracle Linux 5 Update 5 with Unbreakable Enterprise Kernel2.6.32-100.0.19 or later# On Oracle Linux 62.6.32-100.28.5.el6.x86_64 or later# On Oracle Linux 6 with Red Hat Compatible Kernel# Note: Only the distributions and versions listed in the earlier list are# supported. Do not install the software on other versions of Linux.# 82.6.32-71.el6.x86_64 or later# On Oracle Linux 73.8.13-33.el7uek.x86_64 or later# On Oracle Linux 7 with Red Hat Compatible Kernel3.10.0-54.0.1.el7.x86_64 or later# On Red Hat Enterprise Linux 5 Update 22.6.18 or later# On Red Hat Enterprise Linux 5 Update 52.6.18 or later# On Red Hat Enterprise Linux 62.6.32-71.el6.x86_64 or later# On Red Hat Enterprise Linux 73.10.0-54.0.1.el7.x86_64 or later# On Asianux Server 32.6.18 or later# On Asianux Server 42.6.32-71.el6.x86_64 or later# On SUSE Linux Enterprise Server 102.6.16.21 or later# On SUSE Linux Enterprise Server 112.6.27.19 or later
安装包需求
# The following or later version of packages for Oracle Linux 4 and Red Hat# Enterprise Linux 4 must be installed:binutils-2.15.92.0.2compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.97elfutils-libelf-devel-0.97expat-1.95.7gcc-3.4.6gcc-c++-3.4.6glibc-2.3.4-2.41glibc-2.3.4-2.41 (32 bit)glibc-common-2.3.4glibc-devel-2.3.4glibc-headers-2.3.4libaio-0.3.105libaio-0.3.105 (32 bit)libaio-devel-0.3.105libaio-devel-0.3.105 (32 bit)libgcc-3.4.6libgcc-3.4.6 (32-bit)libstdc++-3.4.6libstdc++-3.4.6 (32 bit)libstdc++-devel 3.4.6make-3.80numactl-0.6.4.x86_64pdksh-5.2.14sysstat-5.0.5# The following or later version of packages for Oracle Linux 5, Red Hat Enterprise# Linux 5, and Asianux Server 3 must be installed:binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24 (32 bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5 (32 bit)glibc-headers-2.5ksh-libaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit)libgcc-4.1.2libgcc-4.1.2 (32 bit)libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2make-3.81sysstat-7.0.2# The following or later version of packages for Oracle Linux 6, Red Hat Enterprise# Linux 6, and Asianux Server 4 must be installed:binutils-2.20.51.0.2-5.11.el6 (x86_64)compat-libcap1-1.10-1 (x86_64)compat-libstdc++-33-3.2.3-69.el6 (x86_64)compat-libstdc++-33-3.2.3-69.el6.i686gcc-4.4.4-13.el6 (x86_64)gcc-c++-4.4.4-13.el6 (x86_64)glibc-2.12-1.7.el6 (i686)glibc-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6.i686kshlibgcc-4.4.4-13.el6 (i686)libgcc-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6.i686libstdc++-devel-4.4.4-13.el6 (x86_64)libstdc++-devel-4.4.4-13.el6.i686libaio-0.3.107-10.el6 (x86_64)libaio-0.3.107-10.el6.i686libaio-devel-0.3.107-10.el6 (x86_64)libaio-devel-0.3.107-10.el6.i686make-3.81-19.el6sysstat-9.0.4-11.el6 (x86_64)# The following or later version of packages for Oracle Linux 7, and Red Hat# Enterprise Linux 7 must be installed:binutils-2.23.52.0.1-12.el7.x86_64compat-libcap1-1.10-3.el7.x86_64gcc-4.8.2-3.el7.x86_64gcc-c++-4.8.2-3.el7.x86_64glibc-2.17-36.el7.i686glibc-2.17-36.el7.x86_64glibc-devel-2.17-36.el7.i686glibc-devel-2.17-36.el7.x86_64kshlibaio-0.3.109-9.el7.i686libaio-0.3.109-9.el7.x86_64libaio-devel-0.3.109-9.el7.i686libaio-devel-0.3.109-9.el7.x86_64libgcc-4.8.2-3.el7.i686libgcc-4.8.2-3.el7.x86_64libstdc++-4.8.2-3.el7.i686libstdc++-4.8.2-3.el7.x86_64libstdc++-devel-4.8.2-3.el7.i686libstdc++-devel-4.8.2-3.el7.x86_64libXi-1.7.2-1.el7.i686libXi-1.7.2-1.el7.x86_64libXtst-1.2.2-1.el7.i686libXtst-1.2.2-1.el7.x86_64make-3.82-19.el7.x86_64sysstat-10.1.5-1.el7.x86_64# The following or later version of packages for SUSE Linux Enterprise Server 10# must be installed:binutils-2.16.91.0.5compat-libstdc++-5.0.7gcc-4.1.0gcc-c++-4.1.2glibc-2.4-31.63glibc-devel-2.4-31.63glibc-devel-32bit-2.4-31.63ksh-93r-12.9libaio-0.3.104libaio-32bit-0.3.104libaio-devel-0.3.104libaio-devel-32bit-0.3.104libelf-0.8.5libgcc-4.1.2libstdc++-4.1.2libstdc++-devel-4.1.2make-3.80numactl-0.9.6.x86_64sysstat-8.0.4# The following or later version of packages for SUSE Linux Enterprise Server 11# must be installed:binutils-2.19gcc-4.3gcc-32bit-4.3gcc-c++-4.3glibc-2.9glibc-32bit-2.9glibc-devel-2.9glibc-devel-32bit-2.9ksh-93tlibaio-0.3.104libaio-32bit-0.3.104libaio-devel-0.3.104libaio-devel-32bit-0.3.104libstdc++33-3.3.3libstdc++33-32bit-3.3.3libstdc++43-4.3.3_libstdc++43-32bit-4.3.3_libstdc++43-devel-4.3.3_libstdc++43-devel-32bit-4.3.3_libgcc43-4.3.3_libstdc++-devel-4.3make-3.81sysstat-8.1.5
rpm -q package_name
安装所有包cmd:
yum install -y binutils compat-libcap1-1.10-1 compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-33-3.2.3-69.el6.i686 gcc gcc-c++ glibc glibc-devel ksh libgcc-4.4.4-13.el6 libgcc libstdc++ libstdc++-devel libaio-0.3.107-10.el6 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 libaio-devel-0.3.107-10.el6.i686 make sysstat elfutils-libelf-devel
4.配置网络
编辑/etc/sysconfig/network-scripts/ifcfg-eth0文件
vi /etc/sysconfig/network-scripts/ifcfg-eth0
# 我的配置文件
DEVICE=eth0
HWADDR=00:0C:29:F9:44:18
TYPE=Ethernet
UUID=e89b278a-d80-b
ONBOOT=yes
BOOTPROTO=static
BROADCAST=192.168.98.255
IPADDR=192.168.98.128
NETMASK=255.255.255.0
NETWORK=192.168.98.0
# 修改完配置后,记得重启网络哦
service network restart
5.配置主机名
一旦Oracle安装之后,主机名不可变动哦。
vi /etc/hosts
# 我的配置文件
localhost localhost.localdomain localhost4 localhost4.localdomain4
localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.98.128 wing
6.创建操作系统的用户和组
1) 确认oinstall用户组是否存在:`more /etc/oraInst.loc`,如果oinstall用户组存在,则存在该文件,如果oinstall用户组不存在,则不存在该文件。
[root@wing ~]# more /etc/oraInst.loc inventory_loc=/u01/app/oraInventoryinst_group=oinstall
2) 确认dba用户组存在:`grep dba /etc/group`
3) 确认oracle用户存在,并且属于正确的用户组:`id oracle`
# 正确输出如下:[root@wing ~]# id oracleuid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
# 添加oinstall用户组
groupadd oinstall
# 添加dba用户组
groupadd dba
# 添加oracle用户,并归属于正确的用户组
useradd -g oinstall -G dba oracle
# 如果oracle用户已存在,修改其用户组
usermod -g oinstall -G dba oracle
# 为oracle用户加密
passwd oracle
7.调整Linux参数
调整系统参数
查看参数值cmd:
sysctl -a | grep 参数名称
建议参数调整cmd:
vi /etc/sysctl.conf
# 添加如下参数fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576# 使参数生效sysctl -p
调整limits参数
vi /etc/security/limits.conf
# 添加如下参数
调整login参数
vi /etc/pam.d/login
# 添加如下参数
pam_limits.so
调整/etc/profile参数
vi /etc/profile
# 添加如下参数
if [ $USER = &oracle& ]; then
if [ $SHELL = &/bin/ksh& ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536
8.为Oracle软件建立目录
此处假设Oracle软件目录为 /u01/app/oracle
# 建立目录
mkdir -p /u01/app/oracle
# 修改目录用户和组
chown -R oracle:oinstall /u01/app/
# 修改目录权限
chmod -R 755 /u01/app/
9.配置Oracle用户环境变量
# 切换至oracle用户下
su - oracle
# 编辑环境变量文件
vi .bash_profile
# 添加如下环境变量
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=wingorcl
export NLS_LANG=american_america.AL32UTF8
export PATH=$PATH:$ORACLE_HOME/bin:.
# 此刻需要重新切换至oracle用户才能生效
10.解压oracle11gR2软件至相应目录中
unzip linux.x64_11gR2_database_1of2.zip -d /oraapp/
unzip linux.x64_11gR2_database_2of2.zip -d /oraapp/
目录下,可以看到database目录,即为我们所需要的Oracle11gR2安装文件
11.安装前需要在界面操作的terminal中做如下操作
[root@wing database]# w 11:32:46 up
load average: 0.05, 0.11, 0.06USER
PCPU WHATroot
3.38s /usr/bin/Xorg :0 -nr -verbose -audit 4 -auth /var/run/gdm/auth-for-gdm-tBSNYD/database -nolisten tcp vt1root
192.168.98.1
0.01s w[root@wing database]# su - oracle[oracle@wing database]# export DISPLAY=192.168.98.1:0.0# 执行xhost +,显示如下命令即可[oracle@wing ~]# xhost +access control disabled, clients can connect from any host
三、安装Oracle
1.执行Oracle安装脚本
[root@wing database]# su - oracle
[oracle@wing ~]$ cd /oraapp/database/
# 使用oracle用户执行安装脚本
[oracle@wing database]$ ./runInstaller
2.使用Xmanager连接主机接收图形界面(图片省略)
3.按照图形界面提示执,最后需要以root用户手动执行两个脚本
sh /u01/app/oraInventory/orainstRoot.sh
sh /u01/app/oracle/product/11.2.0/db_1/root.sh
四、在Oracle下建库
1.使用netca配置监听
[oracle@wing ~]$ xhost +access control disabled, clients can connect from any host[oracle@wing ~]$ dbca[oracle@wing ~]$ netca# 此处出现图形界面进行配置,配置成功后,输出结果如下Oracle Net Services Configuration:Configuring Listener:WING_LISTENERListener configuration complete.Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start WING_LISTENER
Listener Control complete.
Listener started successfully.Oracle Net Services configuration successful. The exit code is 0
2.使用dbca建立数据库
[root@wing ~]# su - oracle
[oracle@wing ~]$ dbca
# 此时出现图形界面,根据界面提示完成oracle数据库建立
五、Oracle常用软件的启动与关闭
Oracle启动
listener–&Oracle–&EM
##### listener# listener启动[oracle@wing ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-FEB-2016 19:25:02Copyright (c) 1991, 2013, Oracle.
All rights reserved.Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/wing/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521)))Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias
LISTENERVersion
TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date
11-FEB-2016 19:25:03Uptime
0 days 0 hr. 0 min. 20 secTrace Level
offSecurity
ON: Local OS AuthenticationSNMP
OFFListener Parameter File
/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File
/u01/app/oracle/diag/tnslsnr/wing/listener/alert/log.xmlListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521)))The listener supports no servicesThe command completed successfully# listener状态查看[oracle@wing ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-FEB-2016 19:26:44Copyright (c) 1991, 2013, Oracle.
All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias
LISTENERVersion
TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date
11-FEB-2016 19:25:03Uptime
0 days 0 hr. 1 min. 41 secTrace Level
offSecurity
ON: Local OS AuthenticationSNMP
OFFListener Parameter File
/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File
/u01/app/oracle/diag/tnslsnr/wing/listener/alert/log.xmlListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521)))The listener supports no servicesThe command completed successfully# listener端口监听查看[oracle@wing ~]$ netstat -npl | grep 1521(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)tcp
17985/tnslsnr##### Oracle# Oracle启动[oracle@wing ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 11 19:28:21 2016Copyright (c) 1982, 2013, Oracle.
All rights reserved.Connected to an idle instance.SQL& startupORACLE instance started.Total System Global Area
bytesFixed Size
2257312 bytesVariable Size
bytesDatabase Buffers
bytesRedo Buffers
2617344 bytesDatabase mounted.Database opened.# Oracle状态查看[root@wing ~]# ps -ef | grep oracleroot
13275 13254
0 18:46 pts/1
00:00:00 su - oracleoracle
13276 13275
0 18:46 pts/1
00:00:00 -bashoracle
00:00:00 /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr LISTENER -inheritoracle
00:00:00 ora_pmon_wingdboracle
00:00:00 ora_psp0_wingdboracle
00:00:02 ora_vktm_wingdboracle
00:00:00 ora_gen0_wingdboracle
00:00:00 ora_diag_wingdboracle
00:00:00 ora_dbrm_wingdboracle
00:00:00 ora_dia0_wingdboracle
00:00:00 ora_mman_wingdboracle
00:00:00 ora_dbw0_wingdboracle
00:00:00 ora_lgwr_wingdboracle
00:00:00 ora_ckpt_wingdboracle
00:00:00 ora_smon_wingdboracle
00:00:00 ora_reco_wingdboracle
00:00:00 ora_mmon_wingdboracle
00:00:00 ora_mmnl_wingdboracle
00:00:00 ora_d000_wingdboracle
00:00:00 ora_s000_wingdboracle
00:00:00 ora_qmnc_wingdboracle
00:00:00 ora_cjq0_wingdboracle
00:00:00 ora_j000_wingdboracle
00:00:00 ora_j001_wingdboracle
18175 13276
0 19:30 pts/1
00:00:00 sqlplus
as sysdbaoracle
18176 18175
00:00:00 oraclewingdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))oracle
00:00:00 ora_q000_wingdboracle
00:00:00 ora_q001_wingdbroot
18183 13222
0 19:30 pts/0
00:00:00 grep oracle##### EM# EM启动[oracle@wing ~]$ emctl start dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 Copyright (c) 1996, 2013 Oracle Corporation.
All rights reserved.https://wing:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 11g Database Control ........... started. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/wing_wingdb/sysman/log # EM状态[oracle@wing ~]$ emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 Copyright (c) 1996, 2013 Oracle Corporation.
All rights reserved.https://wing:1158/em/console/aboutApplicationOracle Enterprise Manager 11g is running. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/wing_wingdb/sysman/log# EM端口查看[oracle@wing ~]$ netstat -npl | grep 1158(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)tcp
20715/java
Oracle关闭
EM–&listener–&Oracle
##### EM# EM端口监听查看[oracle@wing ~]$ netstat -npl | grep 1158(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)tcp
15338/java# EM关闭操作[oracle@wing ~]$ emctl stop dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 Copyright (c) 1996, 2013 Oracle Corporation.
All rights reserved.https://wing:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 11g Database Control ...
Stopped. # EM状态查看[oracle@wing ~]$ emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 Copyright (c) 1996, 2013 Oracle Corporation.
All rights reserved.https://wing:1158/em/console/aboutApplicationOracle Enterprise Manager 11g is not running.##### listener# listener端口监听查看[oracle@wing ~]$ netstat -npl | grep 1521# listener关闭操作[oracle@wing ~]$ lsnrctl stopLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-FEB-2016 19:13:55Copyright (c) 1991, 2013, Oracle.
All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))The command completed successfully# listener状态查看[oracle@wing ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-FEB-2016 19:14:03Copyright (c) 1991, 2013, Oracle.
All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused##### Oracle# Oracle关闭操作[oracle@wing ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 11 19:14:37 2016Copyright (c) 1982, 2013, Oracle.
All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL& SQL& shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL& # 检查Oracle是否关闭,重新连接,检查是否有数据库连接SQL& exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@wing ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 11 19:16:37 2016Copyright (c) 1982, 2013, Oracle.
All rights reserved.Connected to an idle instance.SQL&
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置: 公开
仅自己可见
正文不准确
标题不准确
排版有问题
主题不准确
没有分页内容
图片无法显示
视频无法显示
与原文不一致}

我要回帖

更多关于 oracle11gr2安装图解 的文章

更多推荐

版权声明:文章内容来源于网络,版权归原作者所有,如有侵权请点击这里与我们联系,我们将及时删除。

点击添加站长微信