Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot reinstall XE 18c after doing an uninstall

RabbitWolfMar 29 2019 — edited Mar 29 2019

Hi,

I successfully installed XE 18c on my Win Pro machine. After a few days, the OracleOraDB18Home1TNSListener service would start and immediately stop. I thought I would try uninstalling and reinstalling XE 18c. However, the even though the uninstall finished and I rebooted my system, the uninstall did not do its job. When I tried to run the installer, I get this stuck at this point:

pastedImage_0.png

Why does the installer think there is already an existing XE database? Pressing NEXT does nothing. What is the installer checking that makes it thinks there is an existing installation? How can I force the installer to do the installation?
This post has been answered by Norman Dunbar on Mar 29 2019
Jump to Answer

Comments

Anurag Tibrewal
Hi,

With whatever requirement you posted so far, it is possible.
You need to write a dml trigger (insert/update/delete) on the table1. Inside the trigger you would be writing a code to do the changes on table2.
Points to remember
- schemaA(where table1 resides) needs the direct insert/update/delete privilege on table2 of schemaB.
- Prefix schema name with table2 inside the trigger.

Regards
Anurag
1 person found this helpful
Knightbeat
Thank you so much, for the reply.

I can't even imagine how did you reply so quickly! I think my question was 100% answered, and now I can surf to know how it can be done, as I now know that It's possible to be done!

Thank you very much! I really appreciate your generosity!
1 - 2

Post Details

Added on Mar 29 2019
18 comments
35,640 views
2 mentions