Home » RDBMS Server » Backup & Recovery » Changing passwd for sys user
Changing passwd for sys user [message #214252] Mon, 15 January 2007 09:46 Go to next message
dzeljko
Messages: 19
Registered: April 2005
Junior Member
Hi Gurus,

I am trying to duplicate database from rman backup to remote host. I don't have passwd for sys user on auxiliary instance (only for system user). According to defined steps for duplicate database, database on auxiliary host has to be in nomount mode. Besides, the last step in duplication process is connect to auxiliary using the following command

RMAN>connect auxiliary sys/passwd@connect_string


Is it possible to change password for sys user if the database is in nomount mode or has anybody idea how to solve this problem. I have to mention that on auxiliary host exists the second instance but it doesn't work because bad backup.

Best regards and please help me..

Zeki
Re: Changing passwd for sys user [message #214256 is a reply to message #214252] Mon, 15 January 2007 09:55 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Try
1.connect without password.
like
"/@tns_entry as sysdba"

or
create new password file through orapwd utility.

regards
Taj

[Updated on: Mon, 15 January 2007 09:55]

Report message to a moderator

Previous Topic: Name column in v$archived_log is null
Next Topic: Error creating a standby database using RMAN
Goto Forum:
  


Current Time: Tue Nov 26 20:49:05 CST 2024