[oracle@bms-26fb ~]$ dbca -silent -createDatabase -responseFile /u01/database/
response/dbca.rsp
[WARNING] [DBT-06801] Specified Fast Recovery Area size (2,780 MB) is less than the recommended value.
CAUSE: Fast Recovery Area size should at least be three times the database size (2,730 MB).
ACTION: Specify Fast Recovery Area Size to be at least three times the database size.
Enter SYS user password:
Enter SYSTEM user password:
Enter PDBADMIN User Password:
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06801] Specified Fast Recovery Area size (2,780 MB) is less than the recommended value.
CAUSE: Fast Recovery Area size should at least be three times the database size (3,571 MB).
ACTION: Specify Fast Recovery Area Size to be at least three times the database size.
Copying database files
1% complete
2% complete
DBCA Operation failed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb1/cdb1.log" for further details.
//錯誤日志
[oracle@bms-26fb ~]$ tail -f /u01/app/oracle/cfgtoollogs/dbca/cdb1/cdb1.log
DBCA_PROGRESS : 1%
[ 2019-05-31 00:39:42.484 CST ] ORA-00821: Specified value of sga_target 600M is too small, needs to be at least 1288M
ORA-01078: failure in processing system parameters
DBCA_PROGRESS : 2%
[ 2019-05-31 00:39:42.485 CST ] ORA-01034: ORACLE not available
[ 2019-05-31 00:39:42.486 CST ] ORA-01034: ORACLE not available
[ 2019-05-31 00:39:47.631 CST ] DBCA_PROGRESS : DBCA Operation failed.
調整內核引數,和引數模板重新靜默安裝軟體和監聽后,靜默建庫還是報這個錯。
1、新手不明白這個sga_target怎么設定,百度查讓進sqlplus。啟動資料庫也報錯。
2、是不是必須要建庫后才能啟動
uj5u.com熱心網友回復:
sga 太小你的模板改大,至少 1288MBFast Recovery Area size 太小,至少4個GB
下面的密碼設定的復雜度不夠
uj5u.com熱心網友回復:
如何改大sga_target樓主怎么解決
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/6859.html
標籤:高級技術
