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

1. Installation planning

Network Planning:

IP: xxxx-static IP

Catalogue planning

ORACLE_BASE: / oracle/app-- you can modify the software catalog by yourself

ORACLE_HOME / oracle/app/db-you can modify the product catalogue by yourself

ORACLE_SID:vicdb

2. Create users and groups

[root@szh ~] # groupadd oinstall

[root@szh ~] # groupadd dba

[root@szh ~] # groupadd oper

[root@szh] # useradd-u 502-g oinstall-G dba,oper oracle

[root@szh ~] # passwd oracle

3. Create a directory

[root@szh] # mkdir-p / oracle/app/db

[root@szh] # chmod-R 775 / oracle

[root@szh] # chown-R oracle.oinstall / oracle

4. Configuration / etc/hosts

5. Modify / etc/sysctl.conf-needed in 10g and repaired during installation in 11g

Add

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 1599973376

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

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 = 1048586

6. Modify / etc/security/limits.conf-needed in 10g and repaired during installation in 11g

Add

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

6. Modify oracle profile

ORACLE_SID=orcl; export ORACLE_SID-at will, no more than 8 characters, can not start with a number! Don't be too unpopular ~

ORACLE_BASE=/oracle/app; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/db; export ORACLE_HOME

PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/usr/sbin:/bin:/usr/local/bin:.; export PATH

7. Install the machine

7.1 download softwar

Linux_11gR2_database_1of2.zip and linux_11gR2_database_2of2.zip

7.2 decompression software (one by one)

It is best to check the directory in the environment variable

[root@szh ~] # cd / home/oracle/

[oracle@szh ~] # unzip linux_11gR2_database_1of2.zip

[oracle@szh ~] # unzip linux_11gR2_database_2of2.zip

[oracle@szh ~] # exit

7.3 set up the remote open graphical interface

