Modify Oracle Character Set

[Oracle @ gisdb bin] $./sqlplus
Error 6 initializing SQL * Plus
Message file SP1 <Lang>. MSB not found
SP2-0750: you may need to set ORACLE_HOME to your Oracle Software Directory
[Oracle @ gisdb bin] $ pro
Bash: Pro: Command not found
[Oracle @ gisdb bin] $
[Oracle @ gisdb bin] $ export ORACLE_HOME =/Oracle/product/10.2.0/db_1
[Oracle @ gisdb bin] $./sqlplus

SQL * Plus: Release 10.2.0.5.0-production on Wed Oct 31 15:31:36 2012

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Enter user-Name: System
Enter password:
Error:
ORA-12162: TNS: net service name is incorrectly specified

Enter user-Name: System
Enter password:
Error:
ORA-12162: TNS: net service name is incorrectly specified

Enter user-Name: System/system123 @ gisdb
Error:
ORA-12526: TNS: Listener: all appropriate instances are in restricted mode

SP2-0157: Unable to connect to Oracle after 3 attempts, exiting SQL * Plus
[Oracle @ gisdb bin] $./sqlplus

SQL * Plus: Release 10.2.0.5.0-production on Wed Oct 31 15:32:58 2012

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Enter user-Name: System/system123
Error:
ORA-12162: TNS: net service name is incorrectly specified

Enter user-Name:
Error:
ORA-12162: TNS: net service name is incorrectly specified

SP2-0157: Unable to connect to Oracle after 3 attempts, exiting SQL * Plus
[Oracle @ gisdb bin] $
[Oracle @ gisdb bin] $
[Oracle @ gisdb bin] $ export oracle_sid = gisdb
[Oracle @ gisdb bin] $./sqlplus

SQL * Plus: Release 10.2.0.5.0-production on Wed Oct 31 15:33:43 2012

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Enter user-Name: System
Enter password:
Error:
ORA-01017: invalid username/password; logon denied

Enter user-Name: System/system123

Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the partitioning, OLAP, data mining and real application testing options

SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL> shutdwon
SP2-0042: Unknown command "shutdwon"-rest of line ignored.
SQL> Shutdown
ORA-01031: insufficient privileges
SQL> startup
ORA-32004: obsolete and/or deprecated parameter (s) specified
ORA-01031: insufficient privileges
SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL> Conn/As sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter (s) specified
Oracle instance started.

Total system global area 1610612736 bytes
Fixed size 2096632 bytes
Variable Size 402653704 bytes
Database buffers 1191182336 bytes
Redo buffers 14680064 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup Mount
ORA-32004: obsolete and/or deprecated parameter (s) specified
Oracle instance started.

Total system global area 1610612736 bytes
Fixed size 2096632 bytes
Variable Size 402653704 bytes
Database buffers 1191182336 bytes
Redo buffers 14680064 bytes
Database mounted.
SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes = 0;

System altered.

SQL> alter system set aq_tm_processes = 0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set zhs16gbk;
Alter database character set zhs16gbk
*
Error at line 1:
ORA-12712: new character set must be a superset of old Character Set

SQL> alter database character set internal_use zhs16gbk;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter (s) specified
Oracle instance started.

Total system global area 1610612736 bytes
Fixed size 2096632 bytes
Variable Size 402653704 bytes
Database buffers 1191182336 bytes
Redo buffers 14680064 bytes
Database mounted.
Database opened.
SQL> shutdown immedaite
SP2-0717: Illegal Shutdown option
SQL> Conn/As sysdba
Connected.
SQL> shutdwon immediate
SP2-0734: Unknown command beginning "shutdwon I..."-rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter (s) specified
Oracle instance started.

Total system global area 1610612736 bytes
Fixed size 2096632 bytes
Variable Size 402653704 bytes
Database buffers 1191182336 bytes
Redo buffers 14680064 bytes
Database mounted.
Database opened.
SQL> select * from V $ version;

Banner
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bi
PL/SQL release 10.2.0.5.0-Production
Core 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0-Production
Nlsrtl version 10.2.0.5.0-Production

SQL>

View character set:

SQL> select * From nls_database_parameters;
 
Parameter Value
--------------------------------------------------------------------------------------------------------------
Nls_language American
Nls_territory America
Nls_currency $
Nls_iso_currency America
Nls_numeric_characters .,
Nls_characterset zhs16gbk
Nls_calendar Gregorian
Nls_date_format DD-MON-RR
Nls_date_language American
Nls_sort binary
Nls_time_format HH. Mi. ssxff AM
Nls_timestamp_format DD-MON-RR HH. Mi. ssxff AM
Nls_time_tz_format HH. Mi. ssxff am tzr
Nls_timestamp_tz_format DD-MON-RR HH. Mi. ssxff am tzr
Nls_dual_currency $
Nls_comp binary
Nls_length_semantics byte
Nls_nchar_conv_excp false
Nls_nchar_characterset al16utf16
Nls_rdbms_version 10.2.0.5.0
 
20 rows selected