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
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.
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.