Q

Can't get into new database with same username/password

My username/password is sys/sys. I can connect to one database named oradbs with this password, but when I want to create another database, I can get into SQL*Plus but cannot connect using the same username and password. It throws the ORA-01031 error, insufficient privileges.

I have installed Oracle9i Server in Windows 2000 Service Pack 4. My username/password is sys/sys. I can connect to one database named oradbs with this password, but when I want to create another database, I can get into SQL*Plus but cannot connect using the same username and password. I used:
oradim -new -sid kish
set oracle_sid = kish
sqlplus /nolog
It throws the ORA-01031 error, insufficient privileges. Kindly help me out. I am a DBA starter.
Since you are a self-confessed "DBA starter," I would not recommend creating the database manually. Rather, I would recommend that you use the Oracle wizard for creating databases. This wizard will create your service and configure everything for you. In Start->Programs, you should see a folder for your Oracle software. In that folder, look for Configuration and Management Tools->Database Configuration Assistant. This wizard, called the DBCA for short, will ask you some questions about the database you want to create and then create the database for you.
This was last published in May 2006

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close