SQLDeveloper working, SQLPlus does not work [message #615838] |
Mon, 09 June 2014 18:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9b2c0415b29fb6e069a4f99a3d218857?s=64&d=mm&r=g) |
Andy804
Messages: 7 Registered: June 2014
|
Junior Member |
|
|
I am able to tnsping to my remote databases, I am able to SQLDeveloper connect to the remote databases without any problem. I am running Windows 7.
When I try SQLPlus command line, I record my user id and password and get a ORA-12560 TNS: Protocol Adapter error.
TNSNAMES.ORA file seems to work fine for TNSping and SQLDeveloper (below is an example remote database that I connect to).
QA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TLG0004.MYKFT.net)(PORT = 1521))
)
(CONNECT_DATA =
(SID = q153i0)
)
)
SQLNet.ORA file
NAMES.DEFAULT_DOMAIN = WORLD
NAMES.DIRECTORY_PATH= (tnsnames, onames, host)
Path includes C:\oracle\product\11.2.0.4\client_1\bin
TNS_ADMIN=C:\oracle\product\11.2.0.4\client_1\network\admin
Any suggestions on what I should look at next? I saw people mention listener, but the Oracle database is not running on my computer, it is a remote server that I connect to.
Thanks in advance
|
|
|
|
|
|
|
|
|
|
|
|
Re: SQLDeveloper working, SQLPlus does not work [message #615868 is a reply to message #615866] |
Tue, 10 June 2014 07:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21813 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Andy804, I think that your mistake is in not specifying the database name.
This is what you do:M:\>sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 14:15:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: trafogled
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
This is what you should do:
M:\>sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 14:15:33 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: trafogled@ora11 ------->>> this! Specify database name after the username
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
In your case, that would be
M:\>sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 14:17:45 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: kcahg00@qa --> this!
Enter password:
[Updated on: Tue, 10 June 2014 07:18] Report message to a moderator
|
|
|
|
|