Q

ORA-12560 error after installing Oracle 8i Enterprise Edition

I have installed Oracle 8i Enterprise Edition. When I try to export my data, I am getting the error, "ORA-12560: TNS:Protocol adaptor error."

I have installed Oracle 8i Enterprise Edition on my Windows 2000 server machine. When I try to export my data, I am getting the error, "ORA-12560: TNS:Protocol adaptor error."

This is usually due to a setting in your sqlnet.ora. If you see a line in your sqlnet.ora file (located in ORACLE_HOMEnetworkadmin) like this:

 SQLNET.AUTHENTICATION_SERVICES=(NTS)

then you should try commenting that line out and try again. If you don't see that line, try adding it and see if that changes your outcome.


This was first published in October 2004

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close