ORATraining Blog

Tweet Oracle Fusion Applications Installation: Configuring Oracle Identity and Access Management components Previous: Installing Oracle Identity and Access Management Components Configuring Oracle Identity Management components” can be divided into following tasks. Configuring the Web Tier Create Weblogic Domain for Identity Management Extending the Domain with Oracle Internet Directory Extending the Domain with Oracle Directory Service Manager [...]

Tweet Oracle Fusion Applications Installation: Creating a new Provisioning Plan Previous: Preparing Identity and Policy Store In order to create a new fusion applications provisioning plan we should launch the provisioning wizard again from <framework_location>/provisioning/bin <framework_location> is same what we mentioned in previous post. i.e. /app/fusion [oracle@fusion $ cd /app/fusion/provisioning/bin [oracle@fusion bin]$ ./provisioningWizard.sh   On Welcome screen, click Next   Select [...]

Tweet Oracle Fusion Applications installation: Running Repository Creation Utility (RCU) for Oracle Identity Management Components Previous: Running Oracle Fusion Applications Repository Creation Utility (Applications RCU) Important Note: We are NOT creating a separate database to host Oracle Identity Management schemas. Instead we will create these schemas in our Fusion Database (fusiondb) itself since the schema names [...]

Tweet Oracle PL/SQL Quick Reference   PL/SQL Block Structure DECLARE –Optional   –Variables, Cursors, User-defined exceptions BEGIN –Mandatory   –SQL statements   –PL/SQL statements EXCEPTION –Optional   –Actions to perform when errors occur END; –Mandatory

Tweet Oracle SQL Quick Reference SELECT Query Statement SELECT [DISTINCT] {*, column [alias],…} FROM table WHERE condition(s)] ORDER BY {column, exp, alias} [ASC|DESC]] NOTE: Avoid using DISTINCT with large table as it first does sorting of all the rows and then eliminates duplicate rows, so need a full table scan and thus it’s very slow. [...]