使用rman复制数据库再重新打开时出现这个错误“ORA-01103: database name 'ORCLDG' in control file is not 'ORCL' ” 解决方法: 1.将D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora中的参数db_name改为orcldg,启动数据库到加载状态。startup mount pfile='D:\oracle\product\10.2.0\admin\orcl\pfi...
解决方法:重建controlfile: 1)删除现在的controlfile 2)nomount DB SQL>startup nomount; 3)重建 createcontrolfilesetdatabase"dtberp" resetlogs LOGFILE GROUP1'/u01/app/oracle/oradata/dtserp/REDO01.LOG'SIZE 10M, GROUP2'/u01/app/oracle/oradata/dtserp/REDO02.LOG'SIZE 10M, GROUP3'/u01/app/oracle/...
ORA-01103: database name 'ORCLDG' in control file is not 'ORCL' 使用rman复制数据库再重新打开时出现这个错误“ORA-01103: database name 'ORCLDG' in control file is not 'ORCL' ” 解决方法: 1.将D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora中的参数db_name改为orcldg,启动数据库到加...
ORA-01103: database name 'CLONE' in control file is not 'PROD' This database name is PROD; Issue Details: 1. There was only 11.2 database on this test; (db_name=PROD) and it was working smoothly; 2. We are using EBS 12.1.2; with 11.1.0.7 db; we faced technical issues so we ...
ORA-01103: database name 'WWL' in controlfile is not 'DUMMY' SQL> alterdatabase mount; alter database mount ERROR at line 1: ORA-01103: database name 'WWL' in controlfile is not 'DUMMY' 注意:问题是我恢复的控制文件没有错呀,在本机器上也没有部署过DUMMY的数据库呀,只有一个实例是WWL...
ORA-01103错误解析1、环境介绍:这是一测试库,我将参数文件,控制文件,数据文件全部删除之后,做数据恢复,但是我把控制文件和参数文件都恢复回来了,可数据库却怎么也打不开,报ORA-01103:databasename'WWL'incontrolfileisnot'DUMMY'错误我的数据库名称是:WWL2、执行过程:恢复参数文件:RMAN>setDBID=5520179executingco...
Sign in to Cloud Error Messages Oracle Database Database Error Messages Release 23ai Updated Sep 9, 2024 control file database name 'database_name' does not match parameter file DB_NAME 'db_name' database_name: Name of the database in the control file. ...
ORA-01103: database name 'CMTCTEST' in control file is not 'CMTTEST' Error means database name is different in control file as mentioned in SPFILE with db name parameter. So, we need to modify the SPFILE or PFILE as we used to start the database as menti
SQL> alterdatabase mount; alter database mount ERROR at line 1: ORA-01103: database name 'WWL' in controlfile is not 'DUMMY' 注意:问题是我恢复的控制文件没有错呀,在本机器上也没有部署过DUMMY的数据库呀,只有一个实例是WWL。 查询实例信息,实例信息显示没有错呀是WWL。
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 ...