AI 助理
备案控制台
开发者社区 数据库 文章 正文

duplicate报ORA-01017权限问题

2014-05-26 1182
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： duplicate报ORA-01017权限问题   环境: OS:RedHat EnterPrise Linux 5.8 x64 Cluster:Oracle Grid 11.

duplicate报ORA-01017权限问题

 

环境:

OS:RedHat EnterPrise Linux 5.8 x64

Cluster:Oracle Grid 11.2.0.4

Database:Oracle Database EnterPrise 11.2.0.4

Archive:RAC+DG

         今天在配置DG的过程中，前期环境都已经准备好了，就差最后一步将RAC数据duplicate到standby端，但是蹊跷的事情就在这一步发生了，尝试几次都无法将数据duplicate过去，当然我尝试通过拷贝rman备份到对端也无法完成恢复，死活就报ORA-01017错误，经过几个小时的努力，问题最终也算是得到了比较好的解决。如下:

 

故障现象

rmantarget sys/oracle@jetdb auxiliary sys/oracle@standby
 
RecoveryManager: Release 11.2.0.4.0 - Production on Mon May 26 16:14:36 2014
 
Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connectedto target database: JETDB (DBID=2170518470)
connectedto auxiliary database: JETDB (not mounted)
 
RMAN>duplicate target database for standby from active database nofilenamecheck ;
 
Startingrestore at 26-MAY-14
usingtarget database control file instead of recovery catalog
allocatedchannel: ORA_DISK_1
channelORA_DISK_1: SID=416 device type=DISK
 
channelORA_DISK_1: restoring control file
RMAN-00571:===========================================================
RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002:failure of restore command at 05/26/2014 16:14:54
ORA-19870:error while restoring backup piece /DBBackup/Phycal/stdb_cntl_0fp98vq2_1_1.bkp
ORA-19504:failed to create file "+DATA001/jetdb/controlfile/control01.ctl"
ORA-17502:ksfdcre:3 Failed to create file +DATA001/jetdb/controlfile/control01.ctl
ORA-15001:diskgroup "DATA001" does not exist or is not mounted
ORA-15055:unable to connect to ASM instance
ORA-01017:invalid username/password; logon denied

 

问题分析：

1、  从上面告警日志来看，ORA-01017可以很明显看出是由于权限问题导致。

随即，我们开始检查备库的密码文件，$ORACLE_HOME/dbs/orapw{SID}是存在的。

[oracle@standby dbs]$ ll$ORACLE_HOME/dbs/orapw*
-rw-r----- 1 oracle oinstall 1536 May 2617:49 /DBSoft/oracle/product/11.2.4/dbhome_1/dbs/orapwstandby

 2、  这个时候我们应该查看的是数据库的alter告警文件: 

Errorsin file/DBSoft/oracle/diag/rdbms/standby/standby/trace/standby_asmb_11087.trc  (incident=24130):
ORA-00600:internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [],[], [], [], []
ORA-27302:failure occurred at: skfnbeqOpenI
Incidentdetails in:/DBSoft/oracle/diag/rdbms/standby/standby/incident/incdir_24130/standby_asmb_11087_i24130.trc
UseADRCI or Support Workbench to package the incident.
See Note411.1 at My Oracle Support for error and packaging details.
ORA-00210:cannot open the specified control file
ORA-00202:control file: '+DATA001/jetdb/controlfile/control01.ctl'
ORA-17503:ksfdopn:2 Failed to open file +DATA001/jetdb/controlfile/control01.ctl
ORA-15001:diskgroup "DATA001" does not exist or is not mounted
ORA-15055:unable to connect to ASM instance
ORA-15055:unable to connect to ASM instance
ORA-00600:internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [],[], [], [], []
ORA-27302:failure occurred at: skfnbeqOpenI
ORA-1013signalled during: ALTER DATABASE  MOUNT...
Mon May26 16:31:34 2014

从告警文件中我们可以很明显的看出是 ASM 磁盘有问题，进入进入 grid 用户下 用 srvctl 命令检查 asm 状态： 

[grid@standby~]$ srvctl status asm
ASM isrunning on standby
 
SQL>select name,state,free_mb from v$asm_diskgroup;
 
NAME       STATE          FREE_MB
--------------------- ----------
DATA001    MOUNTED         121112
ARC001     MOUNTED         122483
BAK001     MOUNTED         122826

结果看来 ASM 也是没有问题的，那么唯一的出问题的地方可能就是 Oracle 哪里配置的问题。

3、这个时候我们应该先看看会不会是权限的问题：

[root@standby ~]# id oracle
uid=501(oracle) gid=504(oinstall)groups=504(oinstall) ,505(dba)
[root@standby ~]# id grid
uid=500(grid) gid=504(oinstall) groups=504(oinstall),503(asmadmin),506(asmdba),507(asmoper)

到这里，我们发现问题可能出现在权限上。

