SOLVED

ORA-12560: TNS:protocol adaptor error

Asked by OracleDba17 viewsoracle
1
2
3
4
5
6
7
ORA-12560: TNS:protocol adaptor error

This is the common error in oracle database related to oracle database connection

Problem Statement

ORA-12560: TNS:protocol adaptor error
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
s

Check if your database is up and running

Make sure listener is up and running

Crosscheck if your ORACLE_HOME and ORACLE_SID set up properly

if you are using windows server then go to services.msc and look for oracle service of database. service needs to be started.

Also check for firewall issue

#ORA-12560
OracleDba

Post Your Solution