广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >静态注册和动态注册
  • 182

0
分享到

静态注册和动态注册

2024-04-02 19:04:59 182人浏览 独家记忆
摘要

 创建侦听器侦听器在listener.ora文件中定义，这个文件的默认存储位置为oracle_HOME/network/admin目录。listener.ora文件至少必须声明一个侦听器的名称及其

 创建侦听器

侦听器在listener.ora文件中定义，这个文件的默认存储位置为oracle_HOME/network/admin目录。listener.ora文件至少必须声明一个侦听器的名称及其使用的协议与侦听地址。可以在一个文件中配置多个侦听器，不过这些侦听器必须具有不同的名称与地址。
与其他用于配置Oracle Net 的文件一样，listener.ora文件非常在意看似很小的语法问题。

[oracle@localhost admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = localhost.localdomain)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@localhost admin]$ vi ./listener.ora 
[oracle@localhost admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle

WYH =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
        )
    )

[oracle@localhost admin]$ 


数据库注册

向数据库注册实例的方法有静态注册和动态注册两种。对于静态注册来说，我们可以将一列实例硬编码在listener.ora文件中。动态注册意味着实例在启动时需要定位侦听器并注册到侦听器中。

1、静态注册

在listener.ora文件中添加条目

SID_LIST_WYH =
    (SID_LIST =
        (SID_DESC =
            (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
            (SID_NAME = orcl)
        )
    )

测试静态注册

[oracle@localhost admin]$ lsnrctl

LSNRCTL for linux: Version 11.2.0.3.0 - Production on 14-APR-2016 11:17:49

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for infORMation.

LSNRCTL> start WYH
Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/wyh/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     WYH
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                14-APR-2016 11:17:58
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/wyh/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> 

2、动态测试

初始化参数local_listener会告知实例其应当进行联系的，从而能够查找到注册实例的侦听器的网络地址。在启动实例时，PMON进程会使用该参数来定位一个侦听器，并向其通知实例名称以及实例提供的服务名称。
[oracle@localhost admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 14 12:12:37 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
ORACLE instance started.

Total System Global Area 1436389376 bytes
Fixed Size            2228384 bytes
Variable Size          855641952 bytes
Database Buffers      570425344 bytes
Redo Buffers            8093696 bytes
Database mounted.
Database opened.
SQL> alter system reGISter ;

System altered.

SQL> ho lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-APR-2016 12:14:17

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                14-APR-2016 12:14:38
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL> start
TNS-01106: Listener using listener name LISTENER has already been started
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                14-APR-2016 12:14:38
Uptime                    0 days 0 hr. 0 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
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...
The command completed successfully
LSNRCTL> 
[oracle@localhost admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 14 12:12:37 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
ORACLE instance started.

Total System Global Area 1436389376 bytes
Fixed Size            2228384 bytes
Variable Size          855641952 bytes
Database Buffers      570425344 bytes
Redo Buffers            8093696 bytes
Database mounted.
Database opened.
SQL> alter system register ;

System altered.

SQL> ho lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-APR-2016 12:14:17

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                14-APR-2016 12:14:38
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL> start
TNS-01106: Listener using listener name LISTENER has already been started
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                14-APR-2016 12:14:38
Uptime                    0 days 0 hr. 0 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
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...
The command completed successfully
LSNRCTL> 
LSNRCTL> 
LSNRCTL> exit

SQL> alter system set local_listener='(address=(pro=tcp)(host=localhost.localdomain)(port=1522))';

System altered.

SQL> ho lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-APR-2016 12:20:35

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> stop
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
LSNRCTL> start WYH
TNS-01106: Listener using listener name WYH has already been started
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     WYH
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                14-APR-2016 11:23:13
Uptime                    0 days 0 hr. 58 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/wyh/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
Services Summary...
Service "orcl" has 2 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
  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...
The command completed successfully
LSNRCTL> 
LSNRCTL> exit

SQL> 
SQL> 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name '((ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522)))'
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
ORACLE instance started.

Total System Global Area 1436389376 bytes
Fixed Size            2228384 bytes
Variable Size          855641952 bytes
Database Buffers      570425344 bytes
Redo Buffers            8093696 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile ;

File created.

SQL> 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1436389376 bytes
Fixed Size            2228384 bytes
Variable Size          855641952 bytes
Database Buffers      570425344 bytes
Redo Buffers            8093696 bytes
Database mounted.
Database opened.
SQL> create pfile from spfile ;

File created.

SQL> 

您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: 静态注册和动态注册

本文链接: https://www.lsjlt.com/news/43689.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
  • 静态注册和动态注册
     创建侦听器侦听器在listener.ora文件中定义，这个文件的默认存储位置为ORACLE_HOME/network/admin目录。listener.ora文件至少必须声明一个侦听器的名称及其...
    99+
    2022-10-18
  • oracle 动态注册和静态注册
    动态注册：实例启动后，pmon每分钟自动将服务名注册到侦听器中，也可以手动注册alter system register；系统默认有一个listener；不需要listener.ora文件也可以启动侦听，实...
    99+
    2022-10-18
  • oracle动态注册和静态注册监听器
         oracle动态注册和静态注册的区别：动态监听不需要在listener.ora文件中记录关于数据的任何信息，只需要将监听器的配置信息写入到该文件。例如：&n...
    99+
    2022-10-18
  • Oracle监听的静态注册和动态注册
    静态注册：通过解析listene.ora文件 动态注册：由PMON进程动态注册至监听中 在没有listener.ora配置文件的情况下，如果启动监听，则监听为动态注册。用图形化netca创建...
    99+
    2022-10-18
  • 关于Android的静态注册和动态注册以及跨平台的静态和动态注册的理解
    Android的静态注册和动态注册以及跨平台的静态和动态注册的理解 何为Android广播： Android广播就是一个全局大喇叭，就是告知，就...
    99+
    2022-06-06
    静态 跨平台 动态 Android
  • Android的广播Receiver动态注册和静态注册示例
    广播接收器注册一共有两种形式 : 静态注册和动态注册. 两者及其接收广播的区别: 1.动态注册的广播 永远要快于 静态注册的广播,不管静态注册的优先级设置的多高,不管动态注册的...
    99+
    2022-06-06
    示例 静态 Android
  • Oracle DBA如何监听的静态注册与动态注册
    这篇文章主要介绍“Oracle DBA如何监听的静态注册与动态注册”，在日常操作中，相信很多人在Oracle DBA如何监听的静态注册与动态注册问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，...
    99+
    2022-10-19
  • Android中使用Receiver怎么实现动态注册与静态注册
    Android中使用Receiver怎么实现动态注册与静态注册？针对这个问题，这篇文章详细介绍了相对应的分析和解答，希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。广播接收器注册一共有两种形式 : 静态注册和动态注册.两者及其接...
    99+
    2023-05-31
    android receiver roi
  • BroadcastReceiver静态注册案例详解
    BroadcastReceiver静态注册案例演示，供大家参考，具体内容如下 静态注册与动态注册的区别： 动态注册：广播接收器可以自由的控制注册与取消，具有很大的灵活性。但只有在应用...
    99+
    2022-11-13
  • 注册静态监听（Register static listener）
    1. 首先进去 $ORACLE_HOME/network/admin 目录下，修改 listener.ora     go to  $ORACLE_H...
    99+
    2022-10-18
  • Android静态,动态注册与跨平台接收广播
    Android静态,动态注册与跨平台接收广播 静态注册 在activity_main.xml 中添加一个button，用来发送广播的点击事件 ...
    99+
    2022-06-06
    跨平台 动态 Android
  • 如何注册动态域名
    注册动态域名的方法：1、搜索注册动态域名的网站。2、进入网站并注册账号。3、登录网站后点击创建DNS解析并在下拉菜单栏中选择：动态域名设置。4、设置域名。5、将不固定的IP地址与域名捆绑起来即可。具体操作步骤：在浏览器中搜素并选择一个能注册...
    99+
    2022-10-21
  • Android关于广播的静态注册和动态注册及广播数据写入界面的心得体会
    Android关于广播的静态注册和动态注册及广播数据写入界面的心得体会 记得在我上学的时候，每个班级的教室里都会装有一个喇叭，这些喇叭都是接入到...
    99+
    2022-06-06
    界面 数据 静态 动态 Android
  • 深入Android中BroadcastReceiver的两种注册方式（静态和动态）详解
    今天我们一起来探讨下安卓中BroadcastReceiver组件以及详细分析下它的两种注册方式。 BroadcastReceiver也就是“广播接收者”的意思，顾名思义，它就是...
    99+
    2022-06-06
    静态 动态 Android
  • BroadcastReceiver动态注册案例详解
    BroadcastReceiver动态注册案例演示，供大家参考，具体内容如下 此案例共介绍2种动态注册广播接收器，为自定义广播接收器和系统广播接收器。当点击发送按钮后，将会弹出收到自...
    99+
    2022-11-13
  • 怎么动态注册Bean到Spring
    这篇文章主要介绍了怎么动态注册Bean到Spring的相关知识，内容详细易懂，操作简单快捷，具有一定借鉴价值，相信大家阅读完这篇怎么动态注册Bean到Spring文章都会有所收获，下面我们一起来看看吧。1、理论一般如果想将类注册到sprin...
    99+
    2023-06-29
  • SpringBean和Controller如何实现动态注册与注销
    这篇文章主要讲解了“SpringBean和Controller如何实现动态注册与注销”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“SpringBean和Controller如何实现动态注册与...
    99+
    2023-07-05
  • BeanDefinitionRegistryPostProcessor如何动态注册Bean到Spring
    目录1、理论2、实战代码总结下1、理论 一般如果想将类注册到spring容器，让spring来完成实例化，常用方式如下： xml中通过bean节点来配置；使用@Service、@Co...
    99+
    2022-11-13
  • Android中怎么实现动态注册
    这期内容当中小编将会给大家带来有关Android中怎么实现动态注册，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。第一种写法：首先新建一个Java类，通过"New/Other/Broadcast ...
    99+
    2023-06-04
  • Android中怎么利用广播实现静态注册
    Android中怎么利用广播实现静态注册，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。而Android中的广播机制则更为灵活，因为每个应用程序可以对自己感兴趣的广播进行注册，这...
    99+
    2023-06-04
软考高级职称资格查询
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作