Root users execute xhost + (allows all users (clients) to access the graphical interface.

Ssh-X oracle@10.1.1.55 remote login

Enter the xclock command to check if the graphical interface can be opened remotely

7.4 installation

7.4.1 cd / home/oracle/database, running runInstaller

(1) the following window may pop up when running. There is a problem with the hosts file. Restart the machine after the change and run the installation script again.

(2) when the following window appears, check it out and click next.

① shows in English:

② displays in Chinese:

(3) the following dialog box appears, click yes.

(4) the following dialog box appears, choose to install only the software, and click next.

① English interface:

② Chinese interface:

(5) the following dialog box appears, select to install single instance, and click next.

① English interface:

② Chinese interface:

(6) choose a language

① English interface:

② Chinese interface:

(7) choose Enterprise Edition

① English interface:

② Chinese interface:

(8) path selection, click next directly.

① English interface:

② Chinese interface:

(9) next step

① English interface:

② Chinese interface:

(10) next step

① English interface:

② Chinese interface:

(11) Click the next step to perform the condition check, and the following error message will be reported:

(12) install the four packages in the prompts on the host using the yum source:

[root@szh ~] # yum-y install libaio-devel-0.3.106

[root@szh ~] # yum-y install sysstat-7.0.2

[root@szh ~] # yum-y install unixODBC-2.2.11

[root@szh ~] # yum-y install unixODBC-devel-2.2.11

Then check it again, leaving the following error report:

(13) Click Patch at this time and check again, and you will be prompted to run the following script:

(14) after executing the above script on the host

[root@szh ~] # sh / tmp/CVU_11.2.0.1.0_oracle/runfixup.sh

Response file being used is: / tmp/CVU_11.2.0.1.0_oracle/fixup.response

Enable file being used is: / tmp/CVU_11.2.0.1.0_oracle/fixup.enable

Log file location: / tmp/CVU_11.2.0.1.0_oracle/orarun.log

Setting Kernel Parameters...

Kernel.sem = 250 32000 100 128

Fs.file-max = 6815744

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.wmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_max = 1048576

Fs.aio-max-nr = 1048576

Uid=502 (oracle) gid=500 (oinstall) groups=500 (oinstall), 501 (dba), 502 (oper)

(15) Click OK again

① English interface:

② Chinese interface:

(16) Click finish to start the installation

① English interface:

② Chinese interface:

(17) when installed at 94%, the following error occurs

① English interface:

② Chinese interface:

Execute the two scripts in the prompt with root on the host

Sh / oracle/oraInventory/orainstRoot.sh

Sh / oracle/app/db/root.sh

[root@szh ~] # sh / oracle/oraInventory/orainstRoot.sh

Change permissions / oracle/oraInventory.

Add read and write permissions for the group.

Removes global read, write, and execute permissions.

Change the group name / oracle/oraInventory to oinstall.

The execution of the script is complete.

[root@szh ~] # sh / oracle/app/db/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= / oracle/app/db

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

Copying dbhome to / usr/local/bin...

Copying oraenv to / usr/local/bin...

Copying coraenv to / usr/local/bin...

Creating / etc/oratab file...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

(18) Click OK to enter the following interface to complete the product installation

When you FIXABLE, clicking fix&checkagin will generate a script

=

8. Build the database by DBCA

Database Configuration Assistant can be used to create databases, configure database options, delete databases, manage templates, create new templates using predefined template settings, create new templates from existing databases, and delete database templates.

To create a database using Database Configuration Assistant, you can refer to the following steps:

(1) oracle executes the command dbca, and the following window appears

① English interface:

② Chinese interface:

(2) the picture above is the welcome interface, never mind it, click next, the following window appears, and select the "create database" option.

① English interface:

② Chinese interface:

(3) then click next to the window below to select the type of database to be created from the predefined template. You can choose custom or general-purpose database, and then click next.

Note: you can use the Show details (Show Details) option to view the database you want to create.

Templates can be created with or without data files. (without data files: contains only the structure of the database. You can specify and change all database parameters. With data files: contains both the structure of the database and the physical data files in it. Automatically create all log files and control files for the database, and you can add or remove control files, log groups, and change the target location and name of the data file. Data files, tablespaces, or fallback segments cannot be added or deleted. Unable to change initialization parameters. )

① English interface:

② Chinese interface:

(4) specify the global database name and SID in the window below, and then click next.

① English interface:

② Chinese interface:

(5) specify the management method to appear in the following window, uncheck the front of the configuration enterprise management, and click next.

① English interface:

② Chinese interface:

(6) set the password for the database administrator and click next.

① English interface:

② Chinese interface:

(7) specify the storage type, specify the location of the tracking file, and click next.

① English interface:

② Chinese interface:

(8) specify the flashback area and archive mode, and click next.

① English interface:

② Chinese interface:

(9) Select the database part and click next.

Specify the features to be used in the database here. Determine any scripts to run after the database is created. I acquiesce here.

① English interface:

② Chinese interface:

(10) allocate memory (typical or custom (for those with experience) and choose the character set and connection mode, and then click next.

① English interface:

② Chinese interface:

The third option allows you to customize the selection of Chinese character sets.

① English interface:

② Chinese interface:

(11) define database storage parameters. By default, click next.

Note: click the File Location Variables button to change any file location variable

① English interface:

② Chinese interface:

(12) Select "create Database" and click finish.

① English interface:

② Chinese interface:

(13) Click ok when the following window appears.

① English interface:

② Chinese interface:

(14) start installing the database instance:

(15) installation completed:

(16) if the conditional check is not done as prompted when installing the ORACLE database, the following error will occur when installing the database instance:

=

If the operating system can support Chinese:

If you want to install in Chinese

Switch the system environment to the Chinese environment

Export LANG=zh_CN.UTF-8

Switching system environment in Chinese and English

Export LANG=en_US.UTF-8

Connect to sqlplus, if you want to change the environment variable with an English prompt

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG

Use Chinese

NLS_LANG= "Simplified Chinese_china.ZHS16GBK"; export NLS_LANG

Character set problems of main terminals

NLS_LANG format: "language _ region. Character set"

Change the time format of the current session: SQL > alter session set nls_date_format='YYYY-MM-DD'

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.