做网站要用框架吗,百度品牌广告多少钱一个月,南宁seo产品优化服务,怎么在windows做网站静态注册#xff1a;通过解析listene.ora文件 动态注册#xff1a;由PMON进程动态注册至监听中 在没有listener.ora配置文件的情况下#xff0c;如果启动监听#xff0c;则监听为动态注册。用图形化netca创建的监听#xff0c;默认也为动态注册 1.静态注册 listener.ora文…静态注册通过解析listene.ora文件 动态注册由PMON进程动态注册至监听中 在没有listener.ora配置文件的情况下如果启动监听则监听为动态注册。用图形化netca创建的监听默认也为动态注册 1.静态注册 listener.ora文件监听的配置文件静态注册读取该文件动态注册不必要 可以通过netca工具创建也可以手动编辑。典型的listener.ora文件内容 LISTENER_PHAMR (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST phamrdb1-vip)(PORT 1521)) ) SID_LIST_LISTENER_PHALR (SID_LIST (SID_DESC (GLOBAL_DBNAME phalr) (ORACLE_HOME /oracle/product/11.2.0) (SID_NAME phalr) ) ) listener.ora文件两大模块 LISTENER模块监听名字、连接协议、监听主机、监听端口等基本配置信息 SID_LIST_LISTENER模块配置监听的静态注册特性包含数据库服务名、ORACLE_HOME、实例名等信息。 注意SID_NAME就是数据库实例名在Linux环境大小写敏感 GLOBAL_DBNAME就是数据库服务名,可以省略默认和SID_NAME保持一致也可以不一致。 ORACLE_HOME默认和$ORACLE_HOME环境变量保持一致。Windows该参数无效取自注册表。 静态注册监听不知道实例的具体状态所以监听启动之初查看实例信息其状态信息显示为UNKNOWN.例如 oraclephamrdb1: /home/oracle lsnrctl status LISTENER_PHAMR LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-NOV-2016 17:17:37 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOSTphamrdb1-vip)(PORT1521))) STATUS of the LISTENER ------------------------ Alias LISTENER_PHAMR Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 01-OCT-2016 14:12:51 Uptime 47 days 3 hr. 4 min. 45 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/product/11.2.0/network/admin/listener.ora Listener Log File /oracle/diag/tnslsnr/phamrdb1/listener_phamr/alert/log.xml Listening Endpoints Summary... (DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOST10.178.1.64)(PORT1521))) Services Summary... Service phamr has 1 instance(s). 监听状态中的服务名 Instance phamr, status UNKNOWN, has 1 handler(s) for this service... 监听状态中的实例名 The command completed successfully 2动态注册 在动态注册监听的环境中listener.ora文件可以不包括当前数据库的实例信息所以这个文件不必要。 实例启动时会由Oracle PMON进程将数据库实例信息动态注册至监听上。 当Oracle实例关闭时会再次由PMON进程自动从监听里面撤销当前实例信息。 所以要实现动态注册数据库的实例至少要处于nomount状态 监听动态注册时的实例状态来自PMON进程动态注册时的实例状态一般有3种状态READY、BLOCKED和RESTRICED READY表示数据库实例已经处于mount或者open状态可以接受客户端连接 BLOCKED表示数据库实例还处于nomount状态或者该实例类型为ASM实例不接受客户端连接如果这时候客户端去连 接数据库会报ora-12528错误 RESTRICED表示数据库处于RESTRICED模式不接受普通权限的远程客户端连接如果这时候客户端去连接数据库会报 ora-12526错误 oraclefsdata: /oracle/product/11.2.0/network/admin lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-NOV-2016 16:01:43 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS(PROTOCOLtcp)(HOST)(PORT1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 17-NOV-2016 15:57:23 Uptime 0 days 0 hr. 4 min. 19 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /oracle/diag/tnslsnr/fsdata/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOSTfsdata)(PORT1521))) Services Summary... Service FSDATA has 1 instance(s). Instance FSDATA, status READY, has 1 handler(s) for this service... Service FSDATAXDB has 1 instance(s). Instance FSDATA, status READY, has 1 handler(s) for this service... The command completed successfully oraclefsdata: /oracle/product/11.2.0/network/admin lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-NOV-2016 15:58:47 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS(PROTOCOLtcp)(HOST)(PORT1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 17-NOV-2016 15:57:23 Uptime 0 days 0 hr. 1 min. 23 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /oracle/diag/tnslsnr/fsdata/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOSTfsdata)(PORT1521))) Services Summary... Service FSDATA has 1 instance(s). Instance FSDATA, status BLOCKED, has 1 handler(s) for this service... The command completed successfully 实例既可以动态注册同时静态注册状态分别显示为READY和UNKNOWN oraclefsdata: /oracle/product/11.2.0/network/admin lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-NOV-2016 17:50:14 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOSTfsdata)(PORT1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 17-NOV-2016 15:57:23 Uptime 0 days 1 hr. 52 min. 50 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/product/11.2.0/network/admin/listener.ora Listener Log File /oracle/diag/tnslsnr/fsdata/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOSTfsdata)(PORT1521))) Services Summary... Service FSDATA has 2 instance(s). Instance FSDATA, status UNKNOWN, has 1 handler(s) for this service... Instance FSDATA, status READY, has 1 handler(s) for this service... Service FSDATAXDB has 1 instance(s). Instance FSDATA, status READY, has 1 handler(s) for this service... The command completed successfully 3.监听的常用命令 lsnrctl start [listener_name] lsnrctl stop [listener_name] lsnrctl status [listener_name] lsnrctl service [listener_name] lsnrctl reload [listener_name] 4.监听的别名 监听默认名字是LISTENER可以配置别名 oraclefsdata: /dump ps -ef | grep tnslsnr | grep -v grep oracle 29598 1 0 15:57 ? 00:00:00 /oracle/product/11.2.0/bin/tnslsnr LISTENER -inherit oraclephamrdb1: /home/oracle ps -ef | grep tnslsnr| grep -v grep oracle 38300 1 0 Oct01 ? 06:21:54 /oracle/product/11.2.0/bin/tnslsnr LISTENER_PHAMR –inherit转载于:https://www.cnblogs.com/andy6/p/7453395.html
