-
Issue in RMAn Duplicate
Hi ,
I have two database , find and fint.
Need to duplicate find to fint m using RMAN.
RMAN is configured for both find and fint in rmancatalog.
I edit tnsnames.ora and listener.ora of fint as below :
TNSNAMES.ora
----------------
OEMP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dclnderdb11.hertz.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oemp.hertz.com)
)
)
find=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=dclnderdb06.hertz.com)(PORT=1526))
(CONNECT_DATA=
(SERVICE_NAME=find)
(INSTANCE_NAME=find)
)
)
fint=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=dclnderdb06.hertz.com)(PORT=1523))
(CONNECT_DATA=
(SERVICE_NAME=fint)
(INSTANCE_NAME=fint)
)
)
Listner.ora
=============
fint =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dclnderdb06.hertz.com)(PORT = 1523))
)
)
SID_LIST_fint =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u15/oracle/fint/db/tech_st/11.1.0)
(SID_NAME = fint)
)
(SID_DESC =
(ORACLE_HOME=/u01/oracle/find/db/tech_st/11.1.0)
(SID_NAME = find)
)
)
--------------------------------------------------
ISSUE:
I am getting the below mentioned error while invokin RMAN
can any body help me
RMAN> connect target sys/diagon03@find;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
RMAN> connect catalog rman_user/rman1234@oemp;
connected to recovery catalog database
RMAN> connect AUXILIARY sys/stream12@fint;
connected to auxiliary database: FINT (not mounted)
RMAN>
-
ISSUE:
I am getting the below mentioned error while invokin RMAN
can any body help me
RMAN> connect target sys/diagon03@find;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
Perhaps you need to configure your "find" database correctly, check out the fine Oracle® Database Administrator's Guide on this issue.
Or...because you are on the same host, setup the environment for 'find' database and try this (see if it works):
Code:
RMAN> connect target sys/diagon03
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
do you have the password file created
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|