Solutions for Oracle Net Configuration Assistant failed exceptions

From: http://blog.itpub.net/25851087/viewspace-1419440/

Category: Oracle

"Environment Parameters"

Host os::win7 32bit

Client os::oracle Enterprise Linux 5

Virtual machines: VMware 10.0..1

Oracle version: Oracle 11g R2

"The scene of the disaster is a reappearance"

1 , Obstacle Description:

During the installation of ORACLE11GR2 in CentOS or Oracle Enterprise Linux environments, when the user installs Oracle,
"Create andConfigure a database" was selected and "[INS-20802] Oracle Net Configuration Assistant was present during the installation process failed "The error,
Specific as shown.

2 , obstacle scene pictures

Figure 1:

Figure 2:

"Obstacle Scene II reappearance"

1 , Obstacle Description:

When the user installs Oracle, it selects "Install database softwareonly" and an error occurs when starting DBCA.

After the user installs only the Oracle11groot database software (that is, when the user installs Oracle, the "Installdatabase softwareonly" is selected), When you are ready to configure listener through NETCA, the "[INS-20802] Oracle Net configuration Assistant failed" error is reported when executing NETCA.

2 , obstacle scene pictures

"Cause of the problem"

DBCA program due to lack of patch package does not start properly, need to hit P8670579_112010_linux.zip patch pack.

"Solutions"

To the following Web site to download the P8670579_112010_linux.zip patch package, follow the README.txt steps to the patch after the execution of DBCA, create a graph of the db out, problem resolution.

P8670579_112010_linux.zip Download:

Free on http://linux.linuxidc.com/(server for Linux commune)

User name and password are www.linuxidc.com

Specific download directory in/2012 Profile/8 months/28th/oracle 11GR2 Execute DBCA report error

Online search for a lot of related posts, basically said 64-bit machine installed 32-bit data caused, but my machine is 32-bit,
The version of Oracle that was downloaded is also 32-bit, but it is also reported in this error. First of all, according to the online said need to hit the patch P8670579_112010_linux.zip.

"Patch Installation Steps"

1. Download the P8670579_112010_linux.zip and upload it to the directory on the server/ftp

2. Verify that the Oracle_home is configured

[Email protected]]$ echo $ORACLE _home

/u01/app/oracle/product/11.2.0/db_1

3. Check the version of Perl and require more than 5.00503 versions

[Email protected] 8670579]$ perl-v

This was Perl, v5.8.8 built for I386-linux-thread-multi

4.Verify the OUI Inventory.

$opatch lsinventory//You can use the following command if you do not include the Opath path to the Oralce user's path variable: $/u01/app/oracle/product/11.2.0/db_1/opatch/ Opatch lsinventory

Attention:

Opatch command is in the $oracle_home/opatch/directory, the environment variable path does not contain the directory, the direct-typing opatch command is prompted to find the change command, you need to add the directory to path.

The command results are as follows:

5. Unzip the patch pack

$unzip P8670579_112010_linux.zip

6. Ensure that the database is stopped.

$CD/ftp/8670579

$opatch Apply // execute this command in the 8670579 directory

7. If the patch is successful, subordinate results will appear.

"Where's the patch?"

"README.txt is described in the following "

The instructions in README.txt are as follows:

[Email protected] 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 has 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 has 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 the returned version of Perl is 5.00503 or higher
If the Perl configured for the oracle_home are 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-all customers is 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 would 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
would be referred to later in the document as <patch_top>.
7. Unzip the patch zip file into the <patch_top>.
unzip-d <patch_top> <zip_file>
8. Shut down services running from the Oracle_home.
Before applying this patch, does a clean shut down of all services
Running from the Oracle_home.
(a) in a Non-rac environment:
Shut down all services, that is 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 under the RAC system, shut down the services for
The specific machine is running from the oracle_home.
Opatch'll be used on each node in the RAC system one at
A time. If This patch was not rolling RAC installable treat
It as a non-rac environment and shut down all services.
As an example, in the case of a-a-node RAC system:
1. Stop instances running on Node 1.
2. Run ' Opatch apply <patch_top>/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-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 in the directory where the patch is located.
% CD <patch_top>/8670579
2. Apply the patch.
Use the following command to apply the patch to the Oracle_home:
% Opatch Apply
When Opatch starts, it'll validate the patch and make sure there
is no conflicts with the software already installed in the oracle_home.
Opatch categorizes of 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 would automatically is 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 is unzipped.
% CD <patch_top>/8670579
3. Run Opatch to deinstall the patch.
% Opatch Rollback-id 8670579

Attention:

Opatch command is in the $oracle_home/opatch/directory, the environment variable path does not contain the directory, the direct-typing opatch command is prompted to find the change command, you need to add the directory to path.

-------the End------

Nice Day
Zjrodger

If the reader wants to reprint, please indicate the source and the author's name, thank you.
Address 01:http://space.itpub.net/25851087
Address 02:http://www.cnblogs.com/zjrodger/
Address 03:http://blog.csdn.net/zjrodger
Author Name: Zjrodger

Solutions for Oracle Net Configuration Assistant failed exceptions