CPO Oracle database settings

jlouvet · ‎01-26-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

Shaun Roberts · ‎01-27-2012

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.

--Shaun Roberts
Principal Engineer, CX
shaurobe@cisco.com