当前位置： 首页 > news >正文

那个网站做二手设备比较好/友链网

news 2025/8/3 12:21:25
那个网站做二手设备比较好,友链网,wordpress 文章底部,做论坛网站的元素文章结束给大家来个程序员笑话：[M] 昨日在户客现场一套RAC在启动监听的时候报TNS-12545 TNS_12560 TNS-00515错误，经过理处后复恢畸形， 今天在自己的虚拟机上还原了这个题问，记录下： OS:Linux DB:10.2.0.4 RAC 一、模拟…

文章结束给大家来个程序员笑话：[M]

    昨日在户客现场一套RAC在启动监听的时候报TNS-12545 TNS_12560 TNS-00515错误，经过理处后复恢畸形，

    今天在自己的虚拟机上还原了这个题问，记录下：

    OS:Linux

    DB:10.2.0.4 RAC

    一、模拟复恢到事变生发时的况情

    1、手工关闭监听后换切VIP

[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ srvctl stop listener -n orlrac1
[oracle@orlrac1 ~]$ srvctl stop listener -n orlrac2
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcldb.db  application    ONLINE    ONLINE    orlrac1     
ora....b1.inst application    ONLINE    ONLINE    orlrac1     
ora....b2.inst application    ONLINE    ONLINE    orlrac2     
ora....SM1.asm application    ONLINE    ONLINE    orlrac1     
ora....C1.lsnr application    OFFLINE   OFFLINE               
ora....ac1.gsd application    ONLINE    ONLINE    orlrac1     
ora....ac1.ons application    ONLINE    ONLINE    orlrac1     
ora....ac1.vip application    ONLINE    ONLINE    orlrac1     
ora....SM2.asm application    ONLINE    ONLINE    orlrac2     
ora....C2.lsnr application    OFFLINE   OFFLINE               
ora....ac2.gsd application    ONLINE    ONLINE    orlrac2     
ora....ac2.ons application    ONLINE    ONLINE    orlrac2     
ora....ac2.vip application    ONLINE    ONLINE    orlrac2     
[oracle@orlrac1 ~]$

    2、手工换切vip   ------题问的键关，昨天的题问是两个节点的VIP不知道什么原因互换了

[oracle@orlrac1 ~]$ crs_relocate ora.orlrac1.vip -c orlrac2
Attempting to stop `ora.orlrac1.vip` on member `orlrac1`
Stop of `ora.orlrac1.vip` on member `orlrac1` succeeded.
Attempting to start `ora.orlrac1.vip` on member `orlrac2`
Start of `ora.orlrac1.vip` on member `orlrac2` succeeded.
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ crs_relocate ora.orlrac2.vip -c orlrac1
Attempting to stop `ora.orlrac2.vip` on member `orlrac2`
Stop of `ora.orlrac2.vip` on member `orlrac2` succeeded.
Attempting to start `ora.orlrac2.vip` on member `orlrac1`
Start of `ora.orlrac2.vip` on member `orlrac1` succeeded.
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ 
[oracle@orlrac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcldb.db  application    ONLINE    ONLINE    orlrac1     
ora....b1.inst application    ONLINE    ONLINE    orlrac1     
ora....b2.inst application    ONLINE    ONLINE    orlrac2     
ora....SM1.asm application    ONLINE    ONLINE    orlrac1     
ora....C1.lsnr application    OFFLINE   OFFLINE               
ora....ac1.gsd application    ONLINE    ONLINE    orlrac1     
ora....ac1.ons application    ONLINE    ONLINE    orlrac1     
ora....ac1.vip application    ONLINE    ONLINE    orlrac2     
ora....SM2.asm application    ONLINE    ONLINE    orlrac2     
ora....C2.lsnr application    OFFLINE   OFFLINE               
ora....ac2.gsd application    ONLINE    ONLINE    orlrac2     
ora....ac2.ons application    ONLINE    ONLINE    orlrac2     
ora....ac2.vip application    ONLINE    ONLINE    orlrac1     
[oracle@orlrac1 ~]$ ----查看IP否是已换切[root@orlrac1 ~]# 
[root@orlrac1 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 08:00:27:9F:BD:A4  inet addr:192.168.100.111  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:1485 errors:0 dropped:0 overruns:0 frame:0TX packets:992 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:141378 (138.0 KiB)  TX bytes:119168 (116.3 KiB)eth0:1    Link encap:Ethernet  HWaddr 08:00:27:9F:BD:A4  inet addr:192.168.100.114  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1eth1      Link encap:Ethernet  HWaddr 08:00:27:05:6D:5E  inet addr:172.168.1.101  Bcast:172.168.1.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:103726 errors:0 dropped:0 overruns:0 frame:0TX packets:69201 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:79639044 (75.9 MiB)  TX bytes:26738291 (25.4 MiB)lo        Link encap:Local Loopback  inet addr:127.0.0.1  Mask:255.0.0.0UP LOOPBACK RUNNING  MTU:16436  Metric:1RX packets:12392 errors:0 dropped:0 overruns:0 frame:0TX packets:12392 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:6477913 (6.1 MiB)  TX bytes:6477913 (6.1 MiB)[root@orlrac1 ~]# [root@orlrac2 ~]# 
[root@orlrac2 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 08:00:27:A2:A1:2A  inet addr:192.168.100.113  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:471 errors:0 dropped:0 overruns:0 frame:0TX packets:266 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:49614 (48.4 KiB)  TX bytes:27620 (26.9 KiB)eth0:2    Link encap:Ethernet  HWaddr 08:00:27:A2:A1:2A  inet addr:192.168.100.112  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1eth1      Link encap:Ethernet  HWaddr 08:00:27:25:23:D7  inet addr:172.168.1.102  Bcast:172.168.1.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:69257 errors:0 dropped:0 overruns:0 frame:0TX packets:103814 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:26754117 (25.5 MiB)  TX bytes:79662388 (75.9 MiB)lo        Link encap:Local Loopback  inet addr:127.0.0.1  Mask:255.0.0.0UP LOOPBACK RUNNING  MTU:16436  Metric:1RX packets:10450 errors:0 dropped:0 overruns:0 frame:0TX packets:10450 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:6388467 (6.0 MiB)  TX bytes:6388467 (6.0 MiB)[root@orlrac2 ~]# 
[root@orlrac2 ~]# [oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6192.168.100.111 orlrac1 orlrac1.oracle.com
192.168.100.112 orlrac1-vip192.168.100.113 orlrac2 orlrac2.oracle.com
192.168.100.114 orlrac2-vip172.168.1.101 orlrac1-priv
172.168.1.102 orlrac2-priv
[oracle@orlrac1 admin]$ ----两个节点的VIP已互交

    二、题问重现

    1、手动启动Listener

[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ lsnrctl start LISTENER_ORLRAC1LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 27-APR-2013 16:51:15Copyright (c) 1991, 2010, Oracle.  All rights reserved.Starting /u01/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/product/10.2.0/db_1/network/log/listener_orlrac1.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orlrac1-vip)(PORT=1521)(IP=FIRST)))
TNS-12545: Connect failed because target host or object does not existTNS-12560: TNS:protocol adapter errorTNS-00515: Connect failed because target host or object does not existLinux Error: 99: Cannot assign requested addressListener failed to start. See the error message(s) above...

    题问重现，同如昨天的情形，报了TNS-12545\TNS-12560\TNS-00515的错误

    题问生发后，首先ping了一下相干的IP地址和网络别名都能ping通，查检listener.ora和/etc/hosts等相干配置文件，都未发现异常，不过还是实验修改这些文件来察观否是是有其他线索。

    

    2、修改listener.ora中ADDRESS中的次序  ----恰是这个操纵发现了一些线索

[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ cat listener.ora
# listener.ora.orlrac1 Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora.orlrac1
# Generated by Oracle configuration tools.LISTENER_ORLRAC1 =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.111)(PORT = 1521)(IP = FIRST)))(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = orlrac1-vip)(PORT = 1521)(IP = FIRST)))(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))))[oracle@orlrac1 admin]$ ---再次启动监听
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ lsnrctl start LISTENER_ORLRAC1LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 27-APR-2013 16:55:20Copyright (c) 1991, 2010, Oracle.  All rights reserved.Starting /u01/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/product/10.2.0/db_1/network/log/listener_orlrac1.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.111)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orlrac1-vip)(PORT=1521)(IP=FIRST)))
TNS-12545: Connect failed because target host or object does not existTNS-12560: TNS:protocol adapter errorTNS-00515: Connect failed because target host or object does not existLinux Error: 99: Cannot assign requested addressListener failed to start. See the error message(s) above...[oracle@orlrac1 admin]$ ---错误旧依，但是有点不同
/*
交换地址前：
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orlrac1-vip)(PORT=1521)(IP=FIRST)))交换地址后：
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.111)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orlrac1-vip)(PORT=1521)(IP=FIRST)))为什么第一个public的IP是畸形的，到了vip就不畸形了，难道VIP出题问了，但是ping vip是通的，难道是说orlrac1-vip没在这个节点上
*/

    3、通过ifconfig名来查看卡网上vip的地址到底是多少

