Tech Rescue

Oracle

How to solve ORA-25188: Cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster

This time I was trying to reproduce an specific scenario and all of a sudden I was getting ORA-25188 in Tomcat’s console. A quick search on google revealed this method:

Connect as sysdba

C:Userszulu>sqlplus / as sysdba

Run the command, wait for the confirmation message

SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.

That’s it, at least for me it worked but in seems that this is not a definitive solution.

Sources:

http://stackoverflow.com/questions/17011783/oracle-error-ora-25188-spontaneously-appearing-for-unknown-reasons

Read next

Install Kong OSS DB-less mode in Ubuntu Mate Impish 21.10 in Raspberry PI 4

1. Pull docker images. sudo docker pull arm64v8/kong 2. Run Kong in DB-less mode. sudo docker run -d --name kong \ -e "KONG_DATABASE=off" \ -e "KONG_PROXY_ACCESS_LOG=/dev/stdout" \ -e "KONG_ADMIN_ACCESS_LOG=/dev/stdout" \ -e "KONG_PROXY_ERROR_LOG=/dev/stderr" \ -e "KONG_ADMIN_ERROR_

Install DecK for Kong in Ubuntu 20.04 (focal)

1. Download the TAR file: curl -sL https://github.com/kong/deck/releases/download/v1.11.0/deck_1.11.0_linux_amd64.tar.gz -o deck.tar.gz 2. Extract the TAR file: tar -xf deck.tar.gz -C /tmp 3. Copy the files to the right place: sudo

Authorize a user to authenticate with SSH key

NOTE: I am assuming that sshd is already up and running on your Skynet server. If not, run systemctl status sshd, if down you can run systemctl start sshd and systemctl enable sshd to start the service and allow it to run at system startup. For the purposes of this