Contents
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.
How do I connect to sqlplus as Sysdba in Windows?
Starting and Shutting Down a Database with SQL*Plus
- Go to your Oracle Database server.
- Start SQL*Plus at the command prompt: C:\> sqlplus /NOLOG.
- Connect to Oracle Database with username SYSDBA: SQL> CONNECT / AS SYSDBA.
- To start a database, enter: SQL> STARTUP [PFILE=path\filename]
How do I start sqlplus as Sysdba?
Steps
- Log in to SQL *Plus: sqlplus ‘/ as sysdba’
- Create a new user with an administrator password: create user user_name identified by admin_password ;
- Assign the sysdba privilege to the new Oracle user: grant sysdba to user_name ;
Is there an ora-12560 error in SYSDBA?
Enter user-name: system as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: system as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error
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.
Why do I get tns-12560 on SQL Plus?
At that point I could connect to SQL plus using ‘sys as sysdba’ to execute commands like creating the user, granting privileges etc. But now when I log in a few months later to do the same exercise on a new backup I can no longer connect to SQLPlus, always getting “ORA-12560: TNS:protocol adapter error” for any user.
What is the type of ora-12560 TNS error?
It worked fine without any errors. i take enjoy about this database.One day when i login sql*plus at that time error can occur.The type of error is “ORA-12560: TNS:protocol adapter error”. I had getting “”ORA-12560: TNS:protoco.But ur 2nd-guide line more help me. ur 2nd guide line is Start –> Run–> type ” services.msc”