I have installed Oracle Database 9.2.0.1.0.
I have not created any databases yet. Instead of using ODCA I would like to
create a database manually. In order to do it I have to issue CREATE
DATABASE command. Unfortunatelly I don't know how to gain access to SQL, is
there any way I can do it?

"Pawel Mlynski" <pmg3@op.pl> wrote in message
news:812qlhf236s8$.17fasuhp8l9d3$.dlg@40tude.net.. .
>I have installed Oracle Database 9.2.0.1.0.
> I have not created any databases yet. Instead of using ODCA I would like
> to
> create a database manually. In order to do it I have to issue CREATE
> DATABASE command. Unfortunatelly I don't know how to gain access to SQL,
> is
> there any way I can do it?

you dont have access to sql*plus? f you dont you cant do it. best way is to
fire up dbca and save the scripts at the end, then you can see how it is
done

Pawel Młyński wrote:

> I have installed Oracle Database 9.2.0.1.0.
> I have not created any databases yet. Instead of using ODCA I would like to
> create a database manually. In order to do it I have to issue CREATE
> DATABASE command. Unfortunatelly I don't know how to gain access to SQL, is
> there any way I can do it?

write a create database script and save it on a local hard disk
modify the init.ora
start SQL*Plus

SQL> / as sysdba
SQL> startup nomount
SQL> pfile=<path_and_init_dot_ora_file_name>
SQL> @<path_and_script_name>

Some samples can be found at: http://www.psoug.org
click on Morgan's Library
click on database
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

DBCA will create some disk structures for you, on top of creating the
database.
If you don't use it, you will have to create those directories (that contain
the init.ora, trace files, alert log) yourself. If you don;t use standard
locations another DBA logging on your system will have to check where you
choose to put those files. Not hard but a loss of time.
Also on OpenVMS (don't know for Unix) you have procedure files (you may call
them scripts) that are created from sample files, in order to connect to the
database (those are executed "forked" when a dedicated server process is
started for the new connection). You can easily create those yourself if you
know how (or modify them for troubleshooting purposes), but again that's
time consuming when you have a tool that can do it for you.

Other than that, use the CREATE DATABASE command.

--
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Pawel M³yñski" <pmg3@op.pl> a écrit dans le message de
news:812qlhf236s8$.17fasuhp8l9d3$.dlg@40tude.net.. .
> I have installed Oracle Database 9.2.0.1.0.
> I have not created any databases yet. Instead of using ODCA I would like
to
> create a database manually. In order to do it I have to issue CREATE
> DATABASE command. Unfortunatelly I don't know how to gain access to SQL,
is
> there any way I can do it?
>

On Mon, 03 Jan 2005 17:46:36 +0100, Pawel Młyński wrote:

> I have installed Oracle Database 9.2.0.1.0.
> I have not created any databases yet. Instead of using ODCA I would like to
> create a database manually. In order to do it I have to issue CREATE
> DATABASE command. Unfortunatelly I don't know how to gain access to SQL, is
> there any way I can do it?

Why do you want to create the database manually?

While there is nothing wrong with doing so, many who ask that question
have a basic misunderstanding of Oracle. Just checking that you are
heading down the right thought process.

On Mon, 3 Jan 2005 17:46:36 +0100, Pawel M³yñski <pmg3@op.pl> wrote:

>I have installed Oracle Database 9.2.0.1.0.
>I have not created any databases yet. Instead of using ODCA I would like to
>create a database manually. In order to do it I have to issue CREATE
>DATABASE command. Unfortunatelly I don't know how to gain access to SQL, is
>there any way I can do it?

On windows you have to create a service first with oradim. You will
need an *.ini file.
When the service is running you can connect to that from SQLPLUS.

It is a fine educational excersize to create the databse yourself, and
good for finetuning a production database (if you know what you are
doing .-)
But don't make it harder than necessary. Use ODCA to create the
scripts You don't have to create the database!
Then study and modify the script to your whishes.

Hans Erik Busk
Denmark

