eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle Database 19c 的发布时间确定和升级建议 | Blog首页 | Oracle 比率:Redo Nowait Ratio 的计算方式 »

Oracle 12.2 DBCA 使用 Silent 建库

许久没有用 Silent 方式建库了,非常顺畅,建立一个 12.2 非多租户的数据库:

[oracle12c@iz2zeezinabu7k6olgelwez ~]$ dbca -silent -createDatabase \

> -templateName General_Purpose.dbc \

> -gdbname eygle -sid eygle -responseFile NO_VALUE \

> -characterSet AL32UTF8 \

> -sysPassword OraPasswd1 \

> -systemPassword OraPasswd1 \

> -createAsContainerDatabase false \

> -databaseType MULTIPURPOSE \

> -automaticMemoryManagement false \

> -totalMemory 1536 \

> -storageType FS \

> -datafileDestination "/u01/oracle12c/db/oradata/" \

> -redoLogFileSize 50 \

> -emConfiguration NONE \

> -ignorePreReqs

[WARNING] [DBT-11207] Specified SGA size is greater than the shmmax on the system. This might make database creation to fail with ORA-27125 - Unable to create shared memory segment error.

ACTION: Specify SGA size lesser than or equal to the shmmax on the system.

Copying database files

1% complete

2% complete

18% complete

33% complete

Creating and starting Oracle instance

35% complete

40% complete

44% complete

49% complete

50% complete

53% complete

55% complete

Completing Database Creation

56% complete

57% complete

58% complete

62% complete

65% complete

66% complete

Executing Post Configuration Actions

100% complete

Look at the log file "/u01/oracle12c/db/cfgtoollogs/dbca/eygle/eygle.log" for further details.

如果是多租户,增加几个参数,类似如下:

dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname cdb01 -sid cdb01 -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword OraPasswd1 \
-systemPassword OraPasswd1 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName pdb3 \
-pdbAdminPassword OraPasswd1 \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1536 \
-storageType FS \
-datafileDestination "/u01/app/oracle/oradata/" \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs

操作很简单.


历史上的今天...
    >> 2013-01-16文章:
    >> 2010-01-16文章:
    >> 2008-01-16文章:
    >> 2007-01-16文章:
    >> 2006-01-16文章:
           How Big SCN can be?
    >> 2005-01-16文章:
           FAQ List

By eygle on 2019-01-16 21:16 | Comments (0) | Oracle12c/11g | 3329 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com