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
Hi,

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 11.2.0.2.0 - Production on 08-MAY-2
013 08:47:06

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

Used parameter files:
C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Rocky-PC
)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
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.

Regards,

Jerald

Legend

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