Home > database >  Oracle12.2 ORA - 00821 error, for building a silent need so processing
Oracle12.2 ORA - 00821 error, for building a silent need so processing

Time:09-15

[oracle @ BMS - fb ~ 26] $dbca - silent - createDatabase - responseFile/u01/database/
The response/dbca. RSP
[WARNING] [DBT - 06801] Specified Fast Recovery Area size (2780 MB) is less than the it value.
CAUSE: the Fast Recovery Area size should at further be three times the database size (2730 MB).
ACTION: Specify the Fast Recovery Area Size to be at further three times the database Size.
Enter SYS user password:

Enter the SYSTEM user password:

Enter PDBADMIN User Password:

[WARNING] [DBT - 06208] The 'SYS password rose does not conform to The Oracle it standards.
CAUSE:
A. the Oracle recommends that the password rose should be at further eight characters in length, contain at further 1 uppercase character, 1 lower case character and one digit [0-9].
B.T he "rose is a keyword that Oracle does not how to be, informs the as password
ACTION: Specify a strong password. If the required refer Oracle documentation for guidelines.
[WARNING] [DBT - 06208] The 'SYSTEM' password rose does not conform to The Oracle it standards.
CAUSE:
A. the Oracle recommends that the password rose should be at further eight characters in length, contain at further 1 uppercase character, 1 lower case character and one digit [0-9].
B.T he "rose is a keyword that Oracle does not how to be, informs the as password
ACTION: Specify a strong password. If the required refer Oracle documentation for guidelines.
[WARNING] [DBT - 06208] The 'PDBADMIN password rose does not conform to The Oracle it standards.
CAUSE:
A. the Oracle recommends that the password rose should be at further eight characters in length, contain at further 1 uppercase character, 1 lower case character and one digit [0-9].
B.T he "rose is a keyword that Oracle does not how to be, informs the as password
ACTION: Specify a strong password. If the required refer Oracle documentation for guidelines.
[WARNING] [DBT - 06801] Specified Fast Recovery Area size (2780 MB) is less than the it value.
CAUSE: the Fast Recovery Area size should at further be three times the database size (3571 MB).
ACTION: Specify the Fast Recovery Area Size to be at further three times the database Size.
Copying the 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.



//error log
[oracle @ BMS - fb ~ 26] $tail -f/u01/app/oracle/cfgtoollogs/dbca/cdb1/cdb1 log
1% DBCA_PROGRESS:
[the 2019-05-31 00:39:42. 484 CST] ORA - 00821: the Specified value of sga_target 600 m is too small, needs to be at further 1288 m
ORA - 01078: a failure in processing system parameters

2% DBCA_PROGRESS:
[the 2019-05-31 00:39:42. 485 CST] ORA - 01034: ORACLE not available

[the 2019-05-31 00:39:42. 486 CST] ORA - 01034: ORACLE not available

[the 2019-05-31 00:39:47. 631 CST] DBCA_PROGRESS: DBCA Operation failed.


Adjust the kernel parameters, and parameter template to silence after installing software and monitoring, silent or at the wrong of building warehouse,

1, novice don't see how the sga_target set, baidu to check make up sqlplus, start the database error,
2, must to build library to start

CodePudding user response:

Sga is too small you template change big, at least 1288 MB
Fast Recovery Area size is too small, at least 4 GB
The complexity of the password below

CodePudding user response:

How to change a big sga_target
The building Lord how to solve
  • Related