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
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..

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


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

create new password file through orapwd utility.


[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: Sat Jul 22 12:20:09 CDT 2017

Total time taken to generate the page: 0.08301 seconds