password change

Posted on 2011-04-20
Medium Priority
Last Modified: 2012-05-11

Can i change the passwords of sys and system when the database is up. will any anyone running jobs as sys or system be affected by this?

Question by:aravind_314
  • 3
LVL 74

Accepted Solution

sdstuber earned 668 total points
ID: 35435373
can you?  yes
will it affect jobs already running?  no

the password change will only affect the NEXT session that tries to log in,  not anything that is already connected
LVL 74

Assisted Solution

sdstuber earned 668 total points
ID: 35435407
do note though,  nobody should actually be running anything as SYS unless there is an installation, upgrade or grant to sys owned object.

Unfortunately it's a common practice for people to do lots of things as SYS when they don't need to.
SYSTEM is also overpowered for most activities, but is at least a step away from using SYS all the time.

SYS is a special user,  permissions, auditting, policies etc don't behave the same for SYS as for other users.
So, not only is powerful enough to do a lot of damage, but it also doesn't "play by the rules" so its use isn't recommended
for anything except those actions where it actually required, which is rare.
LVL 23

Assisted Solution

OP_Zaharin earned 332 total points
ID: 35438179
hi aravind,
- do you have DB Console installed? if you change the SYS and SYSTEM password in SQL Plus, then it also must be changed in DB Console too. changing it in DB Console would require you to login as SYSMAN user and then go to setup (top right corner) click on Administrators and change it there.

Expert Comment

ID: 35453453
yes You can change your sys and system what ever  jobs are running. tey affect on next session ...u not need worry about the current session..
LVL 74

Expert Comment

ID: 35453493
spyresonse,  that's the same thing said above.  please read all previous posts to be sure you're not posting duplicate information

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question