alter system register不起作用
各位,我在使用alter system register进行动态注册的时候,发现这个命令没有起作用,不知道什么原因,能帮我看看不。多谢啊环境信息如下:os:redhat6.4db version:BANNER CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0PL/SQL Release 12.1.0.2.0 - Production 0CORE 12.1.0.2.0 Production 0TNS for Linux: Version 12.1.0.2.0 - Production 0NLSRTL Version 12.1.0.2.0 - Production 0hosts# more /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain610.152.12.199 localhost.localdomainlis文件如下$ more listener.ora# listener.ora Network Configuration File: /home/oracle/product/12102/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.
LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.152.12.199)(PORT = 1521)) ))
SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home/oracle/product/12102/dbhome_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = orcl12c) (ORACLE_HOME = /home/oracle/product/12102/dbhome_1) (SID_NAME = ORCL12C) ))
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
数据库参数:SQL> show parameter name;
NAME TYPE VALUE------------------------------------ ----------- ------------------------------cell_offloadgroup_name stringdb_file_name_convert stringdb_name string orcl12cdb_unique_name string orcl12cglobal_names boolean FALSEinstance_name string ORCL12Clock_name_space stringlog_file_name_convert stringpdb_file_name_convert stringprocessor_group_name stringservice_names string T1SQL>监听状态如下:$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 20-AUG-2014 05:06:15
Copyright (c) 1991, 2014, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.152.12.199)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 12.1.0.2.0 - ProductionStart Date 20-AUG-2014 03:21:40Uptime 0 days 1 hr. 44 min. 35 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /home/oracle/product/12102/dbhome_1/network/admin/listener.oraListener Log File /home/oracle/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.152.12.199)(PORT=1521)))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "orcl12c" has 1 instance(s).Instance "ORCL12C", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully$
沒看到listener的parameter參數 监听不是起来了么?alter system register不起作用是什么意思? xue xi zhong !
页:
[1]