文章摘要
本文描述了在升级或恢复Oracle数据库时遇到的常见错误，尤其是当系统中有多个Oracle HOME实例时，可能因环境识别问题导致无法正常启动。错误信息包括ORA-00904（"I"."UNUSABLEBEGINNING#":?invalid?identifier）和ORA-01092（"ORACLE?instance?terminated.?Disconnection?forced"）。解决方案包括正确设置环境变量（如ORACLE_SID、ORACLE_HOME等）、使用RMAN备份检查升级日志，并参考相关文档（如Note 1905616.1SRDC等）进一步诊断和解决问题。
APPLIES?TO:
Oracle?Database?-?Enterprise?Edition?-?Version?11.2.0.4?and?later
Information?in?this?document?applies?to?any?platform.
SYMPTOMS
?
SQL>?alter?database?open;
alter?database?open
*
ERROR?at?line?1:
ORA-01092:?ORACLE?instance?terminated.?Disconnection?forced
ORA-00704:?bootstrap?process?failure
ORA-00604:?error?occurred?at?recursive?SQL?level?2
ORA-00904:?”I”.”UNUSABLEBEGINNING#”:?invalid?identifier
Process?ID:?23346
Session?ID:?680?Serial?number:?51933
CHANGES
?After?restoring?the?database?to?another?server?by?RMAN,?it?is?failed?to?startup.
After?upgrade?or?post?upgrade
CAUSE
?>>>>>ORA-00904:?”I”.”UNUSABLEBEGINNING#”:?invalid?identifier
This?error?appears?due?to?using?the?incorrect?sqlplus?environment.?For?example.,?By?default?SQLPLUS?will?connect?to?the?default?ORACLE_HOME,?say?12C?Home?but?if?you?are?duplicating?the?11g?database?on?same?host?the?it?must?be?Oracle?11g?Environment?in?order?to?complete?the?process.
1?-?This?issue?happens?when?we?have?installed?multiple?Oracle?Homes?in?a?single?system.
2?-?We?need?to?make?sure?that?we?are?in?the?right?environment?when?we?are?restoring?it.
SOLUTION
You?need?to?set?all?the?required?Environment?Variables?first?as?per?your?need?like?ORACLE_SID,?ORACLE_BASE,?ORACLE_HOME,?TNS_ADMIN,?PATH?with?proper?values
(OR)
Simply?work?by?going?to?the?bin?directory?of?your?required?ORACLE_HOME
SET?ORACLE_HOME=Your_Oracle_Home
CD?ORACLE_HOME\bin
Even?if?you?set?all?the?environment?parameter?properly,?then?need?to?investigate?further?to?verify?the?rman?backup?set?which?used?to?restore?or?verify?the?upgrade?logs,?component,?dba_registry?etc.
Provide?the?details?requested?in?below?Notes?based?on?the?post?restore?or?post?upgrade
Note?1905616.1SRDC?-?Startup?Issues:?Checklist?of?Evidence?to?Supply?(Doc?ID?1905616.1)
Note?1906468.1SRDC?-?Startup?Shutdown?-?Oracle?Binary?and?OS?Resources:?Checklist?of?Evidence?to?Supply?(Doc?ID?1906468.1)
Note:1672387.1SRDC?-?Data?Collection?for?Upgrade?Issues
Note?753041.1?How?to?Diagnose?Components?with?NON?VALID?Status?in?DBA_REGISTRY?after?an?Upgrade?(Doc?ID?753041.1)
Note?1965956.1SRDC?-?Data?Collection?for?Datapatch?issues?(Doc?ID?1965956.1)
Note?1671416.1SRDC?-?Required?diagnostic?data?collection?for?RMAN?Restore?and?Recover?Using?TFA?Collector?(Recommended)?or?Manual?Steps?(Doc?ID?1671416.1)