oracle10g 无法注册动态监听

aaaaaaaa2000

os:

1. [oracle@oracle10-t ~]$ uname -a
   
2. Linux oracle10-t 2.6.39-300.26.1.el5uek #1 SMP Thu Jan 3 18:31:38 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

复制代码

db:

1. SQL> select * from v$version where rownum<2;
   
2. 
   
3. BANNER
   
4. ----------------------------------------------------------------
   
5. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
   

复制代码

使用的是单机的ASM环境
监听信息:

1. [oracle@oracle10-t dbs]$ lsnrctl status
   
2. 
   
3. LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-DEC-2013 09:51:47
   
4. 
   
5. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
   
6. 
   
7. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.5)(PORT=1521))
   
8. STATUS of the LISTENER
   
9. ------------------------
   
10. Alias                     LISTENER
    
11. Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
    
12. Start Date                19-DEC-2013 09:44:13
    
13. Uptime                    0 days 0 hr. 7 min. 34 sec
    
14. Trace Level               off
    
15. Security                  ON: Local OS Authentication
    
16. SNMP                      OFF
    
17. Listener Parameter File   /home/oracle/ora10g/product/10201/db_1/network/admin/listener.ora
    
18. Listener Log File         /home/oracle/ora10g/product/10201/db_1/network/log/listener.log
    
19. Listening Endpoints Summary...
    
20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.5)(PORT=1521)))
    
21.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
    
22. Services Summary...
    
23. Service "+ASM" has 1 instance(s).
    
24.   Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
    
25. Service "orcl" has 1 instance(s).
    
26.   Instance "ora10test", status UNKNOWN, has 1 handler(s) for this service...
    
27. The command completed successfully
    
28. [oracle@oracle10-t dbs]$

复制代码

监听配置文件

1. [oracle@oracle10-t admin]$ more listener.ora
   
2. 
   
3. LISTENER =
   
4.   (ADDRESS_LIST=
   
5.        (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.5)(PORT=1521))
   
6.        (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
   
7. SID_LIST_LISTENER=
   
8.    (SID_LIST=
   
9.         (SID_DESC=
   
10.           (GLOBAL_DBNAME=orcl)
    
11.           (SID_NAME=ora10test)
    
12.           (ORACLE_HOME=/home/oracle/ora10g/product/10201/db_1)
    
13.         )
    
14.         (SID_DESC =
    
15.         (GLOBAL_DB_NAME = ASM)
    
16.         (ORACLE_HOME = /home/oracle/ora10g/product/10201/db_1)
    
17.         (SID_NAME = +ASM)
    
18.         )
    
19. )
    
20. SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

复制代码

TNS_ADMIN空

1. [oracle@oracle10-t admin]$ echo $TNS_ADMIN
   
2. 
   
3. [oracle@oracle10-t admin]$

复制代码

service_name:

1. SQL> show parameter name
   
2. 
   
3. NAME                                 TYPE        VALUE
   
4. ------------------------------------ ----------- ------------------------------
   
5. db_file_name_convert                 string
   
6. db_name                              string      ora10tes
   
7. db_unique_name                       string      ora10test
   
8. global_names                         boolean     FALSE
   
9. instance_name                        string      ora10test
   
10. lock_name_space                      string
    
11. log_file_name_convert                string
    
12. service_names                        string      ora10test

复制代码

现在ora10test服务无法注册到监听里，不知道什么地方出了，请刘大帮忙看一下，多谢

vict_

手工注册一下呢？
看下local_listner

lunar

把  SID_LIST_LISTENER 去掉试试看

aaaaaaaa2000

恩，现在想用动态注册，但总是不起作用

Liu Maclean(刘相兵

Service "orcl" has 1 instance(s).
  Instance "ora10test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

不是有静态注册吗？