使用RMAN做duplicate遇到ORA-12514和ORA-01031 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor --这个很明显是监听文件配置的问题,首先查看口令文件,如果没有先建立 orapwd file='$ORACLE_HOME/dbs/orapw$ORACLE_SID' password=oracle entries=10 force=y 再查看 SQL>...
今天在练习书上一个示例时,出现"ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 错误",示例如下: C:\>rman target sys/orcl@demo 恢复管理器: Release 10.2.0.1.0 - Production on 星期三 10月 1 15:04:00 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到目标数据...
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of servic when run rman duplicate from active database, got error as below. Please advice. I followed all required steps such as 1. static Listener, 2. (UR = ...
NOFILENAMECHECK SPFILE PARAMETER_VALUE_CONVERT 'G:\oracle\oradata\provstdb\CONTROL01.CTL', 'E:\Oracle\oradata\ProvSTDB\CONTROL01.CTL' SET DB_CREATE_FILE_DEST 'E:\Oracle\oradata\ProvSTDB\'; Here also is the tnsnames.ora: GIHUB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HS...
使用RMAN做duplicate遇到ORA-12514和ORA-01031 2010-02-05 11:39 −ORA-12514: TNS:listener does not currently know of service requested in connect descriptor--这个很明显是监听文件配置的问题,首先查看口令文件,如果没有先建立orapwd file='$ORACLE_HOME/d... ...
1 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/system01.dbf2 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/sysaux01.dbf3 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/undotbs01.dbf4 Full 1635573 30-JAN-15 /oracle/data_ora/stuorcl/users01.dbf...
using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/DGWH/datafile/o1_mf_system_9361jnkf_.dbf ...
4. 修改listener.ora 和tnsnames.ora 文件 用图形做(减少故障率) 数据库服务orcl 静态注册 [oracle@jackdba u01]$ export DISPLAY=192.168.2.111:0.0 [oracle@jackdba u01]$ xhost + access control disabled, clients can connect from any host [oracle@yutianedu u01]$ netmgr ...
ORA-12514 ORA-12518 ORA-12899 ORA-15025 ORA-15032 ORA-15017 ORA-15040 ORA-15032 ORA-15017 ORA-15063 ORA-15038 ORA-15042 ORA-15038 ORA-15096 ORA-15131 ORA-16038 ORA-16038 ORA-00354 ORA-16188 ORA-16191 ORA-17070 ORA-19633 ORA-19921 ORA-21779 ORA-27047 ORA-...
ORA-12514 ORA-12518 ORA-12899 ORA-15025 ORA-15032 ORA-15017 ORA-15040 ORA-15032 ORA-15017 ORA-15063 ORA-15038 ORA-15042 ORA-15038 ORA-15096 ORA-15131 ORA-16038 ORA-16038 ORA-00354 ORA-16188 ORA-16191 ORA-17070 ORA-19633 ORA-19921 ORA-21779 ORA-27047 ORA-...