131 积分	1 好友	13 主题

发消息

[SQL调优] alter system register不起作用

1^#

发表于 2014-8-20 17:30:52 | 查看: 5681| 回复: 5

各位，我在使用alter system register进行动态注册的时候，发现这个命令没有起作用，不知道什么原因，能否帮我看看。多谢啊
环境信息如下:
os：redhat6.4
db version:
BANNER                                                                            CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production             0
PL/SQL Release 12.1.0.2.0 - Production                                                 0
CORE 12.1.0.2.0    Production                                                             0
TNS for Linux: Version 12.1.0.2.0 - Production                                           0
NLSRTL Version 12.1.0.2.0 - Production                                                 0

hosts
[root@localhost tmp]# more /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1       localhost localhost.localdomain localhost6 localhost6.localdomain6
10.152.12.199 localhost.localdomain
lis文件如下
[oracle@localhost admin]$ 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             string
db_file_name_convert                string
db_name                            string    orcl12c
db_unique_name                      string    orcl12c
global_names                      boolean    FALSE
instance_name                      string    ORCL12C
lock_name_space                   string
log_file_name_convert             string
pdb_file_name_convert             string
processor_group_name                string
service_names                      string    T1
SQL>
监听状态如下:
[oracle@localhost ~]$ 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                   LISTENER
Version                TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date             20-AUG-2014 03:21:40
Uptime                   0 days 1 hr. 44 min. 35 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /home/oracle/product/12102/dbhome_1/network/admin/listener.ora
Listener Log File       /home/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening 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
[oracle@localhost ~]$

分享0

收藏0 回复只看该作者道具举报

harryzhang

2^#

发表于 2014-8-20 22:22:31

修改 local_listener ？

回复只看该作者道具举报

aaaaaaaa2000

3^#

发表于 2014-8-21 09:09:52

SQL> show parameter local;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
local_listener                      string
parallel_force_local                boolean    FALSE

监听是在1521端口上不需要设置local_listener吧

回复只看该作者道具举报