数据库监听安装默认localhost,此时无法被他人访问,需要修改监听为ip.
两种方式:
1、oracle安装路径里边的 net Manager 监听程序Listener修改localhost为ip,ipconfig查看个人网络ip
2、直接修改自己的listener.ora文件中的host地址为ip
如下图
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\daily\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\daily\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\daily\oracle\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\daily\oracle
监听配置好需要重新启动监听服务。相关指令参考如下。
服务启动与停止:
net start oracleserviceorcl
net stop oracleserviceorcl
监听启动与停止:
lsnrctl start
lsnrctl stop