OraFAQ Forum: Backup & Recovery » Connect to Target db

Home » RDBMS Server » Backup & Recovery » Connect to Target db (oracle, 11g, aix61)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Connect to Target db [message #531857 is a reply to message #531842]

Fri, 18 November 2011 01:49

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Connect to Target db [message #531875 is a reply to message #531857]

Fri, 18 November 2011 04:05

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?

Report message to a moderator

Re: Connect to Target db [message #531876 is a reply to message #531875]

Fri, 18 November 2011 04:09

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

Report message to a moderator

Re: Connect to Target db [message #531877 is a reply to message #531875]

Fri, 18 November 2011 04:13

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Connect to Target db [message #531878 is a reply to message #531876]

Fri, 18 November 2011 04:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Connect to Target db [message #531879 is a reply to message #531877]

Fri, 18 November 2011 04:16

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)

Report message to a moderator

Re: Connect to Target db [message #531881 is a reply to message #531879]

Fri, 18 November 2011 04:27

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post result "env | sort | egrep '(ORA|NLS|TNS|PATH)'"
Are you on the database server?

Regards
Michel

Report message to a moderator

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

Re: Connect to Target db [message #531898 is a reply to message #531887]

Fri, 18 November 2011 06:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Forgot to ask, is LOCAL variable set?
What do you get with sqlplus with same connect string?

Regards
Michel

Report message to a moderator

Re: Connect to Target db [message #531906 is a reply to message #531898]

Fri, 18 November 2011 06:42

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

Report message to a moderator

Re: Connect to Target db [message #531909 is a reply to message #531906]

Fri, 18 November 2011 06:58

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

scott/tiger@amspqa80

This is not
Quote:

sys/sys_password

Post "env | grep LOCAL"

Regards
Michel

Report message to a moderator

Re: Connect to Target db [message #531953 is a reply to message #531842]

Fri, 18 November 2011 14:34

BeefStu
Messages: 208
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

Report message to a moderator

Re: Connect to Target db [message #531955 is a reply to message #531953]

Fri, 18 November 2011 14:43

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Connect to Target db [message #532584 is a reply to message #531955]

Wed, 23 November 2011 09:33

Michael90
Messages: 2
Registered: November 2011

Junior Member

Also had the same problem. Still waiting for solutions here.

Report message to a moderator

Re: Connect to Target db [message #532612 is a reply to message #532584]

Wed, 23 November 2011 10:51

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"Same" may not be same.
Copy and paste what you have and all what we asked to OP.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 08:37:07 CST 2025