"Insufficient privileges" error when creating database
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.
This was first published in October 2004