Latest Technology Blog

On Database Tier 1. Logon as oracle database user and source environment for R12 RDBMS ORACLE_HOME 2. Start database instance for which you want to change R12 port 3. Backup contextfile 4. Change as below in contextfile         dbport  : Change database port from 1521 to 1541         db_ons_localport : 6300 to 6320         db_ons_remoteport : 6400 to 6420         cmanport : 1521 to 1541 5. Run adautocfg.sh On Apps Tier Change Application port from 8000 to 8020 1. Logon as application manager user and source environment for R12 2. Backup contextfile 3. Run adpreclone    $ perl ./adpreclone.pl appsTier 4. Run adcfgclone and choose new port pool    $ cd $COMMON_TOP/clone/bin    $ perl ./adcfgclone.pl appsTier 5. Check new application URL SQL> select home_url from icx_parameters; HOME_URL ----------...

Issue: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows     ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 106     ORA-06512: at line 1 - Database error modifying the server     AutoConfig could not successfully execute the following scripts:     Directory: <$COMMON_TOP>/admin/install/<SID>_<HOSTNAME>     adgendbc.sh             INSTE8_SETUP       1      AutoConfig is exiting with status 1 Solution : 1. Open a new Shell on the APPS-Tier and source the APPL-User-Environment 2. Clean the table FND_NODES :     $ sqlplus apps/<password>    SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;    COMMIT;    EXIT;    3. E xecute Autoconfig on the DB Tier, then on the Application Tier to populate tables w...