SQLPLUS错误:ORA-12504:在CONNECT_DATA中未为TNS:listener提供SERVICE_NAME [英] SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

问题描述

我从Oracle下载了SQLPLUS:

I downloaded SQLPLUS from Oracle:

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

Basic Lite和SQL * Plus

Basic Lite and SQL*Plus

然后我启动了SQL * Plus:

I then fired up 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)建议的查询，

I ran the queries suggested by Jakub, I got

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>

推荐答案

您缺少服务名称:

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

编辑

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

If you can connect to the database from other computer try running there:

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

和

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

这篇关于SQLPLUS错误:ORA-12504:在CONNECT_DATA中未为TNS:listener提供SERVICE_NAME的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！