安装oracle12f 闪退,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 name

SQL> alter session set container=BHDB_PDB ;

Session altered.

SQL> create user liuwenhe identified by "liuwenhe#123";

User created.

四：oracle 19c 无法动态注册监听(原因未知)解决办法：使用静态注册曲线救国，

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = bhdb_pdb)

(ORACLE_HOME = /data/u01/app/oracle/product/12.2.0.1/db_1)

(SID_NAME = bhdb)

)

(SID_DESC =

(GLOBAL_DBNAME = bhdb_pdb2)

(ORACLE_HOME = /data/u01/app/oracle/product/12.2.0.1/db_1)

(SID_NAME = bhdb)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = slave15.happycfc.net)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

五：低版本客户端连接高版本的oracle 12c 由于版本不兼容导致连接不上

Oracle11g 客户端，链接Oracle12C 2.*数据库服务， 出现的版本不兼容问题

使用PLSQ报错

Oracle12c连接问题ORA-28040：没有匹配的验，具体如下

解决办法：

在配置文件中添加如下语句

vi $ORACLE_HOME/network/admin/sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

解释：

SQLNET.ALLOWED_LOGON_VERSION_SERVER：控制可以连接到12c数据库的客户端版本(client —>orace 12c db )

SQLNET.ALLOWED_LOGON_VERSION_CLIENT：控制12c数据库可以连到哪些版本的数据库(orace 12c db —>其它版本的oracle db)，例如：控制通过DB LINK可连接到哪些版本的oracle库。

该参数用来限制可以连接到数据库服务器上的最小客户端版本，比如设置值为10，即10g，11g等以上客户端版本可以连接到数据库服务器上。在没有指定的时候是用默认值的，导致低版本连接不上高版本的数据库。说白了解决兼容性问题就是让高版本的额数据库服务也能让低版本的额数据库来连接。

六：安装oracle 18c开始，Oracle希望你把安装包解压到$ORACLE_HOME目录下，否则静默安装的时候会抛出下面的错误

./runInstaller -silent -responseFile /data/oracle18c/oracle_software/install/response/db_install2.rsp -ignorePrereqFailure

Launching Oracle Database Setup Wizard...

[FATAL] [INS-35954] The installer has detected that the Oracle home location provided in the response file is not correct.

CAUSE: The Database Oracle home is the location from where the installer is executed. It has been detected that the value set in the response file is different (/data/oracle18c/product). Value expected is: /data/oracle18c/oracle_software

ACTION: It is not required to specify ORACLE_HOME in the response file for Database installation. Alternatively, set it to the location of the installer (/data/oracle18c/oracle_software).

解决办法：解压的时候直接解压到oracle_home：

unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME

七：oracle 18c 开始应答文件路径发生变化,具体如下：

软件$ORACLE_HOME/install/response/db_install.rsp

监听$ORACLE_HOME/assistants/netca/netca.rsp

建库$ORACLE_HOME/assistants/dbca/dbca.rsp