1.首先以sysdba的身份登录上去 conn /as sysdba
2.关闭数据库shutdown immediate;3.以mount打来数据库,startup mount4.设置session SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;5.启动数据库alter database open;6.修改字符集 ALTER DATABASE character set INTERNAL_USE ZHS16GBK;INTERNAL_USE 提供的帮助就会使oracle绕过了子集与超集的验证,这条语句和上面的语句内部操作时完全相同的。7.关闭,重新启动SQL>shutdown immediate;SQL> startup