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.

Mr. Muskrat
  • 22,772
  • 3
  • 20
  • 21
Mansoor Gee
  • 1,071
  • 8
  • 20
  • Is your database open? This error can be seen when the database is not started. – Ollie Nov 23 '11 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. – Harrison Nov 23 '11 at 13:36
  • @Ollie My database has already started. – Mansoor Gee Nov 24 '11 at 04:53
  • @Mansoor Gee, is your listener started too? – Ollie Nov 24 '11 at 09:11
  • @Ollie How can I check this that listener has started? – Mansoor Gee Nov 24 '11 at 09:30
  • See my answer from yesterday. At the command prompt type: lsnrctl start. You can check the status with lsnrctl status – Ollie Nov 24 '11 at 10:13

2 Answers2

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

Ollie
  • 17,058
  • 7
  • 48
  • 59
  • Last I checked sql developer doesn't need a tnsnames.ora – orbfish Nov 23 '11 at 16:32
  • 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. – Ollie Nov 23 '11 at 19:07
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.

PPShein
  • 13,309
  • 42
  • 142
  • 227