Creating new Database in Oracle 10g XE -
problem creating new database in oracle express edition.
platform: ubuntu 12
oracle : 10g express edition
i trying create new database in oracle , took of oracle docs achieve that.
i successful in creating 'initialization parameter file' database 'mynewdb'. even, have changed environment variable oracle_sid
point value 'mynewdb'.
the problem is, when try connect database hitting connect sys/passwd sysdba
, prompted error saying insufficient privileges'. so, restored oracle_sid variable 'xe'.
now, logged in sysdba privileges , issued 'create database' command create 'mynewdb' database. time prompted again error saying
database name 'mynewdb' not match parameter db_name 'xe'
Comments
Post a Comment