每日一道理
因为自信，在呀呀学语时，我靠着纤嫩的双腿，迈出人生的第一步；因为自信，我一次次将第一名的奖状高高举起；因为自信，我毫不吝惜地剪掉飘逸的长发，在运动场上展现风采……感谢自信，它给了我一双翅膀，让我在电闪雷鸣中去飞翔，在风雨中去搏击人生！
[root@orlrac1 ~]# 
[root@orlrac1 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 08:00:27:9F:BD:A4  inet addr:192.168.100.111  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:1485 errors:0 dropped:0 overruns:0 frame:0TX packets:992 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:141378 (138.0 KiB)  TX bytes:119168 (116.3 KiB)eth0:1    Link encap:Ethernet  HWaddr 08:00:27:9F:BD:A4  inet addr:192.168.100.114  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1eth1      Link encap:Ethernet  HWaddr 08:00:27:05:6D:5E  inet addr:172.168.1.101  Bcast:172.168.1.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:103726 errors:0 dropped:0 overruns:0 frame:0TX packets:69201 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:79639044 (75.9 MiB)  TX bytes:26738291 (25.4 MiB)lo        Link encap:Local Loopback  inet addr:127.0.0.1  Mask:255.0.0.0UP LOOPBACK RUNNING  MTU:16436  Metric:1RX packets:12392 errors:0 dropped:0 overruns:0 frame:0TX packets:12392 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:6477913 (6.1 MiB)  TX bytes:6477913 (6.1 MiB)[root@orlrac1 ~]# [root@orlrac2 ~]# 
[root@orlrac2 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 08:00:27:A2:A1:2A  inet addr:192.168.100.113  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:471 errors:0 dropped:0 overruns:0 frame:0TX packets:266 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:49614 (48.4 KiB)  TX bytes:27620 (26.9 KiB)eth0:2    Link encap:Ethernet  HWaddr 08:00:27:A2:A1:2A  inet addr:192.168.100.112  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1eth1      Link encap:Ethernet  HWaddr 08:00:27:25:23:D7  inet addr:172.168.1.102  Bcast:172.168.1.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:69257 errors:0 dropped:0 overruns:0 frame:0TX packets:103814 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:26754117 (25.5 MiB)  TX bytes:79662388 (75.9 MiB)lo        Link encap:Local Loopback  inet addr:127.0.0.1  Mask:255.0.0.0UP LOOPBACK RUNNING  MTU:16436  Metric:1RX packets:10450 errors:0 dropped:0 overruns:0 frame:0TX packets:10450 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:6388467 (6.0 MiB)  TX bytes:6388467 (6.0 MiB)[root@orlrac2 ~]#

    确切同如想猜的一样，两个节点VIP的地址生发了互交，当在启动监听的时候，在析解listener.ora的过程当中vip的地址未在本节点上，所以产生了TNS的报错

    

    三、解决方法

    把VIP换切应相的节点，无需停库，O(∩_∩)O哈！

[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ crs_relocate ora.orlrac1.vip -c orlrac1
Attempting to stop `ora.orlrac1.vip` on member `orlrac2`
Stop of `ora.orlrac1.vip` on member `orlrac2` succeeded.
Attempting to start `ora.orlrac1.vip` on member `orlrac1`
Start of `ora.orlrac1.vip` on member `orlrac1` succeeded.
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ crs_relocate ora.orlrac2.vip -c orlrac2
Attempting to stop `ora.orlrac2.vip` on member `orlrac1`
Stop of `ora.orlrac2.vip` on member `orlrac1` succeeded.
Attempting to start `ora.orlrac2.vip` on member `orlrac2`Start of `ora.orlrac2.vip` on member `orlrac2` succeeded.
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcldb.db  application    ONLINE    ONLINE    orlrac1     
ora....b1.inst application    ONLINE    ONLINE    orlrac1     
ora....b2.inst application    ONLINE    ONLINE    orlrac2     
ora....SM1.asm application    ONLINE    ONLINE    orlrac1     
ora....C1.lsnr application    OFFLINE   OFFLINE               
ora....ac1.gsd application    ONLINE    ONLINE    orlrac1     
ora....ac1.ons application    ONLINE    ONLINE    orlrac1     
ora....ac1.vip application    ONLINE    ONLINE    orlrac1     
ora....SM2.asm application    ONLINE    ONLINE    orlrac2     
ora....C2.lsnr application    OFFLINE   OFFLINE               
ora....ac2.gsd application    ONLINE    ONLINE    orlrac2     
ora....ac2.ons application    ONLINE    ONLINE    orlrac2     
ora....ac2.vip application    ONLINE    ONLINE    orlrac2     
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ [root@orlrac1 Server]# 
[root@orlrac1 Server]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 08:00:27:9F:BD:A4  inet addr:192.168.100.111  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:3471 errors:0 dropped:0 overruns:0 frame:0TX packets:2720 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:313510 (306.1 KiB)  TX bytes:587585 (573.8 KiB)eth0:2    Link encap:Ethernet  HWaddr 08:00:27:9F:BD:A4  inet addr:192.168.100.112  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1eth1      Link encap:Ethernet  HWaddr 08:00:27:05:6D:5E  inet addr:172.168.1.101  Bcast:172.168.1.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:120995 errors:0 dropped:0 overruns:0 frame:0TX packets:81088 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:90326689 (86.1 MiB)  TX bytes:30357317 (28.9 MiB)lo        Link encap:Local Loopback  inet addr:127.0.0.1  Mask:255.0.0.0UP LOOPBACK RUNNING  MTU:16436  Metric:1RX packets:21804 errors:0 dropped:0 overruns:0 frame:0TX packets:21804 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:6951201 (6.6 MiB)  TX bytes:6951201 (6.6 MiB)[root@orlrac1 Server]# 
[root@orlrac1 Server]# [root@orlrac2 ~]# 
[root@orlrac2 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 08:00:27:A2:A1:2A  inet addr:192.168.100.113  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:753 errors:0 dropped:0 overruns:0 frame:0TX packets:489 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:71154 (69.4 KiB)  TX bytes:42369 (41.3 KiB)eth0:1    Link encap:Ethernet  HWaddr 08:00:27:A2:A1:2A  inet addr:192.168.100.114  Bcast:192.168.100.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1eth1      Link encap:Ethernet  HWaddr 08:00:27:25:23:D7  inet addr:172.168.1.102  Bcast:172.168.1.255  Mask:255.255.255.0UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1RX packets:81146 errors:0 dropped:0 overruns:0 frame:0TX packets:121063 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:30368327 (28.9 MiB)  TX bytes:90345089 (86.1 MiB)lo        Link encap:Local Loopback  inet addr:127.0.0.1  Mask:255.0.0.0UP LOOPBACK RUNNING  MTU:16436  Metric:1RX packets:20018 errors:0 dropped:0 overruns:0 frame:0TX packets:20018 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:6833331 (6.5 MiB)  TX bytes:6833331 (6.5 MiB)[root@orlrac2 ~]# 
[root@orlrac2 ~]#

    启动监听

[oracle@orlrac1 admin]$ lsnrctl start LISTENER_ORLRAC1LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 27-APR-2013 17:22:30Copyright (c) 1991, 2010, Oracle.  All rights reserved.Starting /u01/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/product/10.2.0/db_1/network/log/listener_orlrac1.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.111)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.112)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.111)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_ORLRAC1
Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date                27-APR-2013 17:22:30
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/oracle/product/10.2.0/db_1/network/log/listener_orlrac1.log
Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.111)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.112)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
The listener supports no services
The command completed successfully
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ [root@orlrac2 ~]# su - oracle
[oracle@orlrac2 ~]$ lsnrctl start LISTENER_ORLRAC2LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 27-APR-2013 17:22:56Copyright (c) 1991, 2010, Oracle.  All rights reserved.Starting /u01/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/product/10.2.0/db_1/network/log/listener_orlrac2.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.114)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.113)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orlrac2-vip)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_ORLRAC2
Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date                27-APR-2013 17:22:56
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/oracle/product/10.2.0/db_1/network/log/listener_orlrac2.log
Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.114)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.113)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
The listener supports no services
The command completed successfully
[oracle@orlrac2 ~]$ 
[oracle@orlrac2 ~]$ 
[oracle@orlrac2 ~]$ [oracle@orlrac1 admin]$ 
[oracle@orlrac1 admin]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcldb.db  application    ONLINE    ONLINE    orlrac1     
ora....b1.inst application    ONLINE    ONLINE    orlrac1     
ora....b2.inst application    ONLINE    ONLINE    orlrac2     
ora....SM1.asm application    ONLINE    ONLINE    orlrac1     
ora....C1.lsnr application    ONLINE    ONLINE    orlrac1     
ora....ac1.gsd application    ONLINE    ONLINE    orlrac1     
ora....ac1.ons application    ONLINE    ONLINE    orlrac1     
ora....ac1.vip application    ONLINE    ONLINE    orlrac1     
ora....SM2.asm application    ONLINE    ONLINE    orlrac2     
ora....C2.lsnr application    ONLINE    ONLINE    orlrac2     
ora....ac2.gsd application    ONLINE    ONLINE    orlrac2     
ora....ac2.ons application    ONLINE    ONLINE    orlrac2     
ora....ac2.vip application    ONLINE    ONLINE    orlrac2     
[oracle@orlrac1 admin]$

    题问解决，总结：做DBA的眼神很要重，任何一个小的线索都是解决题问的键关啊。。。。

    

