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 -> Help: user create database command

Help: user create database command

From: Fcs2635 <fcs2635_at_aol.com>
Date: 2000/05/13
Message-ID: <20000513141141.23218.00000278@ng-fz1.aol.com>#1/1

I am reading Oracle8, beginning's guide. On the section to create another database, they provide the following sequence.

SVRMGR>connect internal
SVRMGR>spool scratch.log
SVRMGR>set echo on
SVRMGR>startup nomount pfile=d:\orant\database\initprac.ora
SVRMGR>create database prac
2     datafile 'd:\orant\database\dbs1prac.dbf'  size 10m
3     logfile 'd:\orant\database\log1prac.dbf',
                'd:\orant\database\log2prac.dbf'     size 200k
4     maxlogfiles.......

.......
statement processed.

The problem is, when i type: connect internal, the database ask me for my password, when I type oracle, the database log me to another database, which is the default database, ORCL, and when you try to create database, you get an error message that the database is mounted by another instance. If you type the password with some other word, you will get an error message that the logon fail. There must be something wrong with their instruction, could someone help me out how to create a database using command line?

Thank you very much. Received on Sat May 13 2000 - 00:00:00 CDT

Original text of this message

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