Home -> Usenet -> comp.databases.oracle -> creating a new database

creating a new database

From: Kristoffp <kristoffp_at_aol.com>
Date: 1996/07/26
Message-ID: <4tb1dt$t3q_at_newsbf02.news.aol.com>#1/1 







Hi world,


Sorry for this question, but I'm a oracle novice.
I tried to create a new database with the following steps:



    
  
  1.   copied init.ora to openroadinit.ora, and change the 
   db_name-parameter to openroad.
  
  2.   Set ORACLE_SID to openroad.
  
  3.   Called sqldba 


  
      
    
    •   connect internal
    
    •   startup nomount
    
    •   create database openroad
   datafile '/data3/oracle2/openroad/openroad_system' SIZE 2M,
   logfile group 1 ('/data1/oracle2/openroad/log1.log', 
   		    '/data3/oracle2/openroad/log1.log') SIZE 100K,
   	   group 2 ('/data1/oracle2/openroad/log2.log',
   		    '/data3/oracle2/openroad/log2.log') SIZE 100K,
   character set we8dec;




  
    





I get the followin errormessage:



logfile group 1 ('/data1/oracle2/openroad/log1.log',
*


ORA-02236: invalid file name





All directories exists.


So what is wrong ?



Thanks for any answer


Kristoff
Received on Fri Jul 26 1996 - 00:00:00 CEST












Original text of this message