Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 11g Installation for database 10g

999608Mar 27 2013 — edited Mar 30 2013
We want to evaluate OBIEE for our business. We want to install OBIEE 11g as stand-alone i.,e not integrated with any ERP, but we have our own data warehouse kind of system.
We ran on Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

Questions:
1) Can we install latest OBIEE 11g version on our database.
2) Is ‘web logic ‘ server mandatory ?. If yes, do we need to buy separate license for web logic server?.
3) Any suggestions?

Comments

unknown-951199

>Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';

Above renders null & void any support contract between you & Oracle.


I hope you have a good backup that was completed before your fatal modification.


jgarry

Tom says it best: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1224836384599#16453523492091

Hemant K Chitale

See the strongly worded warning in Oracle Support Note "Changing Or Choosing the Database Character Set ( NLS_CHARACTERSET ) (Doc ID 225912.1)"

Hemant K Chitale

Srini Chavali-Oracle 
To update Character set in Oracle.


Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';

As stated, this is not supported - it will corrupt your database beyond repair. You will have to restore from a good backup taken before this statement was issued.

The supported methods are documented -

http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch11charsetmig.htm#NLSPG467

Database Migration Assistant for Unicode - Overview

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 27 2013
Added on Mar 27 2013
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #database, #installation, #obiee
8 comments
852 views