1. Precise Oracle version, edition (e.g. standard, enterprise, etc.), and patch levels.
11.2.0.4.0 Enterprise
2. OS vendor for the Oracle database server.
Linux SUSE 11
3. Oracle hostname (or at least the make-up of it, such as the length of the hostname in characters and any non-alphabet characters used like periods or hyphens or similar, so as to keep your details confidential), username, service ID, and length of the password.
hostname: YYXXXXXXprd12.fpprod.corp
username: niku
serviceID: CLARITY
service Name: XXXDEV1
4. I presume it is not an Oracle RAC environment, given you are using the CSA fields and not a JDBC URI string of your own, but if you could confirm if it is or isn't RAC please.
No RAC normal storage
5. Health Check database reported item values (for nls_date, nls_sort, nls_comp, database characterset)
here is a copy paste from an export to excel from the portlet nsql query you added in one of your posts regarding nls_date_format setting:
parameter value level
NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY database NLS_COMP BINARY session NLS_COMP BINARY instance
NLS_DATE_FORMAT database NLS_DATE_FORMAT DD-MON-RR session NLS_DATE_FORMAT YYYY-MM-DD HH24:MI:SS instance
NLS_LANGUAGE ENGLISH database NLS_LANGUAGE AMERICAN session NLS_LANGUAGE ENGLISH instance
NLS_RDBMS_VERSION 11.2.0.4.0
NLS_SORT BINARY database NLS_SORT XWEST_EUROPEAN session NLS_SORT instance
NLS_TERRITORY UNITED KINGDOM database NLS_TERRITORY UNITED KINGDOM session NLS_TERRITORY AMERICA instance
*** there are 2 potential conflicts which CSA is complaining about...
Date Format is only OK at Instance level since they created a trigger for it
Sort is OK at DB level but not at session level...
Can I continue on with the installation in that case? it is only a DEV/Test environment... and the customer does NOT want to create a dedicated DB instance for Clarity as they claim it is not a critical application here and only maximum 30 concurrent users will ever use the system (100 in total). I told them I would not be flexible for PROD environment but maybe we could give it a try for DEV... what do you reckon?
many thanks!