RE: Create Database ORA-907 need help
You don't need to put any Bracket after keyword 'LOGFILE' See following lines... CREATE DATABASE OHIR LOGFILE 'D:\Oracle\oradata\OHIR\redo01.log' SIZE 1024K, 'D:\Oracle\oradata\OHIR\redo02.log' SIZE 1024K, 'D:\Oracle\oradata\OHIR\redo03.log' SIZE 1024K MAXLOGFILES 12 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE 'D:\Oracle\oradata\OHIR\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K MAXDATAFILES 50 MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1; HTH, Rajesh -Original Message- Sent: Wednesday, September 05, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, Can someone tell me whats wrong with my script ? CREATE DATABASE TEST LOGFILE ( '/test/redo01.log' SIZE 10K, '/test/redo02.log' SIZE 10K, '/test/redo03.log' SIZE 10K ) MAXL0GFILES 6 MAXINSTANCES 4 NOARCHIVELOG CHARACTER SET US7ASCII DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON ; When I try this script, I recieve this SVRMGRL @CreateDB '/test/redo01.rdo' SIZE 10K, ORA-00907: missing right paranthesis Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Create Database ORA-907 need help
Try to remove the brackets. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 2:27 PM Hi all, Can someone tell me whats wrong with my script ? CREATE DATABASE TEST LOGFILE ( '/test/redo01.log' SIZE 10K, '/test/redo02.log' SIZE 10K, '/test/redo03.log' SIZE 10K ) MAXL0GFILES 6 MAXINSTANCES 4 NOARCHIVELOG CHARACTER SET US7ASCII DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON ; When I try this script, I recieve this SVRMGRL @CreateDB '/test/redo01.rdo' SIZE 10K, ORA-00907: missing right paranthesis Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Create Database ORA-907 need help
Chk the spelling of maxlogfiles. You have used 0(zero) instead of 'O'. -- On Tue, 04 Sep 2001 23:55:42 Sinardy wrote: Hi all, Can someone tell me whats wrong with my script ? CREATE DATABASE TEST LOGFILE ( '/test/redo01.log' SIZE 10K, '/test/redo02.log' SIZE 10K, '/test/redo03.log' SIZE 10K ) MAXL0GFILES 6 MAXINSTANCES 4 NOARCHIVELOG CHARACTER SET US7ASCII DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON ; When I try this script, I recieve this SVRMGRL @CreateDB '/test/redo01.rdo' SIZE 10K, ORA-00907: missing right paranthesis Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Create Database ORA-907 need help
Hi Sinardy! First of all take a look at $ORACLE_HOME/RDBMS/admin/build_db.sql for sample code. Rajesh was right - brackets not needed here. cu, Igor -Original Message- From: Sinardy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Create Database ORA-907 need help Hi all, Can someone tell me whats wrong with my script ? CREATE DATABASE TEST LOGFILE ( '/test/redo01.log' SIZE 10K, '/test/redo02.log' SIZE 10K, '/test/redo03.log' SIZE 10K ) MAXL0GFILES 6 MAXINSTANCES 4 NOARCHIVELOG CHARACTER SET US7ASCII DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON ; When I try this script, I recieve this SVRMGRL @CreateDB '/test/redo01.rdo' SIZE 10K, ORA-00907: missing right paranthesis Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BELOV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).