Tech Rescue

Latest

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: 1. Connect as sysdba C:Userszulu>sqlplus / as sysdba 2. Run the command, wait for the confirmation message SQL>

How to open computer management window from cmd in Windows 7?

A few days ago I needed to connect an external hard drive with a weird partition to my computer to format it as NTFS. I right clicked Computer and click Manage and nothing happened. I really don’t know why and I didn’t even care about solving it. The

How to solve ORA-01017: Invalid username/password; logon denied

I was trying to connect to a database today when I found this: I think there could be a lot of reasons for this, but the easiest approach is to reset the user’s password, that is if the user exists of course. Here is the solution: 1. Connect as

How to solve ORA-28001: The password has expired

The other day I was happily opening SQL Developer when I found this horrible thing. Here is how to solve it. 1. Connect as sysdba to the database. C:UsersSiry>sqlplus / as sysdba 2. Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEFAULT

How to execute several .SQL files from console

Yesterday I needed to run an older version of a project just to make a few changes, for that I needed to update my old code for that project and run all the scripts (.SQL files) to update the database. A colleague gave me a line of code to get

How to kill all processes with the same name in Windows 7?

Well, today at work I was using IBM Rational Synergy to sync my files and be able to compare them in order to determine which ones to keep / discard. The comparing tool I’m using is KDiff3, which in my opinion it’s ok, but when you select a bunch

How to grant access to remote PC in MySQL?

The problem we were facing was that a colleague was trying to access to a MySQL database in my computer, we were both in the same network, he was being asked for password, so for that, here is how to grant root access to another IP to your local database.