I have installed Oracle8i on my PC[p3]. After installation at the time of login I used "scott" as username and...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
"tiger" as password, but it is displaying "TNS protocol error." What does it means and how do I solve this? You can get this error message when you are using the DOS version of SQL*Plus. Before you invoke SQL*Plus, type the following:
Use your database's identifier instead of 'my_sid'.
Additionally, you can use Net Manager to create a TNS alias which points to your database. Then, when you connect with SQL*Plus, you will use this TNS alias as follows:
By explicitly stating the TNS alias, you are also telling SQL*Plus which protocol to use.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.