怎么解決oracle 12c靜默安裝的使用問題

本篇內容主要講解“怎么解決oracle 12c靜默安裝的使用問題”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學習“怎么解決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

到此，相信大家對“怎么解決oracle 12c靜默安裝的使用問題”有了更深的了解，不妨來實際操作一番吧！這里是億速云網站，更多相關內容可以進入相關頻道進行查詢，關注我們，繼續學習！