Ubuntu10.10 installation oracle10g graphic tutorial

 

Environment: Host XP, 3 GB memory, VMware: ubuntu10.10, hard disk 30 GB, memory 1024 MB

 

The installation of virtual machines is not explained. There are a lot of online services, Baidu or Google.

 

 

1Download oracle10g

 

Log on to the official website www.oracle.com, download it, find oracle10g, and download

 

Oracle Database 10GRelease 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86: 10201_database_linux32.zip

 

Link: http://www.oracle.com/technetwork/database/10201linuxsoft-097986.html

 

 

 

 

 

2Update ubuntu

 

Sudo apt-get update

 

Sudo apt-get upgrade

 

Oracle is written in java, so JDK is required. You can search for jdk in [Ubuntu Software Center]. After installing OpenJDK, you do not need to set the path.

 

 

 

3Install the missing package

 

1). sudo apt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio1 alien

 

2). sudo apt-get install rpm libaio1 ksh libtool libstdc ++ 5 build-essential

 

Or use the following method (I have never tried it)

 

Search for compat-libstdc ++-33-3.2.3-61.i386.rpm and download it.

 

Links provided by individuals:

 

Http://rpm.pbone.net/index.php3? Stat = 26 & dist = 53 & size = 237109 & name = compat-libstdc % 2B % 2B-33-3.2.3-61.i386.rpm

 

Open shell, use cd, and enter the directory,

 

1). Log On As the root user: su-

 

2) execute the installation command: alien-I compat-libstdc ++-33-3.2.3-61.i386.rpm

 

 

 

4Modify the ubuntu version to cheat the oracle installer.

 

You need to create a file redhat-release in the/etc/directory. You need the permission to create the file. After the file is created, add the following content:

 

$ Sudo gedit/etc/redhat-release

 

Add the following line and save it.

 

Red Hat Linux release 3.1 (drupal)

 

5Create a user.

 

1) log on to the root user: su-

 

(If your root password is not manually set, use the sudo passwd root command to reset the password and then log on again ).

 

2) create an Oracle user and two groups for the installer.

 

First, check whether they already exist:

 

$ Grep oinstall/etc/group

 

$ Grep dba/etc/group

 

$ Grep nobody/etc/group

 

If they are not in the system, create them.

 

$ Sudo addgroup oinstall

 

$ Sudo addgroup dba

 

$ Sudo addgroup nobody

 

$ Sudo useradd-m-g oinstall-G dba-p passwd-d/home/oracle-s/bin/bash oracle

 

$ Sudo usermod-g nobody

 

Note: If you do not understand the preceding parameters, run the following command: man useradd.

 

Allocate a password to an oracle user

 

Sudo passwd oracle

 

6Add a user to the sudoer list

 

Sudo gedit/etc/sudoers

 

In the next line of "root ALL = (ALL) ALL", add:

 

Oracle ALL = (ALL) ALL

 

Save.

 

Note: by default, users are not added to the sudoers list in Linux. You must manually add the account to the sudoers list by the root user so that the normal account can execute the sudo command.

 

7Create an oracle installation directory.

 

# Mkdir-p/opt/ora10
# Chown-R oracle: oinstall/opt/ora *
# Chmod-R 775/opt/ora *

 

You have generated the runtime path of oracle and granted the write permission to the oracle user. The execution permission is granted to the dba group.

 

8And system environment configuration.

 

1) Add the following lines to the/etc/sysctl. conf file:

 

Run the sudo gedit/etc/sysctl. conf command to edit the file.

 

Kernel. shmall = 2097152

 

Kernel. shmmax = 2147483648

 

Kernel. shmmni = 4096

 

Kernel. sem = 250 32000 100 128

 

Fs. file-max = 65536

 

Net. ipv4.ip _ local_port_range = 1024 65000

 

Update the system and run:

 

$ Sudo sysctl-p

 

2) Add the following lines to the/etc/security/limits. conf file:

 

* Soft nproc 2407

 

* Hard nproc 16384

 

* Soft nofile 1024

 

* Hard nofile 65536

 

3) Establish a soft connection:

 

$ Sudo ln-s/usr/bin/awk

 

$ Sudo ln-s/usr/bin/rpm

 

$ Sudo ln-s/usr/bin/basename

 

4) modify the environment variables of oracle users in ubuntu.

 

Edit: gedit/home/oracle/. bashrc file, add:

 

Export ORACLE_HOME =/opt/ora10
Export ORACLE_OWNER = oracle
Export ORACLE_SID = ora1
Export ORACLE_TERM = xterm
Export PATH = $ ORACLE_HOME/bin: $ ORACLE_HOME/Apache/bin: $ PATH

 

 

 

9Install oracle

 

Log out after completion and use the oracle user to log on. After extracting the downloaded zip file, the database folder is generated.

 

Cd to enter the database.

 

Run:./runInstaller

 

Enter the graphical interface for oracle installation. If garbled characters appear on the Interface

 

Change the jre of the oracle Installation File Without the built-in jre. Use the jre of the operating system and add a parameter after the runinstaller to change the path in which the installer reads the jre. The statement is as follows:
./RunInstaller-JreLoc/usr/lib/jvm/java-1.6.0-openjdk/jre

 

On the installation page, select [next ]:

 

Specify the product list directory and proof of identity. [next ]:

 

 

Select "Enterprise Edition" as the installation type and [next]

 

 

Specify the main directory and [next]

 

 

After operating system check, to select Configuration options,Select "Install database software only" and [next]

 

Display the summary information, [install]

 

 

Installing...

 

 

 

In this step, you need to open the terminal and run the two scripts prompted by the root user.

 

 

Press "[/usr/local/bin]:" To continue. Return to the oracle Installation page and click "OK]

 

 

 

Installation complete. [exit]

 

 

 

10. Install the database

 

Run the following command on the terminal: dbca. If Chinese characters are garbled

 

Modify the dbca file:

 

Cd $ ORACLE_HOME/bin

 

Cp dbca. bak

 

Sudo gedit dbca

 

Find "JRE_DIR =/opt/ora10/jdk/jre"

 

Replace

 

JRE_DIR =/Usr/lib/jvm/java-1.6.0-openjdk/jre

 

Save and run the following command on the "terminal": dbca. The Chinese character is displayed normally.

 

 

[Next]

 

 

 

Select "create database" and [next]

 

 

 

Default Value: [next]

 

 

 

Configure the Database Service name. Note: when entering the sid, it must be consistent with the oracle environment variable. You can view it through gedit/home/oracle/. bashrc. [next]

 

 

 

Default Value: [next]

 

Specify a password for the database. [next]

 

 

Default Value: [next]

 

 

 

Default Value: [next]

 

 

 

Default Value: [next]

 

 

Default Value: [next]

 

 

Select "ZHS16GBK" as the character set and [next]

 

 

[Next]

 

 

[Done]

 

 

 

[OK]

 

 

Installing...

 

 

Complete.

 

11. Start oracle

 

Run as oracle on the terminal

 

Start the TNS Listener: $ ORACLE_HOME/bin/lsnrctl start

 

($ ORACLE_HOME is the installation directory of oracle:/opt/ora10. Run cd to go to the installation directory of oracle, go to the bin folder, and run $ lsnrctl start ).

 

Disable TNS: $ ORACLE_HOME/bin/lsnrctl stop
Start sqlplus: $ ORACLE_HOME/bin/sqlplus/nolog

Disable sqlplus: SQL> exit

 

 

 

12. Reference

Http://www.bkjia.com/database/201112/113316.html

Http://www.bkjia.com/database/201112/113317.html