oracle添加静态监听

配置静态监听
[oracle@milk11G admin]$ cd $ORACLE_HOME/network/admin
[oracle@milk11G admin]$ pwd
/u01/oracle/app/oracle/product/11.2/network/admin
如果你是还想用原来的监听端口（1521）注册静态监听，那么如方法一
如果你要用其他端口注册监听例如1527，那么就如方法二

方法一：
[oracle@milk11G admin]$ cat listener.ora 
SID_LIST_LISTENER =    
  (SID_LIST =    
    (SID_DESC =    
      (SID_NAME = PLSExtProc)    
      (ORACLE_HOME =/u01/oracle/app/oracle/product/11.2/ )         ----------根据你的环境修改
      (PROGRAM = extproc)    
    )    
    
    (SID_DESC =    
      (GLOBAL_DBNAME =milk11G )                           ----------根据你的环境修改
      (ORACLE_HOME = /u01/oracle/app/oracle/product/11.2/)     ----------根据你的环境修改
      (SID_NAME =milk11G)                                   ----------根据你的环境修改
    )        
  )
方法二：
[oracle@milk11G admin]$ cat listener.ora 
listener_1527 =                                                             
  (DESCRIPTION_LIST =                                              
    (DESCRIPTION =                                                 
      (ADDRESS_LIST =                                              
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.2)(PORT = 1527)) 
      )                                                            
    )                                                              
  )  
SID_LIST_listener_1527 =                                                    
  (SID_LIST =                                                      
   (SID_DESC =                                                     
      (ORACLE_HOME = /u01/oracle/app/oracle/product/11.2/)         
      (SID_NAME = milk11G)
      (GLOBAL_DBNAME = milk11G)                                           
    )                                                              
  )

最后你要是用方法一，记得重启监听
[oracle@milk11G admin]$  lsnrctl stop 
[oracle@milk11G admin]$ lsnrctl start
[oracle@milk11G admin]$ lsnrctl status查看状态
要是显示末尾两行如下的话：
The listener supports no services
The command completed successfully
那就进行入下操作：
oracle@milk11G admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 24 22:39:15 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system register;                            ---------可以多跑几次
System altered.

如方法二的话也要拉起对应的监听就行
[oracle@milk11G admin]$  lsnrctl start listener_1527

 

2020 16:09:13ORA-17628: Oracle error 19505 returned by remote Oracle server
解决此问题有两种方法：
第一种是在listener.ora中直接将实例信息静态注册到监听
[oracle@zlj admin]$ more listener.ora
SID_LIST_LISTENER =  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = rac)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = rac1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.22)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

第二种是修改tnsname.ora中的内容，在连接串中添加(UR=A)可以在数据库nomount状态下连接成功
[oracle@zlj admin]$ vi tnsnames.ora
rac=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.22)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
     (UR=A)
    )
  )