情况一:
C:\Documents and Settings\Administrator>sqlplus "system/solaris@li as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 4 08:38:15 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
情况二:
C:\Documents and Settings\Administrator>set oracle_sid=li
C:\Documents and Settings\Administrator>sqlplus "system/solaris as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 4 08:40:31 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
如果使用sid登陆则登陆不上去
tns.ora:
li =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL =TCP)(host=COMPUTER)(PORT=1521))
)
(CONNECT_DATA =
(service_name=LI)
)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
请高手帮解决一下
C:\Documents and Settings\Administrator>sqlplus "system/solaris@li as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 4 08:38:15 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
情况二:
C:\Documents and Settings\Administrator>set oracle_sid=li
C:\Documents and Settings\Administrator>sqlplus "system/solaris as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 4 08:40:31 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
如果使用sid登陆则登陆不上去
tns.ora:
li =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL =TCP)(host=COMPUTER)(PORT=1521))
)
(CONNECT_DATA =
(service_name=LI)
)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
请高手帮解决一下
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-136036/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8135069/viewspace-136036/