linux系统Oracle创建监听程序
使用netca配置监听程序:
[root@ora ~]# xhost + 192.168.6.1
192.168.6.1 being added to access control list
[root@ora ~]# su - oracle
[oracle@ora admin]$ pwd
/u01/app/oracle/product/11.2.0/db_1/network/admin
[oracle@ora admin]$ ls
samples shrept.lst
[oracle@ora admin]$ DISPLAY=192.168.6.1:0.0
[oracle@ora admin]$ export DISPLAY
[oracle@ora admin]$ netca
Oracle Net Services Configuration:
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150755175-1950432710.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150801213-674051916.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150807152-636016424.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150812472-1043934831.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150818535-2040545940.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150825397-1286810467.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150832187-1501318009.png)
![](https://img2020.cnblogs.com/blog/2163941/202009/2163941-20200923150838321-1981994979.png)
Configuring Listener:LISTENER
Listener configuration complete.
Configuring Listener:LISTENER
Listener configuration complete.
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
创建完成后会在$ORACLE_HOME/network/admin下自动生成一个listener.ora的文件:
[oracle@ora admin]$ ls
listener.ora samples shrept.lst
[oracle@ora admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /u01/app/oracle