Daily Archives: February 12, 2015

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: Connect as sysdba to the database C:\Users\hecperez>sqlplus / as […]

How to check Oracle database version?

So today I needed to check what was my Oracle version because the PARTITION is not working and as far as I understand my version is not compatible with it. Here’s how to do it. Log in as sysdba C:\Users\recon1>sqlplus / as sysdba Run the following query SQL> select * from v$version; BANNER ——————————————————————————– Oracle […]