Madhu,
Changing the SYS and SYSTEM passwords is something we do periodically here and
we have no issues with it. It actually does not mess up your password file. What
would concern me is the database links. In my book SYS and SYSTEM should NOT have any
dblinks or any dblinks that refer to them. They are forbidden schemas to use.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Thursday, June 12, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
Hello ALL,
We have a plan to change the SYS and SYSTEM user's passwords. There are two DBLINKs
created for each user and I am not sure who is using them , Is there any way ( trace )
to check who is using these DBLINKs ??
Also you might have done the password changes many times for SYS/SYSTEM , were there
any issues associated with password change ??
The following info. might be useful for your replies:
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
INTERNAL TRUE TRUE
SYS TRUE TRUE
remote_login_passwordfile=exclusive
I will be grateful , pl share your experiences with me.
Thank You,
Madhu Reddy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reddy, Madhusudana
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
