ORA-12560: TNS: protocol adapter error

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
ricardo25ti
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 44
Joined: Tue, 05 Jan 2010 11:01 pm
Location: RN

Good morning to all

I am trying to connect the SQPLUS with the following command:

SQLPLus "/ SYSDBA"

When you run the command the following error occurs:

ORA-12560: TNS: Protocol adapter error

In this machine there is more than one customer installed, I checked The conclusion that this error is related to this, since if I run the
command
SQLPLUS User / password @ instance

works normally

The problem is that I have to enter a user who has privileged to overthrow and raise the bank


victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

ORA-12560: TNS: Protocol Adapter Error
Cause: The Generic Protocol Adapter Error Occurred.

Action: Check Addresses Used for Proper Protocol Specification. Before Reporting This Error, Look at The Error Stack and Check for Lower Level Transport Errors. For further details, turn on tracing and re-execute the operation. Turn Off Tracing When The Operation Is Complete.
http://en.glufke.net/oracle/viewtopic.php?t=4674 http://www.dba-oracle.com/t_ora_12560_t ... _error.htm
RJG
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 79
Joined: Tue, 16 May 2006 11:40 am
Location: Patos de Minas - MG

I do so and always enter:
SQLPlus
User (only in the user field only)

SYS / Password @ Banco SYSDBA
B]
Post Reply
  • Information
  • Who is online

    Users browsing this forum: Bing [Bot] and 1 guest