Tuesday 21 August 2012

Applications File Server connection with the node. There may be a network configuration problem, or the TNS listener on node may not be running.


Please Visit http://www.conacent.com/?page_id=218

Problem :-

Applications File Server connection with the node.
There may be a network configuration problem,
or the TNS listener on node may not be running.


Solution :-

In the Profile Option –>system –>

RRA: Enabled is set as No in Site Level. Make it to Yes.
RRA: Service Prefix should be BLANK


Save and Logout and Retest the Issue.

Tuesday 14 August 2012

adcrdb.sh INSTE8 AutoConfig is exiting with status 1


Please Visit http://www.conacent.com/?page_id=218


Problem -

[INSTANTIATE PHASE]
  AutoConfig could not successfully instantiate the following files:
    Directory: /devdbhome/CRMTEST/crmproddb/10.2.0/appsutil/install/CRMTEST_test      adcrdb.sh               INSTE8        


AutoConfig is exiting with status 1


Solution -
 
To implement the solution, please execute the following steps :
1. copy the missing 'adcrdb.sh' template from the Source to the Target Instance :
Source Location :
<$ORACLE_HOME>/appsutil/template
Target Location :
<$ORACLE_HOME>/appsutil/template
2. Change ownership and permission of adcrdb.sh file to match with the other templates, which resides in the template directory.
3. Re-start the adcfgclone dbTier on the Target Instance.






java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation


Please Visit http://www.conacent.com/?page_id=218


Problem -

java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
    at oracle.apps.ad.tools.configuration.NetServiceHandler.updateNodeIdIfNull(NetServiceHandler.java:357)
    at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:2953)
AC-50480: Internal error occurred: java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation

Solution -

1. SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
2. SQL> commit;
3. Compile the FNDSM trigger by connecting as apps
    SQL> alter trigger fndsm compile;






   (If compilation error occurs then Run this script)
    CREATE OR REPLACE TRIGGER fndsm
    AFTER INSERT OR UPDATE ON FND_NODES
    FOR EACH ROW
    BEGIN
      if ( :new.NODE_NAME <> 'AUTHENTICATION' ) then
         if ( (:new.SUPPORT_CP='Y')
              or (:new.SUPPORT_FORMS='Y')
              or (:new.SUPPORT_WEB='Y') ) then
             fnd_cp_fndsm.register_fndsm_fcq(:new.NODE_NAME);
         end if;
         if (:new.SUPPORT_CP = 'Y') then
             fnd_cp_fndsm.register_fndim_fcq(:new.NODE_NAME);
        end if;
       end if;
    END;


4. run autoconfig on dbtier and then followed by appstier
5. start the middle tier.