oracle常用操作

cmd命令开始

sqlplus /nolog  --访问sqlplus

connect /as sysdba  --dba身份登陆

SHUTDOWN IMMEDIATE;  --关闭数据库

select * from V$NLS_PARAMETERS; --查看数据库字符集

ORA-12899错误value too large for column

代码如下 复制代码

sys@PROD>SHUTDOWN IMMEDIATE;
 Database closed.
 Database dismounted.
 ORACLE instance shut down.
 sys@PROD>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.
 sys@PROD>ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

Elapsed: 00:00:02.19
 sys@PROD>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

Elapsed: 00:00:00.02
 sys@PROD>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

Elapsed: 00:00:00.01
 sys@PROD>ALTER DATABASE OPEN;

Database altered.

Elapsed: 00:00:05.09
 sys@PROD>ALTER DATABASE CHARACTER SET ZHS16GBK ;
 ALTER DATABASE CHARACTER SET ZHS16GBK
                *
 ERROR at line 1:
 ORA-00911: 无效字符

Elapsed: 00:00:00.00
 

---报字符集不兼容，此时用INTERNAL_USE指令不对字符集超集进行检查

 代码如下 复制代码

sys@PROD>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;

 Database altered.