ORA-01552: cannot use system rollback segment for non-system tablespace “string”
Cause: Used the system rollback segment for non-system tablespace operations.
If this is a clone database, this will happen when attempting any data modification outside the UNDOTBS tablespace.
Solution :
1) Switch to Automatic Undo Management
$ sqlplus / as sysdba
alter system set undo_management=auto scope=spfile;
2) Restart the database.
SQL> Shutdown immediate;
SQL> startupRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/24/2023 09:23:19
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u03/archive2/1_4134_983485279.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3This ORA-19625 errors are related with file specified as input to a copy or backup operation, or as the target for an incremental restore, could not be identified as an Oracle file. An OS-specific error accompanies this error to help pinpoint the problem.
To solve this error, Specify an different file and retry the operation.
Try to run the following commands.
RMAN> crosscheck copy of archivelog all
RMAN> crosscheck archivelog all
RMAN> resync catalog
RMAN> delete force obsolete;
RMAN> delete expired archivelog all ;If the problem is not solved,then Files were deleted at OS level and Archive log files were deleted at OS level. To solve this error, Run the following commands.
RMAN> Change archivelog '' UNCATALOG ;
Please note the first archive log name would be present in the error message ORA-19625:
For example :-
RMAN-06059: expected archived log not found, lost of archived log
ORA-19625: error identifying file /var/opt/arch_oltp28_1_744738.arc
ORA-27037: unable to obtain file status
RMAN> Change archivelog '/var/opt/arch_oltp28_1_744738.arc' uncatalog;
Run the archive log backup command check if you still get the error
Keeping specify the archive log file name reported in ORA-19625 till backup of archive log goes fine
Or
RMAN> Change Archivelog all Uncatalog ;
Please note the above command will uncatalog the information about the Archive log from catalog database.
Follow the steps as mentioned below:
1) Click start and click on internet explorer
2) Hit Alt key on keyboard
3) Click on Tools, internet options
4) Click on security tab
5) Click on Custom level
6) Scroll down to Enable XSS FILTER “Under Scripting”
7) Place a check mark for Disable XSS FILTER and click on Ok
8) Click ok to close the properties windows
9) Restart internet explorer and check for issue
Below steps to get the forgotten apps user password in oracle apps R12.
Step 1:
Connect to sys user
Step 2:
Create function to know the encrypted password
Step 3:
Step 4:
Apps password using encrypted guest password
Step 5:
Test the password is working fine or not
Users may not able to able to see Help >Diagnostics option or get an error “Function Not Available to this Responsibility. Please check with your system administrator.”
These profiles need to be set at user level. So specific user can access this functionality (ex. Support folks/Developers)
Navigation: Go to System Administrator responsibility
Profile> System
Profile Option Name: Utilities:Diagnostics
User Level: Yes
Profile Option Name: Hide Diagnostics menu entry
User Level: NO
Save changes
Have user logout of Oracle Application and login again
User should be able to access Help >Diagnostics Menu
