oracle - SQLPLUS错误:ORA-12504:在CONNECT_DATA中未为TNS:listener提供SERVICE_NAME

Question

我从Oracle下载了SQLPLUS:

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Basic Lite和SQL * Plus

然后，我启动了SQL * Plus:

c:\Program Files\Oracle\instantclient_12_1>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 15 15:25:36 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

并尝试连接到数据库:

connect user\password@hostname

并收到错误消息:

ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

我想念什么？

我运行了雅库布(Jakub)建议的查询，

SQL> select sys_context('USERENV','SERVICE_NAME') from dual;

SYS_CONTEXT('USERENV','SERVICE_NAME')
--------------------------------------------------------------------------------

SYS$USERS

SQL> select sys_context('USERENV','SID') from dual;

SYS_CONTEXT('USERENV','SID')
--------------------------------------------------------------------------------

877

SQL>

Answer 1

您缺少服务名称:

 SQL> connect username/password@hostname:port/SERVICENAME

编辑

如果可以从其他计算机连接到数据库，请尝试在该计算机上运行:

select sys_context('USERENV','SERVICE_NAME') from dual

和

select sys_context('USERENV','SID') from dual