DevTest DB character set

[Balamurugan Ravi]

Hi Team,

Can we use the below character set for DevTest DB setup or should we alter the database into UTF8 character set.

 

Character set:

PARAMETER	VALUE	CON_ID
NLS_CHARACTERSET	WE8MSWIN1252	0
NLS_NCHAR_CHARACTERSET	AL16UTF16	0

 

Version                : DevTest 10.1

Database             : AWS RDS Oracle 12c standard

 

Thanks,

Balamurugan.

[Legacy User]

No.

Configure Enterprise Dashboard to Use Oracle - DevTest Solutions - 10.1 - CA Technologies Documentation  

Ensure the characterset supports Unicode.

For example, a UTF Characterset (such as AL32UTF8) and a UTF8 National Characterset; otherwise, DevTest may not be able to connect to the database.

If DevTest will create the database automatically at start-up, please ensure the User Acct has the permissions necessary to create tables and views.  DBO privileges is the best option during initial connection. The privileges can be turned down to CRUD after a successful install and connection if that is an issue.

[Balamurugan Ravi]

Thanks J_NeSmith

[radhiga]

Hi Joel,

Currently we are using 11g, Can you please tell me how to interact with 12c DB in Ca Lisa 10.2 version??

[Legacy User]

11g and 12c should be similar. You might need to swap out the ojdbc JAR in LISA_HOME\lib\shared with a version of the JAR for 12c.  I do not recall if the JAR shipped with DevTest is compatible.  The screenshot of 12c, above, was taken from a customer running DT 9.1; therefore, it should work with 10.2.