【ORA-02011】duplicate database link name
故障描述
刪除物化檢視資訊進行重建,在進行dblink的建立過程時,由於沒有刪除之前建立的dblink導致新的dblink無法使用之前使用過的名字。
SYS@EMREP> select db_link,owner from dba_db_links;
DB_LINK
--------------------------------------------------------------------------------
OWNER
------------------------------
PROD
PUBLIC
PROD
MVIEWADMIN
SYS@EMREP> create public database link prod
connect to hr identified by hr using 'PROD';
2 create public database link prod
*
ERROR at line 1:
ORA-02011: duplicate database link name
我們看到由於dblink已經存在,無法建立同名的dblink;
先欲將dblink drop掉報如下錯誤
刪除物化檢視資訊進行重建,在進行dblink的建立過程時,由於沒有刪除之前建立的dblink導致新的dblink無法使用之前使用過的名字。
SYS@EMREP> select db_link,owner from dba_db_links;
DB_LINK
--------------------------------------------------------------------------------
OWNER
------------------------------
PROD
PUBLIC
PROD
MVIEWADMIN
SYS@EMREP> create public database link prod
connect to hr identified by hr using 'PROD';
2 create public database link prod
*
ERROR at line 1:
ORA-02011: duplicate database link name
我們看到由於dblink已經存在,無法建立同名的dblink;
先欲將dblink drop掉報如下錯誤
SYS@EMREP> drop database link PROD;
drop database link PROD
*
ERROR at line 1:
ORA-02024: database link not found
SYS@EMREP> drop database link 'prod';
drop database link 'prod'
*
ERROR at line 1:
ORA-01729: database link name expected
連線到dblink的owner使用者下再次嘗試drop操作
SYS@EMREP> conn mviewadmin/mviewadmin
Connected.
MVIEWADMIN@EMREP> drop database link prod;
Database link dropped.
SYS@EMREP> drop public database link prod;
Database link dropped.
操作成功
drop database link PROD
*
ERROR at line 1:
ORA-02024: database link not found
SYS@EMREP> drop database link 'prod';
drop database link 'prod'
*
ERROR at line 1:
ORA-01729: database link name expected
連線到dblink的owner使用者下再次嘗試drop操作
SYS@EMREP> conn mviewadmin/mviewadmin
Connected.
MVIEWADMIN@EMREP> drop database link prod;
Database link dropped.
Database link dropped.
操作成功
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29319205/viewspace-1270810/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- To use Rman to duplicate database be careful of db_file_name_convertDatabase
- duplicate databaseDatabase
- RMAN duplicate databaseDatabase
- 錯誤:duplicate column name: picstitle
- database link概述Database
- CREATE DATABASE LINKDatabase
- Database Link使用Database
- 建立Database LinkDatabase
- oracle database linkOracleDatabase
- Management on database linkDatabase
- DUPLICATE DATABASE 注意事項Database
- 通過rman duplicate database!Database
- Database Link的建立Database
- Oracle Database Link ProblemsOracleDatabase
- Tensorboard: ValueError: Duplicate plugins for name projectorORBErrorPluginProject
- Oracle 11G Duplicate DatabaseOracleDatabase
- RMAN duplicate database到新主機Database
- Oracle identifiers :Database NameOracleIDEDatabase
- Oracle database link 詳解OracleDatabase
- oracle database link 應用OracleDatabase
- oracle database link 的使用OracleDatabase
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- Oracle identifiers :Global database nameOracleIDEDatabase
- Oracle 11g Rman Active database duplicateOracleDatabase
- Determining the Global Database Name (86)Database
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- oracle database link (dblink) 工作原理OracleDatabase
- Oracle Database Link Problems【Blog 搬家】OracleDatabase
- database link 關閉session問題DatabaseSession
- Database Link 建立注意的兩點Database
- [vue-router] Duplicate named routes definition: { name: "home", path: "/home" }Vue
- oracle中instance name 和database name的一點體會OracleDatabase
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- Oracle11g RMAN Duplicate from Active DatabaseOracleDatabase
- Duplicating Database using RMAN duplicate commandDatabase
- oracle實驗記錄 手工 duplicate database(1)OracleDatabase
- oracle實驗記錄Rman duplicate database(1)OracleDatabase