Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which rights to create database ?

Re: Which rights to create database ?

From: Ron Reidy <rereidy_at_indra.com>
Date: Tue, 02 Apr 2002 22:26:23 -0700
Message-ID: <3CAA927F.210440F@indra.com>


Theo Klein wrote:
>
> I executed this commands:
> connect SYS/Password_at_datenban as sysdba;
> grant sysdba to scott;
> disconnect;
>
> Now I tried this:
> connect scott/tiger_at_datenban as sysdba;
> create database test;
>
> But instead to create the database I get this error messages:
>
> ORA-01501: CREATE DATABASE not successfull
> ORA-01100: Database already joined with MOUNT
>
> What's wrong ?
>
> Theo Klein

$ oerr ora 1100
01100, 00000, "database already mounted" // *Cause: A database is already mounted in this instance. // *Action:

As the cause above shows, an instance is already running for this SID. Have you read the concepts manual, DBA guide, etc.?

-- 
Ron Reidy
Oracle DBA
Received on Tue Apr 02 2002 - 23:26:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US