It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,446
×2,348
×1,381
×2

question asked: Oct 09 '13, 7:05 a.m.
question was seen: 6,394 times
last updated: Dec 01 '13, 7:29 p.m.

Related questions

RPTUSER on Oracle

0
Yohko Tanaka (105●2●32●39) | asked Oct 09 '13, 7:05 a.m.
edited Oct 21 '13, 4:11 p.m. by Douglas Bush (281●2●5)
When setting up Oracle for CLM, does RPTUSER need to be created in advance?
If so, where this user should be created?

In this infocenter, it says "Note: For Oracle: An OS level user is not required. The report user must have access to the data warehouse."
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.rrdi.admin.doc/topics/t_configure_datasource_conn_dw.html

Do I need to create oracle user (named RPTUSER) before doing setup wizard?
Or setup wizard create RPTUSER during setup?

Accepted answer

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Oct 17 '13, 5:10 a.m.
Hello Yokho,

the RPTUSER must be created before running the setup wizard.

Some references are in this info center section:

Creating a reporting user account for connecting to the data warehouse
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.rational.rrdi.admin.doc/topics/t_configure_datasource_conn_dw.html

Best Regards
Francesco
Yohko Tanaka selected this answer as the correct answer
Comments
Yohko Tanaka commented Oct 17 '13, 5:39 a.m.

Thank you. I really appreciate it.

3 other answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Oct 09 '13, 8:21 a.m.
edited Oct 09 '13, 8:23 a.m.
Hello Yokho,

according to the jazz wiki entry:

More Control over the Oracle Data Warehouse Setup
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup

The Custom Report Database User (RPTUSER) is the database user used by RRDI and Rational Insight to read data from the Data Warehouse.This user must already exist in the database. None of the he Data Warehouse setup scripts will create the user.

You can create the RPTUSER with commands similar to these, when connected to the data warehouse from sqlplus:

CREATE USER RPTUSER IDENTIFIED BY [Password] DEFAULT TABLESPACE [Your DW tablespace] QUOTA UNLIMITED ON [Your DW tablespace] TEMPORARY TABLESPACE RIS_TEMP;

GRANT CONNECT, CREATE SESSION TO RPTUSER;

Best Regards
Francesco
Comments
Yohko Tanaka commented Oct 16 '13, 9:49 p.m.

Thank you for the reply.

In this information center, it doesn't guide that we should create "RPTUSER" before executing setup wizard.
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html

Sorry for ask this again, but RPTUSER MUST be created beforehand? Or does setup wizard create it for me?

0
permanent link
Yohko Tanaka (105●2●32●39) | answered Nov 24 '13, 5:22 a.m.
Hi, I have another question.
How do I change password for RPTUSER?
My customer requires changing password of Oracle users on a regular basis.
When the password of RPTUSER is changed in a oracle, how do I set the new password in CLM?
I found Insight's information center, but I didn't configure Insight. ( I configured only RTC/RQM/RRC)

http://pic.dhe.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.deploying.doc/topics/t_change_pwd_for_rptuser.html

I also check "advanced property" of /jts/admin. I found "RPTUSER" in "Custome Report Database user" section, but it seems there is no "password" section for RPTUSER.

Does anybody know how to change RPTUSER's password?


0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Nov 25 '13, 4:50 a.m.
edited Nov 25 '13, 4:51 a.m.
Hello Yohko,

to my understanding the RPTUSER is not used within CLM, so there's no need to change the password.

Best Regards
Francesco
Comments
Yohko Tanaka commented Dec 01 '13, 7:29 p.m.

Thank you. I understand.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.