CODEWITHSUNDEEP
oracle-databaseoracle11goracle-sqldeveloper
Vishal Zanzrukia
Vishal Zanzrukia

Reputation: 4973

Not able to connect to oracle database using Oracle SQL Developer

I am new to Oracle, I have installed Oracle Server 11g2 and Oracle SQL Developer (client) tool.

I am able to connect server from command prompt successfully, please have a look here : http://prntscr.com/hytzdn

I am trying to connect the server from Oracle SQL Developer (client) tool but it's not allowing me. I am getting this SID specific error : http://prntscr.com/hyu1i2

Can someone please help me to resolve this? Thanks in advance.

Upvotes: 0

Views: 63

Answers (1)

Aydın Özgür
Aydın Özgür

Reputation: 24

In your command prompt connection type this query

select * from global_name;

Then in sql developer change your sid name with the query result.

Upvotes: 1

Related Questions