今天接到通知,下周去一个新客户那边部署新环境,问题是时间还很紧,让下周一就去,时间紧还不是大问题,问题是产品的中间件Weblogic跟数据库Oracle我都好久没玩了,没得办法,只能提前演练一下了,为了下次找起来更加方便,就把过程整理到本博客上面来,也可以方便其他童鞋的查询吧。
谁要是跟我纠结时间这么紧,哪来的时间写博客的,我跟谁急哦!方便自己,也方便大家嘛!
华丽分割线
一.查看系统配置信息
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<code>[root@web-db ~]</code><code># hostname --fqdn //查看主机名</code>
<code>web-db</code>
<code>[root@web-db ~]</code><code># ifconfig eth0 //查看本机IP地址</code>
<code>eth0 Link encap:Ethernet HWaddr 06:F1:96:00:00:C0</code>
<code> </code><code>inet addr:192.168.153.153 Bcast:192.168.153.255 Mask:255.255.255.0</code>
<code> </code><code>inet6 addr: fe80::4f1:96ff:fe00:c0</code><code>/64</code> <code>Scope:Link</code>
<code> </code><code>UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1</code>
<code> </code><code>RX packets:1706513 errors:0 dropped:0 overruns:0 frame:0</code>
<code> </code><code>TX packets:877952 errors:0 dropped:0 overruns:0 carrier:0</code>
<code> </code><code>collisions:0 txqueuelen:1000</code>
<code> </code><code>RX bytes:2565533900 (2.3 GiB) TX bytes:59768622 (56.9 MiB)</code>
<code>[root@web-db ~]</code><code># cat /etc/hosts</code>
<code>127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4</code>
<code>::1 localhost localhost.localdomain localhost6 localhost6.localdomain6</code>
<code>192.168.153.153 web-db</code>
<code>[root@web-db ~]</code><code># cat /etc/redhat-release //查看RHEL发行版本</code>
<code>Red Hat Enterprise Linux Server release 6.3 (Santiago)</code>
<code>[root@web-db ~]</code><code># uname -m //查看本机CPU架构</code>
<code>x86_64</code>
<code>[root@web-db ~]</code><code># free -m //查看内存跟交换分区信息</code>
<code> </code><code>total used </code><code>free</code> <code>shared buffers cached</code>
<code>Mem: 7870 2876 4993 0 12 2609</code>
<code>-/+ buffers</code><code>/cache</code><code>: 254 7616</code>
<code>Swap: 5760 0 5760</code>
<code>[root@web-db ~]</code><code># df -H //查看分区挂载信息</code>
<code>Filesystem Size Used Avail Use% Mounted on</code>
<code>/dev/mapper/VolGroup-lv_root</code>
<code> </code><code>9.1G 3.6G 5.1G 41% /</code>
<code>tmpfs 4.2G 0 4.2G 0% </code><code>/dev/shm</code>
<code>/dev/vda1</code> <code>508M 33M 449M 7% </code><code>/boot</code>
<code>/dev/vdb5</code>
<code> </code><code>30G 181M 28G 1% </code><code>/u01</code>
当然,有朋友会问:你用的是物理机还是虚拟机?
我这么有钱,想想就知道我用的是什么了,是不是?
<code>[root@web-db ~]</code><code># lscpu</code>
<code>Architecture: x86_64</code>
<code>CPU </code><code>op</code><code>-mode(s): 32-bit, 64-bit</code>
<code>Byte Order: Little Endian</code>
<code>CPU(s): 8</code>
<code>On-line CPU(s) list: 0-7</code>
<code>Thread(s) per core: 1</code>
<code>Core(s) per socket: 1</code>
<code>CPU socket(s): 8</code>
<code>NUMA node(s): 1</code>
<code>Vendor ID: GenuineIntel</code>
<code>CPU family: 6</code>
<code>Model: 13</code>
<code>Stepping: 3</code>
<code>CPU MHz: 2393.998</code>
<code>BogoMIPS: 4787.99</code>
<code>Hypervisor vendor: KVM</code>
<code>Virtualization </code><code>type</code><code>: full</code>
<code>L1d cache: 32K</code>
<code>L1i cache: 32K</code>
<code>L2 cache: 4096K</code>
<code>NUMA node0 CPU(s): 0-7</code>
咦? 怎么不是物理机,我说我什么时候这么有钱的呢?用的还是KVM虚拟机。
呵呵,开个玩笑,我们继续技术交流,禁止鄙视使用虚拟机的屌丝!
二.配置系统YUM源,安装依赖包
<code>[root@web-db ~]</code><code># mount /dev/sr0 /media/</code>
<code>mount</code><code>: block device </code><code>/dev/sr0</code> <code>is write-protected, mounting </code><code>read</code><code>-only</code>
<code>[root@web-db ~]</code><code># cat /etc/yum.repos.d/rhel-source.repo</code>
<code>[rhel6u3-core]</code>
<code>name=rhel6u3-core</code>
<code>baseurl=</code><code>file</code><code>:</code><code>///media</code>
<code>enabled=1</code>
<code>gpgcheck=0</code>
<code>[root@web-db ~]</code><code># yum clean all</code>
<code>Loaded plugins: product-</code><code>id</code><code>, subscription-manager</code>
<code>Updating certificate-based repositories.</code>
<code>Unable to </code><code>read</code> <code>consumer identity</code>
<code>Cleaning repos: rhel6u3-core</code>
<code>Cleaning up Everything</code>
<code>[root@web-db ~]</code><code># cat package.list //需要安装的依赖包信息列表</code>
<code>binutils</code>
<code>compat-libcap1</code>
<code>compat-libstdc++-33</code>
<code>compat-libstdc++-33*.i686</code>
<code>elfutils-libelf-devel</code>
<code>gcc</code>
<code>gcc-c++</code>
<code>glibc*.i686</code>
<code>glibc</code>
<code>glibc-devel</code>
<code>glibc-devel*.i686</code>
<code>ksh</code>
<code>libgcc*.i686</code>
<code>libgcc</code>
<code>libstdc++</code>
<code>libstdc++*.i686</code>
<code>libstdc++-devel</code>
<code>libstdc++-devel*.i686</code>
<code>libaio</code>
<code>libaio*.i686</code>
<code>libaio-devel</code>
<code>libaio-devel*.i686</code>
<code>make</code>
<code>sysstat</code>
<code>unixODBC</code>
<code>unixODBC*.i686</code>
<code>unixODBC-devel</code>
<code>unixODBC-devel*.i686</code>
<code>[root@web-db ~]</code><code># yum install `cat package.list` -y //安装依赖包</code>
三.修改内核参数
<code>[root@web-db ~]</code><code># cp /etc/sysctl.conf \</code>
<code>/etc/sysctl</code><code>.conf_20131016.bak</code><code>//</code><code>备份文件</code>
<code>[root@web-db ~]</code><code># cat /etc/sysctl.conf //在文件爱呢最后添加如下</code>
<code>##==========Setting For Oracle 11G R2============##</code>
<code>kernel.shmmni = 4096</code>
<code>kernel.sem = 250 32000 100 128</code>
<code>fs.</code><code>file</code><code>-max = 6815744</code>
<code>fs.aio-max-nr = 1048576</code>
<code>net.ipv4.ip_local_port_range = 9000 65500</code>
<code>net.core.rmem_default = 4194304</code>
<code>net.core.wmem_default = 262144</code>
<code>net.core.rmem_max = 4194304</code>
<code>net.core.wmem_max = 1048576</code>
<code>[root@web-db ~]</code><code># sysctl -p //让修改立即生效</code>
<code>net.ipv4.ip_forward = 0</code>
<code>net.ipv4.conf.default.rp_filter = 1</code>
<code>net.ipv4.conf.default.accept_source_route = 0</code>
<code>kernel.sysrq = 0</code>
<code>kernel.core_uses_pid = 1</code>
<code>net.ipv4.tcp_syncookies = 1</code>
<code>error: </code><code>"net.bridge.bridge-nf-call-ip6tables"</code> <code>is an unknown key</code>
<code>error: </code><code>"net.bridge.bridge-nf-call-iptables"</code> <code>is an unknown key</code>
<code>error: </code><code>"net.bridge.bridge-nf-call-arptables"</code> <code>is an unknown key</code>
<code>kernel.msgmnb = 65536</code>
<code>kernel.msgmax = 65536</code>
<code>kernel.shmmax = 68719476736</code>
<code>kernel.shmall = 4294967296</code>
四. 创建Oracle用户以及相关权限修改
1. 创建oracle 用户组跟用户
<code>[root@web-db ~]</code><code># groupadd oinstall</code>
<code>[root@web-db ~]</code><code># groupadd dba</code>
<code>[root@web-db ~]</code><code># useradd -g oinstall -G dba -m oracle</code>
<code>[root@web-db ~]</code><code># echo oracle |passwd --stdin oracle //创建密码</code>
<code>Changing password </code><code>for</code> <code>user oracle.</code>
<code>passwd</code><code>: all authentication tokens updated successfully.</code>
2. 修改限制
<code>[root@web-db ~]</code><code># cp /etc/security/limits.conf /etc/security/limits.conf.20131016.bak</code>
<code>##=============Setting For Oracle 11G R2=============##</code>
<code>oracle soft nproc 2047</code>
<code>oracle hard nproc 16384</code>
<code>oracle soft nofile 1024</code>
<code>oracle hard nofile 65536</code>
<code>oracle soft stack 10240</code>
<code>[root@web-db ~]</code><code># cat /etc/pam.d/login</code>
<code>##======Setting For Oracle 11G R2========##</code>
<code>session required pam_limits.so</code>
<code>[root@web-db ~]</code><code># cat /etc/profile</code>
<code>##===Setting For Oracle 11G R2=====##</code>
<code>if</code> <code>[ $USER = </code><code>"oracle"</code> <code>]; </code><code>then</code>
<code> </code><code>if</code> <code>[ $SHELL = </code><code>"/bin/ksh"</code> <code>]; </code><code>then</code>
<code> </code><code>ulimit</code> <code>-p 16384</code>
<code> </code><code>ulimit</code> <code>-n 65536</code>
<code> </code><code>else</code>
<code> </code><code>ulimit</code> <code>-u 16384 -n 65536</code>
<code> </code><code>fi</code>
<code>fi</code>
<code>[root@web-db ~]</code><code># source /etc/profile</code>
3. 创建oracle安装目录以及配置相关变量
<code>创建安装oracle目录</code>
<code>[root@web-db ~]</code><code># mkdir -p /u01/app/oracle</code>
<code>[root@web-db ~]</code><code># chown oracle:oinstall -R /u01/app/</code>
<code>[root@web-db ~]</code><code># chmod -R 755 /u01/app/</code>
<code>[root@web-db ~]</code><code># su - oracle</code>
<code>[oracle@web-db ~]$ </code><code>cp</code> <code>~/.bash_profile ~/.bash_profile.20131016.bak</code>
<code>[oracle@web-db ~]$ </code><code>cat</code> <code>~/.bash_profile</code>
<code>##====Setting For Oracle11g R2=====##</code>
<code>ORACLE_BASE=</code><code>/u01/app/oracle</code>
<code>ORACLE_HOME=$ORACLE_BASE</code><code>/product/11</code><code>.2.0</code><code>/db_1</code>
<code>ORACLE_SID=clouddb</code>
<code>export</code> <code>ORACLE_BASE ORACLE_HOME ORACLE_SID</code>
<code>PATH=$ORACLE_HOME</code><code>/bin</code><code>:$PATH</code>
<code>export</code> <code>PATH</code>
<code>[oracle@web-db ~]$ </code><code>source</code> <code>~/.bash_profile</code>
五.开始安装Oracle软件
<code>[oracle@web-db oracle_install]$ ll</code>
<code>total 2295600</code>
<code>-rwxr--r--. 1 oracle oinstall 1239269270 Oct 16 17:03 linux.x64_11gR2_database_1of2.zip</code>
<code>-rwxr--r--. 1 oracle oinstall 1111416131 Oct 16 17:05 linux.x64_11gR2_database_2of2.zip</code>
<code>[oracle@web-db oracle_install]$ unzip linux.x64_11gR2_database_1of2.zip</code>
<code>[oracle@web-db oracle_install]$ unzip linux.x64_11gR2_database_2of2.zip</code>
<code>[oracle@web-db oracle_install]$ </code><code>cd</code> <code>database/</code>
<code>[oracle@web-db database]$ </code><code>ls</code>
<code>doc </code><code>install</code> <code>response rpm runInstaller sshsetup stage welcome.html</code>
<code>[oracle@web-db database]$ </code><code>exit</code> <code>//</code><code>回到root用户</code>
<code>[root@web-db ~]</code><code># xhost + //如果没有安装图形化,可以[root@web-db ~]# yum groupinstall "Desktop" "X Window System" -y</code>
使用oracle用户开始安装
<code>[oracle@web-db database]$ </code><code>export</code> <code>DISPLAY=192.168.153.153:0.0</code>
<code>[oracle@web-db database]$ .</code><code>/runInstaller</code>
<code>Starting Oracle Universal Installer...</code>
<code>Checking Temp space: must be greater than 120 MB. Actual 1728 MB Passed</code>
<code>Checking swap space: must be greater than 150 MB. Actual 5760 MB Passed</code>
<code>Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed</code>
<code>Preparing to launch Oracle Universal Installer from </code><code>/tmp/OraInstall2013-10-17_11-14-21AM</code><code>. Please wait ...</code>
<a href="http://blog.51cto.com/attachment/201310/133036744.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133038768.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133040255.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133042809.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133045430.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133047929.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133050824.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133052771.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133055973.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133057985.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133100932.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133102279.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/133311105.jpg" target="_blank"></a>
<code>[root@web-db ~]</code><code># id</code>
<code>uid=0(root) gid=0(root) </code><code>groups</code><code>=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023</code>
<code>[root@web-db ~]</code><code># /u01/app/oraInventory/orainstRoot.sh</code>
<code>Changing permissions of </code><code>/u01/app/oraInventory</code><code>.</code>
<code>Adding </code><code>read</code><code>,write permissions </code><code>for</code> <code>group.</code>
<code>Removing </code><code>read</code><code>,write,execute permissions </code><code>for</code> <code>world.</code>
<code>Changing groupname of </code><code>/u01/app/oraInventory</code> <code>to oinstall.</code>
<code>The execution of the script is complete.</code>
<code>[root@web-db ~]</code><code># /u01/app/oracle/product/11.2.0/db_1/root.sh</code>
<code>Running Oracle 11g root.sh script...</code>
<code>The following environment variables are </code><code>set</code> <code>as:</code>
<code> </code><code>ORACLE_OWNER= oracle</code>
<code> </code><code>ORACLE_HOME= </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1</code>
<code>Enter the full pathname of the </code><code>local</code> <code>bin directory: [</code><code>/usr/local/bin</code><code>]:</code>
<code> </code><code>Copying dbhome to </code><code>/usr/local/bin</code> <code>...</code>
<code> </code><code>Copying oraenv to </code><code>/usr/local/bin</code> <code>...</code>
<code> </code><code>Copying coraenv to </code><code>/usr/local/bin</code> <code>...</code>
<code>Creating </code><code>/etc/oratab</code> <code>file</code><code>...</code>
<code>Entries will be added to the </code><code>/etc/oratab</code> <code>file</code> <code>as needed by</code>
<code>Database Configuration Assistant when a database is created</code>
<code>Finished running generic part of root.sh script.</code>
<code>Now product-specific root actions will be performed.</code>
<code>Finished product-specific root actions.</code>
<a href="http://blog.51cto.com/attachment/201310/133313561.jpg" target="_blank"></a>
六. 配置监听器
<code>[oracle@web-db ~]$ netca</code>
<code>Oracle Net Services Configuration:</code>
<code>Configuring Listener:LISTENER</code>
<code>Listener configuration complete.</code>
<code>Oracle Net Listener Startup:</code>
<code> </code><code>Running Listener Control:</code>
<code> </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/bin/lsnrctl</code> <code>start LISTENER</code>
<code> </code><code>Listener Control complete.</code>
<code> </code><code>Listener started successfully.</code>
<code>Oracle Net Services configuration successful. The </code><code>exit</code> <code>code is 0</code>
<a href="http://blog.51cto.com/attachment/201310/134915550.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134917857.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134919341.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134922581.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134924837.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134926729.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134928516.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/134930311.jpg" target="_blank"></a>
<code>[oracle@web-db ~]$ </code><code>cat</code> <code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/network/admin/listener</code><code>.ora </code><code>//</code><code>查看生成的文件</code>
<code># listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora</code>
<code># Generated by Oracle configuration tools.</code>
<code>LISTENER =</code>
<code> </code><code>(DESCRIPTION_LIST =</code>
<code> </code><code>(DESCRIPTION =</code>
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = web-db)(PORT = 1521))</code>
<code> </code><code>)</code>
<code> </code><code>)</code>
<code>ADR_BASE_LISTENER = </code><code>/u01/app/oracle</code>
<code>[oracle@web-db ~]$ lsnrctl status </code><code>//</code><code>查看监听器状态</code>
<code>LSNRCTL </code><code>for</code> <code>Linux: Version 11.2.0.1.0 - Production on 17-OCT-2013 13:54:40</code>
<code>Copyright (c) 1991, 2009, Oracle. All rights reserved.</code>
<code>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=web-db)(PORT=1521)))</code>
<code>STATUS of the LISTENER</code>
<code>------------------------</code>
<code>Alias LISTENER</code>
<code>Version TNSLSNR </code><code>for</code> <code>Linux: Version 11.2.0.1.0 - Production</code>
<code>Start Date 17-OCT-2013 13:48:10</code>
<code>Uptime 0 days 0 hr. 6 min. 31 sec</code>
<code>Trace Level off</code>
<code>Security ON: Local OS Authentication</code>
<code>SNMP OFF</code>
<code>Listener Parameter File </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/network/admin/listener</code><code>.ora</code>
<code>Listener Log File </code><code>/u01/app/oracle/diag/tnslsnr/web-db/listener/alert/log</code><code>.xml</code>
<code>Listening Endpoints Summary...</code>
<code> </code><code>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=web-db)(PORT=1521)))</code>
<code>The listener supports no services</code>
<code>The </code><code>command</code> <code>completed successfully</code>
七. 创建数据库实例clouddb
<code>[oracle@web-db ~]$ dbca</code>
<a href="http://blog.51cto.com/attachment/201310/151103300.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151106241.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151108770.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151111920.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151113938.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151133552.jpg" target="_blank"></a>
注意:这边的密码千万别包含@字,否则在创建数据库实例的时候,
报错:ORA-12154 tns could not resolve the connect identifier specified
<a href="http://blog.51cto.com/attachment/201310/151519339.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151522451.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151524250.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151527259.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151529205.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151531876.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151534761.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151536402.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151538650.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151541222.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/151543301.jpg" target="_blank"></a>
八. 创建Oracle启动脚本
1.修改oratab文件
<code>[root@web-db ~]</code><code># cp /etc/oratab /etc/oratab_20131017.bak</code>
<code> </code><code>//N</code> <code>改为 Y</code>
<code>[root@web-db ~]</code><code># tail -n 1 /etc/oratab \</code>
<code>clouddb:</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1</code><code>:Y</code>
2. 修改dbstart跟dbshut脚本中ORACLE_HOME_LISTENER的值
【<code>ORACLE_HOME_LISTNER=$1 修改为 ORACLE_HOME_LISTNER=$ORACLE_HOME</code>】
<code>[root@web-db ~]</code><code># cp /u01/app/oracle/product/11.2.0/db_1/bin/dbstart /u01/app/oracle/product/11.2.0/db_1/bin/dbstart_20131017.bak</code>
<code>[root@web-db ~]</code><code># cp /u01/app/oracle/product/11.2.0/db_1/bin/dbshut /u01/app/oracle/product/11.2.0/db_1/bin/dbshut_20131017.bak</code>
<code>[root@web-db ~]</code><code># vi /u01/app/oracle/product/11.2.0/db_1/bin/dbstart //修改第80行</code>
<code>[root@web-db ~]</code><code># vi /u01/app/oracle/product/11.2.0/db_1/bin/dbshut //修改第50行</code>
3.创建启动脚本文件
33
<code>[root@web-db ~]</code><code># cat /etc/init.d/oracle</code>
<code>#!/bin/bash</code>
<code># chkconfig: 2345 98 10</code>
<code># description: Oracle auto start-stop script.</code>
<code># /etc/rc.d/init.d/oracle</code>
<code>. </code><code>/etc/rc</code><code>.d</code><code>/init</code><code>.d</code><code>/functions</code>
<code>export</code> <code>ORACLE_BASE=</code><code>/u01/app/oracle</code>
<code>export</code> <code>ORACLE_HOME=$ORACLE_BASE</code><code>/product/11</code><code>.2.0</code><code>/db_1</code>
<code>export</code> <code>ORACLE_SID=clouddb</code>
<code>export</code> <code>PATH=$PATH:$ORACLE_HOME</code><code>/bin</code>
<code>case</code> <code>"$1"</code> <code>in</code>
<code>start)</code>
<code>echo</code> <code>"==start oracle=="</code>
<code>su</code> <code>oracle -c </code><code>"$ORACLE_HOME/bin/dbstart"</code>
<code>su</code> <code>oracle -c </code><code>"$ORACLE_HOME/bin/emctl start dbconsole"</code>
<code>su</code> <code>oracle -c </code><code>"$ORACLE_HOME/bin/lsnrctl start"</code>
<code>touch</code> <code>/var/lock/subsys/oracle</code>
<code>echo</code> <code>"`date` ==oracle startup successful== "</code><code>>> </code><code>/var/log/oracle11g</code><code>.log</code>
<code>;;</code>
<code>stop)</code>
<code>echo</code> <code>"==shutdown oracle=="</code>
<code>su</code> <code>oracle -c </code><code>"$ORACLE_HOME/bin/dbshut"</code>
<code>su</code> <code>oracle -c </code><code>"$ORACLE_HOME/bin/emctl stop dbconsole "</code>
<code>su</code> <code>oracle -c </code><code>"$ORACLE_HOME/bin/lsnrctl stop"</code>
<code>rm</code> <code>-f </code><code>/var/lock/subsys/oracle</code>
<code>echo</code> <code>"`date` ==oracle shutdown successful== "</code><code>>> </code><code>/var/log/oracle11g</code><code>.log</code>
<code>*)</code>
<code>echo</code> <code>"Usage: "</code><code>$0</code><code>" start |stop "</code>
<code>exit</code>
<code>esac</code>
<code>exit</code> <code>0</code>
注意:上述脚本第2行chkconfig: 2345 98 10 中的98该值需要注意,我原来按照很多教程都写的99,发现系统重启之后,Oracle根本不会随机启动,查看发现有两个99的服务
<code>[root@web-db ~]</code><code># ls /etc/rc2.d/S99*</code>
<code>/etc/rc2</code><code>.d</code><code>/S99local</code> <code>/etc/rc2</code><code>.d</code><code>/S99oracle</code>
所以改成不存在的数值:98,测试通过,完美运行。
4. 赋予可执行权限,加入开机启动
<code>[root@web-db ~]</code><code># chmod a+x /etc/init.d/oracle</code>
<code>[root@web-db ~]</code><code># chkconfig --add oracle</code>
<code>[root@web-db ~]</code><code># chkconfig oracle on</code>
5. 启动服务,查看是否成功
<code>[root@web-db ~]</code><code># ps -ef |grep ora //没有ora真正进程</code>
<code>oracle 5598 1 0 13:23 pts</code><code>/0</code> <code>00:00:00 dbus-launch --autolaunch 29eae0cf81f05ed989bd283900000022 --binary-syntax --close-stderr</code>
<code>oracle 5599 1 0 13:23 ? 00:00:00 </code><code>/bin/dbus-daemon</code> <code>--fork --print-pid 5 --print-address 7 --session</code>
<code>root 5803 1716 0 13:54 pts</code><code>/0</code> <code>00:00:00 </code><code>su</code> <code>- oracle</code>
<code>oracle 5804 5803 0 13:54 pts</code><code>/0</code> <code>00:00:00 -</code><code>bash</code>
<code>root 20479 20462 0 15:49 pts</code><code>/1</code> <code>00:00:00 </code><code>grep</code> <code>oracle</code>
启动服务
<code>[root@web-db ~]</code><code># service oracle start //启动oracle服务</code>
<code>Processing Database instance </code><code>"clouddb"</code><code>: log </code><code>file</code> <code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/startup</code><code>.log</code>
<code>Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0</code>
<code>Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.</code>
<code>https:</code><code>//web-db</code><code>:1158</code><code>/em/console/aboutApplication</code>
<code>Starting Oracle Enterprise Manager 11g Database Control .......... started.</code>
<code>------------------------------------------------------------------</code>
<code>Logs are generated </code><code>in</code> <code>directory </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/web-db_clouddb/sysman/log</code>
再次查看ora进程
34
35
36
37
38
<code>[root@web-db ~]</code><code># ps -ef |grep ora</code>
<code>oracle 20495 1 0 15:49 ? 00:00:00 </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/bin/tnslsnr</code> <code>LISTENER -inherit</code>
<code>oracle 20632 1 0 15:49 ? 00:00:00 ora_pmon_clouddb</code>
<code>oracle 20634 1 0 15:49 ? 00:00:00 ora_vktm_clouddb</code>
<code>oracle 20638 1 0 15:49 ? 00:00:00 ora_gen0_clouddb</code>
<code>oracle 20640 1 0 15:49 ? 00:00:00 ora_diag_clouddb</code>
<code>oracle 20642 1 0 15:49 ? 00:00:00 ora_dbrm_clouddb</code>
<code>oracle 20644 1 0 15:49 ? 00:00:00 ora_psp0_clouddb</code>
<code>oracle 20646 1 0 15:49 ? 00:00:00 ora_dia0_clouddb</code>
<code>oracle 20648 1 1 15:49 ? 00:00:01 ora_mman_clouddb</code>
<code>oracle 20650 1 0 15:49 ? 00:00:00 ora_dbw0_clouddb</code>
<code>oracle 20652 1 0 15:49 ? 00:00:00 ora_lgwr_clouddb</code>
<code>oracle 20654 1 0 15:49 ? 00:00:00 ora_ckpt_clouddb</code>
<code>oracle 20656 1 0 15:49 ? 00:00:00 ora_smon_clouddb</code>
<code>oracle 20658 1 0 15:49 ? 00:00:00 ora_reco_clouddb</code>
<code>oracle 20660 1 0 15:49 ? 00:00:00 ora_mmon_clouddb</code>
<code>oracle 20662 1 0 15:49 ? 00:00:00 ora_mmnl_clouddb</code>
<code>oracle 20664 1 0 15:49 ? 00:00:00 ora_d000_clouddb</code>
<code>oracle 20666 1 0 15:49 ? 00:00:00 ora_s000_clouddb</code>
<code>oracle 20748 1 0 15:49 ? 00:00:00 ora_qmnc_clouddb</code>
<code>oracle 21053 1 0 15:49 ? 00:00:00 ora_cjq0_clouddb</code>
<code>oracle 21265 1 0 15:49 ? 00:00:00 </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/perl/bin/perl</code> <code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/bin/emwd</code><code>.pl dbconsole </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/web-db_clouddb/sysman/log/emdb</code><code>.</code><code>nohup</code>
<code>oracle 21289 21265 45 15:49 ? 00:00:26 </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/jdk/bin/java</code> <code>-server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1</code> <code>-Doracle.home=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/oc4j</code> <code>-Doracle.oc4j.localhome=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/web-db_clouddb/sysman</code> <code>-DEMSTATE=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/web-db_clouddb</code> <code>-Doracle.j2ee.dont.use.memory.archive=</code><code>true</code> <code>-Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/oc4j/j2ee/OC4J_DBConsole_web-db_clouddb/config/jazn</code><code>.xml -Djava.security.policy=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/oc4j/j2ee/OC4J_DBConsole_web-db_clouddb/config/java2</code><code>.policy -Djavax.net.ssl.KeyStore=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/sysman/config/OCMTrustedCerts</code><code>.txt-Djava.security.properties=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/oc4j/j2ee/home/config/jazn</code><code>.security.props -DEMDROOT=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/web-db_clouddb</code> <code>-Dsysman.md5password=</code><code>true</code> <code>-Drepapi.oracle.home=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1</code> <code>-Ddisable.checkForUpdate=</code><code>true</code> <code>-Doracle.sysman.ccr.ocmSDK.websvc.keystore=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/jlib/emocmclnt</code><code>.ks -Dice.pilots.html4.ignoreNonGenericFonts=</code><code>true</code> <code>-Djava.awt.headless=</code><code>true</code> <code>-jar </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/oc4j/j2ee/home/oc4j</code><code>.jar -config </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/oc4j/j2ee/OC4J_DBConsole_web-db_clouddb/config/server</code><code>.xml</code>
<code>oracle 21302 21265 1 15:49 ? 00:00:01 </code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/db_1/bin/emagent</code>
<code>oracle 21329 1 6 15:49 ? 00:00:03 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21364 1 1 15:49 ? 00:00:00 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21530 1 0 15:49 ? 00:00:00 ora_q000_clouddb</code>
<code>oracle 21532 1 0 15:49 ? 00:00:00 ora_q001_clouddb</code>
<code>oracle 21777 1 0 15:49 ? 00:00:00 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21782 1 1 15:49 ? 00:00:00 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21830 1 0 15:50 ? 00:00:00 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21837 1 0 15:50 ? 00:00:00 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21840 1 7 15:50 ? 00:00:02 oracleclouddb (LOCAL=NO)</code>
<code>oracle 21861 1 8 15:50 ? 00:00:02 oracleclouddb (LOCAL=NO)</code>
6登陆OEM,查看实例监控信息
-----------------------------------------------
用户名:sys
密码:创建数据库实例的时候设置的密码,那边我提醒密码不要包含@字符的,你懂了吧。
连接身份:SYSDBA
<a href="http://blog.51cto.com/attachment/201310/160236622.jpg" target="_blank"></a>
<a href="http://blog.51cto.com/attachment/201310/160136208.jpg" target="_blank"></a>
本文转自 暗黑魔君 51CTO博客,原文链接:http://blog.51cto.com/clovemfong/1310212,如需转载请自行联系原作者