Monthly Archives: February 2014

How to execute .SQL files from console

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, […]

How to create Oracle users in Oracle 11g XE

Here is how it’s done. Log on as SYSTEM user C:\Users\delta1>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 […]

How to see available SID’s in Oracle

Once you have installed Oracle database and rebooted the system you can go to a command line window and type the following: C:\Users\hecperez>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 […]