Recently i installed Oracle 11g in my windows7 machine. Oracle DB server running without any issues. Please find below tnslistner logs.
TNS Ping Utility for 32-bit Windows: Version 184.108.40.206.0 - Production on 08-MAY-2
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
)(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.
You are trying to connect to database using apex credentials, please find the schema name associated with your apex user and use that to connect to database.
To list users of your database start sqlplus session and fire the below sql
sqlplus / as sysdba
select username from dba_users;
Thanks a lot Yoonas,
I thought both apex users and XE schema users are same, thats why i tried to connect in sql client.
I have created new user and i am able to connect from sql client.
My issue resolved. Once again, thanks a lot.