Home » RDBMS Server » Backup & Recovery » Connect to Target db (oracle, 11g, aix61)
Connect to Target db [message #531842] Fri, 18 November 2011 00:31 Go to next message
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 #531857 is a reply to message #531842] Fri, 18 November 2011 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You are not in the dba group
2/ Password file is only use on a network connection (that is using @...)

Also you read among:
http://www.orafaq.com/forum/?SQ=bf8fdd285c976b46e98c5b121d49da4b&t=search&srch=insufficient+privileges&btn_submit=Search& amp;field=all&forum_limiter=5&search_logic=AND&sort_order=DESC&author=
http://www.google.com/search?hl=en&source=hp&q=rman+ora-01031+insufficient+privileges

Regards
Michel
Re: Connect to Target db [message #531875 is a reply to message #531857] Fri, 18 November 2011 04:05 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
1/ You are not in the dba group

What need to do for the above?
Re: Connect to Target db [message #531876 is a reply to message #531875] Fri, 18 November 2011 04:09 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Tried to grant the SYSDBA privilege to rman and Got the below issue.
SQL> grant sysdba to rman;
grant sysdba to rman
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled


SQL> sho parameter remote_login

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

Re: Connect to Target db [message #531877 is a reply to message #531875] Fri, 18 November 2011 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
chandu_imax wrote on Fri, 18 November 2011 11:05
1/ You are not in the dba group

What need to do for the above?


I mean in the OS DBA group.
Post result of "id" at OS prompt.

Regards
Michel

Re: Connect to Target db [message #531878 is a reply to message #531876] Fri, 18 November 2011 04:14 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
chandu_imax wrote on Fri, 18 November 2011 11:09
Tried to grant the SYSDBA privilege to rman and Got the below issue.
SQL> grant sysdba to rman;
grant sysdba to rman
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled


SQL> sho parameter remote_login

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE



1/ This is useless. Normally there is no "rman" account in the database
2/
ORA-01994: GRANT failed: password file missing or disabled
 *Cause:  The operation failed either because the INIT.ORA parameter
          REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the
          password file was missing.
 *Action: Create the password file using the orapwd tool and set the
          INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.

Regards
Michel
Re: Connect to Target db [message #531879 is a reply to message #531877] Fri, 18 November 2011 04:16 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Below is the result. In DBA group only.

$ id
uid=1001(oracle) gid=1001(dba) groups=1(staff)
Re: Connect to Target db [message #531881 is a reply to message #531879] Fri, 18 November 2011 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post result "env | sort | egrep '(ORA|NLS|TNS|PATH)'"
Are you on the database server?

Regards
Michel
Re: Connect to Target db [message #531887 is a reply to message #531881] Fri, 18 November 2011 04:57 Go to previous messageGo to next message
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

Re: Connect to Target db [message #531898 is a reply to message #531887] Fri, 18 November 2011 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forgot to ask, is LOCAL variable set?
What do you get with sqlplus with same connect string?

Regards
Michel
Re: Connect to Target db [message #531906 is a reply to message #531898] Fri, 18 November 2011 06:42 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
 Forgot to ask, is LOCAL variable set? 


I didn't get you.


Able to connect to sqlplus with the connecting string.

$ sqlplus scott/tiger@amspqa80

SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 18 18:10:07 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


Regards,
Chandu
Re: Connect to Target db [message #531909 is a reply to message #531906] Fri, 18 November 2011 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
scott/tiger@amspqa80

This is not
Quote:
sys/sys_password


Post "env | grep LOCAL"

Regards
Michel
Re: Connect to Target db [message #531953 is a reply to message #531842] Fri, 18 November 2011 14:34 Go to previous messageGo to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
[code]

The target will be what ever your ORACLE_SID is pointing too:

No catalog
===========
rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Fri Nov 18 15:27:45 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: OTAPDEV (DBID=2571197296)

With Catalog
============
rman catalog rman/rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Fri Nov 18 15:29:08 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: OTAPDEV (DBID=2571197296)
connected to recovery catalog database


No catalog using service name
=============================

rman target=sys/sys@otadev


Re: Connect to Target db [message #531955 is a reply to message #531953] Fri, 18 November 2011 14:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And???
Can you explain your post and in what it is related to your previous posts.
Is this a question or a solution?

Regards
Michel
Re: Connect to Target db [message #532584 is a reply to message #531955] Wed, 23 November 2011 09:33 Go to previous messageGo to next message
Michael90
Messages: 2
Registered: November 2011
Junior Member
Also had the same problem. Still waiting for solutions here.
Re: Connect to Target db [message #532612 is a reply to message #532584] Wed, 23 November 2011 10:51 Go to previous message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Same" may not be same.
Copy and paste what you have and all what we asked to OP.

Regards
Michel
Previous Topic: duplicate database error : ORA-01405: fetched column value is NULL
Next Topic: ORA-01161: database name CCSPS in file header does not match given name of CCSP
Goto Forum:
  


Current Time: Tue Feb 20 02:26:02 CST 2018

Total time taken to generate the page: 0.01437 seconds