oracle10g

How to create database in oracle 10G

I am trying to create tabase in Oracle 10g using query

Create database testdb

but it showing error CREATE DATABASE failed database already mounted

Please help me..

Solution

  • Use "STARTUP NOMOUNT" first.

    Follow the directions in the Oracle docs. Or, much easier - use the DBCA (Database Configuration Assistant).