windows命令连接linux oracle网络原理及配置教程(15)

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 04-JAN-2018 10:56:57

Uptime 0 days 0 hr. 0 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.47)(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...

The command completed successfully

因为刚起来

信息的最底下Services里面没有jiagulun这个名字

因为这时候还没有注册进来

因为这个注册是后台进程PMON注册的

PMON进程根据init.ora中的instance_name、service_names两个参数将实例和服务动态注册到listener中

就是将的名字将的Service_names注册进来

pmon进程在instance启动的时候会注册

而且它定期巡查，每隔一段时间可以进行新的注册

所以程序有改变后，PMON注册需要一段时间才能够过来

为了加快速度我们可以用手工注册一下

先连入

[oracle@redhat4 admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 4 11:01:55 2018

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

然后执行命令

SQL> alter system register;

System altered.

这个命令常用

就是强制PMON抓紧时间将service_names注册到里面去

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-71958-15.html