Reports12C – Configuration
Reports12C – Configuration Before opening Reports builder you have to perform these additional steps: Execute wlst.cmd from C:\app\oracle\product\12.2.1\oracle_common\common\bin Connect to AdminServer. connect(weblogic,your_passwd,your_hostename:7001) Run the following wlst command. createReportsToolsInstance(instanceName=’reptools1′,machine=’AdminServerMachine’) Restart WLS_REPORTS After completing the previous steps, reports builder can be used. run rwbuilder.bat from C:\app\oracle\config\domains\frs\reports\bin\rwbuilder.bat
Forms12c-Configuration
Configuring Forms Using the Config Wizard In order to complete the configuration, open a Windows DOS shells as administrator and run the config wizard located in <ORACLE_HOME>/oracle_common/common/bin The Templates screen appears, choose the selected components Enter the WebLogic Domain administration username and password required to access WebLogic Server Control and Fusion Middleware Control. Choose production […]
Forms12c and Reports12c-installation
Forms12c and Reports12c-installation Run as administrator This page prompts you to choose or not software updates for your components. Choose no and click Next. Specify the Oracle home location to install the product Choose Forms and Reports Deployment to install all of the products. Click Next. The Prerequisites Checks page appears – We have a […]
Configure a pluggable database
Configure a pluggable database After installing oracle database12c, we configure a pluggable database which is part of Forms12c installation Run dbca.bat in a windows-shell command as administrator Or choose database configuration assistant menu option as shown in this screen or
Install demo schemas in oracle database12c
This tutorial shows how to deploy demo schemas in oracle database 12c First, we will begin by creating a new pluggable database12c on witch demo schemas should be deployed. Open your start meu and search for dbca.bat, it is in %ORACLE_HOME%BIN Run dbca.bat as admisitrator Choose Manage pluggable databases Create a pluggable database Select a […]
Change the screen resolution with ubuntu15.04 on windows10 hyper-v machine
When you install Ubuntu 15.04 inside Hyper-V virtual machine of windows10, the integration components and virtualized drivers are also installed, including the Hyper-V video driver. However, it is not possible to change the screen resolution inside your virtual machine. Screen resolution on the server: Screen resolution inside virtual machine Resolution: 1152×864(4:3), can not be changed […]
sql-aggregate functions
Using Rollup, Cube, Grouping and Grouping Sets. Rollup – operation: It is a sub-class of group by-clause, aggregating the select statement’s output. For our test, the promotions – table in sh schema is used, SELECT P.PROMO_CATEGORY, P.PROMO_END_DATE, P.PROMO_COST FROM PROMOTIONS P ORDER BY P.PROMO_CATEGORY; PROMO_CATEGORY […]
Oracle forms11g batch – conversion
Convert Oracle Forms modules to Oracle Forms Script in batch-mode Let’s convert our forms modules contained in ModuleSource directory. Just create a simple dos-script: @Echo OFF cls Echo converting Forms Modules from fmb format to to fmt format…. for %%f IN (*.fmb) do frmcmp userid=summit/summit@xe module=%%f batch=YES script=YES module_type=FORM compile_all=yes window_state=minimize Echo FINISHED CONVERTING FORMS […]
Oracle forms11g batch-compile
Compile forms modules in batch-mode We can run the Migration Assistant in batch mode on Windows and UNIX computers. We will do the test on WindowsXp system If we have an application with many forms modules, let’s say for example, more than 60 forms modules and we have made a change in one or more […]
About Me
Senior oracle DBA/Developer | OCI Certified | OCP | OCE Sql Certified Expert
