oracle 12c 静默安装以及使用问题小结

一：一定先创建监听，然后建库，否则报错：[oracle@tvy-mysql-cdsp-01 database]$ dbca -silent -createDatabase -responseFile /media/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.[FATAL] [DBT-07505] Selected listener (LISTENER) does not exist.ACTION: Specify an existing listener. 二：当内存大于4G的时候，需要automaticMemoryManagement=FALSE[oracle@tvy-mysql-cdsp-01 database]$ dbca -silent -createDatabase -responseFile /media/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.[FATAL] [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB.CAUSE: The current total physical memory is 125GB.三：只能在特定的pdb数据库创建用户，不能在cdb创建用户，除非你创建 公用用户(开头必须是字母+##)create user c##liuwenhe identified by test;否则会报错!SQL> create user liuwenhe identified by "liuwenhe#123";create user liuwenhe identified by "liuwenhe#123"*ERROR at line 1:ORA-65096: invalid common user or role nameSQL> alter session set container=BHDB_PDB ;Session altered.SQL> create user liuwenhe identified by "liuwenhe#123";User created. 四：oracle 19c 无法动态注册监听(原因未知)解决办法：使用静态注册曲线救国，