Issue with running catupgrd.sql while Database upgrade from 10.2.0.4 to 11.2.0.3:

Getting below error while running catupgrd.sql scripts while DB upgrade.

SELECT TO_NUMBER('MUST_HAVE_RUN_PRE-UPGRADE_TOOL_FOR_TIMEZONE')
                *
ERROR at line 1:
ORA-01722: invalid number

Cause:
------------
The Pre-Upgrade Script is not creating the registry$database table & inserting the Platform DST Patch Information.The error may also appear if the the registry$database table exists,  but does not contain the required information.

Solution:
-----------------

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit

SQL> create table registry$database_b as select * from registry$database;

Table created.

select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit

SQL> INSERT into registry$database
  2                      (platform_id, platform_name, edition, tz_version)
  3                 VALUES ((select platform_id from v$database),
  4                         (select platform_name from v$database),
  5                          NULL,
  6                         (select version from v$timezone_file));

1 row created.

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit
         13 Linux x86 64-bit                                             4

SQL> commit;

Commit complete.

SQL> delete from sys.registry$database where TZ_VERSION is NULL;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit                                             4

Ref Doc: catupgrd.sql fails With ORA-01722 Invalid Number after running the Pre-Upgrade Script [ID 1466464.1]

Opatch Error while Applying PSU 5 Patch in 11g.

Recently i got the below error while applying the PSU5 Patch on one of my Dev instance.

[oracle@xxxxxxxxxxxxxxxxxxxxx]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
UtilSession failed: oracle/cluster/install/InstallException
Log file location: /oracle/product/11.2.0.3/XXXXXX/cfgtoollogs/opatch/opatch2013-04-25_02-37-35AM_1.log
OPatch failed with error code 73
The Stack Trace error shows the below error:

[Apr 25, 2013 2:37:38 AM]    OUI-67073:UtilSession failed: oracle/cluster/install/InstallException
[Apr 25, 2013 2:37:38 AM]    Finishing UtilSession at Thu Apr 25 02:37:38 EDT 2013
[Apr 25, 2013 2:37:38 AM]    Log file location: /oracle/product/11.2.0.3/OIMDEV/cfgtoollogs/opatch/opatch2013-04-25_02-37-35AM_1.log
[Apr 25, 2013 2:37:38 AM]    Stack Description: java.lang.RuntimeException: oracle/cluster/install/InstallException
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgClusterwareInfo.createClusterwareInfo(OiipgClusterwareInfo.java:155)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgClusterwareInfo.getClusterwareInfo(OiipgClusterwareInfo.java:180)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgDetectCluster.<init>(OiipgDetectCluster.java:131)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.sysman.oii.oiip.oiipg.OiipgDetectCluster.getDetectCluster(OiipgDetectCluster.java:146)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.Rac.getLocalNode(Rac.java:1789)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.Rac.getInstance(Rac.java:1236)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.Rac.getInstance(Rac.java:1101)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.opatchutil.NSession.validateConnectStringNodes(NSession.java:85)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:418)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
[Apr 25, 2013 2:37:38 AM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Apr 25, 2013 2:37:38 AM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Apr 25, 2013 2:37:38 AM]    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Apr 25, 2013 2:37:38 AM]    StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2346)
[Apr 25, 2013 2:37:38 AM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:613)

I tried to search in oracle.support and google and didn't fine anything.. it 's looks more like java error rather than Database error. Then i carefully saw the java error and found that it is trying to searching Local Node. While querying opatch lsinv, the local and remote node was showing different node name rather than current node..

Rac system comprising of multiple nodes
  Local node = xxxxxxxxxxxxxxxx
  Remote node = xxxxxxxxxxxxxxxxx
SO i updated the updateNodeList parameter like below, and the opatch apply went successful.

cd $ORACLE_HOME/oui/bin/
./runInstaller -silent -updateNodeList ORACLE_HOME=/oracle/product/11.2.0.3/XXXXX "CLUSTER_NODES={host.cisco.com}"

Issues while applying RUP 7 Patch on 11.5.10 CU2 on IBM AIX

1 ld: 0711-783 WARNING: TOC overflow. TOC size: 78748 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
ld: 0711-101 FATAL ERROR: Allocation of 16204512 bytes failed
in routine init_symtab_info. There is not enough memory available.      

Solution: ld: 0711-101 FATAL ERROR: While Relinking Product MSC MSO MSR (Doc ID 330990.1)       
LDR_CNTRL=""MAXDATA=0x40000000""
export LDR_CNTRL          Run the patch again      
                           "
2.AD Worker error:
The index cannot be created as the table has duplicate keys.
Use the following SQL statement to identify the duplicate keys:

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above                                                                          

 Solution: Patch 6241631-11i.ATG_PF.H.RUP7 fails on icxwtab.odf: Table Has Duplicate Keys (Doc ID 1148403.1)            
    1. Run the backup copy of ICXDLTMP.sql as the APPS user from the 11i.ATG_PF.H.delta.7 Patch directory.
    For example :
    sqlplus apps/apps_pwd @patch Directory/backup/[SID]/[HostName]/icx/sql/ICXDLTMP.sql           
 2. Restart the failed worker via the adctrl Utility using option 2"

adncep3(): Invalid destination character set: UTF8

Issue with the Patch Admerge :
----------------------------------------
Character-set converting files...
adncep3(): Invalid destination character set:  UTF8

Adncnv error:
  Character-set conversion failed

Please check the adncnv logfile at admrgpch.log.

************* Start of AD Character-set Conversion session *************
AD Character-set Conversion version: 12.0.0
AD Character-set Conversion started at: Fri Jan 27 2012 05:32:18

AD Merge Patch error:
  Character-set conversion failed.

Solution:
--------
To implement the solution, please execute the following steps:

1. Manually set (and export) environment variable NLS_LANG to be American_America.US7ASCII.

2. Run again
     admrgpch -s patches -d mrgd_patches -merge_name mrg_patch

3. Migrate the solution as appropriate to other environments.

Export Import Issues

IMP-00019: row rejected due to ORACLE error 1

IMP-00003: ORACLE error 1 encountered

ORA-00001: unique constraint (APPLSYS.FND_CONC_PROG_ONSITE_INFO_U1) violated

ORA-06512: at "APPS.FND_PROG_ONSITE_INSERT", line 4

ORA-04088: error during execution of trigger 'APPS.FND_PROG_ONSITE_INSERT'

Solution:

We have dropped the index FND_CONC_PROG_ONSITE_INFO_U1 and import the table FND_CONCURRENT_PROGRAMS and finally create the index.

SQL> Drop index FND_CONC_PROG_ONSITE_INFO_U1;

Index dropped.

dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_CONCURRENT_PROGRAMS  commit=y ignore=Y log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi_1

Import: Release 10.2.0.3.0 - Production on Fri Jan 21 17:51:43 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing APPLSYS's objects into APPLSYS
. . importing table      "FND_CONCURRENT_PROGRAMS"       9841 rows imported
Import terminated successfully without warnings.

SQL> select count(*) from APPLSYS.FND_CONCURRENT_PROGRAMS;

  COUNT(*)
----------
      9841

SQL> CREATE INDEX "APPLSYS"."FND_CONC_PROG_ONSITE_INFO_U1" ON "APPLSYS"."FND_CONC_PROG_ONSITE_INFO" ("PROGRAM_APPLICATION_ID", "CONCURRENT_PROGRAM_ID") PCTFREE 0 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT) TABLESPACE  "APPS_TS_TX_IDX" ;

Index created.

Issues: 

IMP-00058: ORACLE error 1552 encountered
ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_SEED'
Import terminated successfully with warnings.

We tried to execute the import command with below command and got the error.

dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_USER  commit=y ignore=Y CONSTRAINTS=N indexes=N
log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi

Import: Release 10.2.0.3.0 - Production on Fri Jan 21 14:20:22 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing APPLSYS's objects into APPLSYS
. . importing table                     "FND_USER"
IMP-00058: ORACLE error 1552 encountered
ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_SEED'
Import terminated successfully with warnings.

Then accordign to DOC ID:OERR: ORA 1552 cannot use system rollback segment for non-system tablespace (Doc ID 18951.1), we have created a new rollback segment and made it online and tried the import again.

SQL> create rollback segment ssi_test TABLESPACE APPS_UNDOTS1;

Rollback segment created.

SQL> select SEGMENT_NAME,OWNER,STATUS,TABLESPACE_NAME from DBA_ROLLBACK_SEGS where SEGMENT_NAME='SSI_TEST';

SEGMENT_NAME                   OWNER  STATUS
------------------------------ ------ ----------------
TABLESPACE_NAME
------------------------------
SSI_TEST                       SYS    OFFLINE
APPS_UNDOTS1

SQL> alter rollback segment ssi_test online;

Rollback segment altered.

SQL> select SEGMENT_NAME,OWNER,STATUS,TABLESPACE_NAME from DBA_ROLLBACK_SEGS where SEGMENT_NAME='SSI_TEST';

SEGMENT_NAME                   OWNER  STATUS
------------------------------ ------ ----------------
TABLESPACE_NAME
------------------------------
SSI_TEST                       SYS    ONLINE
APPS_UNDOTS1

We got unique constraint (APPLSYS.FND_USER_U1) violated error while again import.

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (APPLSYS.FND_USER_U1) violated

Also we tried with option   CONSTRAINTS=N indexes=N  , but same error reoccured.

SO we plan to truncate the FND_USER table after taking the backup(fnd_user_bkp_210111) and tried the import , it was successfull.

SQL> SQL> create table fnd_user_bkp_210111 as select * from fnd_user;

Table created.

SQL> select count(*) from fnd_user;

  COUNT(*)
----------
       452

SQL> select count(*) from fnd_user_bkp_210111;

  COUNT(*)
----------
       452

SQL> truncate table fnd_user;

Table truncated.

dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_USER  commit=y ignore=Y

log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi

Import: Release 10.2.0.3.0 - Production on Fri Jan 21 15:32:15 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing APPLSYS's objects into APPLSYS
. . importing table                     "FND_USER"        452 rows imported
Import terminated successfully without warnings.

SQL> select count(*) from fnd_user;

  COUNT(*)
----------
       452

Weblogic not start after creating the Domain.

After creating a domain using a RDBMS Security Store and starting WebLogic Server, we have reports that it cannot be started up with errors like the following:

psfmw_domain/servers/AdminServer/logs/AdminServer.log00006. Log messages will continue to be logged in /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/user_projects/domains/ipsfmw_domain/servers/AdminServer/logs/AdminServer.log.>
<Aug 19, 2011 3:12:17 AM CDT> <Notice> <Log Management> <BEA-170019> <The server log file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/user_projects/domains/ipsfmw_domain/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.>
<Aug 19, 2011 3:12:23 AM CDT> <Error> <Security> <BEA-090870> <The realm "myrealm" failed to be loaded: weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift..
weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealm(CommonSecurityServiceManagerDelegateImpl.java:465)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadRealm(CommonSecurityServiceManagerDelegateImpl.java:840)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealms(CommonSecurityServiceManagerDelegateImpl.java:869)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1028)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        Truncated. see log file for complete stacktrace
Caused By: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:365)
        at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:315)
        at com.bea.common.engine.internal.ServiceEngineImpl.lookupService(ServiceEngineImpl.java:257)
        at com.bea.common.engine.internal.ServicesImpl.getService(ServicesImpl.java:72)
        at weblogic.security.service.CSSWLSDelegateImpl.getService(CSSWLSDelegateImpl.java:155)
        Truncated. see log file for complete stacktrace
Caused By: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /u100/app/IPSFMW/oripsfmw/oracle/Oracle/Middleware/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadFullLDIFTemplate(BootStrapServiceImpl.java:910)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFTemplate(BootStrapServiceImpl.java:688)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:176)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:160)
        at com.bea.common.security.internal.service.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:106)
        Truncated. see log file for complete stacktrace
Caused By: <openjpa-1.1.1-SNAPSHOT-r422266:965591 fatal store error> kodo.jdo.FatalDataStoreException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2170)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2017)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1915)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1833)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
        Truncated. see log file for complete stacktrace
Caused By: <openjpa-1.1.1-SNAPSHOT-r422266:965591 nonfatal store error> kodo.jdo.DataStoreException: ORA-00942: table or view does not exist
 {prepstmnt 15960898 INSERT INTO BEAXACMLAP (DOMN, REALMN, TYPEN, CN, XVER, CTS, WCN, WCI, WXF, XD, XS, MTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) ipsfmw_domain, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Fmbean@G, (String) 1.0, (null) null, (null) null, (null) null, (Blob) oracle.sql.BLOB@908f05, (InputStream) java.io.ByteArrayInputStream@9dc8f2, (String) 3, (Timestamp) 2011-08-19 03:12:23.296] [reused=0]} [code=942, state=42000]
FailedObject: com.bea.common.security.store.data.XACMLAuthorizationPolicy@1486b51
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4207)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4171)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
        at kodo.jdbc.kernel.BatchingPreparedStatementManager.flushInternal(BatchingPreparedStatementManager.java:214)
        Truncated. see log file for complete stacktrace
Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00942: table or view does not exist
 {prepstmnt 15960898 INSERT INTO BEAXACMLAP (DOMN, REALMN, TYPEN, CN, XVER, CTS, WCN, WCI, WXF, XD, XS, MTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) ipsfmw_domain, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Fmbean@G, (String) 1.0, (null) null, (null) null, (null) null, (Blob) oracle.sql.BLOB@908f05, (InputStream) java.io.ByteArrayInputStream@9dc8f2, (String) 3, (Timestamp) 2011-08-19 03:12:23.296] [reused=0]} [code=942, state=42000]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1421)
        Truncated. see log file for complete stacktrace
>
<Aug 19, 2011 3:12:23 AM CDT> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
<Aug 19, 2011 3:12:23 AM CDT> <Critical> <WebLogicServer> <BEA-000362> <Server failed. Reason:

There are 1 nested errors:

weblogic.security.service.SecurityServiceRuntimeException: [Security:090399]Security Services Unavailable
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:916)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1050)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        at weblogic.security.SecurityService.start(SecurityService.java:141)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

>
<Aug 19, 2011 3:12:23 AM CDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<Aug 19, 2011 3:12:23 AM CDT> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<Aug 19, 2011 3:12:23 AM CDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>
-bash-3.2$

Cause:

The root cause is that the RDBMS Tables are not created in the Security Datastore.

Solution:

Before booting the domain, the RDBMS tables need to be created in the database:
Specify the same connection properties, including the credentials of the user who has access, the database URL, etc., as specified for that RDBMS during domain creation.
    Run the appropriate script to create RDBMS tables. There are a set of SQL scripts for creating/removing RDBMS tables under WL_HOME/server/lib: e.g., for Oracle DB, rdbms_security_store_oracle.sql is to create RRDBMS tables and rdbms_security_store_oracle_remove.sql is to remove these tables.

For details, please refer to "Create RDBMS Tables in the Security Datastore" part in http://www.oracle.com/pls/as1111/lookup?id=SECMG346

Ref Doc:

WebLogic Server Cannot Start Up with RDBMS Security Store (Doc ID 1327167.1)
WebLogic Server Does Not Start With Error: BEA-090870 The realm "myrealm" failed to be loaded (Doc ID 1328521.1)

Running AutoConfig On DB Node Reports: UnsatisfiedLinkError Exception Loading Native Library: njni11 while DB upgraded to 11.2.0.2

Recently While DB Upgraded from 11.1.0.7 to 11.2.0.2 , while running autoconfig below is the error


Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: njni11 (No such file or directory)

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

This issue because of Database 11.2 it only comes with 64bit libraries, but we are still trying to use 32bit java as defined by context variables s_jdktop and s_jretop which points to ORACLE_HOME/appsutil/jre

So changed the s_jdktop and s_jretop in $CONTEXT_FILE  to point to $ORACLE_HOME/jdk/jre and ran the autoconfig and if went successful.

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

Reference DOC: 1087973.1