section1问题求教

harrysb101

如下所示：按参考资料将section1中的所有试题做完后

用tnsping可以Ping通
但是sqlplus用conn sys/oracle@prod as sysdba报错
---------------------------------------------------------------
[oracle@station17 ~]$ tnsping prod

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 18-SEP-2015 17:31:23

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=station17.example.com)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=PROD)))
OK (10 msec)


----------------------------------------------------------------------------------------
[oracle@station17 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Sep 18 17:31:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> conn sys/oracle@prod as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

admin

tnsping能ping通只说明：网络通，数据库没开都会通。
问题出在：服务注册方面。

jackson

有没有注意到服务名的大小写，大写试试看