Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OPatch error

768527Sep 28 2010
Hello everybody.

I'm a newbie in applying/installing Oracle patches.
I'm trying to upgrade the Discoverer from 4i to 10g and for this I'm supposed to install this update (among others): 2291496.
Since I didn't do this until now, I read on the Internet and I'm trying to use OPatch to install the update.
I downloaded the file, extracted it, uploaded on the server in the oracle user's home directory.
I logged on with the oracle user, set the $ORACLE_HOME env and tried to call the opatch apply command.

This is the command line:

[oracle@ispdevtst 2291496]$ /u01/oracle/ispdb/9.2.0/OPatch/opatch apply
PERL5LIB=/u01/oracle/ispdb/9.2.0//Apache/perl/lib/5.00503:/u01/oracle/ispdb/9.2.0/OPatch/perl_modules; export PERL5LIB
/u01/oracle/ispdb/9.2.0//Apache/perl/bin/perl /u01/oracle/ispdb/9.2.0/OPatch/opatch.pl apply
Oracle Home = /u01/oracle/ispdb/9.2.0/
Location of Oracle Universal Installer components = /u01/oracle/ispdb/9.2.0/oui
Location of OraInstaller.jar = "/u01/oracle/ispdb/9.2.0/oui/jlib"
Oracle Universal Installer shared library = /u01/oracle/ispdb/9.2.0/oui/lib/linux/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /u01/oracle/ispdb/9.2.0/inventory
Path to Java = /u01/oracle/ispdb/9.2.0/jre/1.4.2/bin/java

oracle.ops.mgmt.cluster.ClusterInfoException: CMCLI ERROR: OpenCommPort: connect failed with error 2. /u01/oracle/ispdb/9.2.0/oui/bin/lsnodes.bin: struct size 0
at oracle.ops.mgmt.cluster.ClusterInfo.getNodeNames(ClusterInfo.java:259)
at oracle.sysman.oii.oiip.oiipg.OiipgVendorClusterwareInfo.isCluster(OiipgVendorClusterwareInfo.java:75)
at oracle.sysman.oii.oiip.oiipg.OiipgDetectCluster.isCluster(OiipgDetectCluster.java:149)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at opatch.OuiDep.isCluster(OuiDep.java:96)
at opatch.O2O.setIsCluster(O2O.java:724)
at opatch.O2O.queryRAC(O2O.java:801)
at opatch.O2O.setupInventoryThenRAC(O2O.java:921)
at opatch.GetPlatformID.main(GetPlatformID.java:43)

OPatch Version 1.0.0.0.51
Perl Version 5.00503

/u01/oracle/ispdb/9.2.0/OPatch/opatch.pl version: 1.0.0.0.51
Copyright (c) 2001-2004 Oracle Corporation. All Rights Reserved.

The patch directory area must be a number.

ERROR: OPatch failed because of problems in patch area.
[oracle@ispdevtst 2291496]$

Can anyone tell what can I do or what am I doing wrong here ?

Thank you and regards,
Sorin Miroiu

Comments

Nabot Dash
Answer

Domain name is an important parameter you need to have that handy before proceeding here:

1. Verify the domain name:

show parameters db_domain;

OR

SELECT value FROM v$parameter WHERE UPPER(name) = 'DB_DOMAIN';

2. Change if applicable (Take DBA help)

If the domain name has any characters other than A-Z (letters), 0-9 (numerals), _ (underscore), # (hash), $ (dollar),. (period), or @ (at the rate), for example, a '-' (hyphen), then change the domain name.

alter system set db_domain='<domain_name_with_illegal_char_replaced_with_legal_char>' scope=spfile sid='*';

3. Have the connection string in following format.

    SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)))

4. Provide the target database name:

    SELECT value FROM v$parameter WHERE UPPER(name) = 'DB_NAME';

Then you can have all these to check your connection.

Please mark Helpful or Correct if this information helped you in any way.

Cheers !

Marked as Answer by Beauty_and_dBest · Sep 27 2020
1 person found this helpful
Beauty_and_dBest

Thaks Noname

I will check that...brb

yoonas

Please see if it helps, i did it longer back when i had to work on FSG transfer

https://yoonusp.blogspot.com/2015/01/transferring-fsg-from-one-instance-to.html

Regards,

Yoonas

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 26 2010
Added on Sep 28 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-standard-edition-one
0 comments
308 views