文章结束给大家分享下程序员的一些笑话语录： 很多所谓的牛人也不过如此，离开了你，微软还是微软，Google还是Google，苹果还是苹果，暴雪还是暴雪，而这些牛人离开了公司，自己什么都不是。

转载于:https://www.cnblogs.com/jiangu66/archive/2013/04/28/3050001.html

http://www.lbrq.cn/news/1476379.html

相关文章：

  • 陕西省交通建设集团西长分公司网站/sem是什么品牌
  • 宣传网站建设方案模板下载/网络营销策划案
  • 如何把自己做的网站放到微信上/品牌推广方案范文
  • 大型营销型网站制作/网络营销的作用
  • 国内知名公关公司/快速整站排名seo教程
  • 网站开发流程数据库/杭州推广平台有哪些
  • 中国建筑八个局排名/排名优化系统
  • 网站制作现状解决方案/sem优化托管
  • 多用户商城网站建设方案/网络广告创意
  • 网站建设推广人员/网站seo视频狼雨seo教程
  • 天津电子商务网站建设/郑州seo联系搜点网络效果好
  • 母婴会所 网站源码/企业网站设计公司
  • 真人做爰直播网站/网站seo外包公司有哪些
  • 建筑网站带图解/seo优化搜索推广
  • 贸易网站怎么做/处理事件seo软件
  • 表白网站建设/什么推广平台好
  • miniui做的网站/济宁百度推广公司
  • 分类信息网站建设专职/关键词排名关键词快速排名
  • 乐陵310seo/鹤壁网站seo
  • 大庆做网站找谁/搜索大全搜索引擎
  • 福州电子商务网站建设/拓客app下载
  • 怎样在工商局网站做公示/百度seo新站优化
  • 鹏牛网做网站怎么样/外链网站推荐
  • 网站设置在哪里找/百度seo优化哪家好
  • 合肥有多少做网站的/seo网站推广优化
  • 普陀网站建设/百度推广登录入口
  • 简单网站的制作/2020国内十大小说网站排名
  • 叫别人做网站安全吗/广告平台网站有哪些
  • 网站维护产品推介/接广告推广
  • 使用织梦系统建设网站/免费的推广引流软件
  • WAIC引爆AI，智元机器人收购上纬新材，Geek+上市，157起融资撑起热度|2025年7月人工智能投融资观察 · 极新月报
  • MybatisPlus-逻辑删除
  • 逻辑回归 银行贷款资格判断案列优化 交叉验证，调整阈值，下采样与过采样方法
  • cmd怎么取消关机命令
  • 新手小白如何快速检测IP 的好坏？
  • QT6 Python UI文件转换PY文件的方法