Home » RDBMS Server » Enterprise Manager » backup/recovery plan for remote database
backup/recovery plan for remote database [message #68274] Sat, 01 March 2003 01:24 Go to next message
azad
Messages: 18
Registered: May 2002
Junior Member
hello,
In my test environment, I am running two database in two seperate machine. One is local database and another remote database.
UNDER OEM I discoverd node so my remote database(test8i) has been added to the navigator pan( under node). I setup my preferred credentials is
target name: test
type : database
username: sys
pasword : change_on_install
role: sysdba
My node setup as : sysman

I can connect this remote database as a user like sys/change_on_install....Normal. BUT I am not be able to connect as a sysdba therefore, when I could'nt setup backup/recovery option... it gives me error said 'ora-01031:insuffcient privileges' some times I got 'ora-01017: invalid username/password: logon denied'
Questions:
To manage and backup a remote database on my local OEM what are the setup steps I should take? or how do I setup sysdba privileges for remote database into my local machine? Please give me some advice.
Thank you
Re: backup/recovery plan for remote database [message #68278 is a reply to message #68274] Mon, 03 March 2003 05:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did u grant sysdba privs to the SYS in remote mode?
Re: backup/recovery plan for remote database [message #68281 is a reply to message #68278] Mon, 03 March 2003 19:56 Go to previous message
azad
Messages: 18
Registered: May 2002
Junior Member
yes I did. I also create a password file for sysdba orapwd utl. I changed the remote_login_password=exclusive. It is working fine
Thank you for your help
Previous Topic: Local Net Service Name Configuration
Next Topic: help to me
Goto Forum:
  


Current Time: Sat May 21 12:52:46 CDT 2022