oracle指定ip指定用户访问,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 上的程序，但是登录失败，怎么回事呢