Category Archives: Action_Plan

Action_Plan: steps to achieve a goal

R12 disable all users script

regulatory after clone, you asked to close “disable/ end date/ deactivate” application “end” users

use the following script

declare cursor x is
select user_name from apps.fnd_user where LOWER(user_name) Not IN ('list some users you don't want to close');
for all_user in x loop
end loop;

Tags: ,

httpd: error while loading shared libraries: cannot open shared object file: No such file or directory


Review the HTTP log file. The error is very clear about the missing soft link. It would show this error:

<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: cannot open shared object file: No such file or directory

cd $INST_TOP/logs/ora/10.1.3/opmn

vi HTTP_Server~1.log
14/03/04 00:54:51 Start process
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: cannot open shared object file: No such file or directory
14/03/04 00:54:53 Start process
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: cannot open shared object file: No such file or directory
14/03/04 10:22:12 Start process


missing prerequisite step

Solution ::

To implement the solution, please execute the following steps:

1. Shut down all Oracle Application Services.

2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/ /usr/lib/

3. Start up all Oracle Application Services.


Tags: , , , , ,

Installing OBIEE on MS windows 7

1         Main steps:

  • Install database “or connect exist certified database”.
  • Install “Create” Oracle Fusion Middleware Repertory.
  • Install OBIEE


2         Listed steps

2.1        Install loopback adaptor, to overcome any connectivity issue.

  1. Open Device Manager from Control Panel.
  2.  From Action menu choose “Add legacy hardware”
  3.  From “Add Hardware” wizard choose “Install the hardware that I manually select from a list”
  4. A list of common hardware choose ”Network adaptors”
  5.  Select “Microsoft” from Manufacturer list then choose “Microsoft Loopback Adaptor”
  6. Press Next to start driver installation, then press Finish to complete the installation.
  7.  Now, give an IP to the net adapter connection, from Control Panel > Network and Sharing Center, click on “Change adapter setting” link from the top left window side.
  8. Right-click on the  “Local Area Connection 2”, Choose “Prosperities” from the menu
  9.  Double-click on “Internet Protocol Version 4 (TCP/IPv4), supply the shown IP ( and subnet mask ( in proper fields, Then press “OK”, then “OK”
  10. To edit “hosts” file, Open “Notepad” program as administrator
  11. Locate “hosts” file in directory (C:\Windows\System32\drivers\etc)
  12. Uncomment localhost line, Add the highlighted line

“Assigned IP to loopback adapter <tab> computer name”


2.2        Intall Oracle Database to be oracle fusion middleware repository database.

  1. Start the installation from “Setup.exe” file, in “Configure Security Updates”uncheck “I wish to receive…..”, Press Next.
  2. In “Select Installation Option”, choose “ create and configure a database”, press Next
  3.  In “System Class” choose “Server Class” and press Next.
  4.  In “Grid Installation Option” choose “Single instance database installation”, press Next
  5.  In “Select Installation Type” choose “Advanced Install”, Press Next.
  6.  Add “Arabic” language from “Available Languages” in “Select Product Languages” then press Next
  7.  In “Select Database edition” choose “Enterprise Edition”, Press Next.
  8.  In “Specify Installation Location” choose an empty directory e.g. (C:\oracle\db) to be the base directory where all related installation files will be under it.
  9.  In “Select Configuration Type” choose “General Purpose” <as we will use this database to be the fusion middleware repository so general purpose database will be sufficient>, Press Next.
  10. In “Specify Database Identifier” give a name for the database obtain “obidb” for Global database name and  SID, then Press Next
  11.  In “Specify Configuration options” specify the following;
  12.                   i.   In “Memory” tab check “Enable Automatic Memory Management” and reduce the amount to 2048 MB
  13.                 ii.   In “Character Sets” Tab,  Choose “Use Unicode (AL32UTF8)” option
  14.                iii.   In “Security” tab, uncheck “Assert all new security Settings”
  15.               iv.   In “Sample Schemas”, Check “Create database with sample schemas”
  16. In “Specify Management Options”, just press Next.
  17. In “Specify Database Storage Options”, just Press Next.
  18. In “Specify Recovery Options”, just Press Next.
  19. In “Specify Schema Password”, choose “Use the same password for all accounts, supply an alphabetic password of 8 character length: welcome1
  20. A warning message appears if you inter a weak password, press “Yes” to continue with your password anyway.
  21.  A prerequisite check will run, after pass it “Summary”  window will appear, Press “Finish” to start installation
  22. Before finishing the installation a “database Configuration Assistant” window appears to change schema passwords <if you want> just press OK. In ”Finish” window press Close.

2.3        Install RCU

  1. Start Repository Creation Utility from command line, start from directory <rcuHome>\BINà rcu.bat
  2. In “Welcome” window, press Next to start the installation
  3. In “Create Repository”, Choose “Create” then press Next.
  4. In “Database Connection Details”, first choose database type as (Oracle database), supply database hostname, port, service name and username and password of sys, Press Next.
  5. A checking prerequisites window appears, When finish press OK
  6. In “Select Component”, supply a prefix name for all component you will choose (DEV), Then choose the following component:Oracle AS Repository Componentsà AS Common SchemasàMetadata Services; the schema owner will be (DEV_MDS)
  7. Oracle AS Repository ComponentsàOracle Business Intelligenceà Business Intelligence Platform; the schema owner will be (DEV_BIPLATFORM)
  8. A checking prerequisites window appears, When finish press OK
  9. In “Schema Password”, Supply a password (welcome1) in “Use same password for all schemas” option, Then press Next
  10. In “Map Tablespaces” accept all given values and press Next
  11. In “Summary” window review all values and press Create.
  12. After creation completion press Close

2.4        Install OBIEE

  1. Start the installation wizard from setup.exe under bishiphome\Disk1 directory, A welcome screen appears, Press Next to start installation
  2. In “Install Software Updataes”, Choose “Skip Software Update” and press Next
  3. In “Select Installation Type”, select “Enterprise Install” option with install ORACLE_HOME and configure INSTANCE_HOME
  4. In “Create Or Scale Out”, Choose “Create New BI System”, Supply a password(welcome1) for weblogic user, accept other values
  5. In “Specify Installation Location”, Supply “Oracle Middleware Installation Location” which is equivalent to ORACLE_BASE as C:\oracle\MW, Then press Next
  6. If you use a FAT partition a warning message will appears, Press Yes to continue with installation
  7.  In “Configure Component” Choose all available component, then press Next
  8. In “BIPLATFORM Schema” give connection information to repository database, choose (Oracle Database) in Database type, write the connection string as hostname:prot:service_name, supply BIPLATFORM Schema username and password.
  9. In “MDS Schema” as pervious window choose (Oracle Database) in Database type, write the connection string as hostname:prot:service_name, supply MDS Schema username and password
  10. In “Configure Ports”, Choose “Auto Port Configuration” option then press Next
  11. In “Specify Security Update” uncheck “I wish to receive……” then press next.
  12. A confirmation message appears press Yes to continue.
  13. A summary window appears, review it and press Install
  14. While installation “Installation Progress” and “Configuration Progress” windows appears, which takes 20~30 minutes
  15. “Complete” window shows status.

Tags: , ,

After R12 Clone: Consult the OPP service log for details

After make a clone of R12, the new instance gave “Completed, Warning” for all XML output requests the request log show the following:

Post-processing of request 509561 failed at <timestamp> with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

you can review the OPP log file from the following query to find the location and file name for the OPP log:

fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name 
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp 
WHERE fcpp.processor_id = fcp.concurrent_process_id
 AND fcpp.action_type = 6
 AND fcpp.concurrent_request_id = &request_id;

the OPP log file will be in the $APPLCSF/$APPLLOG with an name of “FNDOPP*.txt”

now the log file shows the error:

[UNEXPECTED] [50032:RT509560] oracle.apps.xdo.XDOException: Unable to create font cache directory: /u01/SID/instapps/CONTEXT_NAME/temp/xdofonts/SID


1. Navigation Path:

(Responsibility) XML Publisher Administrator > (Menu) Home > (Tab) Administration > (SubTab) Configuration > Properties > General > Temporary directory

2. Provide a valid value to ‘Temporary directory’, and click button ‘Save’.

3. Re-test the issue.

Tags: , , , ,

Bad Performance in R12 Online AP Create Accounting

According to the helpful Oracle Support DocId:791049.1 ::R12 SLA/FAH: How to Improve Performance in Subledger Accounting & Financials Accounting Hub
in the 4th FAQ which explain how to capturing trace and/or tkprof.

1. Enable tracing using the profile option – ‘Initialization SQL Statement – Custom’
Set this at the user level with the following string:
2. Login using the user for which you set the profile option.
3. Reproduce the issue.
4. Reset the profile option to its prior value.
5. Locate the generated trace, using the query:
select name, value from v$parameter where name like ‘user_dump_dest’;
6. Convert the trace file into tkprof format using the command:
tkprof <filename.trc> <output_filename_SORT.txt> explain=apps/<password> sort='(prsela,exeela,fchela)’

in the 5Th FAQ witch explain basic points to check before logging a performance bug. and one of these basic step is to stop the Debug logging”if it;s not nessessary, Or you can make it on USER level not SITE level”

Do you have any of the following profiles set to Yes at the User Level?
If so, then please disable them (i.e., set them to No) and re-run Create Accounting:

When running Create Accounting, the profile values should be set as follows:

FND: Debug Log Enabled = No
SLA: Enable Diagnostics = No
AR: Enable Debug Message Output = No — If it is for Receivables.




Tags: , , , , , ,

Oracle 11i / R12 – How To : How To Disable The Personal Profiles Form

Oracle 11i / R12 – How To : How To Disable The Personal Profiles Form.


Tags: , ,


rhel root password recovery

rhel root password recovery


Tags: , , ,