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

2024-03-10 00:38

本文主要是介绍10gR1中ora-00201,ora-01103错误的解决办法,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

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

 

[oracle@rdas3 log]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Tue Dec 6 10:37:26 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> 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 startup


SQL> create spfile from pfile;

File created.

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


SQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version
10.0.0.0.0
ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl'


SQL> show parameter com

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
commit_point_strength integer 1
compatible string 10.0.0
max_commit_propagation_delay integer 700
nls_comp string
plsql_compiler_flags string INTERPRETED, NON_DEBUG
plsql_v2_compatibility boolean FALSE
SQL> alter system set compatible='10.1.0.3.0' scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
ORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'


SQL> oerr ora 1103
SP2-0734: unknown command beginning "oerr ora 1..." - rest of line ignored.
SQL> host oerr ora 1103
01103, 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_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string DEFAULT
SQL> 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 immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> exit

 

FROM: http://xzh2000.itpub.net/post/96/47739

这篇关于10gR1中ora-00201,ora-01103错误的解决办法的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/792466

相关文章

springboot循环依赖问题案例代码及解决办法

《springboot循环依赖问题案例代码及解决办法》在SpringBoot中,如果两个或多个Bean之间存在循环依赖(即BeanA依赖BeanB,而BeanB又依赖BeanA),会导致Spring的... 目录1. 什么是循环依赖?2. 循环依赖的场景案例3. 解决循环依赖的常见方法方法 1:使用 @La

MySQL错误代码2058和2059的解决办法

《MySQL错误代码2058和2059的解决办法》:本文主要介绍MySQL错误代码2058和2059的解决办法,2058和2059的错误码核心都是你用的客户端工具和mysql版本的密码插件不匹配,... 目录1. 前置理解2.报错现象3.解决办法(敲重点!!!)1. php前置理解2058和2059的错误

Docker镜像pull失败两种解决办法小结

《Docker镜像pull失败两种解决办法小结》有时候我们在拉取Docker镜像的过程中会遇到一些问题,:本文主要介绍Docker镜像pull失败两种解决办法的相关资料,文中通过代码介绍的非常详细... 目录docker 镜像 pull 失败解决办法1DrQwWCocker 镜像 pull 失败解决方法2总

Python中ModuleNotFoundError: No module named ‘timm’的错误解决

《Python中ModuleNotFoundError:Nomodulenamed‘timm’的错误解决》本文主要介绍了Python中ModuleNotFoundError:Nomodulen... 目录一、引言二、错误原因分析三、解决办法1.安装timm模块2. 检查python环境3. 解决安装路径问题

如何解决mysql出现Incorrect string value for column ‘表项‘ at row 1错误问题

《如何解决mysql出现Incorrectstringvalueforcolumn‘表项‘atrow1错误问题》:本文主要介绍如何解决mysql出现Incorrectstringv... 目录mysql出现Incorrect string value for column ‘表项‘ at row 1错误报错

关于Docker Desktop的WSL报错问题解决办法

《关于DockerDesktop的WSL报错问题解决办法》:本文主要介绍关于DockerDesktop的WSL报错问题解决办法的相关资料,排查发现是因清理%temp%文件夹误删关键WSL文件,... 目录发现问题排查过程:解决方法其实很简单:重装之后再看就能够查到了:最后分享几个排查这类问题的小www.cp

电脑开机提示krpt.dll丢失怎么解决? krpt.dll文件缺失的多种解决办法

《电脑开机提示krpt.dll丢失怎么解决?krpt.dll文件缺失的多种解决办法》krpt.dll是Windows操作系统中的一个动态链接库文件,它对于系统的正常运行起着重要的作用,本文将详细介绍... 在使用 Windows 操作系统的过程中,用户有时会遇到各种错误提示,其中“找不到 krpt.dll”

Pycharm安装报错:Cannot detect a launch configuration解决办法

《Pycharm安装报错:Cannotdetectalaunchconfiguration解决办法》本文主要介绍了Pycharm安装报错:Cannotdetectalaunchconfigur... 本文主要介绍了Pycharm安装报错:Cannot detect a launch configuratio

SpringBoot项目启动错误:找不到或无法加载主类的几种解决方法

《SpringBoot项目启动错误:找不到或无法加载主类的几种解决方法》本文主要介绍了SpringBoot项目启动错误:找不到或无法加载主类的几种解决方法,具有一定的参考价值,感兴趣的可以了解一下... 目录方法1:更改IDE配置方法2:在Eclipse中清理项目方法3:使用Maven命令行在开发Sprin

前端bug调试的方法技巧及常见错误

《前端bug调试的方法技巧及常见错误》:本文主要介绍编程中常见的报错和Bug,以及调试的重要性,调试的基本流程是通过缩小范围来定位问题,并给出了推测法、删除代码法、console调试和debugg... 目录调试基本流程调试方法排查bug的两大技巧如何看控制台报错前端常见错误取值调用报错资源引入错误解析错误