Oracle/Oracle

Advertisement


Question
os is windows 8.1
oracle 11g rdbms
How can we use CREATE DATABASE statement oracle 11g? i tried that through sys as dba user but i am getting data base is already mounted,what's that mean?

Answer
Hi Santhosh


Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm

The there a few steps that take place before you actually issue the CREATE DATABASE statement.The Oracle's DBA Administration Guide recommends the following steps in creating your database instance:
Step 1: Specify an Instance Identifier (SID)

Step 2: Ensure That the Required Environment Variables Are Set

Step 3: Choose a Database Administrator Authentication Method

Step 4: Create the Initialization Parameter File

Step 5: (Windows Only) Create an Instance

Step 6: Connect to the Instance

Step 7: Create a Server Parameter File

Step 8: Start the Instance

Step 9: Issue the CREATE DATABASE Statement

Step 10: Create Additional Tablespaces

Step 11: Run Scripts to Build Data Dictionary Views

Step 12: Run Scripts to Install Additional Options (Optional)

Step 13: Back Up the Database.

Step 14: (Optional) Enable Automatic Instance Startup

Now assuming that you've completed steps 1 through 7, your next step is to mount the database.  The command for Step 7 is

STARTUP NOMOUNT

Up until this point, you've setup up the instance but it needs to be mounted before you can issue the CREATE DATABASE (step 9) statement.

When you run the CREATE DATABASE (step 9), it should mount and open the database for use.

I hope this is helpful to you.

Peter

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Peter Choi

Expertise

I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2016 About.com. All rights reserved.