Tech Rescue

Hector Perez

How to connect to a remote Oracle database

Here is how to connect to a remote Oracle database using SQLPlus: sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=protocol)(HOST=host)(PORT=port))(CONNECT_DATA=(SID=sid))) Please note that the words in Italics represent variables: user – user name for the remote database pass – password for the remote database protocol

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