Oracle Fusion Middleware & Application Server

Wednesday, September 21, 2016

Configure jobStatusRepository in Oracle Reports 12c

Within this blog post I will show you how to configure the Oracle Reports 12c jobStatusRepository against an Oracle Database.

Within Oracle Reports since release 11.x a major change is, that within the jobStatusRepository configuration, we have now to use an entry in the Credential Store Facility (CSF).

At first create in your target database for the Reports Server Queue a user:

create user rwadmin identified by "Oracle12c" default tablespace users quota unlimited on users;
grant create table to rwadmin;
grant create view to rwadmin;
grant create trigger to rwadmin;
grant create procedure to rwadmin;
grant create sequence to rwadmin;

After you have created your user for the Reports Server Queue, go to the $ORACLE_HOME/reports/admin/sql directory of your Oracle Forms & Reports Installation, open a sqlplus and connect to your target database with the above created user and execute the rw_server.sql. This will create all necessary and required objects for the Reports Server Queue.

SQL> connect rwadmin/Oracle12c@<your tnsnames_entry>
SQL> @rw_server.sql

As next we need to create an entry in the Credential Store Facilty. For this connect to your Enterprise Manager for Fusion Middleware http://server:port/em and select from the WebLogic Menu the Option "Security / Credentials"

Here we need to create a Map

Providing a Map Name, e.g. reports and confirm with OK

After creating the Map, you should see as following and we can now create a Key attached to our Map.

Provide following informations:

  • Select the Map, in this example "reports"
  • Leave Type with "Password"
  • Provide User Name = choose Oracle Database User from above
  • Prove the Password of the Oracle Database User 2 times
  • Optionally you can provide a description

After you have created the Key, you should see following:

The next step would be normally to invoke the System MBean Browser in order to configure your jobStatusRepository, but as there is a small "unexpected feature" (some people call it even a bug :-) ), I will go now directly into the configuration file of the underlying Reports Server and add the necessary elements.

Simply go to the Directory $DOMAIN_HOME/fr_domain/config/fmwconfig/components/ReportsServerComponent/<your_reports_server_name> and open the configuration file rwserver.conf with an editor.

In case you are using the System MBean Browser to configure the below settings, the System MBean Browser will not add the necessary class reference "oracle.reports.server.JobRepositoryDB" and will cause that you can not startup your Reports Server.

For the below configuration provide the following values:

  • dbpassword = csf:<Your_Map_Name>:<Your_Key_Name>
  • dbconn = <Your_DB_Servername>:<LISTENER_PORT>:<ORACLE_SID>
  • dbuser = <Your_DB_Username>

   <jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
      <property name="dbpassword" value="csf:reports:reports_repository"/>
      <property name="dbconn" value="forms12:1521:FRREPO"/>
      <property name="dbuser" value="rwadmin"/>

Finally restart your Reports Server

./ <Your_Reports_Server_Name>
./ <Your_Reports_Server_Name>

Now you can generate a Report and you should be able to see the executed Reports in your Reports Server Queue in the Database

Wednesday, September 14, 2016

Microsoft SQL Server under Linux - Preview

Today something off topic, as I am normally blogging about Oracle Fusion Middleware stuff.

Microsoft SQL Server under Linux - Preview ... many of you (specially the Oracle Guys) might think now "WHAT ????", but its really true.
Some months ago Microsoft announced that they will release a SQL Server Version for Linux and I was lucky to get into the Preview Program.

The installation of the SQL Server under Linux (currently supported under Ubuntu 16 or RedHat 7) is quite easy and its completed in around 15 minutes (depending of your download speed).

What is quite cool, is that the SQL Server can also be installed under Docker :-)

It's really SQL Server under Linux :-)

As a native UNIX User I recognised one small thing, which were disturbing me, when you want to restore a Database Backup you have to use Windows Path notations which will be internally mapped to UNIX Path notations, but I am pretty sure that within the next Releases or at least with the final Release this small problem will be adjusted.

From the first look, SQL Server on Linux looks quite interesting.