Install Oracle 8.1.6

Run Oracle 8.1.6 Enterprise Edition CD
- Select “Oracle8i Enterprise Edition 8.1.6.0.0
- Select “Typical (1001MB)”
- Database/SID (myDB/myDB)
- Message: “Database Creation Completed”
- Exit (log: C:\Program Files\Oracle\Inventory\Logs\InstallActions.log

Running Oracle 8.1.6 the first time
- Start->Programs->Oracle-orahome81->Application Development->SQL Plus
- User Name/Password (system/manager)
- Leave “Host string” (blank)
- What users are setup: select username from dba_users;
- CREATE USER &userid IDENTIFIED BY &password;
- GRANT CONNECT, RESOURCE TO &userid
- Log onto new userid: CONNECT &userid
- Alter user identified by

After restarting, if you get an ORA-01034: Oracle not Available error, it is because Oracle instance is not running. Do manual start as following
C:\>svrmgrl
SVRMGR>connect internal
SVRMGR>startup (shutdown immediate)
Change system, sys and ctxsys password:
SQL>alter user system/sys/ctxsys identified by password

Create first Oracle 8.1.6 Database
- Start->Programs->Oracle-orahome81-> Database Administration->Database Configuration Assistant
- "Create a database." ->"Custom“->"Multipurpose“->“10" concurrent users->"Dedicated Server Mode“->
- Global Database Name/SID (GEMSDB81/GEMSDB81)->Next
- Temporary/Rollback Tab (Size:150)
- Redo log size - 5000
- Checkpoint Interval – 10000 (default)
- Process (50)

If you encounter ora-01102 error
C:\>set oracle_sid=s1
C:\>svrmgrl
C:\>connect internal
C:\>shutdown immediate
C:\>exit

Net8 Assistant
- Start form menu
- Local->Service Naming->”+”
- Net Service Name: “GEMS816”->TCP/IP->Host Name “myDB”, Port Number: 1521->Service Name: “myDB”->Finish

Add listener
- Start from menu
- Select “Listener configuration”->Select “Add”->Listener Name: “myDB”->”TCP” selected->Use the standard port number of 1521->”No”

Delete a database
- Oracle Database Configuration Assessant->”Delete a database
- “OracleServicemyDB”

Start Oracle Listener
- Cmd Window
- C:>LSNRCTL
- LSNRCTL>start (stop)