I'm getting the error "insufficent privileges" when I do "create database" using a custom script. I installed Oracle 9 with the user "oracle" which has administrator privileges, and I tried to create the new database with the user "oracle." The error message actually appears when it is firing the custom script.
When you create a database, you must have the following conditions met:
- You must sign on to the instance as SYSDBA.
- You must start the database in NOMOUNT mode.
Once those conditions are met, then you can issue the CREATE DATABASE command.
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.