---- listener.ora ----
t0cxcc =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.9.11)(PORT = 1533))
)
)
)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.9.11)(PORT = 1533))
)
)
)
SID_LIST_t0cxcc =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME =/paic/hq/t0cxcc/rdbms/oracle/product/11.2.0)
(SID_NAME = t0cxcc)
)
)
sqlplus '/ as sysdba'
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.31.9.11)(PORT=1533)))' scope=both;
(SID_LIST =
(SID_DESC =
(ORACLE_HOME =/paic/hq/t0cxcc/rdbms/oracle/product/11.2.0)
(SID_NAME = t0cxcc)
)
)
sqlplus '/ as sysdba'
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.31.9.11)(PORT=1533)))' scope=both;
---- tnsnames.ora ----
t0cxcc =(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.31.9.11)(PORT=1533))(connect_data =(sid = t0cxcc )))
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-747193/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
