oracle创建静态监听

[oracle@localhost admin]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@localhost admin]$ cat listener.ora
SID_LIST_listener=
(SID_LIST=
  (SID_DESC=
   (SID_NAME=orcl)
   (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
  )
)


启动监听

[oracle@localhost admin]$ lsnrctl start


tns配置

test_db =
(DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.160)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SID = orcl)
     )
)

posted @ 2018-12-19 13:39  bugbeta  阅读(1220)  评论(0)  编辑  收藏  举报