- Welcome BMC Customer Support Site Guest User
Knowledge Article
Remedy - Server - How to verify NLS SESSION PARAMETERS values using the Driver utility
How to verify NLS SESSION PARAMETERS values using the Driver utility
Remedy AR System Server
AR System
Remedy AR System Server all versions with Oracle databases.
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 |
Attachment(s):