How to remove ORA-01100:DATABASE ALREADY MOUNTED?
I am using Oracle 11g and there is a database created during installation named "xyz" and user "xyz".Now I created a user 'abc' and gave the following permission to abc.
"CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK,
CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM,
CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE,
CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE"
Now, I am trying to create database named 'abc'
At the time of creation of the database, I am get the following exception:
ORA-01501:CREATE DATABASE FAILED
ORA-01100:DATABASE ALREADY MOUNTED
Please tell me how to come out of this. What standard procedure should be for creating a database?
The following steps need to be followed to remove ORA-01100:DATABASE ALREADY MOUNTED :
1.Create suitable directory for new database
Like:
1.C:oraclexepporacledminDB_NAME
2.C:oraclexepporacledminDB_NAMEdump
3.C:oraclexepporacledminDB_NAMEdpdump
3.C:oraclexepporacledminDB_NAMEpfile
2.Create new database instance for new database
C:Windowssystem32>oradim -new -sid DB_NAME
3.Create password file for new database.
Like: C:Windowssystem32>orapwd file=C:oraclexepporacleproduct .2.0serverdatabasePWDDB_NAME.ora password=password
4.Create New pfile in C:oraclexepporacledminDB_NAMEpfile link
Startup nomount stage db using new pfile
Set an oracle instance.
SET ORACLE_SID=DB_NAME
start sql plus and connect.
start oracle Instance.
SQL>startup nomount pfile='path of initDB_NAME.ora';
6.Create database script with necessary space and file.
7.Check instance status
select status from v$instance;
8.version
select * from v$version;