Problem:
When mount -t nfs ebusinesstest:/u0/oracle/testdata /mnt/testdata/ executed, the following error is returned:
mount: mount to NFS server ‘ebusinesstest’ failed: RPC Error: Program not registered.
Solution:
Run:
service nfs restart
on source and target machines.
Problem:
After cloning Production to Test, Active Users report is run from System Administrator responsibility. When View Output is clicked, the following message appears:
ERROR
File server could not verify its initialization parameters
Solution:
In the 8.0.6/network/admin/<CONTEXT_NAME>/listener.ora file, open the file and search for APPLFSTT and delete it. Ensure that 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,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )
)
Exit the application, bounce the application tier services and then log back in.
References:
Metalink Doc ID: 662053.999
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
Problem:
/etc/oraInst.loc points to an Inventory that does not exist:
mkdir : No such file or directory at ./adclone.pl line 1274
ERROR: Failed to execute ./adclone.pl
Solution:
As root user, ran /tmp/orainstRoot.sh.
Reran clone again, but it failed.
The root directory had completely filled up because the backup was restored to /oracle and not /u0/oracle. Removed /oracle, then reran /tmp/orainstRoot.sh and tried script again.
Problem:
When trying to clone Illuminat TEST database, the following error occurred:
sh: adchkutl.sh: command not found
Solution:
perl adcfgclone.pl dbTier
Use:
perl ./adcfgclone.pl dbTier
To run the pay_register.rdf custom report from the Command Prompt, enter the following command at the prompt:
C:> C:oracleproduct10.2.0db_2binrwbuilder.exe report="C:Documents and Settingsuser01DesktopReports Tuning Issuetest.aippay_register.rdf" userid=apps/apps@vis2.world tracemode=TRACE_APPEND tracefile=c:temppay_register01.txt traceopts=(trace_SQL,TRACE_PLS,trace_prf,trace_tms)
The report loads in Reports Builder.
1. Compile the packages by typing Shift+Ctrl+K.
2. Run the Paper Layout version of the report by Shift+Ctrl+R.
3. In the Payroll ID parameter field, enter 112.
4. In the Pay Advice Date field, enter 2003/08/29.
1. Open the report in Reports Developer and double-click on the Data Model icon (not word).
2. Double-click the Q_1 box. The SQL code for the Q_1 query appears.
3. Copy all the SQL code and run it in SQL Developer.
4. For the p_payroll_id, enter 112
5. For the p_pay_advice_date, enter 29-AUG-2003
Problem:
When trying to set up Workflow Notifications in Oracle Application Manager, the following error occurred:
Validation error occurred. Please check indicated fields below.
Solution:
Log on as user SYSADMIN and set up the workflow.
Run the $FND_TOP/sql/wfver.sql script.
Problem:
After logging on to the E-Business Suite PROD instance, all the responsibilities have disappeared.
Solution:
In adadmin, enable maintenance mode. Exit adadmin. Run adadmin again and disable maintenance mode.
Recent Comments