Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listener refused the connection error : ORA - 12505 TRIED EVERYTHING

947836Jul 6 2012 — edited Jul 10 2012
Hi, I am new to Oracle using version 11g . I am using Windows XP 32 bit.My Host name is co-67349b991dc4, port 1521, SID - sid1. My problem is that I am unable to connect to start Oracle SQL developer .

Everytime I try to connect I am getting this error:-

Listener refused the connection error : ORA - 12505, TNS: listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was: co-67349b991dc4:1521:sid1

I read almost every forums of oracle dot com but in vain. I am posting my tnsnames.ora and listener.ora files. Any help will be highly appreciated.


tnsnames.ora

# tnsnames.ora Network Configuration File: F:\app\rk\product\11.1.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co-67349b991dc4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)




listener.ora

# listener.ora Network Configuration File: F:\app\rk\product\11.1.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = co-67349b991dc4)(PORT = 1521))
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2012
Added on Jul 6 2012
14 comments
7,214 views