Cannot create connection in Oracle SQL Developer

oracle oracle-sqldeveloper ora-12560
Mansoor Gee picture Mansoor Gee · Nov 23, 2011 · Viewed 7k times · Source

I am a new user in Oracle. In Oracle SQL Developer, whenever I want to create a new connection and fill the "New Database Connection" form, it gives me this error: -

ORA-12560: TNS:protocol adapter error

Please Help.

Answer

Ollie picture Ollie · Nov 23, 2011

To add more to my comment on the question...

Ensure your database is open (has been started up).

  1. Start all oracle services for your database
  2. Start the databases listener (lsnrctl start)
  3. Startup your database instance (startup open <database_name>)

Also, ensure the database you are trying to connect to has an entry in the tnsnames.ora file your SQL Developer is using (depending upon your setup you may have a tnsnames.ora for both your oracle client and database software if they are on the same physical hardware like your PC or laptop).

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More