Shulou(Shulou.com)06/01 Report--

I. Installation package:

p13390677_112040_Linux-x86-64_1of7.zip

p13390677_112040_Linux-x86-64_2of7.zip

II. Configure global parameters:

1. Configure oracle user permissions: vim /etc/security/limits.conf

Write the following on the last line of the configuration:

oracle soft nofile 65536

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

limits.conf file format:

username|@groupname type resource limit

nofile: Maximum number of file descriptors that can be opened

nproc: Maximum number of processes available to a single user

3) soft: soft limit, generally does not exceed the hard limit

Hard limit, soft limit values are generally higher than hard limit values

2. Configure Linux kernel parameters: vi /etc/sysctl.conf //Set sysctl.conf to improve Linux performance

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

kernel.shmmax = 6160392192

kernel.shmmni = 4096

kernel.shmall = 2097152

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

1) shmmax: Defines the maximum size of the shared memory segment in bytes; default is 32M.

2) shmmni: User sets the maximum number of system-wide shared memory segments; default: 4096.

3) shmall: defines the total amount of shared memory that can be used by the system at one time, in "page"; default: 2097152.

4) sem: indicates the semaphore set.

file-max: Maximum number of file handles. The maximum number of files that can be opened.

aio-max-nr: Sets the number of asynchronous IO requests that can be held simultaneously.

7) net.ipv4.ip_local_port_range: The range of ports used for outbound connections. Default: 32768-61000

8) net.core.rmem_default: The default value of memory reserved for receive buffering for TCP sockets.

9) net.core.rmem_max: The default value of memory reserved for receive buffering for TCP sockets.

10) net.core.wmem_default: Memory reserved for TCP socket for sending buffer Default: 16384 (16k)

11) core.wmem_max: The maximum amount of memory reserved for TCP socket transmit buffering.

12) Use the [sysctl -p] command to take effect immediately.

Create oralce database users and user groups

Create data user group: dba

groupadd dba

Create installation user group: oinstall

groupadd oinstall

Create user: oracle

useradd -g oinstall -G dba -m oracle //-m Do not automatically create user login directories

Set user password:

passwd oracle

4. Create the file directory and permissions used by oracle:

1. Create Oracle's base directory:

mkdir -p /u01/app/oracle

mkdir Create directory command

-p Multiple subdirectories can be created simultaneously

2. Assign users and groups to the base directory:

chown -R oracle.oinstall /u01/

chown Change users and groups

-R Change the users and groups of all subdirectories in the directory of the day

/** This command can be invoked graphically in a subsequent oracle user installation oracle program **/

#xhost +

The following are all operated under oracle user

su - oracle

5. Configure oracle user environment variables:

vim .bashrc //configure environment variables

source .bashrc //execute this file to take effect environment variable

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

/** ORACLE_BASE: oracle base directory **/

export ORACLE_BASE=/u01/app/oracle

/** ORACLE_HOME: oracle home directory **/

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

/** ORACLE_SID: oracle process name **/

export ORACLE_SID=orcl

/** PATH: command environment variable; add the directory path of ORACLE_HOME/bin to this environment variable

export PATH=$ORACLE_HOME/bin:$PATH

/** LD_LIBRARY_PATH: dynamic library lookup path variable; add the directory path of ORACLE_HOME/lib to this environment variable

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

/** Set language environment **/

export LANG=en_US

VI. Decompress the installation package:

unzip p13390677_112040_Linux-x86-64_1of7.zip

unzip p13390677_112040_Linux-x86-64_2of7.zip

Note: Make sure the extracted directory permissions are oracle user and oinstall group

7. Create directories for Oracle software installation and upgrade, and configure permissions:

1. Create directory: oraInventory

mkdir /u01/app/oraInventory

2. Assign and confirm directory permissions:

VIII. Installation of database:

1. Run the installation script:

cd database/

./ runInstaller

2. Graphical interface installation:

1) Waiting for the graphical interface to be invoked:

2) Error reported in calling:

PRVF-0002:Could not retrieve local nodename

This problem occurs because the local node name cannot be found.

a. First check that the network is not connected and cannot be started:

b. Solve the problem that eth0 cannot be started:

/** Check if network management services are enabled **/

[root@db Desktop]# service NetworkManager status

/** Network management tools affect the network startup of eth0. Under normal circumstances, it is closed. Now it is started, so the service is closed **/

[root@db Desktop]# service NetworkManager stop

/** Restart eth0 NIC service again and start successfully **/

[root@db Desktop]# service network restart

After the network problem is resolved, try to start oralce installation again, the problem is still the same.

c. Change the hosts file: add the host name and address to it

Start oracle installation again, problem solved, can display graphical installation.

3) Formal graphical interface installation:

Configure security updates, fill in the email address to receive security updates, and want to receive security updates through My Oracle Support.

b. If the security update mailbox is not configured, the next prompt message, for security issues, it is best to provide the mailbox.

Keep choosing yes.

c. Download the update software: here we choose to skip the software update project

d. Installation options:

As the name suggests, a new database installation requires the first choice, but if someone wants to build their own database, they can choose the second.

e. Select which system to install on: Select server class:

f. System network type installation option: select single instance database installation.

g. Installation Type: Select Advanced Installation.

h. Product language: select Simplified Chinese and English.

i. Database version: select Enterprise version (4.7GB)

j. Database installation location:

oracle_base: /u01/app/oracle

software location: /u01/app/oracle/PRODUCT/11.2.0/db_1

The above directory is the default of the system, and the setting of environment variables is also consistent with this. If you need to modify the default installation path, then the environment variables should also be changed.

k. Create a product list:

The manifest directory can be changed or left unchanged by default, but the permissions for this directory must be accessible to the oinstall group user.

l. Configure database type: Select General Purpose/Transaction.

m. Database identifier:

Global database name: orcl

Oracle Service Identifier (SID): orcl

n. Parameter configuration options: Normal installation is the default, mainly focusing on the character set. If the character set of imported data is inconsistent, the database migration may fail.

o. Database management option setting: Use Database Control to manage databases.

Database Storage: Select the local file system location for storage.

Backup and Recovery: Choose not to enable automatic backup.

r. Scheme password: Use the same password for all accounts [oracle]

Because the password of the database administrator account is relatively simple, there are the following prompts. Select yes.

s. Operating system personnel belong to group:

t, installation condition check, there may be some system parameters are not right ah, or dependent package missing ah and so on environment check.

Check the dependency packages to see if there are any missing installation packages that are not installed. Install these dependency packages according to the prompts.

Install gcc and gcc-c++, check Again

If there is an installation package that can't be found, I know it doesn't have much impact, so I ignore it and continue with the installation.

You will be warned if you continue, press yes.

u. Product summary, which mainly contains variable position parameters configured before, etc. It is recommended to save it for archiving.

After v, install, start installing the database.

Install Database Instance

Installation process prompts database creation completed, related information and password management.

During installation, two scripts need to be run, both of which need to be run as root.

W. Installation is complete.

IX. Installation completed and database entered:

Use the command sqlplus / as sysdba to enter the database and display the situation as shown in the figure below, that is, all installations are completed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.