CPO Oracle database settings

Unanswered Question
Jan 26th, 2012

Hi,

The CPO install guide mention to modify the Oracle database settings as follow:

"For the Oracle DB instance dedicated to TEO, use the following script to change the case-sensitive settings in the Oracle database. The user must have database administrative rights to execute this script.

After changing the settings, the user must reset the database server.

Script

ALTER SYSTEM SET NLS_COMP=LINGUISTIC scope=spfile;

ALTER SYSTEM SET NLS_SORT=BINARY_CI scope=spfile; "

We are deploying TEO in an existing database containing other applications. Modifying the Database properties has indicated above may (still investigating) create issues with the other existing applications.

What is the impact of not applying the above changes to the database ?

Thank you,

JB

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Average Rating: 0 (0 ratings)
Shaun Roberts Fri, 01/27/2012 - 10:35

Julio suggested checking out these two bugs:

CSCtr89012 Oracle database is case sensitive

CSCts03785 Operations -> search is case sensitive in Oracle

He said it was close to the end of regression and was safer for them to ask for case insensitive settings.

The drawback to not having this would be some select type statements would not work or some things in tasks might not work...

ie. "task" would not match up with "Task"

I would suggest contacting Don Freeman and/or Julio Silveria for more information.

Actions

Login or Register to take actions

This Discussion

Posted January 26, 2012 at 9:59 PM
Stats:
Replies:1 Avg. Rating:
Views:414 Votes:0
Shares:0

Related Content

Discussions Leaderboard