Oracle Common Operations

CMD command starts

Sqlplus/nolog--Visit sqlplus

Connect/as SYSDBA--dba Identity Login

SHUTDOWN IMMEDIATE; --Close the database

SELECT * from V$nls_parameters; --View the database character set

ORA-12899 error value too large for column

Code to copy code as follows

[email protected]>shutdown IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
[email protected]>startup MOUNT
ORACLE instance started.

Total System Global area 939495424 bytes
Fixed Size 2233960 bytes
Variable Size 671091096 bytes
Database buffers 260046848 bytes
Redo buffers 6123520 bytes
Database mounted.
[email protected]>alter SYSTEM ENABLE RESTRICTED SESSION;

System altered.

elapsed:00:00:02.19
[email protected]>alter SYSTEM SET job_queue_processes=0;

System altered.

elapsed:00:00:00.02
[email protected]>alter SYSTEM SET aq_tm_processes=0;

System altered.

elapsed:00:00:00.01
[email protected]>alter DATABASE OPEN;

Database altered.

elapsed:00:00:05.09
[email protected]>alter DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK
*
ERROR at line 1:
ORA-00911: Invalid character

elapsed:00:00:00.00

---the character set is incompatible, this time with the internal_use instruction does not check the character set superset

Code to copy code as follows

[email protected]>alter DATABASE CHARACTER SET internal_use ZHS16GBK;

Database altered.

Oracle Common Operations