10gR1中ora

2023-03-24 20:43| 来源: 网络整理| 查看: 265

10gR1中ora-00201,ora-01103错误的解决办法转载

mb61c186c579369 2022-01-06 10:50:41

文章标签 sql oracle 数据库文章分类代码人生

今天刚到公司,有个网友发了ip与密码过来让我帮你启动数据库,进去后发现数据库安装的比较乱,启动数据库时报00201的错误,很久不摸这些安装方面的东西啦,有点生,忙完了一些例行工作,然后就静下心来测试,很快就启动数据库啦.

[oracle@rdas3 log]$ sqlplus "/ as sysdba"SQL*Plus: Release 10.1.0.3.0 - Production on Tue Dec 6 10:37:26 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile*ERROR at line 1:ORA-32001: write to SPFILE requested but no SPFILE specified at startupSQL> create spfile from pfile;File created.SQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesORA-00205: error in identifying controlfile, check alert log for more infoSQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;System altered.SQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version10.0.0.0.0ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl'SQL> show parameter comNAME TYPE VALUE------------------------------------ ----------- ------------------------------commit_point_strength integer 1compatible string 10.0.0max_commit_propagation_delay integer 700nls_comp stringplsql_compiler_flags string INTERPRETED, NON_DEBUGplsql_v2_compatibility boolean FALSESQL> alter system set compatible='10.1.0.3.0' scope=spfile;System altered.SQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'SQL> oerr ora 1103SP2-0734: unknown command beginning "oerr ora 1..." - rest of line ignored.SQL> host oerr ora 110301103, 00000, "database name '%s' in controlfile is not '%s'"// *Cause: The database name in the controlfile does not match your// database name.// *Action: Either find the correct controlfile or change your database name.SQL> show parameter db_nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_name string DEFAULTSQL> alter system set db_name=ORCL scope=spfile;System altered.SQL> alter database mount;alter database mount*ERROR at line 1:ORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'SQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesDatabase mounted.Database opened.SQL> exit

赞收藏评论分享举报

上一篇：Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)

下一篇：How To Upgrade ASM from 10.2 to 11.1 (RAC)

【本文地址】

公司简介

联系我们

今日新闻

推荐新闻

专题文章