Ubuntu 10.10 Oracle 10g graphic tutorial

Ubuntu 10.10 Oracle 10g 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 described.

2. Update 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.

3. Install 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)

Download and search: compat-libstdc ++-33-3.2.3-61.i386.rpm.

Links provided by individuals:

------------------------------------------ Split line ------------------------------------------

Free in http://linux.bkjia.com/

The username and password are both www.bkjia.com

Download the Oracle 10g image and text tutorials/

For the download method, see

------------------------------------------ Split line ------------------------------------------

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

4. Modify 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)

5. Create 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

6. Add 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.

7. Create 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.

8. 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

9. Install 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 checking the operating system, go 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