Graph tutorial for installing and deploying an Oracle Server in CentOS 6.3, centosoracle

Graph tutorial for installing and deploying an Oracle Server in CentOS 6.3, centosoracle

1. installation environment:

Linux: CentOS 6.3 64-bit
Oracle: Oracle11gR2 64-bit

Ii. system requirements:

1. Requirements for installing Oracle in Linux

System Requirements	Description
Memory	Physical memory must be higher than 1 GB
Swap space	Generally, it is twice the memory size. For example, you can set the swap partition size to 3 GB for 1 GB memory.
Hard Disk	5G or above

Iii. system core parameter configuration:

Perform the following steps under the Root user:

1) modify the user's SHELL restrictions and modify the/etc/security/limits. conf file

Enter the command vi/etc/security/limits. conf, press the I key to enter the editing mode, and add the following content to the file.

Copy codeThe Code is as follows:
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536

After editing, Press Esc and enter ": wq" to save the disk and exit.

2) modify the/etc/pam. d/login file, enter the command vi/etc/pam. d/login, press the I key to enter the editing mode, and add the following content to the file.

Copy codeThe Code is as follows:
Session required/lib/security/pam_limits.so
Session required pam_limits.so

After editing, Press Esc and enter ": wq" to save the disk and exit.

3) modify the Linux kernel, modify the/etc/sysctl. conf file, enter the command vi/etc/sysctl. conf, press the I key to enter the editing mode, and add the following content to the file.

Copy codeThe Code is as follows:
Fs. file-max = 6815744
Fs. aio-max-nr = 1048576
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 4194304
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048576

After editing, Press Esc and enter ": wq" to save the disk and exit.

4) to make the/etc/sysctl. conf change take effect immediately, run the following command. Input: sysctl-p:

Copy codeThe Code is as follows:
Linux :~ # Sysctl-p
Net. ipv4.icmp _ echo_ignore_broadcasts = 1
Net. ipv4.conf. all. rp_filter = 1
Fs. file-max = 6815744
Fs. aio-max-nr = 1048576
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 4194304
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048576

5) edit/etc/profile, enter the command vi/etc/profile, press the I key to enter the editing mode, and add the following content to the file.

Copy codeThe Code is as follows:
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi

Fi

After editing, Press Esc and enter ": wq" to save the disk and exit.

6) Create related users and groups as owners of software installation and support groups.

Create a user and enter the following command:
Copy codeThe Code is as follows:
Groupadd oinstall
Groupadd dba

Create an Oracle user and password, and enter the following command:
Copy codeThe Code is as follows:
Useradd-g oinstall-G dba-m oracle
Passwd oracle

The password will be entered twice, but the password must be consistent. Press enter to confirm.

7) Create a database software directory, a data file storage directory, and a directory location based on your needs. Pay attention to the disk space. Here I will put it under the oracle user, for example:

Enter the following command:
Copy codeThe Code is as follows:
Mkdir/home/oracle/app
Mkdir/home/oracle/app/oracle
Mkdir/home/oracle/app/oradata
Mkdir/home/oracle/app/oracle/product

8) change the directory owner to be owned by an Oracle user and enter the following command:

Copy codeThe Code is as follows:
Chown-R oracle: oinstall/home/oracle/app

9) configure the environment variables of oracle users. First, switch to the newly created oracle user,

Input: su-oracle, and then directly enter: vi. bash_profile

Press I to edit. bash_profile, enter the editing mode, and add the following content:

Copy codeThe Code is as follows:
Umask 022
Export ORACLE_BASE =/home/oracle/app
Export ORACLE_HOME = $ ORACLE_BASE/oracle/product/11.2.0/dbhome_1
Export ORACLE_SID = orcl
Export PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib

After editing, Press Esc and enter ": wq" to save the disk and exit.

4. Image installation process:

1) After all the required operations are completed, log out of the system and log in as an Oracle user on the graphic interface. First, copy the downloaded Oracle Installation Package to linux. We recommend that you use Xmanager or other ftp tools.

Open a terminal and run the unzip command to decompress the oracle Installation File, for example:

Enter the following command:
Copy codeThe Code is as follows:
Unzip linux.x64_11gR2_database_1of2.zip
Unzip linux.x64_11gr2_database5of2.zip

After decompression, the cd enters the decompressed directory database.

Enter the following command:
Copy codeThe Code is as follows:
Cd database

Run the ls command to view the files contained in the decompressed database, for example:

2)Before installation, check whether the system is in English. If the Chinese version is used, change the environment variable to English.

Copy codeThe Code is as follows:
Export LANG = en_us

Then enter the command:./RunInstaller

After installing this step, we can see that many rpm packages are not available. We can find the missing packages from the linux installation CD or ISO and upload them to linux using ftp, then run rpm-ivh xxx. rpm -- nodeps-force is used for installation (add -- nodeps -- force indicates forced installation, and rpm-ivh xxx is used directly. if the rpm installation fails, the installation process is omitted.

When all the packages are installed, execute installation process 2 in the oracle graphical interface again. Then, the installation will pass the Environment check.

After the installation is complete, the system prompts you to use the root permission to execute two shell scripts. Locate the location according to the prompted path, for example, in/home/oracle/app/oracle/product/11.2.0/dbhome_1/root. sh.

And/home/oracle/app/oraInventory/orainstRoot. sh to open a new terminal, enter the command:

Copy codeThe Code is as follows:
Su-root
Cd/home/oracle/app/oracle/product/11.2.0/dbhome_1
Sh root. sh
Cd/home/oracle/oraInventory
Sh orainstRoot. sh

V. database creation

1) in oracle user graphical interface (GUI), a new terminal is opened. The following interface is displayed when you directly enter the command dbca. Here we use a custom database.

Enter the unified password (you can also set the password separately)

Database storage location, which is used by default here

Quick Recovery and archiving are not specified.

Remove uncommon modules

Memory Allocation and specified Character Set

After a long wait, when you see this interface, the oracle database creation is complete.

You can use sqlplus to check whether a new command window is opened, enter sqlplus, and then enter the user name and password. If you can test the window, we will not introduce it too much here.

Configure listeners and Local Network Services

1) open a new terminal in the oracle user graphical interface (GUI) of the oracle user. Enter the command netca to bring up the following interface.

2) create a listening service (Act as an oracle Server and connect other oracle clients to the local oracle Server)

3) configure the local network service name (Act as the oracle client and connect to other oracle servers)

Enter the database instance name of the connected oracle Server

Enter the IP address of the oracle server

Select Test

Click change Login, enter a user name and password of the connected oracle Server, and click OK.

If the test is successful, check whether the network is smooth, whether the connected oracle Server is started, and whether the listener is started)

Name your local network service name

Next, click Next.

6. test:

Check whether the oracle service is enabled

# Lsof-I: 1521

In this way, the installation and configuration of the oracle server are basically complete.

In Centos 63, how does one configure the vsftpd ftp server? Graphic tutorial

Hello, go to the desktop, open your terminal, and enter the command
Yum install vsftpd press Enter.
Reference: www.juxiwang.com/read-tid-2971.html

This problem occurs when centos63 is installed with oracle11g. How can this problem be solved? I found several solutions, but none of them work.

Vi/etc/profile
Vi/etc/redhat-release
Vi ../database/response/enterprise. rsp
You can consider silent installation, and the required dependency packages are all yum!