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:
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