监听注意事项

时间:2022-12-18 21:01:02

[oracle@ocm1 admin]$ vi listener.ora

lsnr1 =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.101)(PORT=1527))
)

SID_LIST_LSNR1=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(SID_NAME=orcl)
(ORACLE_HOME=/oracle/product/)
)
)

监听的名字一定要顶到文件的开头,不能有空格,否则认不出来监听名字。