Error ORA-12560 TNS:protocol adapter error

2.3k Views Asked by At

I just Installed Oracle DB g11 whenever I want to login to scott/tiger database, It gives me ORA-12560: TNS:protocol adapter error. But there's a weird thing. Now, alot of people say that I have to start the OracleService from services in my PC. But, I can't find it there. I would be thankful if you helped me. Thanks

1

There are 1 best solutions below

2
On

Please check your oracle service and listener are started. Oracle service name usual like OracleService<your sid>.
For example. your Oracle SID is orcl. Your Orace service name is OracleServiceORCL.
and your Listener should end with "TNSListener" like default listener name OracleOraDb11g_home1TNSListener. The both of them have to running.
Then, try to connect your DB with SQLPlus. Open DOS command promt and type this command

>sqlplus <your userlogin>/<your login password>@<your sid>

If connection is success. Result should show like below massage.

C:\Users\monkawee>sqlplus ***/******@orcl

SQL*Plus: Release 11.2.0.1.0 Production on ネ. 狠.ツ. 3 17:04:57 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


爼ラ靉チオ靉。ムコ:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Good luck.