I have installed Oracle 11g Database on my database server so when i’m trying to start the database i got the ORA-12560: TNS:protocol adapter error:
ORA-12560: TNS:protocol adapter error
Seems like the environments are not set properly so in order to solve the ORA-12560: TNS:protocol adapter error or to set the Oracle sid follow the below procedure:
Go to Start >> Command prompt >> Type,
C:\Users\Administrator>set oracle_sid=ECC ( ECC is the OraSID )
Now run the Net start command.
C:\Users\Administrator>net start oracleserviceECC
The requested service has already been started.
Now try again the Database will start Properly 🙂