TNS Protocol adapter error while starting Oracle SQL*Plus

oracle oracle11g sqlplus
Brian picture Brian · Jan 9, 2012 · Viewed 105.4k times · Source

Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection error.

I try to login as sys as sysdba and provide the password.

All the services are started. I'm on Windows 7.

Any help would be appreciated.

enter image description here

Answer

Sivadas Melazhi picture Sivadas Melazhi · Jan 10, 2012

Try 

sqlplus sys/<your password>@<your SID> as sysdba

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?

Read More
PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 Here is my code. DECLARE rec_ENAME EMPLOYEE.ENAME%TYPE; …

Read More