RRDI 2.0 Oracle database scripts
3 answers
Hi Bin,
After execute the installation manager the scripts are recorded in this location
/opt/ibm/RationalReporting/reportserver/contentstore
After execute the installation manager the scripts are recorded in this location
/opt/ibm/RationalReporting/reportserver/contentstore
Comments
Hi, Oliveira
What version of RRDI are you talking about? Also, at what point do you see a recording option? Please be specific.
Actually, can you simply send me your scripts? I need to know what tablespace to create, what users to create.
Thanks.
Sorry, Bin Chen. I was talking about version 1.0.1.2.
For those who are installing RRDI 2.0 on Oracle database server, here are few things you might want to do first. These are hard learned facts that were not found in IBM's installation guide.
- once you created RICM database with Oracle DBCA, you will need to create at least a table sapce, I call it RPT_TS.
- you will need to create a schema user, say RPTAdmin and assign default table space to RPT_TS, you will need to grant create table, index, views, connect, sequence etc to RPTAdmin. This part was covered under "database considerations" in the install guide.
- For RPTUser, the report user that you created in DW database, this user needs access to RIDW schema, so you will need to grant select on all tables and all views of RIDW to RPTUser.
The rest steps were covered in the install guide, but I personally believe the install guide is not Oracle friendly.