Oracle Net Configuration Assistant failed異常的解決方案
【環境引數】
Host OS: : Win7 32bit
Client OS: : Oracle Enterprise Linux 5
虛擬機器: VMware 10.0..1
Oracle 版本: Oracle 11g R2
【障害場景一再現】
1 、障礙描述:
在
CentOS
或者
Oracle Enterprise Linux
環境下,
安裝
Oracle11gR2
的過程
中,使用者在安裝
Oracle
時,
選擇了“
Create and Configure a database
”,在安裝的過程中出現了“
[INS-20802] Oracle Net Configuration Assistant failed
”的錯誤,
具體如下圖所示。
2 、障礙場景圖片
圖 1 :
圖 2 :
【障礙場景二再現】
1 、障礙描述:
使用者在安裝 Oracle 時,選擇的是“ Install database software only ”之後,啟動 DBCA 時出現錯誤。
在使用者僅僅安裝完 Oracle11gRoot 資料庫軟體 後(即,使用者在安裝 Oracle 時,選擇了“ Install database software only ”),準備通過 netca 來配置 listener 時,在執行 netca 的時候報出“ [INS-20802] Oracle Net Configuration Assistant failed ”錯誤。
2 、障礙場景圖片
【問題原因】
DBCA 程式由於缺少補丁包無法正常啟動,需要打 p8670579_112010_LINUX.zip 補丁包。
【解決方案】
到下述網站上下載 p8670579_112010_LINUX.zip 補丁包 , 按照 README.txt 步驟將該補丁打上後執行 dbca,, 建立 db 的圖形出來了 , 問題解決 .
p8670579_112010_LINUX.zip 下載:
具體下載目錄在 /2012 年資料 /8 月 /28 日 /Oracle 11gR2 執行 DBCA 報錯誤
網上搜尋了很多相關的帖子
,
基本上說的是
64
位的機器安裝了
32
位的資料導致的
,
但我的機器是
32
位的
,
下載的
oracle
版本也是
32
位的
,
但也報這個錯誤
.
先不管了
,
按照網上說的需要
打補丁
p8670579_112010_LINUX.zip
.
【補丁安裝步驟】
1. 下載 p8670579_112010_LINUX.zip, 並上傳到伺服器上的目錄 /ftp
2. 確認是否配置了 ORACLE_HOME
[oracle@primary]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
3. 檢查 perl 的版本 , 需要 5.00503 以上的版本
[oracle@primary 8670579]$ perl -v
This is perl, v5.8.8 built for i386-linux-thread-multi
4. Verify the OUI Inventory.
$opatch lsinventory // 若沒有將 opath 的路徑加入到 oralce 使用者的 PATH 變數中,也可以使用以下命令: $/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory
注意:
opatch 命令是在 $ORACLE_HOME/OPatch/ 目錄下 , 環境變數 PATH 中沒有包含該目錄的話 , 直接敲入 opatch 命令是提示找不到改命令的 , 這時需要將該目錄加入到 PATH 中 .
命令結果如下所示:
5. 解壓縮補丁包
$unzip p8670579_112010_LINUX.zip
6. 確保資料庫已經停止。
$cd /ftp/8670579
$opatch apply
//
在
8670579
這個目錄下執行此命令
7. 若打完補丁成功,則會出現下屬結果。
【補丁補充的是什麼地方】
【 README.txt 裡的說明如下】
README.txt 裡的說明如下 :
[oracle@primary 8670579]$ more README.txt
=========================================================================
Interim Patch for Base Bug: 8670579
=========================================================================
Date: 25th February 2010
-------------------------------------------------------------------------
Platform. Patch for : Linux x86
Product Patched : NETWORK
Product Version # : 11.2.0.1
RAC Rolling Installable : YES
Online Installable : NO
Bugs Fixed by this patch:
-------------------------
8670579 - DBBETA :NETCA/DBCA FAILED WITH HOTSPOT VIRTUAL MACHINE
Patch Preinstall Steps
----------------------
1. For non-recommended patches, you must have the exact symptoms
described in the service request (SR).
2. Confirm the version of Perl installed and configured for the ORACLE_HOME.
Oracle requires that all customers have at least Perl 5.00503 installed
and configured for patching activities inside the ORACLE_HOME. Follow
these steps to check the Perl version for the ORACLE_HOME being patched:
- source the ORACLE_HOME environment
- execute "perl -v"
- verify that the returned version of Perl is 5.00503 or higher
If the Perl configured for the ORACLE_HOME is not at 5.00503 or
higher, follow the directions in this metalink note to update to
a more recent version:
https://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=189489.1
3. Verify the OUI Inventory.
OPatch needs access to a valid OUI inventory to apply patches.
Validate the OUI inventory with the following command:
% opatch lsinventory
If the command errors out, contact Oracle Support and work to validate
and verify the inventory setup before proceeding.
4. Review and download the latest version of OPatch.
Oracle recommends that all customers be on the latest version of OPatch.
Please review the following metalink note and follow the instructions
to update to the latest version if needed:
https://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=224346.1
5. Confirm executables appear in your system PATH.
The patching process will use the unzip and the opatch executables. After
sourcing the ORACLE_HOME environment, confirm both of these exist before
continuing:
- "which opatch"
- "which unzip"
If either of these executables do not show in the PATH, correct the problem
before proceeding.
6. Create a location for storing the unzipped patch. This location
will be referred to later in the document as .
7. Unzip the patch zip file into the .
unzip -d
8. Shut down services running from the ORACLE_HOME.
Before applying this patch, do a clean shut down of all services
running from the ORACLE_HOME.
(a) In a non-RAC environment:
Shut down all services that are running from this ORACLE_HOME.
Confirm the return status from each shutdown command to verify
the shutdown is successful and there are no errors.
(b) In a RAC environment:
For each node in the RAC system, shut down the services for
the specific machine that are running from the ORACLE_HOME.
OPatch will be used on each node in the RAC system one at
a time. If this patch is not rolling RAC installable treat
it as a non-RAC environment and shut down all services.
As an example, in the case of a two node RAC system:
1. Stop instances running on node 1.
2. Run 'opatch apply /8670579' on node 1.
3. When the apply finishes, opatch asks for confirmation
before going on to apply the patch to node 2.
4. Start instances on node 1.
5. Stop instances running on node 2.
6. Ask opatch to continue to applying the patch to node 2.
7. Start instances on node 2.
9. Apply pre-requisite updates.
Patch Installation Steps:
-------------------------
1. Set your current directory to the directory where the patch is located.
% cd /8670579
2. Apply the patch.
Use the following command to apply the patch to the ORACLE_HOME:
% opatch apply
When OPatch starts, it will validate the patch and make sure there
are no conflicts with the software already installed in the ORACLE_HOME.
OPatch categorizes two types of conflicts:
(a) Conflicts with a patch already applied to the ORACLE_HOME
In this case, please stop the patch installation and contact
Oracle Support Services.
(b) Conflicts with subset patch already applied to the ORACLE_HOME
In this case, please continue the install, as the new patch
contains all the fixes from the existing patch in the ORACLE_HOME.
The subset patch will automatically be rolled back prior to the
installation of the new patch.
Patch Post Install Instructions:
--------------------------------
sqlplus / as sysdba
exec SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS;
Patch Deinstallation Instructions:
----------------------------------
1. Make sure to follow the same pre-install steps when deinstalling
a patch. This includes verifying the inventory and shutting down
any services running from the ORACLE_HOME / machine before rolling
the patch back.
2. Change to the directory where the patch was unzipped.
% cd /8670579
3. Run OPatch to deinstall the patch.
% opatch rollback -id 8670579
注意:
opatch 命令是在 $ORACLE_HOME/OPatch/ 目錄下 , 環境變數 PATH 中沒有包含該目錄的話 , 直接敲入 opatch 命令是提示找不到改命令的 , 這時需要將該目錄加入到 PATH 中 .
-------The End------
Nice Day
zjrodger
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70020061/viewspace-2906025/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- INS-20802 ORACLE NET CONFIGURATION ASSISTANT FAILED 問題解決OracleAI
- 【xiaotie】Asp.Net異常Asynchronous 的解決方案ASP.NET
- [Ins-20802] Oracle Database Configuration Assistant failedOracleDatabaseAI
- Failed to upgrade Oracle Cluster Registry configuration的解決辦法AIOracle
- “Validation failed for one or more entities”異常的解決辦法AI
- oracle出異常:Io 異常: The Network Adapter could not establish the connection 解決辦法OracleAPT
- [持續更新]hive異常解決方案Hive
- Redis快取的主要異常及解決方案Redis快取
- native程式異常crash定位解決方案
- INS-20802 Automatic Storage Management Configuration Assistant failedAI
- 77種Java異常總結 附解決方案Java
- SpringCloud BeanCurrentlyInCreationException 異常解決方案SpringGCCloudBeanException
- 一種 Laravel 異常上下文解決方案Laravel
- maven異常:Updating Maven Project 的統一解決方案MavenProject
- Tomcat常見異常及解決方案程式碼例項Tomcat
- javaWeb常見異常的解決方法JavaWeb
- Ionic異常及解決
- asp.net 連結 oracle 解決方案ASP.NETOracle
- migrate:rollback 時 dropForeign 丟擲的異常解決方案
- android.os.NetworkOnMainThreadException異常怎麼解決AndroidAIthreadException
- Failed to upgrade Oracle Cluster Registry configurationAIOracle
- Oracle RAC 安裝 執行 root.sh時報Failed to upgrade Oracle Cluster Registry configuration問題的解決OracleAI
- flume file channel 異常解決
- Unknowncolumn'*'in'fieldlist'異常解決
- Mysql 的一些異常解決MySql
- JVM 異常退出的問題解決JVM
- .net 2.0 訪問Oracle --與Sql Server的差異,注意事項,常見異常OracleSQLServer
- oracle程式異常中止時登入掛起問題的解決Oracle
- CentOS 常見異常及解決辦法CentOS
- CrashSight異常崩潰管理解決方案
- socket write failed(24) _Netbackup的問題解決AI
- “The last packet sent successfully to the server was 0 milliseconds ago. ”異常解決方案ASTServerGo
- Shiro身份驗證丟擲AuthenticationException異常,解決方案Exception
- 異常解決——Failed to introspect Class [com.github.pagehelper.autoconfigure.PageHelperAutoConfiguration]AIROSGithub
- flutter packages get - pub get failed (1)解決方案FlutterPackageAI
- oracle 異常Oracle
- 關於SpringMVC的HttpMediaTypeNotSupportedException異常解決SpringMVCHTTPException
- asp.net iis7預設文件錯誤異常的解決方法ASP.NET