TriniDBA

Problem:

After cloning Illuminat Production to Test, Active Users report is run from System Administrator responsibility. When View Output is clicked, the following message appears:

ERROR

File server needs to be re-initialized

Solution:

In the 8.0.6/network/admin/<CONTEXT_NAME>/listener.ora file, open the file and search for APPLFSTT. Change the order of the service names so that the SID (PROD) appears first in the list and there are no spaces between semicolons.

For example:

Change:

( SID_DESC = ( SID_NAME = FNDFS  )

( ORACLE_HOME = /u0/oracle/prodora/8.0.6 )

( PROGRAM = /u0/oracle/prodappl/fnd/11.5.0/bin/FNDFS )

( envs=’EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,APPLFSTT=PROD_806_BALANCE; PROD; PROD_BALANCE; PROD_FO,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )

)

To:

( SID_DESC = ( SID_NAME = FNDFS  )

( ORACLE_HOME = /u0/oracle/prodora/8.0.6 )

( PROGRAM = /u0/oracle/prodappl/fnd/11.5.0/bin/FNDFS )

( envs=’EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,APPLFSTT=PROD;PROD_806_BALANCE;PROD_BALANCE;PROD_FO,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )

)

Then bounce the concurrent manager.

References:

Metalink Doc ID: 662053.999