linux/windows 修改默认1521端口

linux:

alter system set local_listener="(address = (protocol = tcp)(host = 10.1.1.6)(port = 11521))";

windows：

1：找到listener.ora tnsnames.ora 两个文件 页面误操作 建议备份

我这里路径：D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

2.分别修改2文件

       (SID_DESC =
       (GLOBAL_DBNAME = ORCL)
       (ORACLE_HOME =D:\app\Administrator\product\11.2.0\dbhome_1)  
       (SID_NAME = ORCL)

linux6ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.6)(PORT = 11521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = master.orcl.com)
    )
  )
 

3放开相应端口这里以windows为例：

 

 

 

测试成功