Can Oracle Database User have 2 Different Login and Transaction Passwords

Dear All,

Hope all are doing good.

We have requirement for Database Security that

1. Application Database has one User as Administrator now, Administrator should be allowed for any maintenance work to make changes to the
   database and all the changes made to the database should be logged.
2. Administrator shall have
   separate login password & transaction password. Any changes in the System shall be allowed only after successful validation of these passwords.
3. For all completed physical operations, the data recorded in the database should not be allowed to be updated / changed.

so how can we achieve above requirements in our Application Database.