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:


Saturday, January 29, 2011

This database instance failed to turn on flashback database

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/29/2011 00:40:41
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database


Solution:

Friday, January 7, 2011

ORA-29701: unable to connect to Cluster Manager

SQL> startup
ORA-29701: unable to connect to Cluster Manager


[oracle@xxx]/oracle/product/10.2/bin$ ./localconfig delete
You must be logged in as root to run ./localconfig.
Log in as root and restart ./localconfig execution.
exit from oracle account or execute su/sudo

bash-3.00# cd /oracle/product/10.2/bin/
bash-3.00# ./localconfig delete
Stopping CSSD.
Unable to communicate with the CSS daemon.
Shutdown has begun. The daemons should exit soon.
bash-3.00# ./localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Giving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started