Ubuntu 10.04 installation of Oracle10g

Requirement: I want to enable the database under my current user and use MyEclipse to directly connect to the installed database. I have not created any new groups or users,

Requirement: I want to enable the database under my current user and use MyEclipse to directly connect to the installed database. I have not created any new groups or users,

Requirement: I want to enable the database under my current user and use MyEclipse to directly connect to the installed database. I have not created any new groups or users, instead, Oracle is installed under the current user of Ubuntu 10.04.

1. Configuration source (omitted)

Oracle has set up a dedicated apt source server for Ubuntu users. You only need to add the following lines in/etc/apt/source. list to the server.

Deb unstable main non-free

Add the public key of the source server to the keystore of the local apt system. First download the public key and enter:

Wget

After the download is complete, add the public key to the keystore and enter:

Sudo apt-key add RPM-GPG-KEY-oracle

Run:

Sudo apt-get update

Synchronize the software package index file.

2. Install the required package

Sudo apt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio1 libstdc ++ 6 alien

3. Install oracle on an independent partition, such as/opt. My installation directory is/opt/ora10.

// Create the ora10 directory.

$ Sudo mkdir-p/opt/ora10

// Modify the owner and group of the Directory, where UX is the user name and GX is the group of the user. I want to install it under my current user, so my UX is the user name of my current user, and the group is the group where this user name is located.

$ Sudo chown-r ux: GX/opt/ora *

// Modify directory permissions

$ Chmod-R 775/opt/ora *

4. Modify sysctl. conf settings

$ Sudo gedit/etc/sysctl. conf

Add the following row to/etc/sysctl. conf:

----------------------------------------------

Kernel. shmmax = 3147483648

Kernel. shmmni = 4096

Kernel. shmall = 2097152

Kernel. sem = 250 32000 100 128

Fs. file-max = 65536

Net. ipv4.ip _ local_port_range = 1024 65000

----------------------------------------------

Note: shmmax (maximum shared memory) is an important parameter, which is set based on the memory of your machine. If you do not set it properly, the database will be suspended when it is about 86% created. However, I am not quite clear about how to calculate it. I have to refer to the document and use it. I hope the experts can give me some advice.

5. Modify limits. conf settings

$ Sudo gedit/etc/security/limits. conf

Add the following row to/etc/security/limits. conf to modify your resource limits.

----------------------------------------------

* Soft nproc 2407

* Hard nproc 16384

* Soft nofile 1024

* Hard nofile 65536

----------------------------------------------

6. Make the modification take effect

After the preceding file is modified, it must take effect. restart the system or switch to the root user to change the kernel running parameters in the following ways:

# Sysctl-p.