Connect to Target db [message #531842] |
Fri, 18 November 2011 00:31  |
chandu_imax
Messages: 46 Registered: May 2008 Location: Hyderabad
|
Member |
|
|
Hi Experts,
We have two databases dev and prod in one server. I would like to connect to target database prod without a recovery catalog.
Issued the below command and getting the following error message. Please suggest. Thank you in advance.
rman target sys/sys_password nocatalog.
Error we are getting is :
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Nov 18 11:31:59 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
I have also created the password files for both the databases and tried but facing the same issues.
|
|
|
|
|
|
|
|
|
|
Re: Connect to Target db [message #531887 is a reply to message #531881] |
Fri, 18 November 2011 04:57   |
chandu_imax
Messages: 46 Registered: May 2008 Location: Hyderabad
|
Member |
|
|
Yes. I have connected to the server.
Below is the result.
LD_LIBRARY_PATH=/usr/lib:/home/oracle/product/11.2.0/aix61/lib
LIBPATH=/home/oracle/product/11.2.0/aix61/lib:/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:
/home/oracle/product/11.2.0/aix61/lib:
/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:/home/oracle/product/11.2.0/aix61/lib:/home/oracle/product/11.2.0/aix61/lib32:
/usr/lib:/home/oracle/product/11.2.0/aix61/lib:/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:
/home/oracle/product/11.2.0/aix61/lib:/home /oracle/product/11.2.0/aix61/lib32:/usr/lib:/home/oracle/product/11.2.0/aix61/lib:
/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:/home/oracle/product/11.2.0/aix61/lib:/home/oracle/product/11.2.0/aix61/lib32:
/usr/lib:/home/oracle/product/11.2.0/aix61/lib:/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:
/home/oracle/product/11.2.0/aix61/lib:/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:/home/oracle/product/11.2.0/aix61/lib:
/home/oracle/product/11.2.0/aix61/lib32:/usr/lib:
LOCPATH=/usr/lib/nls/loc
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/11.2.0/aix61
ORACLE_INC=/home/oracle/product/11.2.0/aix61/precomp/public
ORACLE_LIB=/home/oracle/product/11.2.0/aix61/lib32
ORACLE_PROC=proc
ORACLE_PROC_VERSION=11.2.0
ORACLE_SID=amspqa80
ORACLE_TERM=hft
ORA_NLS33=/home/oracle/product/11.2.0/aix61/ocommon/nls/admin/data
ORA_NLS=/home/oracle/product/11.2.0/aix61/ocommon/nls/admin/data
PATH=/home/oracle:/home/ddpi/tool:/home/oracle/product/11.2.0/aix61/bin:/usr/bin:/etc:/usr/sbin:
/usr/ucb:/usr/bin/X11:/sbin:/usr/java 131/jre/bin:/usr/java131/bin:/home/ddpi/tool:/home/uscs:/usr/local/profiles:/usr/vac/bin:/usr/local/bin
TNS_ADMIN=/etc
[Updated on: Fri, 18 November 2011 07:00] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|