Oracle 绑定后无法通过指定 IP 访问,求教
如题,有一台 linux 机器上要装 oracle,折腾半天了。
现在服务已经安装成功,并且正常启动。
使用如下命令启动成功:
sudo lsnrctl start sqlplus /nolog conn / as sysdba startup
并且在这种访问模式下能够成功获取到数据
SQL> select * from scott.dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON
于是把服务绑定到局域网 IP,想要从另一台机器上登录,修改了 listener.ora
# Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /home/rogear/tools/oracle11g
和 tnsnames.ora
# tnsnames.ora Network Configuration File: /home/rogear/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
然后重启数据库和监听程序。
这时候使用登录命令会得到提示:
sqlplus scott/[email protected]:1521/orcl ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
请问可能是什么原因造成的? 当前可以确保网络是连同的,确实能访问到 192.168.1.100:1521 上的程序,但是登录失败,怎么回事呢