0

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.

Improve this question
6
  • Is your database open? This error can be seen when the database is not started. Commented Nov 23, 2011 at 13:24
  • 1
    I'll also post this question: do you have the Oracle Client software installed and thus an %oracle_home%/Network/Admin/tnsnames.ora file? If not, you can simply do a connection type of basic and avoid the tnsnames files altogether; or install the ora client and go from there. Commented Nov 23, 2011 at 13:36
  • @Ollie My database has already started. Commented Nov 24, 2011 at 4:53
  • @Mansoor Gee, is your listener started too? Commented Nov 24, 2011 at 9:11
  • @Ollie How can I check this that listener has started? Commented Nov 24, 2011 at 9:30

2 Answers 2

Reset to default
1

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).

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Last I checked sql developer doesn't need a tnsnames.ora
It doesn't need one, but it can reference one. Having no information about the OP's environment i'm trying to cover a range of options.
0

I've faced that kinda problem also and I've tried stop all of oracle services and start it again. But unsuccessful. Eventually, I've needed to install Oracle again which can solve this problem.

Improve this answer

1 Comment

But I don't need to re-install Oracle. There must be some a solution without re-installing it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.