Install Oracle 10g Express

*One instance per machine
*1 CPU
*1 GB RAM
*4 GB total disk space

*Download from Oracle XE Site
*Make sure you are logged in Windows as local administrator. Domain administrator won’t work.
*Double click OracleXE.exe to install
*Accept all default options
*SID is XE (not orcl)
*Port info
-Oracle Listener: 1521
-Oracle services for MS transaction service: 2030
-HTTP port: 8080

*Login as system
*Set process number

alter system set processes=150 scope=spfile;

*Increase open_cursors

alter system set open_cursors=500 scope=both;

*Remove the twenty session limit

alter system reset sessions scope=spfile sid='*';

*Restart Oracle
*Check changes

show parameter sessions;
show parameter processes;

* Combined commands:

alter system set processes=150 scope=spfile;
alter system set open_cursors=500 scope=both;
alter system reset sessions scope=spfile sid='*';
 
show parameter sessions;
show parameter processes;

*If you install 10g Express client, then you don’t see tnsname.ora file
*To connect use username/password@[//]host:port[/service_name]

sqlplus /nolog
connect sys/password@dbhost/xe as sysdba

*Optionally, copy the “NETWORK” directory from a server installation into the client installation

connect user/password@xe