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

屯溪網(wǎng)站建設公司成都創(chuàng)新互聯(lián)公司,屯溪網(wǎng)站設計制作，有大型網(wǎng)站制作公司豐富經(jīng)驗。已為屯溪上千提供企業(yè)網(wǎng)站建設服務。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站建設要多少錢，請找那個售后服務好的屯溪做網(wǎng)站的公司定做！

一：一定先創(chuàng)建監(jiān)聽，然后建庫，否則報錯：

[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.

二：當內(nèi)存大于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數(shù)據(jù)庫創(chuàng)建用戶，不能在cdb創(chuàng)建用戶，除非你創(chuàng)建 公用用戶(開頭必須是字母+##)

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 無法動態(tài)注冊監(jiān)聽(原因未知)解決辦法：使用靜態(tài)注冊曲線救國，

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.*數(shù)據(jù)庫服務， 出現(xiàn)的版本不兼容問題

使用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數(shù)據(jù)庫的客戶端版本(client —>orace 12c db )

SQLNET.ALLOWED_LOGON_VERSION_CLIENT：控制12c數(shù)據(jù)庫可以連到哪些版本的數(shù)據(jù)庫(orace 12c db —>其它版本的oracle db)，例如：控制通過DB LINK可連接到哪些版本的oracle庫。

該參數(shù)用來限制可以連接到數(shù)據(jù)庫服務器上的最小客戶端版本，比如設置值為10，即10g，11g等以上客戶端版本可以連接到數(shù)據(jù)庫服務器上。在沒有指定的時候是用默認值的，導致低版本連接不上高版本的數(shù)據(jù)庫。說白了解決兼容性問題就是讓高版本的額數(shù)據(jù)庫服務也能讓低版本的額數(shù)據(jù)庫來連接。

六：安裝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 開始應答文件路徑發(fā)生變化,具體如下：

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

監(jiān)聽$ORACLE_HOME/assistants/netca/netca.rsp

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

到此，相信大家對“怎么解決oracle 12c靜默安裝的使用問題”有了更深的了解，不妨來實際操作一番吧！這里是創(chuàng)新互聯(lián)網(wǎng)站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學習！