Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help: user create database command
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.......
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
![]() |
![]() |