|
OL = TCP)(HOST = 10.101.1.106)(PORT = 1520))
)
)
)
SID_LIST_LISTENER_USBO2 =
(SID_LIST =
(SID_DESC =
(sid_name=USBO2)
(oracle_home = /users/oracle/OraHome10g)
)
)
LISTENER_USBO2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.1.106)(PORT = 1504))
)
)
)
oracle@sysreportDB:/users/oracle/OraHome10g/network/admin> more tnsnames.ora
USMTHLY=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.101.1.106)
(PORT=1520)
)
(CONNECT_DATA=
(SERVICE_NAME=USMTHLY)
)
)
USBO2=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.101.1.106)
(PORT=1504)
)
(CONNECT_DATA=
(SERVICE_NAME=USBO2)
)
)
#从上面的配置来看，配置无异常。
#下面查看本机host及IP信息，从下面的描述来看，主机host配置无异常
oracle@sysreportDB:~> more /etc/hosts
127.0.0.1 localhost
# special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback
fe00::0 ipv6-localnet
ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts
10.101.1.106 sysreportDB.2goasp.com sysreportDB
oracle@sysreportDB:~> hostname
sysreportDB
# Author : Leshami
# Blog : http://blog.csdn.net/leshami
#下面是其IP信息
oracle@sysreportDB:/var/log> ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:70:82:63
inet addr:10.101.1.106 Bcast:10.201.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5763651 errors:0 dropped:0 overruns:0 frame:0
TX packets:802254 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:8102327746 (7726.9 Mb) TX bytes:88597013 (84.4 Mb)
lo Link encap:Local Loopback #有环路能正常TX,RX
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:92972 errors:0 dropped:0 overruns:0 frame:0
TX packets:92972 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:4993723 (4.7 Mb) TX bytes:4993723 (4.7 Mb)
#尝试手动启动监听，手动启动监听无异常
oracle@sysreportDB:/var/log> lsnrctl start listener_USMTHLY
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-JUL-2014 17:10:49
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Starting /users/oracle/OraHome10g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /users/oracle/OraHome10g/network/admin/listener.ora
Log messages written to /users/oracle/OraHome10g/network/log/listener_usmthly.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sysreportDB.2goasp.com)(PORT=1520)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sysreportDB.2goasp.com)(PORT=1520)))
STATUS of the LISTENER
------------------------
Alias listener_USMTHLY
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 08-JUL-2014 17:10:50
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /users/oracle/OraHome10g/network/admin/listener.ora
Listener Log File /users/oracle/OraHome10g/network/log/listener_usmthly.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sysreportDB.2goasp.com)(PORT=1520)))
Services Summary...
Service "USMTHLY" has 1 instance(s).
Instance "USMTHLY", status UNKNOWN, h |