Home » RDBMS Server » Networking and Gateways » ORA-12560: TNS:protocol adapter error (11g)
ORA-12560: TNS:protocol adapter error [message #659592] Mon, 23 January 2017 05:14 Go to next message
shawaj
Messages: 59
Registered: January 2016
Member
hello experts
i m using the following verson
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

when i use @orcl to connect database the following error show but
when i use @my_computer_name/orcl then it connect successfuly
what is the problem with it
please help me




SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 23 16:31:16 2017

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

Enter user-name: scott/tiger@orcl
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: scott/tigger@hp4420-14/orcl

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL>


================================and this is my tnsnames.ora========
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HP4420-14)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
and i m unable to connect sys as sydba too
please help me

[Updated on: Mon, 23 January 2017 05:28]

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #659595 is a reply to message #659592] Mon, 23 January 2017 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post sqlnet.ora but before, Please read How to use [code] tags and make your code easier to read.

Re: ORA-12560: TNS:protocol adapter error [message #659597 is a reply to message #659595] Mon, 23 January 2017 07:04 Go to previous messageGo to next message
BlackSwan
Messages: 25748
Registered: January 2009
Location: SoCal
Senior Member
>Enter user-name: scott/tigger@hp4420-14/orcl
please explain how above works without error when no such entry in posted tnsnames.ora exists for alias containing "hp4420-14".
Re: ORA-12560: TNS:protocol adapter error [message #659598 is a reply to message #659597] Mon, 23 January 2017 07:53 Go to previous message
Michel Cadot
Messages: 65254
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is easy connect string.

Previous Topic: Oracle Net proxy
Next Topic: ORA-12545: *only* with 32 bit client on Windows Server 2016
Goto Forum:
  


Current Time: Thu Dec 14 13:17:04 CST 2017

Total time taken to generate the page: 0.01607 seconds