Cryptography | Computer Science | Circuits | Math | Physics
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:Usersrecon1>sqlplus / as sysdba Run the following query SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g Express Edition Release …
The other day I was happily opening SQL Developer when I found this horrible thing. Here is how to solve it. Connect as sysdba to the database. C:UsersSiry>sqlplus / as sysdba Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. Set a password for the locked user. SQL> ALTER …
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 the task done faster than executing each file manually, here it is: …
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 of files and compare them in bulk you get a lot of …
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. This worked for us. GRANT ALL ON *.* to root@’10.101.60.142′ …
Very easy, just log in into sqlplus and type as follows if you are in the same path as your file: SQL > @file_name.sql If you are not in the same path as your file, you should type as follows: SQL > @/path/to/file_name.sql What if I need to pass a parameter? Well, not a problem, just type as follows: SQL …
Here is how it’s done. Log on as SYSTEM user C:Usersdelta1>sqlplus system SQL*Plus: Release 11.2.0.2.0 Production on Thu Feb 20 12:01:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 – Production SQL> Execute the CREATE USER command SQL> create user user_name identified by user_password; Provide permissions to the …
Once you have installed Oracle database and rebooted the system you can go to a command line window and type the following: C:Usershecperez>LSNRCTL SERVICES The response should look like this: LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 – Production on 20-FEB-2014 10:23:51 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) Services Summary… Service “CLRExtProc” has 1 instance(s). Instance …