Problem solve
Get help with specific problems with your technologies, process and projects.
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.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
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 /nologIt 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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments