Oracle远程访问配置
-
教你oracle如何 配置开启远程访问方法
1. 修改监听配置文件listener.ora，添加行：LISTENER = (DESCRIPTION_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)))，2. 修改tnsnames.ora文件，确保主机名和端口号正确。，3. 重启监听服务：lsnrctl start，4. 设置oracle用户密码策略，允许远程访问：ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; ALTER PROFILE DEFAULT PASSWORD_REUSE_MAX UNLIMITED; ALTER PROFILE DEFAULT PASSWORD_REUSE_TIME UNLIMITED;，5. 授权远程访问：GRANT CONNECT, RESOURCE TO 用户名 IDENTIFIED BY 密码 USING '连接类型';，6. 刷新权限：FLUSH PRIVILEGES;
