安装oracle输密码就报错,求助linux下安装oracle11g,sqlplus可以连,用户+密码+DB名报错...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

本机是win7的 装个VM虚拟机里面装的rhel6.5的操作系统，在linux里安装玩oracle11g后，输入命令$sqlplus然后在输入用户与密码可以连到数据库，但是用$sqlplus system/oracle@orcl 却报错，提示

“ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor”

然后跳出单独输账户密码，这样却可以进。。。

我数据库里吗配置了两个databse，监听也对应有两个；

LISTENER2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.129)(PORT = 1521))

)

(SID_DESC =

(GLOBAL_DBANAME = testdb.com)

(ORACLE_HOME = /opt/oracle/product/OraHome)

(SID_NAME = TESTDB)

)

)

ADR_BASE_LISTENER2 = /opt/oracle

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.129)(PORT = 1521))

)

(SID_DESC =

(GLOBAL_DBANAME = orcl.com)

(ORACLE_HOME = /opt/oracle/product/OraHome)

(SID_NAME = ORCL)

)

)

ADR_BASE_LISTENER = /opt/oracle

tnsname.ora：

TESTDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.129)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = testdb.com)

)

)

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.129)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.com)

)

)

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.48.129)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 16-OCT-2014 15:04:11

Uptime 0 days 0 hr. 45 min. 3 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /opt/oracle/product/OraHome/network/admin/listener.ora

Listener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.129)(PORT=1521)))

The listener supports no services(这个信息是报什么错呢)

The command completed successfully

我从本机远程连接也连不上报错ora-12514。。。 折腾了几天了网上查各种说法，不知道怎么办了，求大神看看指导一下