批注：此处创建的监听名字listener，database_id=orcl
查看企业管理器的网页浏览方式所在目录参考，，如下：
[root@primary ~]# su - oracle
[oracle@primary ~]$ cd $oracle_home
[oracle@primary db_1]$ cd install
[oracle@primary install]$ more readme.txt
the following j2ee applications have been deployed and are accessible at the url
s listed below.
isql*plus url:
:5560/isqlplus
isql*plus dba url:
:5560/isqlplus/dba
:1158/em
:1158/em
2.打开数据库
[oracle@primary install]$ sqlplus / as sysdba
sql*plus: release 10.2.0.1.0 - production on tue jun 17 08:33:17 2014
copyright (c) 1982, 2005, oracle. all rights reserved.
connected to:
oracle database 10g enterprise edition release 10.2.0.1.0 - production
with the partitioning, olap and data mining options
sql> select instance_name,status from v$instance;
instance_name status
---------------- ------------
orcl open
3.查看监听状态，必须是运行状态
[oracle@primary install]$ lsnrctl status
lsnrctl for linux: version 10.2.0.1.0 - production on 17-jun-2014 08:35:40
copyright (c) 1991, 2005, oracle. all rights reserved.
connecting to (description=(address=(protocol=tcp)(host=primary)(port=1521)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 10.2.0.1.0 - production
start date 17-jun-2014 08:29:31
uptime 0 days 0 hr. 6 min. 8 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /u01/oracle/db_1/network/admin/listener.ora
listener log file /u01/oracle/db_1/network/log/listener.log
listening endpoints summary...
(description=(address=(protocol=tcp)(host=primary)(port=1521)))
(description=(address=(protocol=ipc)(key=extproc0)))
services summary...
service plsextproc has 1 instance(s).
instance plsextproc, status unknown, has 1 handler(s) for this service...
service orcl has 1 instance(s).
instance orcl, status ready, has 1 handler(s) for this service...
service orclxdb has 1 instance(s).
instance orcl, status ready, has 1 handler(s) for this service...
service orcl_xpt has 1 instance(s).
instance orcl, status ready, has 1 handler(s) for this service...
the command completed successfully
查看监听端口号，如下：
[oracle@primary install]$ cd $oracle_home/network/admin/
[oracle@primary admin]$ ls
listener.ora samples shrept.lst tnsnames.ora
[oracle@primary admin]$ more listener.ora
# listener.ora network configuration file: /u01/oracle/db_1/network/admin/listen
er.ora
# generated by oracle configuration tools.
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /u01/oracle/db_1)
(program = extproc)
)
)
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = primary)(port = 1521))
(address = (protocol = ipc)(key = extproc0))
)
)
4.查看/etc/hosts里边的ip地址和主机名必须与实际一致
[root@primary ~]# hostname
primary
[root@primary ~]# ifconfig eth0
eth0 link encap:ethernet hwaddr 00:0c:29:da:7e:f0
inet addr:192.168.10.10 bcast:192.168.10.255 mask:255.255.255.0
inet6 addr: fe80::20c:29ff:feda:7ef0/64 scope:link
up broadcast running multicast mtu:1500 metric:1
rx packets:6392 errors:0 dropped:0 overruns:0 frame:0
tx packets:10621 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
rx bytes:458467 (447.7 kib) tx bytes:1665793 (1.5 mib)
interrupt:59 base address:0x2024
[root@primary ~]# cat /etc/hosts
# do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
192.168.10.10 primary
#::1 localhost6.localdomain6 localhost6
5.关闭企业管理器 emctl stop dbconsole
[oracle@primary ~]$ emctl stop dbconsole
tz set to prc
oracle enterprise manager 10g database control release 10.2.0.1.0
copyright (c) 1996, 2005 oracle corporation. all rights reserved.
:1158/em/console/aboutapplication
stopping oracle enterprise manager 10g database control ...
... stopped.
6.删除em资料库 emca –repos drop
[oracle@primary ~]$ emca -repos drop
started emca at jun 17, 2014 8:44:08 am
em configuration assistant, version 10.2.0.1.0 production
copyright (c) 2003, 2005, oracle. all rights reserved.
enter the following information:
database sid: orcl
listener port number: 1521
password for sys user:
password for sysman user:
do you wish to continue? [yes(y)/no(n)]: y
jun 17, 2014 8:44:19 am oracle.sysman.emcp.emconfig perform
info: this operation is being logged at /u01/oracle/db_1/cfgtoollogs/emca/orcl/emca_2014-06-17_08-44-08-am.log.
jun 17, 2014 8:44:20 am oracle.sysman.emcp.emreposconfig droprepository
info: dropping the em repository (this may take a while) ...
jun 17, 2014 8:46:27 am oracle.sysman.emcp.emreposconfig invoke
info: repository successfully dropped
enterprise manager configuration completed successfully
finished emca at jun 17, 2014 8:46:28 am