1. View database Character Set
The database server character Set select * from Nls_database_parameters, which originates from props$, is the character set representing the database.
Client Character Set Environment select * from Nls_instance_parameters, which originates from V$parameter,
Represents the setting of a client's character set, possibly a parameter file, an environment variable, or a registry
The session Character set environment select * from Nls_session_parameters, which originates from the V$nls_parameters, represents the session's own settings, either the environment variable of the session or the alter sessions complete. If the session does not have a special setting, it will be consistent with nls_instance_parameters.
The client's character set requires consistency with the server in order to correctly display non-ASCII characters of the database. If multiple settings exist, ALTER session> environment variable > registry > Parameter File
Character sets require consistency, but language settings can be different, and language settings are recommended in English. If the character set is ZHS16GBK, then Nls_lang can be AMERICAN_AMERICA.ZHS16GBK.
2. Modify Character Set
8i the above version can modify the character set by ALTER DATABASE, but it is limited to a subset to a superset, and it is not recommended to modify the props$ table, which can cause serious errors.
Startup Nomount;
Alter database Mount exclusive;
Alter system enable restricted session;
Alter system set job_queue_process=0;
Alter database open;
Alter database character Set ZHS16GBK;
3, how to view the database version
SELECT * FROM V$version
Contains version information, core version information, bit information (32-bit or 64-bit), and so on
As for the bit information, on the Linux/unix platform, you can view it through file, such as
File $ORACLE _home/bin/oracle