Re: Create Database ...

From: Jones Chung <jonesc_at_gmail.gcn.net.tw>
Date: Tue, 09 Jun 1998 03:26:54 GMT
Message-ID: <357ca85a.411463656@news.seed.net.tw>

>Here's a quick example (let's say the database is called DW80):
>1. Create the init.ora file (use an exisiting one as template
>
>2. Create the instance:
>C:> oradim80 -NEW -SID dw80 -INTPWD sa
>-STARTMODE AUTO
>-PFILE c:\orant\database\initdw80.ora
>
>3. Set the environement variable:
>C:> SET ORACLE_SID=TEST
>
>4. Connect cia Server Manager and create the database:
>C:> SVRMGR30
>> connect internal/sa
>Connected to an idle instance
>
>5. Do a startup nomount and create the database.
>
>
>regards,
>Billy
>
>

Thanks for your help!
I could already connect into server manager by internal/test, followings are the steps:

---

C:> svrmgr30
 . . . .
SVRMGR>connect internal/test
connected!
SVRMGR>startup nomount

ORACLE °õ¦æ¶µ¦¸¶}©l.

¨t²Î¾ãÅé°Ï¦@      11705004 ­Ó¦ì¤¸²Õ
Fixed Size                       47788 ­Ó¦ì¤¸²Õ
Variable Size                 11173888 ­Ó¦ì¤¸²Õ
Database Buffers                409600 ­Ó¦ì¤¸²Õ
Redo Buffers                     73728 ­Ó¦ì¤¸²Õ

ORACLE °õ¦æ¶µ¦¸¶}©l.
 (* Sorry for the Chinese charters, however it's sucessful for

     starting)
SVRMGR>@d:\OraNT\createdb
create database test
*
ORA-00603: ORACLE server session terminated by fatal error SVRMGR>

---

where the content of createdb.sql is:
>>>>

create database test

   datafile 'test_system' size 10M
   logfile group 0 ('test_log1a', 'test_log1b') size 500K,    group 2 ('test_log2a', 'test_log2b') size 500K; <<<<
what's wrong it happened? Thanks for help again,

regards,
Jones Received on Mon Jun 08 1998 - 22:26:54 CDT