Oracle Point, Oracle Life.

Most Popular Posts

March 28, 2008

Posting Aggregation of CBO Issues with Oracle

Filed under: OraclePoint — R.Wang @ 3:00 pm

Just gave myself a note about some valuable postings from blog “structured data“.

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Popularity: 8% [?]

Tags:none

March 14, 2008

Oracle Discoverer Version Messup

Filed under: OraclePoint — R.Wang @ 6:45 pm

Oracle Discoverer Version Messup

Recently, we experienced a weird problem on using oracle discoverer. Situation: Discoverer Client at version 4.1.37 Discoverer Administraion at version 9.0.4

Problem: Business Area changed on discoverer administration side will not applied in client side.

Solution:

1. Re-install Discoverer Administration Edition 4.1.37

2. Create a new Oracle account with SELECT on DDEF2000 tables

3. Log into the 4.1.37 Admin tool using the new account and create a new EUL

4. Reconnect as owner of the EUL and import the DDEF2000_DIST business area

5. Check the course level to make sure it is varchar

6. Give users’ access to the new EUL and the new business

7. Get user to log on and use Tools/Options/EUL to set his EUL to the new EUL

8. Reconnect user and open a workbook to verify that his issues are fixed. Note: It’s unbelivable that same software only with different version acts totally differently. There must be some significant changes on new version of oracle administration side. Also, experienced that new version didn’t accept importing of business area which is exported in version 4.1.37.

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Popularity: 3% [?]

Tags:none

Page: 1 | 2 | 3 | 4
 

Windows Live Translator:

Google