ORA-12560: TNS:protocol adaptor error

user_435559 0
Viewed 802539

enter image description here

I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ?

Can anyone tell me a perfect solution to solve login problem.

ora-12560 oracle9i oracle sql
19 Answers

Just to add up, follow the screenshot and choose local account to start if not selected. Then start the service.

enter image description here

user_12530880

ORA-12560: TNS:erro de adaptador de protocolo

  1. set Environment Variables: ORACLE_BASE, ORACLE_HOME, ORACLE_SID
  2. make sure your user is part of ORACLE_GROUP_NAME (Windows)
  3. make sure the file ORACLE_HOME/network/admin/sqlnet.ora is: SQLNET.AUTHENTICATION_SERVICES = (NTS)
  4. (Windows) Be carefull when you add a new Oracle client: adding a new path to the PATH env. variable can mess things up. The first entry in this variable makes a difference: certify that the sqlplus executable in the ORACLE_HOME (ORACLE_HOME/bin) comes first in the PATH env. variable.
user_28477020

I try 2 option:

  1. You change service OracleService in Service Tab -> Running
  2. Login with cmd command: sqlplus user_name/pass_word@orcl12C Note: orcle12c -> name of OracleService name run in you laptop
user_71707570

Below fixes can be applied to resolve TNS 12560 error

  1. Get Latest patch for SQL*NET client software
  2. Set $ORACLE_HOME and $PATH variable (should be accessible for System user)
  3. Check permissions on PC client
  4. Check $TNS_ADMIN variable
  5. Check if network has firewall or antivirus issues
  6. Check if windows services Run >> Services.msc has OracleXE or OracleORCL service running Check below link in case of net tracing error:

http://dba-oracle.com/t_sql_net_tracing.htm

user_129094930
Related