由于sys用户密码于orapwd文件不一致导致的ora-03113错误

冷备恢复了一个数据库，其他相关的配置文件均使用原来已存在，包括orapwd密码文件。 在起库时报密码文件不一致，不予理会，继续open数据库，如下：

SQL> startup

ORACLE instance started.



Total System Global Area  633999036 bytes

Fixed Size                   102076 bytes

Variable Size             386482176 bytes

Database Buffers          245760000 bytes

Redo Buffers                1654784 bytes

ORA-01991: invalid password file

'/stg/oracle/8i/app/oracle/product/8.1.7/dbs/orapworacle'

SQL> alter database open;

Database altered.

SQL> 


但是当调用sys下的对象时出现3113错误。

SQL> exec sys.testuser_pwd_prc('hr','test1234');
 
begin sys.testuser_pwd_prc('hr','test1234'); end;
 
ORA-03113: end-of-file on communication channel
 
SQL>  

查看后台alert log   Thu Jun 26 16:35:20 2008
Errors in file /stg/oracle/8i/app/oracle/admin/oracle/udump/oracle_ora_2639
9.trc:
ORA-07445: exception encountered: core dump [00000001010DC798] [SIGBUS] [Invalid
 address alignment] [9] [] []
ORA-01991: invalid password file '/stg/oracle/8i/app/oracle/product/8.1.7/d
bs/orapworacle'
ORA-01991: invalid password file '/stg/oracle/8i/app/oracle/product/8.1.7/d
bs/orapworacle' 重新生成密码文件：  orapwd file=orapworacle password=oracle8i 问题解决： SQL> exec sys.testuser_pwd_prc('hr','test1234');
 
CHANGE  hr's password  successfull !
 
PL/SQL procedure successfully completed
 
SQL>