配置Oracle服务器监听

1：配置监听服务

[oracle@localhost admin]$cd /u01/app/product/11.2.0/dbname_1/network/admin

[oracle@localhost admin]$ ls

listener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora

[oracle@localhost admin]$ [oracle@localhost admin]$ vi listener.ora

a：动态监听可以不用配置，只需要将localhost修改为对应的本机ip地址；

b：配置如下静态监听服务；

SID_LIST_LISTENER=

(SID_LIST=

        (SID_DESC=

                (GLOBAL_DBNAME=orcl)

                (ORACLE_HOME=/u01/app/product/11.2.0/dbname_1)

                (SID_NAME=orcl)

        )

)

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.190)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = /u01/app

2：配置客户机或本地服务器TNS

[oracle@localhost admin]$ cd /u01/app/product/11.2.0/dbname_1/network/admin

[oracle@localhost admin]$ vi tnsnames.ora

my_orcl =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.190)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl

    )

  )

3：测试是否能够正常连接数据库