Cancel
Showing results for 
Search instead for 
Did you mean: 

Renew schema password

Valued Contributor
Valued Contributor

Good morning,

 

while retrying to import an old schema, I got the message above. I have searched the admin manager, but can´t find any option to change the password for the schema user.

 

Where can I change the password?

 

 

 

 

4 REPLIES

Re: Renew schema password

Siemens Genius Siemens Genius
Siemens Genius

Hi,

 

The problem is related to the Schema password expiring in Oracle.  Attached is a pptx that shows how to change the password and set it to never expire.

Re: Renew schema password

Valued Contributor
Valued Contributor
That´s it - thank you! Smiley Happy

Re: Renew schema password

Valued Contributor
Valued Contributor
Okay, still does not work.
I´ve followed your manual for both profiles, but I´ve still got the message "ERROR:
ORA-28011: the account will expire soon; change your password now".

Is it possible to change the password in the gui?

Re: Renew schema password

Valued Contributor
Valued Contributor

Okay, I have managed the problem - one of my sqlplus accounts was still expired, but you can list all accounts with the following command:

 

select username,exiry_date,account_status from dba_users;

 

Than you can repair the exired account like in the slution above - maybe it´s helpful for someone who is not that familiar with sqlplus.