| ORA-12560: TNS:protocol adapter error [message #659592] |
Mon, 23 January 2017 05:14  |
 |
shawaj
Messages: 89
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
