This discussion is archived
2 Replies Latest reply: May 8, 2013 10:16 AM by Peter Jerald RSS

Unable to connect oracle XE in SQL IDE tools

Peter Jerald Newbie
Currently Being Moderated

Recently i installed Oracle 11g in my windows7 machine. Oracle DB server running without any issues. Please find below tnslistner logs.

C:\oraclexe\app\oracle\product\11.2.0\server\bin>tnsping.exe xe

TNS Ping Utility for 32-bit Windows: Version - Production on 08-MAY-2
013 08:47:06

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Rocky-PC
OK (20 msec)

Service Name is also there, DB connections are good. I am able to login the webconsole(i.e. webIDE) in oracle without any issues of now.

But the same i tried to connect SQL IDE tools(i.e. Sql developer) with same creditionals. I am getting login access denied ORA -101017 but using the same credtionals i am able to login in webconsole(i.e. webIDE ... apex) .Even i am unable to connect as sysdba.

Here is the list users i created in oracle DB :

SQL Developer screenshot :

Any body pls help me to solve this issue. Thanks in advance.




  • Correct Answers - 10 points
  • Helpful Answers - 5 points