Home » RDBMS Server » Backup & Recovery » Problem connecting to the target using RMAN (Linux 2.4.24)
Problem connecting to the target using RMAN [message #310203] Mon, 31 March 2008 09:58 Go to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Hello,

I have a problem in connecting to the target database from the auxiliary... say from the (auxiliary) standby database server i issue the following commands..the previous DBA has quit his job before a month i joined...Now I need to perform a RMAN backup of the prod and then duplicate the database on the standby...

/opt/oracle>rman catalog rman/rcvy10g@rman target sys/oracle@prod.oracle.com auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Mar 31 06:48:54 2008
Copyright (c) 1982, 2005, Oracle. 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-01017: invalid username/password; logon denied

Is there a problem with SYS password..Does the host connects to the target via pwd file..I am not sure about the SYS password too as there is no password maintained by the previous DBA at job.

In the listener file there is a password set with logging on.. Does it stop me connecting to the target(prod) database from the standby(auxiliary)...

Please share your knowledge...
Re: Problem connecting to the target using RMAN [message #310206 is a reply to message #310203] Mon, 31 March 2008 10:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Can you connect via SQL*Plus as user SYS to the target?

Edited to reflect correct username.

[Updated on: Mon, 31 March 2008 10:25]

Report message to a moderator

Re: Problem connecting to the target using RMAN [message #310209 is a reply to message #310203] Mon, 31 March 2008 10:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there a problem with SYS password..Does the host connects to the target via pwd file

Yes. Yes.

Regards
Michel
Re: Problem connecting to the target using RMAN [message #310233 is a reply to message #310209] Mon, 31 March 2008 11:37 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Brian,

Either I couldnot connect with sqlplus.

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 31 09:21:48 2008

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

Enter user-name: sys@prod.oracle.com
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

In this case should I change the sys password and recreate the pwd file with the sys pwd in primary as well as the standby databases.. We have 3 standby databases. and also should I need to change anything in the RMAN catalog database..

I am here with attaching the tnsnames entries also for your reference..

prod.oracle.com=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prod.alprod-priv.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = edc.oracle.com)
(SID=edc)
)
)

Please let me know whether changing the SYS password and recreating the passwd file in all instances (primary & standby) will solve the issue..whether there will be any business impact in changing the SYS password..

Thank You...


Re: Problem connecting to the target using RMAN [message #310235 is a reply to message #310233] Mon, 31 March 2008 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
recreating the passwd file in all instances (primary & standby) will solve the issue

As I already said.

Quote:
whether there will be any business impact in changing the SYS password..

It depends on what you do with this password.

Regards
Michel
Re: Problem connecting to the target using RMAN [message #310236 is a reply to message #310209] Mon, 31 March 2008 12:05 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Hi,

Shall I remove the password and other parameter in listener file.

Does the removing of parameters affect the data security..I am attching the listener values.

PASSWORDS_LISTENER = 5311960CE6874588D
LOGGING_LISTENER = ON

Thank You
Re: Problem connecting to the target using RMAN [message #310237 is a reply to message #310235] Mon, 31 March 2008 12:13 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
This is to duplicate the prod database for physical standby database.Nothing more we are going to do.. I wanted to know whether recreating the pwd file will impact the application servers connection to the database..

Re: Problem connecting to the target using RMAN [message #310239 is a reply to message #310237] Mon, 31 March 2008 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Password file is only useful for SYSDBA and SYSOPER connections.

Regards
Michel
Re: Problem connecting to the target using RMAN [message #310247 is a reply to message #310239] Mon, 31 March 2008 13:00 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Thanks a lot Brian/Michel..Its working fine. You are doing a wonderful job..

Re: Problem connecting to the target using RMAN [message #311204 is a reply to message #310247] Thu, 03 April 2008 12:51 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Brian/Michel,

Does recreating the pwd file on standby's affect the standby databases during switch over..How does the pwd file work..

Does it not directly dependent on the SYS password.. since I could not change the SYS password in standby..

how do I change it.Should I stop the log shipping to standby using defer, then bring then recover the standby db's and shutdown.. then change SYS password same as primary and bring back standby..

Re: Problem connecting to the target using RMAN [message #311210 is a reply to message #311204] Thu, 03 April 2008 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 31 March 2008 19:21
Password file is only useful for SYSDBA and SYSOPER connections.

Regards
Michel

Database SYS password is useless when you use a password file.

Regards
Michel

Re: Problem connecting to the target using RMAN [message #311213 is a reply to message #311210] Thu, 03 April 2008 13:15 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Thank You.
Re: Problem connecting to the target using RMAN [message #311240 is a reply to message #311204] Thu, 03 April 2008 16:58 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Dataguard is dependent on the password file and as you know the SYS password must be the same on both systems. You can change the password on each system without having to stop recovery or defer log transport. DataGuard is resilient enough to catch up, it may just take a couple minutes.

However, to avoid the delay for DataGuard to catch up, I would recommend to DEFER log transport and change the password on each system, then ENABLE log transport. Stopping recovery on the standby isn't necessary.
Re: Problem connecting to the target using RMAN [message #311260 is a reply to message #311240] Thu, 03 April 2008 19:06 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
When I tried to change the password in standby i got an error database not open..

Does the standby recognizes the SYS password from the primary..
Re: Problem connecting to the target using RMAN [message #311261 is a reply to message #311260] Thu, 03 April 2008 19:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How are you trying to change the password?
Re: Problem connecting to the target using RMAN [message #311263 is a reply to message #311261] Thu, 03 April 2008 19:37 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
I was unable to connect to the primary thru RMAN and so I have changed the SYS passwd.. and recreated the passwd file with same SYS password on all databases(primary & standby).. Now I need to keep the same SYS passwd for the standby also right..

Here is where I am struck with...If the pwd file takes care of log shipping then if want to switchover to the primary how will the database react...
Re: Problem connecting to the target using RMAN [message #311265 is a reply to message #311263] Thu, 03 April 2008 19:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, the SYS password needs to be the same.

Not sure I know what you mean when you say "switchover to primary". You typically switchover to standby. Switching over has nothing to do with the password changing as long at the passwords are the same.
Re: Problem connecting to the target using RMAN [message #311266 is a reply to message #311265] Thu, 03 April 2008 19:46 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
yep I meant the during switchover to standby or failover to standby...

How do I change the SYS passwd in standby in this case..Is there anyways do it ..
Re: Problem connecting to the target using RMAN [message #311267 is a reply to message #311266] Thu, 03 April 2008 19:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Why do you want to change the password "during" the switchover. There is no need to change the password.

Maybe I'm missing your purpose of changing the password?
Re: Problem connecting to the target using RMAN [message #311268 is a reply to message #311267] Thu, 03 April 2008 20:00 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Yeah you missed my query. To summarize the problem..

1.I had problems in connecting to primary database through RMAN to create a duplicate database.
2.I have reset the SYS password in the primary DB and also recreated the password file..after which I can able to connect to target from the auxiliary
3.then I recreated the pwd file in standby as well and the log shipping was happening ...
4.At this point since I must have the same SYS password in standby databases i tried to reset them..

Let me know if you have any queries...

Re: Problem connecting to the target using RMAN [message #311269 is a reply to message #311268] Thu, 03 April 2008 20:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Well you are done then.

If you reset the password on the standby(s) to what it is on the primary and have verified that log shipment is occurring, there is nothing else to do.
Re: Problem connecting to the target using RMAN [message #311270 is a reply to message #311269] Thu, 03 April 2008 20:14 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Thank you.. Since I have reset the password to the older one I was able to do all stuffs .. If I have changed to a new password then how to go about in changing the same in standby...

Should I stop the log shipping , open the standby and change the SYS pwd to match the primary and then put back in standby..

Michel, You said that pwd file over takes the database SYS pwd.. Do you have any suggestions..
Re: Problem connecting to the target using RMAN [message #311275 is a reply to message #311270] Thu, 03 April 2008 21:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Simply use orapwd on ALL systems and your done !

As I mentioned in one of my previous post, simply set the primary to DEFER change passwords all around then set back to ENABLE.
Re: Problem connecting to the target using RMAN [message #311291 is a reply to message #311270] Thu, 03 April 2008 23:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Michel, You said that pwd file over takes the database SYS pwd.. Do you have any suggestions..

As Brian said, just use orapwd, do not try to use alter user on standby.

Regards
Michel
Re: Problem connecting to the target using RMAN [message #313140 is a reply to message #311291] Thu, 10 April 2008 17:50 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Thanks Brian/Michele,

I would like to change the listener password in the current env, Does it have any impact on the OEM agent or the application connectivity to the database.. Or it is simply used to prevent database from the hackers..What will happen setting the ADMIN_RESTRICTIONS_LISTENER = ON in the listener..Please let me know your views..
Re: Problem connecting to the target using RMAN [message #313141 is a reply to message #313140] Thu, 10 April 2008 17:55 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Should I reload listener after changing the password or should be used only when setting the ADMIN_RESTRICTIONS_LISTENER = ON ..

Re: Problem connecting to the target using RMAN [message #313189 is a reply to message #313140] Fri, 11 April 2008 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this related to "Problem connecting to the target using RMAN"?

Regards
Michel
Re: Problem connecting to the target using RMAN [message #313394 is a reply to message #313189] Fri, 11 April 2008 11:37 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
The RMAN issues no more exists..I just wanted to know whether I need to reload the listener after changing the listener password ..
And to make sure that listener password is only to prevent hackers and it doesnot affect the application access to the database..
Re: Problem connecting to the target using RMAN [message #313403 is a reply to message #313394] Fri, 11 April 2008 13:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Thanks for posting back your results.

Just an FYI, for 10g a listener password is really no longer needed unless you are going to have multiple O/S accounts that need to administer the listener.
Re: Problem connecting to the target using RMAN [message #313404 is a reply to message #313403] Fri, 11 April 2008 13:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... or you want to remotely administer it.

Regards
Michel
Re: Problem connecting to the target using RMAN [message #313418 is a reply to message #313404] Fri, 11 April 2008 18:56 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Correct...good point Michel.
Previous Topic: RMAN backup cant start
Next Topic: RMAN variables
Goto Forum:
  


Current Time: Sun Dec 04 14:37:27 CST 2016

Total time taken to generate the page: 0.14710 seconds