Oracle 10g

Install Oracle 10g on Windows is straight forward enough. One caveat is that if your computer is configured with DHCP IP addresses, you need to install a Microsoft loopback adapter. Follow the install doc to install a loopback adapter. Briefly as follows.

* Go to Control panel
* Double click “Add hardware”
* Select “Yes, I have already connected the hardware”
* Select “Add a new hardware device”
* Select “Install the hardware that I manually select from a list”
* Select “Network adapters”
* Select “Microsoft” and “Microsoft Loopback Adapter”
* Click “Finish” button to close the wizard.

With ip: 10.10.10.10 (or 192.168.x.x) and subnet: 255.255.255.0.
* Go to Control panel
* Double click “Network Connections”
* Right click the newly added adapter and select the “Properties”
* Select “Internet Protocol (TCP/IP)
* Click “Properties”
* Click “Use the following IP address”
* Set IP adress: 10.10.10.10 (or 192.168.x.x) and Subnet mask: 255.255.255.0
* Click “OK” button
* Click “Close” button.

10.10.10.10   mycomputer.mydomain.com   mycomputer

Need to restart computer for the loopback adapter to take effect

CREATE TABLESPACE "SOASMDB" BLOCKSIZE 8192 
DATAFILE  'C:\ORACLE\PRODUCT\10.2.0\ORADATA\orcl\SOASMDB.DBF' SIZE 104857600 REUSE 
AUTOEXTEND ON NEXT 52428800  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  
AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER "SOASM" IDENTIFIED BY VALUES 'secret' DEFAULT TABLESPACE "SOASMDB" TEMPORARY TABLESPACE "TEMP";
CREATE USER "SOAMP" IDENTIFIED BY VALUES 'secret' DEFAULT TABLESPACE "SOASMDB" TEMPORARY TABLESPACE "TEMP";

GRANT resource TO soasm;
GRANT resource TO soamp;

imp parfile=imp.dat

USERID=system
FILE=EXP.DMP
SHOW=n
IGNORE=y
GRANTS=y
ROWS=y
FROMUSER=soasm,soamp
LOG=c:\IMP.log