Alex Rivera | Logout

TNS Protocol adapter error while starting Oracle SQL*Plus

Asked 2012-01-09T00:49:31.200
10

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

oracle-database oracle11g sqlplus
Edit
Report

1 Answer

4

Try typing all of this on the command line:

sqlplus / as sysdba

As what you are doing is starting sqlplus and then using sys as sysdba as the user-name which is incorrect as that is not a valid user. By using the above command Oracle is using your system login credentials to access the db. Also, I would confirm that the sqlplus executable you are running is the correct one by checking your path - ensure it is in the bin of the server installation directories.

answered 2012-01-09T03:06:04.643

Your Answer