Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error logging in to svrmgr after install

I installed a fresh copy of Oracle Enterprise Edition 8.1.7 on Windows 2003. After the install when I log in to svrmgr... or SQL*Plus, I get the following error: ORA-12560: TNS: protocol adapter error. And I can't connect as internal to create database. Could you please help solve this problem?
First, you should know that "connect internal" and the svrmgrl tool were both deprecated as of 8.1.5. However, Oracle still allowed the functionality until 9.0. So, what you're trying to do should work until 9.0.

The problem you're describing is something I've seen and, for me, it usually has to do with a setting in the sqlnet.ora file. I would try adding (if it isn't there) or removing (if it is there) a line like this:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

You may also try logging out and logging back in as the user that you used to install Oracle. This is because during the installation, Oracle creates a new local group named ORA_DBA and adds you to that group. Membership in that group is what determines who is allowed to use functionality like "connect / as sysdba" (a.k.a. "connect internal"). If you're in the group ORA_DBA, you can use the "connect / as sysdba" and if you aren't then you get an insufficient privileges error.

This was last published in June 2004

Dig Deeper on Oracle database installation, upgrades and patches

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close