Oracle Cloud: Some issues with the old IMP & EXP utilities

14. November 2020 Uncategorized 0
As I am still helping one customer to explore the Oracle Cloud, I am learning myself something new every time and I am also facing some issues on that way. The last one is related to the old IMP and EXP tools. One of the automated steps is to export some tables from one database ...

Oracle Cloud: ORA-00018 maximum number of sessions exceeded -> Use DRCP

08. November 2020 Uncategorized 2
One of my customers want to try out the Oracle Cloud, and they started with a small database using the “Always Free” option. So far, so good, except one issue – from time to time, they are getting the error message “ORA-00018: maximum number of sessions exceeded“. Every Oracle DBA would first check the database ...

ORA-01548 & drop Undo tablespace

06. October 2015 Uncategorized 0
Recently I was cloning one RAC database to single instance database, and afterwards I wanted to remove one of the Undo tablespaces. Unfortunately, it didn’t go so smoothly as I expected… SQL> drop tablespace UNDOTBS2 including contents and datafiles; * ERROR at line 1: ORA-01548: active rollback segment \'_SYSSMU39_1583257383$\' found, terminate dropping tablespace Hmmm, ok ...