Daily Archives: February 20, 2014

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