进入cmd
sqlplus / as sysdba
查询监听
SHOW PARAMETER LOCAL_LISTENER;
修改监听IP
ALTER SYSTEM SET LOCAL_LISTENER=’(ADDRESS=(PROTOCOL=TCP)(HOST=新IP地址)(PORT=1521))’;
启动监听
LSNRCTL START
进入cmd
sqlplus / as sysdba
查询监听
SHOW PARAMETER LOCAL_LISTENER;
修改监听IP
ALTER SYSTEM SET LOCAL_LISTENER=’(ADDRESS=(PROTOCOL=TCP)(HOST=新IP地址)(PORT=1521))’;
启动监听
LSNRCTL START