Thursday, July 7, 2022

Configure oracle reports 12c

     No comments

 


Step 01:

Now, in order to develop Report Components, we will utilize WLST, which stands for Weblogic Scripting Tool.

  • We are going to develop a Reports tool for the Machine called "AdminServerMachine" and call it [reportsToolsName].
  • We are going to create a Reports server for the machine called ‘AdminServerMachine’, and its name will be <reportsServerName>.

From the following location, run the WLST.cmd command.

  • C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin\WLST.cmd

In the WLST Window, type the commands that are shown below.

  • connect("weblogic",<"WeblogicPassword">, "localhost:7001")

Now In order to generate report tools, please type the following command.

  •  createReportsToolsInstance(instanceName=’RepTools1’, machine=’AdminServerMachine’)
  • createReportsServerInstance(instanceName=’MyServer1’, machine=’AdminServerMachine’)
  • exit()

Now your Reports Tool and Server is created.

Step 02:

Launching WLS REPORTS is the next step. To run this command, open the command prompt and type in the following.

  • C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startManagedWebLogic.cmd WLS_REPORTS

Launch the Report Builder by navigating to the following location.



I have developed a straightforward report using the HR. Country table.

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

Tuesday, July 5, 2022

Changing Listener Port for Oracle Database

     No comments

Changing Listener Port for Oracle Database


 1. Change listener.ora


 LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.201.198)(PORT = 1523))
    )
  )

2. Connect to sys as sysdba

3. execute the following command:

    ALTER SYSTEM SET LOCAL_LISTENER = "(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.201.198)(PORT=1523))";

4. execute the following command:


    ALTER SYSTEM REGISTER;


I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.