Skip to main content

ORA-12705: invalid or unknown NLS parameter value specified

Use sqlplus to connect a remote oracle providing sid is configured in network/admin/tnsname.ora.

sqlplus username/password@sid

it reports error

ORA-12705: invalid or unknown NLS parameter value specified

it is caused by NLS_LANG setting. To fix, try the following.

set NLS_LANG=american_america.we8iso8859p1
set NLSPATH=NLSPATH=$NLSPATH:/usr/xxx
set LANG=en_US

Comments