ORACLE |
您所在的位置:网站首页 › oracle19c怎么打开 › ORACLE |
监听配置文件路径:$ORACLE_HOME/NETWORK/ADMIN/listener.ora 静态监听:如果知道数据库的信息,可以先在监听文件里面配置好要监听的数据库的实例名,并配置server名称,这种就是静态监听,因为这个监听服务器是由监听程序发起的,所以状态一直是UNKNOWN,且数据库关闭后这个监听还会存在; ===配置静态listener.ora文件 [oracle@microserver02 admin]$ vi listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.4.69)(PORT = 1527)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME =XIAMEN01) (ORACLE_HOME =/u01/app/oracle/product/12.2.0/dbhome_1) (SID_NAME =testdb) ) (SID_DESC & |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |