enq: TS – contention dbms_stats

On 11.2.0.3 sessions were waiting when try to collect statistics with dbms_stats.
Job collecting statistics was blocked by parallel sessions of dbms_stats.

Insert /*+ append */ into sys.ora_temp_1_ds_350003 SELECT /*+  parallel(t,16) parallel_index(t,16)

According to metalink doc , this wait can be seen while using parallelism for dbms_stats.Temporary
solution is setting parallelism to 1 . For permanent solution , patch 12865902  should be applied to database.

Source : Metalink ‘enq: TS – contention’ / Hang While Gathering Statistics in Parallel [ID 1463791.1]

jarsigner: unable to recover key from keystore

I have encountered this problem while signing EBS jarfiles with new digital certificate.Codesigning certificate is used to sign jar files , in order to pass through security issues which come with new Java version 1.7.0_51. 

New cert file has private key with different password. When keystore and keyentry have different password , this issue can become. 

ERROR: JarSigner subcommand exited with status 1

JarSigner standard output:

jarsigner: unable to recover key from keystore

JarSigner error output:

Enter Passphrase for keystore: Enter key password for <Alias>

In order to pass over , keyentry password should be changed to keystore password.

keytool -keypasswd -keystore adkeystore.dat -keypass <KeyEntryPass> -new <KeyStorePass> -alias ykxcodesign

Change Domain Name of Apps Tier for EBS R12

For a certification issue i had to change domain name of apps Tier with following steps.Firstly i have a unclear point that different domains of db Tier and apps Tier is compatible ? After below steps , i have examined there will be no problem.

Related steps

1. Deregister current App server

    As the applications domain name will be changed , app server need to be deregistered.
    perl $AD_TOP/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removeserver

2. Change domain name of server

    Ensure that /etc/hosts shows new domain.

3. Recreate context file with new settings

    mv $INST_TOP/appl/admin/$CONTEXTFILE $INST_TOP/appl/admin/oldcontextfile.xml

    cd $INST_TOP/appl/admin
    perl $COMMON_TOP/clone/bin/adclonectx.pl contextfile=oldcontextfile.xml

    This step will create new context file with new app domain name.

4. Execute autoconfig

    $AD_TOP/bin/adconfig.sh contextfile=$INST_TOP/appl/admin/$CONTEXTFILE appspass=<password>

5. Check fnd_nodes.DOMAIN , fnd_nodes.WEBHOST and icx_parameters.SESSION_COOKIE_DOMAIN values to       ensure that show new domain name.

6. Start all application tier services with adstrtal.sh apps/<appspassword>

ORA-08104: this index object is being online built or rebuilt.

While creating an index , related session has been killed.When trying drop index
or rebuild it following error occured.

ORA-08104: this index object <object_id> is being online built or rebuilt.

SMON should do clean up process.But there must be no transaction against the table in order to SMON be successfull.
To do this application can be stopped and wait until cleanup is done.

For 10.1 SMON need to be waited to finish process,After 10.2 DBMS_REPAIR.ONLINE_INDEX_CLEAN() can be used.

Following script does this cleanup process.

declare
  ret boolean;
begin
  ret=sys.dbms_repair.online_index_clean(&OBJECT_ID);
end;