Ask the Expert

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

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.

    Requires Free Membership to View

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 first published in May 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: