Home » RDBMS Server » Server Administration » what to do next?
what to do next? [message #60734] Mon, 01 March 2004 19:23 Go to next message
Ellen
Messages: 5
Registered: April 2000
Junior Member
I am a newbie on oracle
i have installed oracle software on tru64
$sqlplus internal
$start nomount
it's ok now.now

i want to create a database i write a .sql file

$vi mydb.sql
Create Database mydb
Controlfile reuse
Logfile group 1 ('/orabin/log/log_mydb01.log') size 10M,
group 2 ('/orabin/log/log_mydb02.log') size 10M
maxlogfiles 5
maxloghistory 100
maxlogmemebers 2
Datafile '/orabin/oradata/mydb01.dbf' size 10M
maxdatafile 100
noarchivelog
character set us7ascii

then sql>@mydb.sql.....there was no response
so i want to know if I have missed some steps after i
finished installing the software.

$ORACLE_SID and sql>show parameter instance return the same.

what should i do after i installed the software??

thanks in advance

Report message to a moderator

Re: what to do next? [message #60738 is a reply to message #60734] Tue, 02 March 2004 03:02 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Try to end your "CREATE DATABASE" statement with a semicolon (;) or slash (/) in column 1.

Best regards.

Frank

Report message to a moderator

Previous Topic: Oracle Installation using response file
Next Topic: creating tables in another schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:30:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.