MekalaSubramani (Customer) asked a question.
While restoring our dB from backup due to some missing data we encountered following error message
AveksaExportImportDir]$ /home/oracle/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh -t _2026-06-15 ORACLE_SID=AVDB ORACLE_CONNECTION_ID=AVDB ORACLE_SERVICE_NAME=AVDB AVEKSA_HOME=/home/oracle AVEKSA_USER=avuser AVEKSA_PASS=******** SYS_USER=sys SYS_PASS=******** DEFAULT_TABLESPACE=DATA_1M TEMP_TABLESPACE=TEMP ************************************************************************ Mon Jun 15 14:27:06 EDT 2026 Script history log file: /home/oracle/database/DBA/AVDB/logs/Import_AVDB_avuser_History.log Importing from the AVDB Database . . . IMPORT Input File Dir: /home/oracle/AveksaExportImportDir IMPORT Input File Name: Export_AVDB_avuser_2026-06-15.dmp IMPORT Job Name: AVDB_Import_AVUSER.job Schema Owner: avuser PAR File: /home/oracle/database/DBA/AVDB/export/Import_AVDB_avuser.par LOG File: Import_AVDB_avuser.log Connect as: avuser/********@AVDB Run Date: Mon Jun 15 14:27:06 EDT 2026 -t option: file tagged: _2026-06-15 ************************************************************************ Mon Jun 15 14:27:06 EDT 2026 ============================================================================= Importing process will follow the following steps to configure, import, and update database data Step 1 Dropping and ReCreating the avuser user Step 2 Run the oracle IMPORT utility Step 3 Refresh database statistics Step 4 Updating Control Information ========================================================================= *** *** *** *** *** WARNING !!!! Database User avuser will be DELETED !!! *** *** *** *** Enter ^C with 30 seconds to cancel ... *** *** *** *** *** *** Also ensure that the server process is not running and that there *** *** are no outstanding/remote database connections open through user *** *** avuser *** *** *** ============================================================================= Starting Import Process - ORA-01017: invalid username/password; logon denied ORA-01017: invalid username/password; logon denied
We are in bundle software with DB & version p8.0 P08.
Have any one come across this error and please let us know the issue...
I saw this article -> https://community.rsa.com/s/article/Schema-migration-fails-with-ORA-01017-or-ORA-28000-in-RSA-Governance-Lifecycle
But the article says it's happening when moving from patch 7.5.2 to P8.0 -> two years ago... But this was while retrieving from backup in P8.0 P08
We verified and user status valid...
It is very unclear in which order you are doing your restore.
The link you are referring to is about moving between versions, but so far you only mention doing a restore of something that worked (hence no version change)
In general when doing a restore you need to do it as a SYS-user, and if using a working "dmp-file" then the AVUSER schema needs to be removed before datapump data restore command. WHICH means that you also need to re-create the AVUSER schema before restore as well.
Never used the specific scripts you are using, because I do not trust them.
But if you have a dmp-file, this restore-process is not that difficult. The database dmp-file tech is old. Very old. Most db-admins can help you.
As long you have a working backup (and Aveksa is down) no new data is written to the database. Then I would also not rate this as a P1 ticket. Just very inconvenient: service being down.
Again: Very unclear of what the steps were before getting error message, or even what the command you typed was.