ORA-12560: TNS:protocol adapter error
Questions tagged [ora-12560]
31 questions
85
votes
19 answers
ORA-12560: TNS:protocol adaptor error
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.
Vishwanath Dalvi
- 35,388
- 41
- 123
- 155
6
votes
1 answer
Sql plus doesn't show English
SQL plus doesn't show English as shown here
and it also returns error for system user name and password, even the user name and password are correct!
The error is ORA-12560:TNS:protocol adapter error, what should I dخ??
palAlaa
- 9,500
- 33
- 107
- 166
4
votes
1 answer
ORA-12560: TNS:protocol adapter error
we have a dot net application and it connecting to Oracle and fetching data and moving to SQL server. it was working very fine. just started giving error ORA-12560: TNS:protocol adapter error . Tnsping also giving this error. but if i stop this…
Joseph
- 473
- 2
- 8
- 17
3
votes
3 answers
Cannot connect to Oracle DB from Java - ORA-12560: TNS:protocol adapter error
This is my first Java application I am creating (using Eclipse IDE) and the second Oracle based app (I'm a .NET/MSSQL guy for years). The first Oracle app I wrote in .NET did not have any issues, and I'm trying to connect to the same server.
I have…
dferraro
- 6,357
- 11
- 46
- 69
2
votes
1 answer
Oracle Protocol Adapter Error
HI,
I've just installed Oracle 10 g Express Edition on to my laptop. The platform is Windows XP SP3. Installation went normally. BUt when I try to get connected to the Oracle database via SqlPlus I get "TNS Protocol adapter error".My laptop is on…
Mikayil Abdullayev
- 12,117
- 26
- 122
- 206
2
votes
0 answers
Error ORA-12560 using Toad
I am using toad with Oracle now, and after the installation, I tried to connect using toad, but an error pops up:
ORA-12560: TNS:protocol adapter error
I have already tried to set the ORACLE_HOME and PATH environment variables but the issue is…
zw324
- 26,764
- 16
- 85
- 118
2
votes
2 answers
Connection string to Oracle 10g DB using VB.net
Hey all i am VERY new to a Oracle DB and i am trying to connect to it via VB.net 2010. I have been trying the following:
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim dr As OleDbDataReader
myConnection = New…
StealthRT
- 10,108
- 40
- 183
- 342
1
vote
6 answers
What could be wrong: ping works fine but tnsping works intermittently
We have oracle 10g running on windows server 2003. A machine which runs an application using that database has as of a few weeks ago suddenly started having connectivity problems. Today we ran the automatic updates for windows server and the…
George Mauer
- 117,483
- 131
- 382
- 612
1
vote
1 answer
Unable to retrieve data from table using nodeJS. error: ORA-12560: TNS:protocol adapter error
var oracledb = require('oracledb');
oracledb.getConnection({
user : "SYSTEM",
password : "*************",
connectstring : "localhost/XE"
},
function(err, connection)
{
if(err){
console.error(err.message);
return;
…
Jishnu
- 33
- 1
- 7
1
vote
1 answer
Oracle 10g users are expired
I have an Oracle 10g database which is connected to another server with instance client. Problem is all of users(SYS/SYSTEM/SYSMAN/FATASAN/JAVAHER) are expired (I forgot to change expire date) and also sqlpus and instance client are faced with…
amir
- 85
- 8
1
vote
1 answer
Restore oracle xe problem
I am trying to restore oracle XE by clicking (run as administrator) Restore Database from Start menu -> All Programms ->Oracle Database 10g Express Edition. After entering yes to the confirmation question the error messages appear.
Messages…
Silvia
- 21
- 2
1
vote
3 answers
How to find oracle error codes that could result from a connection error?
I would like to handle an OracleException thrown when my network/database connection is interrupted, where can I find out what error codes I might can receive?
I guess since we are talking about a connection interruption these would be technically…
George Mauer
- 117,483
- 131
- 382
- 612
0
votes
2 answers
Cannot create connection in Oracle SQL Developer
I am a new user in Oracle. In Oracle SQL Developer, whenever I want to create a new connection and fill the "New Database Connection" form, it gives me this error: -
ORA-12560: TNS:protocol adapter error
Please Help.
Mansoor Gee
- 1,071
- 8
- 20
0
votes
1 answer
"ORA-12560: TNS:protocol adapter error" VS designer
I'm trying to view/edit a Form through Visual Studio Designer and am getting a the following error:
ORA-12560: TNS:protocol adapter error
How do I set up my form to display within the designer or development machine show intelligent error…
amadib
- 868
- 14
- 33
0
votes
0 answers
ERROR: ORA-12560: TNS:protocol adapter error after I had a Windows update today my Oracle database doesn't start any more
When I connect with SQL*Plus I get:
ERROR: ORA-12560: TNS:protocol adapter error
Microsoft Windows [Version 10.0.19044.2846]
(c) Microsoft Corporation. All rights reserved.
C:\Windows\system32>LSNRCTL.EXE start
LSNRCTL for 64-bit Windows: Version…
DDG
- 1