2 Replies Latest reply: May 8, 2013 12:16 PM by Peter Jerald RSS

    Unable to connect oracle XE in SQL IDE tools

    Peter Jerald

      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 : http://i42.tinypic.com/2a4zbsj.jpg

      SQL Developer screenshot : http://i43.tinypic.com/k4yxle.jpg

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