本来我的数据库运行的都很好的，但是就今天启动服务的时候，报错，在网上找了很久都没有答案，我的alert_orcl.log内容如下，我只截取了今天的内容，
Sun Dec 06 22:09:28 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 176160768
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_2\DBS\SPFILEORCL.ORA
sga_target = 532676608
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 339738624
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 0
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 177209344
aq_tm_processes = 0
PMON started with pid=2, OS id=4456
PSP0 started with pid=3, OS id=5544
MMAN started with pid=4, OS id=3540
DBW0 started with pid=5, OS id=4852
LGWR started with pid=6, OS id=5712
CKPT started with pid=7, OS id=4552
SMON started with pid=8, OS id=4900
RECO started with pid=9, OS id=3504
MMON started with pid=10, OS id=992
Sun Dec 06 22:09:28 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Dec 06 22:09:28 2009
starting up 1 shared server(s) ...
Sun Dec 06 22:09:28 2009
alter database mount exclusive
MMNL started with pid=11, OS id=2268
Sun Dec 06 22:09:34 2009
Setting recovery target incarnation to 2
Sun Dec 06 22:09:34 2009
Successful mount of redo thread 1, with mount id 1232743706
Sun Dec 06 22:09:34 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sun Dec 06 22:09:34 2009
alter database open
Sun Dec 06 22:09:35 2009
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Sun Dec 06 22:09:35 2009
Started redo scan
Sun Dec 06 22:09:35 2009
Completed redo scan
53 redo blocks read, 4 data blocks need recovery
Sun Dec 06 22:09:35 2009
Started redo application at
Thread 1: logseq 1377, block 3, scn 21551619
Sun Dec 06 22:09:35 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1377 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Dec 06 22:09:35 2009
Completed redo application
Sun Dec 06 22:09:35 2009
Completed crash recovery at
Thread 1: logseq 1377, block 56, scn 21571669
4 data blocks read, 4 data blocks written, 53 redo blocks read
Sun Dec 06 22:09:37 2009
Thread 1 advanced to log sequence 1378 (thread open)
Thread 1 opened at log sequence 1378
Current log# 2 seq# 1378 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sun Dec 06 22:09:37 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Dec 06 22:09:37 2009
SMON: enabling cache recovery
Sun Dec 06 22:09:38 2009
Successfully onlined Undo Tablespace 1.
Sun Dec 06 22:09:38 2009
SMON: enabling tx recovery
Sun Dec 06 22:09:39 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4716.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:39 2009
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Sun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4456.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_5544.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_5712.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_3540.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_4852.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_4552.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:41 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_3504.trc:
ORA-12701: CREATE DATABASE character set is not knownInstance terminated by USER, pid = 4716
ORA-1092 signalled during: alter database open...它提示我有 ORA-12701的错误，说是字符集错误，我是修改过字符集，但是那是上个周一的事情，我这一周都用下来没有问题，同时，我更改字符集，只是
update props$ set value$='UTF8' where name='NLS_CHARACTERSET'
然后利用了一下之后，紧接着我又
update props$ set value$='ZHS16GBK' where name='NLS_CHARACTERSET'
这是我原来的，但是就一直起不来，
一启动就这样，
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 532676608 bytes
Fixed Size 1297700 bytes
Variable Size 184550108 bytes
Database Buffers 339738624 bytes
Redo Buffers 7090176 bytes
Database mounted.
SQL> alter database clear logfile group 4;
alter database clear logfile group 4
*
ERROR at line 1:
ORA-00359: logfile group 4 does not exist
SQL> alter database clear logfile group 3;Database altered.SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> ALTER DATABASE OPEN;
ERROR:
ORA-03114: not connected to ORACLE
在线等！
Sun Dec 06 22:09:28 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 176160768
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_2\DBS\SPFILEORCL.ORA
sga_target = 532676608
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 339738624
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 0
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 177209344
aq_tm_processes = 0
PMON started with pid=2, OS id=4456
PSP0 started with pid=3, OS id=5544
MMAN started with pid=4, OS id=3540
DBW0 started with pid=5, OS id=4852
LGWR started with pid=6, OS id=5712
CKPT started with pid=7, OS id=4552
SMON started with pid=8, OS id=4900
RECO started with pid=9, OS id=3504
MMON started with pid=10, OS id=992
Sun Dec 06 22:09:28 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Dec 06 22:09:28 2009
starting up 1 shared server(s) ...
Sun Dec 06 22:09:28 2009
alter database mount exclusive
MMNL started with pid=11, OS id=2268
Sun Dec 06 22:09:34 2009
Setting recovery target incarnation to 2
Sun Dec 06 22:09:34 2009
Successful mount of redo thread 1, with mount id 1232743706
Sun Dec 06 22:09:34 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sun Dec 06 22:09:34 2009
alter database open
Sun Dec 06 22:09:35 2009
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Sun Dec 06 22:09:35 2009
Started redo scan
Sun Dec 06 22:09:35 2009
Completed redo scan
53 redo blocks read, 4 data blocks need recovery
Sun Dec 06 22:09:35 2009
Started redo application at
Thread 1: logseq 1377, block 3, scn 21551619
Sun Dec 06 22:09:35 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1377 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Dec 06 22:09:35 2009
Completed redo application
Sun Dec 06 22:09:35 2009
Completed crash recovery at
Thread 1: logseq 1377, block 56, scn 21571669
4 data blocks read, 4 data blocks written, 53 redo blocks read
Sun Dec 06 22:09:37 2009
Thread 1 advanced to log sequence 1378 (thread open)
Thread 1 opened at log sequence 1378
Current log# 2 seq# 1378 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sun Dec 06 22:09:37 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Dec 06 22:09:37 2009
SMON: enabling cache recovery
Sun Dec 06 22:09:38 2009
Successfully onlined Undo Tablespace 1.
Sun Dec 06 22:09:38 2009
SMON: enabling tx recovery
Sun Dec 06 22:09:39 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4716.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:39 2009
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Sun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4456.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_5544.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_5712.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_3540.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_4852.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_4552.trc:
ORA-12701: CREATE DATABASE character set is not knownSun Dec 06 22:09:41 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_3504.trc:
ORA-12701: CREATE DATABASE character set is not knownInstance terminated by USER, pid = 4716
ORA-1092 signalled during: alter database open...它提示我有 ORA-12701的错误，说是字符集错误，我是修改过字符集，但是那是上个周一的事情，我这一周都用下来没有问题，同时，我更改字符集，只是
update props$ set value$='UTF8' where name='NLS_CHARACTERSET'
然后利用了一下之后，紧接着我又
update props$ set value$='ZHS16GBK' where name='NLS_CHARACTERSET'
这是我原来的，但是就一直起不来，
一启动就这样，
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 532676608 bytes
Fixed Size 1297700 bytes
Variable Size 184550108 bytes
Database Buffers 339738624 bytes
Redo Buffers 7090176 bytes
Database mounted.
SQL> alter database clear logfile group 4;
alter database clear logfile group 4
*
ERROR at line 1:
ORA-00359: logfile group 4 does not exist
SQL> alter database clear logfile group 3;Database altered.SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> ALTER DATABASE OPEN;
ERROR:
ORA-03114: not connected to ORACLE
在线等！
楼主用下面的方法，修改字符集看看..
1. 关闭数据库
SQL>SHUTDOWN IMMEDIATE2. 启动到Mount
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET ZHS16GBK;
SQL>ALTER DATABASE national CHARACTER SET ZHS16GBK;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP注意：如果没有大对象，在使用过程中进行语言转换没有什么影响，（切记设定的字符集必须是ORACLE支持，不然不能start） 按上面的做法就可以。若出现‘ORA-12717: Cannot ALTER DATABASE NATIONAL CHARACTER SET when NCLOB data exists’ 这样的提示信息，要解决这个问题有两种方法1. 利用INTERNAL_USE 关键字修改区域设置,
2. 利用re-create,但是re-create有点复杂,所以请用internal_use SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT EXCLUSIVE;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE UTF8;
SQL>SHUTDOWN immediate;
SQL>startup;如果按上面的做法做,National charset的区域设置就没有问题Oracle 字符集的查看和修改http://blog.csdn.net/tianlesoftware/archive/2009/12/01/4915223.aspx------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群：62697716
谢谢http://store.taobao.com/shop/view_shop.htm?nekot=YW5keXdhbmdqdW4wMDc=1271486195554&user_number_id=85698354