Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-65008: missing or invalid SEED clause

Zaur AliyevNov 24 2014 — edited Nov 25 2014

Hi. i want to create oracle database manually on oracle linux 7. When i try i meet this error . Could you explain me please where i did mistake ?

[oracle@localhost 12.1.0]$ sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 24 21:38:34 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> conn / as sysdba

Connected to an idle instance.

SQL>

SQL>

SQL> create spfile from pfile='/u01/app/oracle/product/12.1.0/init.ora';

File created.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1543503872 bytes

Fixed Size            2924736 bytes

Variable Size          989859648 bytes

Database Buffers      536870912 bytes

Redo Buffers           13848576 bytes

SQL>

SQL>run

  1  CREATE DATABASE zaur

  2  user sys identified by Oracle101

  3  user system identified by Oracle101

  4  logfile group 1 ('/u01/app/oracle/product/12.1.0/oradata/redo01.log') size 50m,

  5  group 2 ('/u01/app/oracle/product/12.1.0/oradata/redo02.log') size 50 m

  6  maxlogfiles 5

  7  maxlogmembers 5

  8  maxloghistory 1

  9  maxdatafiles 100

10  maxinstances 1

11  character set us7ascii

12  national character set al16utf16

13  datafile '/u01/app/oracle/product/12.1.0/oradata/sysaux.dbf' size 325 m reuse extent management local

14  sysaux datafile '/u01/app/oracle/product/12.1.0/oradata/sysaux.dbf' size 400 m reuse

15  default tablespace tbs_1 datafile '/u01/app/oracle/product/12.1.0/oradata/user.dbf' size 200m reuse autoextend on maxsize unlimited

16  default temporary tablespace tempts1 tempfile '/u01/app/oracle/product/12.1.0/oradata/temp_tbs.dbf' size 20m reuse

17* undo tablespace undotbs datafile '/u01/app/oracle/product/12.1.0/oradata/undo01.dbf' size 200m reuse autoextend on maxsize unlimited

CREATE DATABASE zaur

*

ERROR at line 1:

ORA-65008: missing or invalid SEED clause

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2014
Added on Nov 24 2014
2 comments
5,279 views