还是使用dbua将9.2.0.7的数据库升级到10.2.0.4后遗留问题的其中一个
问题的出现步骤如下(启动数据库的时候从nomount启动到mount的时候报错,却能手工alter database mount,但是在alter databae open的时候报错,数据库直接被down下来了,比较奇怪):
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 21 16:06:49 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 452984832 bytes
Fixed Size 2041304 bytes
Variable Size 411048488 bytes
Database Buffers 33554432 bytes
Redo Buffers 6340608 bytes
ORA-12709: error while loading create database character set
SQL> alter database mount;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> shut immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
最后发现是因为Oracle 10g相对与9i,一些环境变量有了变化,ORA_NLS33改为了ORA_NLS10,而且指向的位置也变了(由ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data变成ORA_NLS10 = $ORACLE_HOME/nls/data),而我在使用dbua升级数据库以后只是将环境变量改名,并没有改指向的位置。纠正后问题解决
问题的出现步骤如下(启动数据库的时候从nomount启动到mount的时候报错,却能手工alter database mount,但是在alter databae open的时候报错,数据库直接被down下来了,比较奇怪):
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 21 16:06:49 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 452984832 bytes
Fixed Size 2041304 bytes
Variable Size 411048488 bytes
Database Buffers 33554432 bytes
Redo Buffers 6340608 bytes
ORA-12709: error while loading create database character set
SQL> alter database mount;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> shut immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
最后发现是因为Oracle 10g相对与9i,一些环境变量有了变化,ORA_NLS33改为了ORA_NLS10,而且指向的位置也变了(由ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data变成ORA_NLS10 = $ORACLE_HOME/nls/data),而我在使用dbua升级数据库以后只是将环境变量改名,并没有改指向的位置。纠正后问题解决
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/498744/viewspace-432957/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/498744/viewspace-432957/