0

Problem with creating new Database in Oracle Express Edition.

Platform: Ubuntu 12
Oracle : 10g Express edition

I am trying to create a new database in oracle and I took the help of Oracle Docs to achieve that.

I was successful in creating the 'Initialization Parameter File' for Database 'mynewdb'. Even, I have changed the environment variable ORACLE_SID to point to value 'mynewdb'.

The problem is, when I try to connect to database by hitting CONNECT SYS/passwd AS SYSDBA , it prompted an error saying Insufficient Privileges'. So, I restored the ORACLE_SID variable back to 'XE'.

Now, I logged in with SYSDBA privileges and then I issued 'CREATE DATABASE' command to create the 'mynewdb' database. This time it prompted again an error saying

database name 'MYNEWDB' does not match parameter db_name 'XE'

ROMANIA_engineer
  • 54,432
  • 29
  • 203
  • 199
Govinda Rao
  • 1
  • 1
  • 1
  • see other anwsers - http://stackoverflow.com/questions/9534136/how-to-create-a-database-after-installing-oracle-database-11g-express-edition – OldProgrammer May 18 '13 at 14:34
  • 4
    In 90% of the cases where people claim they need a new "database" in Oracle, they just need a new schema/user. And I don't think XE supports more than one instance any (which is a "database" in Oracle). –  May 18 '13 at 15:40
  • Your comment should probably be posted as answer. There are 2 parts in it. 1- There is no way to create a new database in Oracle 10g XE; 2- It is not necessary. One should create a new user, grant the appropriate permissions and connect as this new user. – ndvo Sep 09 '15 at 19:57

0 Answers0