Re: create database

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 27 Apr 2001 11:38:29 +0100
Message-ID: <988367962.14422.0.nnrp-07.c30bdde2@news.demon.co.uk>

Someone connecting over the network will require an active database (by which I mean via SQL*Plus or whatever, not telnet) to log in to.

Someone on the server (via telnet) who can physically look around is best placed to decide how and where to create the database. Not someone out in the cold thrashing away via SQL*Plus.

As Sybrand says, there's a difference between creating a database, and planning one... ;-)

Anyway, you basically:
create initYOURSID.ora in .../dbs/
svrmgrl
connect internal (or "sqlplus /nolog" and "connect / as sysdba") startup nomount
create database etc etc

There may be other NT-specific steps, but I dunno them. Have heard mention of 'oradim', maybe it's relevant. Hit the manuals looking is (always) the best advice.

"Thomas Vatter" <thomas.vatter_at_blinx.de> wrote in message news:Xns90906658F61B4thomasvatter_at_192.168.115.1...
> On 26 Apr 2001, you wrote in comp.databases.oracle.server:
> thanks a lot for your answer! I had checked the online manuals, for
> "create database" but couldnt find this info. So I wont create the
> database remotely. But I wonder if it is the right way if network
> applikations cant create the database to save their data. Thus
> installation will be more complicated and customers dont like that. Sure
> dbas want to keep their job, but perhaps today this is not creating
> databases but administrating, configuring, tuning etc. Am I wrong?
Received on Fri Apr 27 2001 - 05:38:29 CDT