date and time expired oracle user

[Former Member]

Dear Experts,

as per my daily activities now i triggered backup through legato and it is given an below error

'CONNECT system/*******'

ORA-28011: the account will expire soon; change your password now

and i checked in database and found

user system status is shown as expired (grace)

but i dont know how to set it @open status , so kindly help me in this issue

Regards

[Former Member · Accepted solution]

Hi Swathi,

If the password is already expired, anyway you have to change it throught brtools.

If the password is not yet expired, you can set it to never expiry.

select profile from DBA_USERS where username = <username>
alter profile <profile_name> limit password_life_time UNLIMITED;

Br,

Venky

[Former Member · Accepted solution]

Dear experts,

now i already executed

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; and is changed to unlimited

and i checked again but it is showing status as expired (grace)

so can i change password , if once i changed password. what is symptoms

Regards

[Former Member · Accepted solution]

Hi Swathi,

Use the following command for changing the password.

brconnect -u system/<password> -f chpass -o <username> -p <password>

Br,

Venky

[former_member188883]

Hi Swathi,

SQL> select username, account_status from dba_users;

Above command will list down the dba users and their status.

For expired users you may change the password using the command

SQL> alter user <username> identified by <passwd>;

SQL> commit;

Regards,

Deepak Kori

[Former Member]

Dear experts,

its a problem of oracle system user is expired so can i change with new password

alter user SYSTEM identified by <giving new passwd>;

is their any effects which i faced for this problem

Regards

[Former Member]

Hi,

If this password is altered with the above statement the table SAPUSER isn't changed, so you may face ORA-01017 (note 1576837). If you use brconnect oracle dictionary and SAPUSER table are updated:

So, use brconnect .

Br,

Venky

[former_member188883]

Hi Swathi,

You can change the password of system user. There won't be any issue.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

thanks for your Reply,

i tried below

SQL> alter user <username> identified by <passwd>;

example- alter user system identified by production

here user name is system

new password is production

here we provided new password but result is an error ..

Regards

[Former Member]

What is the error? Did you try with a password which has not been used previously (last 5 passwords)?

[Former Member]

Dear venkat,

can i try below command

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

ex:

brconnect -u system/<password> -f chpass -o SAPSR3 -p production

is is correct?

[Former Member]

Dear experts,

now i successfully executed below command

alter user <username> identified by <passwd>;

and i checked dba users and now status is open insted of expired(grace).. means its changed

and i tried to take backup but we get same error

my question is why we received same error after changing users password,

we need to do any further?

Regards

[Former Member]

Hi Swathi,

Are you getting the following error?

brbackup -u /.....
BR0051I BRBACKUP 7.00 (18)
BR0055I Start of database backup: bbdzxyz.anf -11-19 05.30.00
BR0280I BRBACKUP time stamp: 2008-11-19 05.30.00
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied

If yes, that is why you have to use brconnect for changing the password. Your previous post is correct.

If you change the password using alter user, the table SAPUSER isn't changed, hence the error.

Br,

Venky

[former_member188883]

Hi Swathi,

ALTER USER <username> IDENTIFIED BY <new_password>;

If this password is altered with the above statement the table SAPUSER isn't changed, so you may face ORA-01017 (note 1576837).

If you use brconnect oracle dictionary and SAPUSER table are updated:

brconnect -u system/<password> -f chpass -o <username> -p <password>

Above command should resolved your problem

Regards,

Deepak Kori

[Former Member]

Dear venkat,

yes after changing system password now i able to connect user at os level . but when i triggered backup it is showing

brbackup -u /.....

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bbdzxyz.anf -11-19 05.30.00

BR0280I BRBACKUP time stamp: 2008-11-19 05.30.00

BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

here user id and password is ok now but why i get this error and how can i solve

i tried with brconnect also but no use

Regards

[former_member184473]

Hello,

This issue is because your SAPUSER hasn't being updated.

Refer to the SAP note [1576837|http://service.sap.com/sap/support/notes/1576837]:

brconnect -u system/<password> -f chpass -o <username> -p <password>

If a user is already locked, you can unlock it as follows (note [951167|http://service.sap.com/sap/support/notes/951167]):

TER USER <username> ACCOUNT UNLOCK;

Regards,

Eduardo

[former_member184473]

Hello,

Check the following note for further information about this issue:

[1627312 ORA-28001: the password has expired|http://service.sap.com/sap/support/notes/1627312]

Regards,

Eduardo Rezende