oracle没有asmdba权限，随即添加上即可。

[root@standby~]# usermod -G 503,506 oracle
[root@standby~]# id oracle
uid=501(oracle)gid=504(oinstall) groups=504(oinstall),503(asmadmin),505(dba),506(asmdba)
我们可以看到如下，再次执行 duplicate ，成功： 

[oracle@standby~]$ rman target sys/oracle@jetdb auxiliary sys/oracle@standby
 
RecoveryManager: Release 11.2.0.4.0 - Production on Mon May 26 17:48:39 2014
 
Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
 
connectedto target database: JETDB (DBID=2170518470)
connectedto auxiliary database: JETDB (not mounted)
 
RMAN>duplicate target database for standby from active database nofilenamecheck;
 
StartingDuplicate Db at 26-MAY-14
usingtarget database control file instead of recovery catalog
allocatedchannel: ORA_AUX_DISK_1
channelORA_AUX_DISK_1: SID=122 device type=DISK
 
contentsof Memory Script:
{
   backup as copy reuse
   targetfile '/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/orapwjetdb1' auxiliaryformat
 '/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/orapwstandby'   ;
}
executingMemory Script
 
Startingbackup at 26-MAY-14
allocatedchannel: ORA_DISK_1
channelORA_DISK_1: SID=14 instance=jetdb1 device type=DISK
Finishedbackup at 26-MAY-14
 
contentsof Memory Script:
{
   backup as copy current controlfile forstandby auxiliary format '+DATA001/jetdb/controlfile/control01.ctl';
}
executingMemory Script
 
Startingbackup at 26-MAY-14
usingchannel ORA_DISK_1
channelORA_DISK_1: starting datafile copy
copyingstandby control file
outputfile name=+BAK001/rman/snapcf_jetdb1.f tag=TAG20140526T174956 RECID=11STAMP=848598598
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finishedbackup at 26-MAY-14
 
contentsof Memory Script:
{
   sql clone 'alter database mount standbydatabase';
}
executingMemory Script
 
sqlstatement: alter database mount standby database
RMAN-05529:WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed todisk group only.
 
contentsof Memory Script:
{
   set newname for tempfile  1 to
 "+data001";
   switch clone tempfile all;
   set newname for datafile  1 to
 "+data001";
   set newname for datafile  2 to
 "+data001";
   set newname for datafile  3 to
 "+data001";
   set newname for datafile  4 to
 "+data001";
   set newname for datafile  5 to
 "+data001";
   backup as copy reuse
   datafile 1 auxiliary format
 "+data001"   datafile
 2 auxiliary format
 "+data001"   datafile
 3 auxiliary format
 "+data001"   datafile
 4 auxiliary format
 "+data001"   datafile
 5 auxiliary format
 "+data001"   ;
   sql 'alter system archive log current';
}
executingMemory Script
 
executingcommand: SET NEWNAME
 
renamedtempfile 1 to +data001 in control file
 
executingcommand: SET NEWNAME
 
executingcommand: SET NEWNAME
 
executingcommand: SET NEWNAME
 
executingcommand: SET NEWNAME
 
executingcommand: SET NEWNAME
 
Startingbackup at 26-MAY-14
usingchannel ORA_DISK_1
channelORA_DISK_1: starting datafile copy
inputdatafile file number=00001 name=+DATA001/jetdb/datafile/system.268.848240089
outputfile name=+DATA001/standby/datafile/system.257.848598605 tag=TAG20140526T175005
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channelORA_DISK_1: starting datafile copy
inputdatafile file number=00002 name=+DATA001/jetdb/datafile/sysaux.260.848240091
outputfile name=+DATA001/standby/datafile/sysaux.258.848598619 tag=TAG20140526T175005
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channelORA_DISK_1: starting datafile copy
inputdatafile file number=00003 name=+DATA001/jetdb/datafile/undotbs1.263.848240091
outputfile name=+DATA001/standby/datafile/undotbs1.259.848598627tag=TAG20140526T175005
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channelORA_DISK_1: starting datafile copy
inputdatafile file number=00005 name=+DATA001/jetdb/datafile/undotbs2.264.848240331
outputfile name=+DATA001/standby/datafile/undotbs2.260.848598627tag=TAG20140526T175005
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channelORA_DISK_1: starting datafile copy
inputdatafile file number=00004 name=+DATA001/jetdb/datafile/users.267.848240091
outputfile name=+DATA001/standby/datafile/users.261.848598629 tag=TAG20140526T175005
channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:02
Finishedbackup at 26-MAY-14
 
sqlstatement: alter system archive log current
 
contentsof Memory Script:
{
   switch clone datafile all;
}
executingMemory Script
 