"Hans Erik Busk" <tbf@cn.stam.dk> wrote in message
news:4q5jt092kfbqpnnodvg0pctrj5nle9v5ks@4ax.com...
> On Mon, 3 Jan 2005 17:46:36 +0100, Pawel M³yñski <pmg3@op.pl> wrote:
>
>>I have installed Oracle Database 9.2.0.1.0.
>>I have not created any databases yet. Instead of using ODCA I would like
>>to
>>create a database manually. In order to do it I have to issue CREATE
>>DATABASE command. Unfortunatelly I don't know how to gain access to SQL,
>>is
>>there any way I can do it?
>
> On windows you have to create a service first with oradim. You will
> need an *.ini file.
> When the service is running you can connect to that from SQLPLUS.
>
> It is a fine educational excersize to create the databse yourself, and
> good for finetuning a production database (if you know what you are
> doing .-)
> But don't make it harder than necessary. Use ODCA to create the
> scripts You don't have to create the database!
> Then study and modify the script to your whishes.
>
> Hans Erik Busk
> Denmark

what a .ini file?

Also its called dbca not odca

GreyBeard wrote:
<snip>

> Why do you want to create the database manually?

Why not? It's a good learning exercise to get intimate with Oracle. As
a personal choice, I don't use DBCA and prefer to create a database
using scripts.

> While there is nothing wrong with doing so, many who ask that
question
> have a basic misunderstanding of Oracle.
Care to elaborate on this.

Regards
/Rauf

Rauf Sarwar wrote:
> GreyBeard wrote:
> <snip>
>
> > Why do you want to create the database manually?
>
> Why not? It's a good learning exercise to get intimate with Oracle.
As
> a personal choice, I don't use DBCA and prefer to create a database
> using scripts.
>
> > While there is nothing wrong with doing so, many who ask that
> question
> > have a basic misunderstanding of Oracle.
> Care to elaborate on this.
>
> Regards
> /Rauf

Apparently you've not experienced someone used to SQL Server, Sybase,
Access or MySQL thinking that creating a database in Oracle is just as
simple as issuing a 'create databse mydb' command. Many who ask think
such is the 'end of the line', yet those of us who do know realise this
is not the case. Creating a database in Oracle is far more involved,
starting with the 'Create database' command and running through the
catalog creation scripts, tabkespace creation commands, and package
installation scripts, as well as creating the init.ora file, the
directory locations for all of the files (control files, redo logs,
tablespaces, archive logs) and whether or not to configure the database
for archivelog mode. Mistakes in any of these scripts will be
difficult for anyone not familiar with the process to discover, much
less resolve.

It is far better for a newbie to use DBCA, choose the option of
creating scripts for the database creation, then using those scripts as
a roadmap or blueprint for any further databases they may choose to
create. Having a solid example to follow is worth far more than
letting someone unfamiliar with database creation start from scratch,
make mistakes, become disillusioned or frustrated and curse Oracle
becuase it is not like the above mentioned database products.

Simpluy because you and I (and most others who contribute here) are
capable of creating a database from scratch, calling it a 'good
learning experience', in no way qualifies someone completely unfamiliar
with the product to do so. In such a case compassion is better than
throwing someone to the wolves, so to speak. making DBCA the logical
starting point for a persons first Oracle database.

David FItzjarrell

On Tue, 04 Jan 2005 01:34:43 -0800, Rauf Sarwar wrote:

>
> GreyBeard wrote:
> <snip>
>
>> Why do you want to create the database manually?
>
> Why not? It's a good learning exercise to get intimate with Oracle. As
> a personal choice, I don't use DBCA and prefer to create a database
> using scripts.

As I said, there is nothing wrong with creating the database manually.

>
>> While there is nothing wrong with doing so, many who ask that
> question
>> have a basic misunderstanding of Oracle.
> Care to elaborate on this.

Go through the archives and check how many people want to 'create
databases on the fly', 'create databases using program', etc.

When coming from other RDBMSs, some people assume they already understand
what is meant by the term 'database'. Because of the difference in
meaning of the term between Oracle and, say SQL Server, they feel they
need to create databases manually to be able to create a lot of them.

In many cases, all they want is to create a schema on the fly.

lol/FGB