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: Can I create a database via oracle client?

Re: Can I create a database via oracle client?

From: Snewber <s_at_s.com>
Date: Thu, 7 Oct 2004 09:32:27 +1000
Message-ID: <ck1vad$r0l$1@bunyip.cc.uq.edu.au>


Thanks for the input.

I don't use oracle on windows so I can't comment and when I read articles like the following then it supports my suspicions.

http://www.news.com.au/common/story_page/0,4057,10967731%5E15316,00.html

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:nq37m092src5g9jooo70t4rpk1f9fiqftu_at_4ax.com...
> On Wed, 6 Oct 2004 10:32:20 +1000, "Snewber" <s_at_s.com> wrote:
>
>>Hi Goran,
>>
>>this is what I suspected as well as the CREATE DATABASE command is still
>>only SQL and thus can be run just like any other SQL, remotely or locally,
>>if you have the correct privileges.
>>
>>Thanks for checking it and giving the correct answer to the original
>>question.
>
> Actually I don't think Goran's answer is correct, he cheats. Nor is it
> smart to do it.
> Goran's answer isn't correct, because it doesn't apply to windows. On
> Windows you would need to create an instance, using oradim, prior to
> creating a database. You simply can't run oradim locally.
> To create a database you would need to have SYSDBA privilege. To get
> SYSDBA privilege you need to have a password file, to have a password
> file you need to run orapwd on the server. *YOU NEED TO HAVE FULL
> ACCESS TO THAT SERVER ANYWAY!!* The OP thought it was possible to
> create a database *WITHOUT* access to that server. That simply isn't
> true! And it is stupid to even want to capable to create a database
> remotely, this would be *A SEVERE SECURITY BREACH*
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Oct 06 2004 - 18:32:27 CDT

Original text of this message

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