datafile1 switched to datafile copy
inputdatafile copy RECID=11 STAMP=848598635 filename=+DATA001/standby/datafile/system.257.848598605
datafile2 switched to datafile copy
inputdatafile copy RECID=12 STAMP=848598635 file name=+DATA001/standby/datafile/sysaux.258.848598619
datafile3 switched to datafile copy
inputdatafile copy RECID=13 STAMP=848598635 filename=+DATA001/standby/datafile/undotbs1.259.848598627
datafile4 switched to datafile copy
inputdatafile copy RECID=14 STAMP=848598635 file name=+DATA001/standby/datafile/users.261.848598629
datafile5 switched to datafile copy
inputdatafile copy RECID=15 STAMP=848598635 filename=+DATA001/standby/datafile/undotbs2.260.848598627
FinishedDuplicate Db at 26-MAY-14

 
文章标签：
数据库备份
服务网格
关系型数据库
Oracle
数据库
SQL
数据库管理
Linux
prudentwoo
目录
相关文章
科技小能手
|
Oracle 关系型数据库 数据库
ORA-16018解决办法
科技小能手
957 0
白及88
|
SQL Oracle 关系型数据库
ORA-01012: not logged on 解决办法
<br><br><p style="line-height:23px; padding-top:0px; padding-bottom:0px; margin-top:8px; margin-bottom:8px; letter-spacing:0.5px; font-size:13px; color:rgb(51,51,51); font-family:微软雅黑,Verdana,sans
白及88
5020 0
猎人笔记
|
SQL 关系型数据库 MySQL
ORA-01948和ORA-04052错误的解决方法
一、事件背景： 业务人员在创建一个物化视图的时候，报了以下错误： SQL> CREATE MATERIALIZED VIEW MV_RETAIL_wbmout_R 2 TABLESPACE SAPDATA 3 PCTUSED 0 ...
猎人笔记
1847 0
yangyi_dba
|
SQL Oracle 关系型数据库
【ora 错误及解决方法】ORA-01652
ORA-01652:unable to extend temp segment by num in tablespace name 产生原因：ORACLE临时段表空间不足，因为ORACLE总是尽量分配连续空间，一旦没有足够的可分配空间或者分配不连续就会出现上述的现象。
yangyi_dba
1215 0
嗯哼9925
|
关系型数据库 数据库 Windows
ORA-03113解决方法
嗯哼9925
1206 0
嗯哼9925
|
Oracle 关系型数据库 数据库
oracle登录错误：ORA-28000: the account is locked 解决方法
嗯哼9925
1360 0
技术小甜
|
监控 数据库
ORA-00257 解决办法
技术小甜
1354 0
技术小甜
|
Oracle 关系型数据库 数据库
ORA-16014 解决办法
技术小甜
982 0
科技小能手
|
SQL 数据库
RMAN duplicate database到新主机
科技小能手
1094 0
科技小能手
|
Oracle 关系型数据库
ORA-12162错误解决
科技小能手
1128 0

热门文章

最新文章

  • 1
    Java 生成 UUID
  • 2
    一文读懂 Serverless 的起源、发展和落地实践
  • 3
    Fiddler抓包：下载、安装及使用
  • 4
    用CodeViz绘制函数调用关系图(call graph)
  • 5
    阿里AI上岗双11服装车间，能识别头发丝直径十分之一的瑕疵
  • 6
    SpringBoot开发案例之整合Dubbo提供者(一)
  • 7
    Dubbo架构介绍
  • 8
    警惕垃圾邮件借加沙新闻进行钓鱼攻击
  • 9
    美国博客刊文发布NetApp StoreVault停产通知
  • 10
    IntelliJ IDEA 12 创建Web项目 教程 超详细版
  • 1
    通义灵码与云计算平台的融合：基础与概述
    36
  • 2
    《深度解析：死锁的“前世今生”与防范之道》
    29
  • 3
    《探秘程序崩溃：核心转储（Core Dump）分析全攻略》
    34
  • 4
    今日 AI 开源｜共 12 项｜开源的DIY健康追踪项目，基于低成本的智能戒指构建私人的健康监测应用
    37
  • 5
    Open Interpreter：AI 赋能终端！在终端中对话AI模型进行编程，通过运行代码来完成各种计算机操作任务
    29
  • 6
    「Mac畅玩鸿蒙与硬件15」鸿蒙UI组件篇5 - Slider 和 Progress 组件
    39
  • 7
    ai断点怎么做?
    15
  • 8
    AI Shell：在命令行里“对话” AI ，微软推出将 AI 助手引入命令行的 CLI 工具，打造对话式交互命令行
    19
  • 9
    ai怎么设计迷宫字体效果?
    15
  • 10
    「Mac畅玩鸿蒙与硬件14」鸿蒙UI组件篇4 - Toggle 和 Checkbox 组件
    29

    • 相关电子书

    更多
  • 低代码开发师（初级）实战教程
  • 冬季实战营第三期：MySQL数据库进阶实战
  • 阿里巴巴DevOps 最佳实践手册
    • 下一篇
    阿里云OSS设置跨域访问