配置监听

更改主机名方法

跟主机名相关的文件有两个分别是

[root@localhost ~]# cat /etc/hosts

[root@localhost ~]# cat /etc/sysconfig/network

修改方法两个文件都要修改 

[root@localhost ~]# vi /etc/hosts

其中hosts里的主机名 对应一个ip 所以更改的同事要记住 分配一个ip

[root@localhost ~]# vi /etc/sysconfig/network

修改HOSTNAME=主机名

重启生效或者用hostname 主机名 命令来切换

配置监听报错

执行netca报错解决方法

[oracle@node1 12:37:13|~]netca

Oracle Net Services Configuration:

Xlib: connection to ":0.0" refused by server

Xlib: No protocol specified

java.lang.NullPointerException

        at oracle.ewt.lwAWT.BufferedApplet.(Unknown Source)

        at oracle.net.ca.NetCA.(Unknown Source)

        at oracle.net.ca.NetCA.main(Unknown Source)

Oracle Net Services configuration failed.  The exit code is -1

图形界面打不开

解决方法切换到root用户下执行xhost +

oracle网络配置 
三个配置文件 listener.ora、sqlnet.ora、tnsnames.ora ，都是放在$ORACLE_HOME/network/admin目录下。

监听进程的配置文件listenter.ora

查阅官方文档

 

Net Services Reference----&gt7 Listener Parameters (listener.ora)-------&gtListener Parameters7.1

[oracle@node1 20:52:14|/oracle/product/1020/network/admin]cat listener.ora

# listener.ora Network Configuration File: /oracle/product/1020/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER=

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=tcp)(HOST=lgy)(PORT=1521))

    )

SID_LIST_LISTENER=

  (SID_LIST=

    (SID_DESC=

      (GLOBAL_DBNAME=PROD)

      (SID_NAME=PROD)

      (ORACLE_HOME=/oracle/product/1020)

      )

    (SID_DESC=

      (GLOBAL_DBNAME=emrep)

      (SID_NAME=emrep)

      (ORACLE_HOME=/oracle/product/1020)

      ))

lsnr2 =

 (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=tcp)(HOST=lgy)(PORT=1526))

)

2.创建tnsnames.ora

参考官方文档

Net Services Reference----&gt6 Local Naming Parameters (tnsnames.ora)----&gt6-1

[oracle@node1 20:52:14|/oracle/product/1020/network/admin]cat tnsnames.ora

# tnsnames.ora Network Configuration File: /oracle/product/1020/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

prod =

 (description =

      (ADDRESS_LIST=

              (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))

      )

      (connect_data =

              (server = dedicated)

              (service_name = prod)

      )

 )

prod_s =

 (description =

      (ADDRESS_LIST=

              (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1526))

      )

      (connect_data =

              (server = shared)

              (service_name = prod)

      )

 )

emrep =

 (description =

      (ADDRESS_LIST=

              (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))

      )

      (connect_data =

              (server = dedicated)

              (service_name = emrep)

      )

 )

racdb =

 (description =

      (ADDRESS_LIST=

              (ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521))

              (ADDRESS=(PROTOCOL=tcp)(HOST=rac2)(PORT=1521))

      )

      (connect_data =

              (server = dedicated)

              (service_name = racdb)

      )

 )

lsnr2 =

 (description =

      (ADDRESS_LIST=

              (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1526))

      )

 )

 

3.生成sqlnet.ora

[oracle@node1 20:52:14|/oracle/product/1020/network/admin]vi sqlnet.ora

加入 NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

监听启动

lsnrctl stat

    

关闭监听

lsnrctl stop

查看监听状态

lsnrctl status

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29638498/viewspace-1317273/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29638498/viewspace-1317273/