oracle 重建监听服务器,配置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：测试是否能够正常连接数据库