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

ORA-12560 error on trying to create database

I've already instaled Oracle 9i without problems, but everytime I try to create a database I receive the ORA-12560 error. I dont't know why. All Oracle services are running. I try to see the scripts that the Database Configuration Assistant generate, and the error happens in the first line of the first SQL script: connect SYS/change_on_install as SYSDBA.

This is usually due to privilege problems or authentication issues on Windows (I presume your platform is Windows). I suggest reviewing the ORACLE_HOMEnetworkadminsqlnet.ora file and see if it contains a line like this:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

If that line is present, remove it and try again.

Also make sure that the user you log on to the server with is in the local group named ORA_DBA. By default, the user that does the installation is placed in this group automatically.

If you are connecting to the server via terminal services or remote desktop services, then you should try going to the actual system console instead. Oracle has had problems with certain combinations of database releases and certain Windows versions.

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