Monday, March 28, 2011

liboraInstaller.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)

Machine Info: SunOS XXX 5.10 Generic_142909-17 sun4u sparc SUNW,Sun-Fire-V440

I run it on Sun Fire which is 64 bit.

[oracle@XXX]/u01/app/oracle/product/wls/oms11g/OPatch$ opatch -invPtrLoc /u01/app/oracle/product/wls/oms11g/oraInst.loc -local -oh /u01/app/oracle/product/wls/oms11g/../oracle_common /u01/app/oracle/product/wls/oms11g/install/oneoffs/111010/9329357
Invoking OPatch 11.1.0.8.0
java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/wls/oracle_common/oui/lib/solaris/liboraInstaller.so: ld.so.1: java: fatal: /u01/app/oracle/product/wls/oracle_common/oui/lib/solaris/liboraInstaller.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1803)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1699)
        at java.lang.Runtime.load0(Runtime.java:770)
        at java.lang.System.load(System.java:1003)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:402)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.(OiipuUnixOps.java:125)
        at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.ssgetUidux(OiipgEnvironment.java:528)
        at oracle.sysman.oii.oiix.OiixEnvironmentOps.ssgetUidux(OiixEnvironmentOps.java:159)
        at oracle.opatch.OUIReplacer.isRootAccess(OUIReplacer.java:716)
        at oracle.opatch.OPatch.main(OPatch.java:445)
Exception in thread "main" java.lang.UnsatisfiedLinkError: no oraInstaller in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1734)
        at java.lang.Runtime.loadLibrary0(Runtime.java:823)
        at java.lang.System.loadLibrary(System.java:1028)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:420)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.(OiipuUnixOps.java:125)
        at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.ssgetUidux(OiipgEnvironment.java:528)
        at oracle.sysman.oii.oiix.OiixEnvironmentOps.ssgetUidux(OiixEnvironmentOps.java:159)
        at oracle.opatch.OUIReplacer.isRootAccess(OUIReplacer.java:716)
        at oracle.opatch.OPatch.main(OPatch.java:445)

OPatch failed with error code 1

Explore:

Friday, March 25, 2011

ORA-27102: out of memory when DBCA -createDatabase

[oracle@xxx zone:xx]~/Install/solaris.sparc64_11gR2_database/database$ $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName $SID -sid $SID -sysPassword $PASSWORD -systemPassword $PASSWORD -sysmanPassword $PASSWORD -dbsnmpPassword $PASSWORD -emConfiguration LOCAL -storageType FS -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -characterset WE8ISO8859P1 -obfuscatedPasswords false -sampleSchema false -oratabLocation /var/opt/oracle/oratab
Copying database files
1% complete
2% complete
4% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/XX01/XX01.log" for further details.
[oracle@xxx zone:xx]~/Install/solaris.sparc64_11gR2_database/database$ less /u01/app/oracle/cfgtoollogs/dbca/XX01/XX01.log
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-27102: out of memory

DBCA_PROGRESS : 4%
ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

DBCA_PROGRESS : 100%


solution

Wednesday, March 23, 2011

WebLogic Server installation, The local BEA product registry is corrupted error

[oracle@em.e-soft.ru zone:em]~/Install$ ./wls1034_solaris32.bin -mode=silent -silent_xml=./silent.xml -Djava.security.egd=file:/dev/./urandom
Extracting 0%....................................................................................................100%
The local BEA product registry is corrupted. Please select another Middleware Home or contact Oracle Support
** Error during execution, error code = 65280.

solution:

Monday, February 21, 2011

no backup or copy of datafile XX found to restore when backup actually exists

Attempting to restore catalogued backup on another host gives following error:

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-FEB-11

released channel: ch01
released channel: ch02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/20/2011 20:35:40
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile XX1 found to restore
RMAN-06023: no backup or copy of datafile XX2 found to restore

but when I did list backup, it shown backup exist.

Erorr was the consequence of  catalog command. There was attempt to catalog backupset with dificult name like /mnt/share/backup/oracle/DBNAME/local-lvl-0-db_3673504914-DB01-20110220-38400-1-1 which catalog was not able to compile.
solution:

Wednesday, February 2, 2011

silent database creation

$ dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbname rcat -sid rcat1 -datafileJarLocation /export/home/oracle/oracle/product/10.2.0/db/assistants/dbca/templates -datafileDestination /export/home/oracle/oracle/product/10.2.0/db/oradata -responseFile NO_VALUE -characterset CL8MSWIN1251
Copying database files
1% complete
3% complete

delete/add Oracle Home from Central Inventory

some times it happens...:

$ ./OPatch/opatch lsinv
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /export/home/oracle/oracle/product/10.2.0/db
Central Inventory : /u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
OUI location      : /export/home/oracle/oracle/product/10.2.0/db/oui
Log file location : /export/home/oracle/oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-02-02_14-30-01PM.log

List of Homes on this system:

  Home name= OraDb10g_home2, Location= "/d03/oracle/product/10.2.0/Db1"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73



Solution:

Sunday, January 30, 2011

alter database open resetlogs error ORA-00349

After restore & recovery I got error:

alter database open resetlogs
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'+ASMDG01/XXX/onlinelog/redo_g1_a'

in alert.log:

Sun Jan 30 06:01:07 2011
Errors in file /oracle/admin/XXX/udump/XXX_ora_3115.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '+DG01/XXX/redo_g4_b'
ORA-17503: ksfdopn:2 Failed to open file +DG01/XXX/redo_g4_b
ORA-15173: entry 'redo_g4_b' does not exist in directory 'XXX'
ORA-00312: online log 4 thread 1: '+DG01/XXX/redo_g4_a'
ORA-17503: ksfdopn:2 Failed to open file +DG01/XXX/redo_g4_a
ORA-15173: entry 'redo_g4_a' does not exist in directory 'XXX'


Solution: