How do I fix error ORA-12560?
Set the Oracle system ID (SID) to C:>set oracle_sid=ORCL. Next, run the Net Start command (C:>net start oracleserviceORCL). This should resolve the ORA-12560 error in this situation.
How do I fix protocol adapter error in Sqlplus?
How to Fix ORA-12560: TNS: Protocol Adapter Error
- Make sure the windows service is up and running.
- Make sure your ORACLE_SID is set to the instance name you’re trying to connect to. If either one or two are not correct you will get the error as seen below.
Why do I get an ora-12560 error from Oracle?
Terminal Service interferes with database creation creating the TNS:Protocol Adapter Error. Using Remote Control on the virtual server worked where the Remote Desktop didn’t. I am installing Oracle 11.1.0 on windows xp. I am getting error ora-12560 when configuration assistant part of installation starting.
Why is Oracle-sqlplus / AS SYSDBA failed to login?
Defining ORACLE_SID ( set ORACLE_SID=localhost) does not made any difference before I try to log as sysdba. Also I was able to start the services and start listener only from command prompt opened as administrator of course where still I can’t sqlplus / as sysdba.
Can you use sqlplus on a CentOS server?
On Centos server I can log in using sqlplus too. I changed tnsnames.ora on windows to same as server.I have added oracle host information in windows host file and I can ping oracle host and telnet host on port 1522. I have disables service iptables so no type of firewall exists on centos.
Why is the ORACLE service not running on my server?
You seem to be saying that services not running is the reason for this error on the server. And you suggested setting oracle_sid manually. However, the oracle service is running as evidenced by the ability to connect to it in SQL developer using the sys login.