How to verify NLS_SORT value using the Driver utility. How to run the database query with the Driver utility: select * from nls_session_parameters |
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers. 1- Open the Driver tool. ARS 19.02.x - Using the driver program ARS 18.08.x - Using the driver program ARS 18.05.x - Using the driver program ARS 9.1.x - Using the driver program 2- Follow these steps (as per the example below): Command: log Control record: Authentication string () : User name () : <Remedy admin user, for example Demo> Password () : <Remedy's user password - note, the pwd will be displayed in plain text > Locale[.charSet] () : Time zone () : Server () : <AR Server name> Command: init INITIALIZATION ARInitialization results ReturnCode: OK Status List : 0 items --- The following step is only to be done if ARS is configured to use a specific AR TCP port. If the Portmapper is used then this step can be skipped --- Command: ssp SET SERVER PORT The port number of server (0): <AR Port> Using private socket? (0): <RPC Socket if used, otherwise press enter> ARSetServerPort results ReturnCode: OK Status List : 0 items ------------------------------------------------------------------ Command: glsql GETLIST SQL SQL command: select * from nls_session_parameters Maximum number of entries to retrieve (500): Get number of matches? (F): ARGetListSQL results ReturnCode: OK Value List List : 17 items Value List : 2 items Value: (char) NLS_LANGUAGE Value: (char) AMERICAN Value List : 2 items Value: (char) NLS_TERRITORY Value: (char) AMERICA Value List : 2 items Value: (char) NLS_CURRENCY Value: (char) $ Value List : 2 items Value: (char) NLS_ISO_CURRENCY Value: (char) AMERICA Value List : 2 items Value: (char) NLS_NUMERIC_CHARACTERS Value: (char) ., Value List : 2 items Value: (char) NLS_CALENDAR Value: (char) GREGORIAN Value List : 2 items Value: (char) NLS_DATE_FORMAT Value: (char) DD-MON-RR Value List : 2 items Value: (char) NLS_DATE_LANGUAGE Value: (char) AMERICAN Value List : 2 items Value: (char) NLS_SORT Value: (char) BINARY |