sorry I am an application developer and not much of a DBA
anyway we are running the totally unsupported SUN Forte UDS and we are attempting to upgrade from oracle 10g to 11g.
so currently we are running or application against
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
select parameter,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET')
Results in
PARAMETER VALUE
NLS_CHARACTERSET US7ASCII
and we are now try to run it against
BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
select parameter,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET')
Results in
PARAMETER VALUE
NLS_CHARACTERSET WE8MSWIN1252
apparently forte requires US7ASCII
so I am guessing
I log onto linux, open up sqlplus and type something like
% setenv NLS_LANG AMERICAN_AMERICA.US7ASCII
is that right? then what do I have to do
shut down and restart the database?
if so I'm not sure of the commands for that.
thanks.