I am trying to login to an Oracle 10g database vía sqlplus.
In the nls_session_parameters I need NLS_DATE_LANGUAGE in American, but I always have Spanish.
In the database server my NLS_LANG is SPANISH_SPAIN.WE8ISO8859P1.
In the client my NLS_LANG is AMERICAN_AMERICA.UTF8.
I tried setting this with an after logon trigger, but it does not work. If I change this setting vía ALTER SESSION it works ok, but it is not a solution.
The database server is a Red Hat Enterprise 5.6 The client is a CentOS 7.5. I am using Oracle Instant client 10.2.0.5.
I do not know how to continue...