• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • Last Modified:

want to cahnge sys and system password on 11g .

Hi Guys,
I need to change sys and system password on 11g. Whats the right method. Please help.
0
nirvairghuman
Asked:
nirvairghuman
  • 2
  • 2
5 Solutions
 
sdstuberCommented:
alter user sys identified by new_password;


alter user system identified by new_password;
0
 
slightwv (䄆 Netminder) Commented:
alter user sys identified by new_password;
alter user system identified by new_password;

You just need to be aware of any applications that might have this information stored like OEM Grid Control and some backup products agents.
0
 
sdstuberCommented:
if you don't have the alter user system privilege you won't be able to execute those commands though
0
 
Mark GeerlingsDatabase AdministratorCommented:
If you don't know what those passwords are now, you can use this syntax to start SQL*Plus and log in as sys without providing a password:

sqlplus / as sysdba

Then you should be able to run both:

alter user sys identified by [new_password];
and:
alter user system identified by [new_password];
0
 
slightwv (䄆 Netminder) Commented:
to add:
you need to be logged in as a member of the OS DBA group to log in as sysdba.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now