install oracle 10g on ubuntu 8.10

installation

here is the ultimate guide, follow the same steps for 10g.

http://www.pythian.com/blogs/1355/installing-oracle-11gr1-on-ubuntu-810-intrepid-ibex

env

the $ORACLE_HOME and other env variables can be set by creating a shell under /etc/profile.d/, also remember to set $ORACLE_SID.

more /etc/profile.d/oracledb.sh
#!/bin/bash

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/oraibex
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=intrepid

dbconsole

to access the web console, login http://localhost:1158/em/ as system and password specified during db creation. the console is managed by

emctl start dbconsole

sqlplus

to connect with sqlplus remotely, first use netmgr on server side to configure.

:/u01/app/oracle/product/10.2.0/oraibex/network/admin$ cat listener.ora tnsnames.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/oraibex/network/admin/listener.ora
# Generated by Oracle configuration tools.

INTREPID =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx-desktop)(PORT = 1521))
)

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/oraibex/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INTREPID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx-desktop)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = intrepid)
)
)

use lsnrctl to start/stop/check listener.
use /etc/init.d/oracledb to start/stop/check oracle.

sqlplus hr/password@//xxx-desktop:port/intrepid or sqlplus hr/password@intrepid

for more info, please refer to http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm