Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle installation stand-alone manual practice version

2025-02-27 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Oracle 11g complete installation manual

Note:

Some computers may need to enable cpu's support for virtualization, please set it up in bios.

1. Install the virtual machine software

Extract the VMware10.rar and install the software. Specific steps (brief).

2, create a virtual machine

1. After installing VMware10, double-click the icon to open it and display the following interface:

2, click to create a new virtual machine

3. Select Custom (Advanced)

4. Select the default settings and click next

5. Choose to install the operating system later, and click next.

6. Client operating system selection: Linux (L)

Version selection Red Hat Enterprise Linux 6

Click next

7. Virtual machine name: can be set at will, specified as RHEL6.4 here

Location: you can also specify any location, this time as the E:\ 11g_vm folder.

Click next

8, keep the default here, select the next step

9, memory size, not less than 2048MB is recommended.

Click next

10, choose to use bridging network, and click next

11J SCSI controller: LSI Logic, click next.

12, virtual disk type: SCSI

Click next

13, choose to create a new disk

Click next

14, disk size: not less than 40GB is recommended. Other options remain default. Click next.

15, disk files: just keep the default, and click next

16, click finish

17, click to edit virtual machine settings

18. Select CD/DVD (SATA), check the connection at startup, and select to use IOS image file in the connection section:

And click Browse to specify the rhel-server-6.4-x86_64.iso file to be downloaded at the beginning

19, click Open

20, click OK

3, install linux 6.4,

1, click to start this virtual machine

2. The following interface appears. Click the mouse on the interface, and the default selection is the first item. Enter.

(note: to cut the mouse out of the virtual machine, use the ctrl+ alt key)

3. When the Disc Found interface appears, select Skip and enter

4. Go to the following interface and click Next

5. Select English and click Next

6. Select U.S.English on the keyboard and click Next

7. Select Basic Storage Devices and click Next

8, the interface will pop up and Yes,discard any data will be selected in the pop-up interface.

9, enter the hostname: rhel6, and click Next

10, time zone selection: Asia/Shanghai, click Next

11. Set the password of the root user: oracle, and confirm, click Next

12, the password is too simple, so pop-up prompt dialog box, select Use Anyway

13, the following screen appears, select Replace Existing Linux System (s), and click Next

14, select Write changes to disk in the pop-up dialog box

15, select the Customize now below, and click Next

16. In order to configure the services that need to be installed in linux, there are many services to be selected. Please deal with them carefully.

Note that you need to right-click on the following components and select Select all optional packages.

The following components need to be installed:

Base System selects the following components

Base

Compatibility libraries

Console Internet tools

Debugging Tools

Hardware monitoring utilities

Java Platform

Large Systems Performances

Legacy UNIX compatibility

Networking Tools

Performance Tools

Security Tools

Storage Availability Tools

Servers selects the following components

FTP server

Network Infrastructure Server

Network Storage Server

Server Platform

System administration tools

Web Services

At will

Databases

At will

System Management selects the following components

SNMP Support

System Management

Web-Based Enterprise Management

Vitualization

At will

Desktops selects the following components

Desktop

Desktop Debugging and Performance Tools

Desktop Platform

General Purpose Desktop

Graphical Administartion Tools

KDE Desktop

Legacy X Window System compatibility

Remote Desktop Clients

X Window System

Applications selects the following components

Graphics Creation Tools

Internet Browser

Development selects the following components

Additional Development

Desktop Platform Development

Development tools

Server Platform Development

Languages

At will

After selecting all of them, click Next

17, go to the installation progress page and wait for the installation to finish

18. After installation, go to the following interface and click Reboot.

19. During the restart process, there will be a page to select the operating system, and you can enter directly. When the restart is complete, enter the following interface and click Forward

20, select Yes,I agree to the License Agreement, and click Forward

21, software update page, click Forward directly

22, create a user interface and click Forward directly

23, set the date and time, and try to keep it consistent with the operating system time, click Forward

24J Kdump page, cancel Enable kdump, click finish

25, select Yes in the pop-up interface

26, select OK in the pop-up interface and restart the virtual machine again.

At this point, the operating system is installed.

4, configure linux

1. After the restart is completed, the following screen appears, and click Other....

2, enter the user name: root

Password: oracle, click log in

Enter the following interface, check Do not show me this again, and click Close

3. Right-click on the desktop, select Open in Terminal, and open a terminal.

4. In the open window, enter the following command

Cat / etc/sysconfig/network, the following results appear. If the value after HOSTNAME is not rhel6, it needs to be modified.

The modified command is vi / etc/sysconfig/network. You can use r (replace), I (insert) and other commands to modify it. Then press Esc and type: X to save the exit. Then type reboot to restart.

5. Turn off the firewall and enter the following command: service iptables stop, enter

6. To permanently turn off the firewall, you need to enter the following command: chkconfig iptables off, and then enter enter

7, close selinux

Commands are as follows: vi / etc/selinux/config

Change the content after SELINUX to disabled, then press Esc, and then type: X to save the exit.

8, modify ip

Commands are as follows: vi / etc/sysconfig/network-scripts/ifcfg-eth0

Make the following changes to its contents:

ONBOOT is yes

BOOTPROTO is static

Then add three more lines:

IPADDR=192.168.200.111

NETMASK=255.255.255.0

GATEWAY=192.168.200.254

Then press Esc and type: X to save the exit.

9, modify the hosts file

The command is as follows:

Vi / etc/hosts

Add the following at the end:

192.168.200.111 rhel6

Then press Esc and type: X to save the exit.

Next, install VMware tools.

1. Select the virtual machine from the virtual machine menu, and click install VMware Tools.

The following window appears

2, drag the VMwareTools-9.6.1-1378637.tar.gz from this folder to the desktop, then right-click, select Extract Here, and extract it to the desktop. The unzipped folder is vmware-tools-distrib, double-click to open it

3, double-click the vmware-install.pl inside, and select Run in Terminal

4, the following window appears, and then enter all the way until the installation is complete.

5, after the installation, the window will automatically close, and then you need to restart the machine.

Enter the following command on the command line: reboot, and then enter

6. At this point, vmware tools is installed.

After the virtual machine restart is complete, you can drag any files into the virtual machine. If you can drag and drop into the virtual machine, it indicates that the vmware tools installation is successful.

Here, you can take a snapshot first. Click

A snapshot can be generated by pressing the button in the.

5. Install oracle database software

After the installation and configuration of the virtual machine operating system, you can install and configure the database. First of all, the following preparations need to be made.

Preparatory work:

1. Kernel parameter modification

At the end of the file, add the following

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

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

Then press Esc, and then type: X to save exit

Then, execute sysctl-p to see if there is a problem with the output

2. Set up users and groups

Enter the following commands in turn on the command line

Groupadd-g 1000 oinstall

Groupadd-g 1001 dba

Useradd-u 1000-g oinstall-G dba oracle

Passwd oracle

The last command is to set the password of the oracle user, this time to oracle

3, create a directory

Enter the following commands in turn:

Mkdir-p / u01/oracle

Chown-R oracle:oinstall / u01 /

Cd

Su-oracle

Cd / u01

Ls-lrt

4. Configure environment variables

Enter the following commands in turn on the command line:

Cd

Vi .bash _ profile

At the end of the file, add the following:

Export ORACLE_BASE=/u01/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

Export ORACLE_SID=ora11g

Export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

Then press Esc, and then type: X to save exit

Then enter source .bash _ profile

5. Resource limit setting

Enter the following commands in turn on the command line:

Su

-- the password of the root user needs to be entered here: oracle

Cd

Vi / etc/security/limits.conf

At the end of the file, add the following:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

Then press Esc, and then type: X to save exit

6. Upload and decompress the database installation software.

Db_112040_Linux-x86-64_1of7.zip

And db_112040_Linux-x86-64_1of7.zip are all dragged onto the desktop of the virtual machine.

Then execute the following command in the command:

Cd

Cd Desktop/

Mv * .zip / U01

Cd / u01

Ls

Then decompress the two files

The decompression command is:

Unzip db_112040_Linux-x86-64_1of7.zip

After the first one is decompressed, then the second one is decompressed. The command is as follows

Unzip db_112040_Linux-x86-64_2of7.zip

After both files are unzipped, the extracted files are automatically placed in a new directory under the current location, database.

Then execute the following command:

Chown-R oracle:oinstall database/

Then execute the command xhost +

At this point, the preparation for the database installation is complete.

Next, start installing the database

1, execute the following command:

Su-oracle

Cd / u01/database

. / runInstaller

Go to the following interface and cancel

The check box in front of I wish to receive security updates via My Oracle Support, click Next

Click yes in the pop-up dialog box

2. Select Skip software update and click Next

3. Select Install database software only and click Next

4. Select Single instance database installation and click Next

5, language selection, keep the default, click Next

6. Select Enterprise Edition and click Next

7. Select the product installation directory and keep it by default. Click Next.

8, product catalog and user group settings, keep the default, click Next

9. Select the database management group, keep the default, and click Next

10, check the page before installation

11. After the inspection, it was found that some package was missing.

At this point, everything except the last pdksh-5.2.14 needs to be installed.

We need to configure yum to install the missing rpm package.

1), click

From the virtual machine menu in, select Settings.

Select CD/DVD (SATA), check connected and connected at startup, and in the connection section below, select use ISO image file, then click Browse, select the original downloaded rhel-server-6.4-x86_64.iso file, then open it, and click OK.

2) in the virtual machine, re-open a new terminal with the right mouse button and enter the following command:

Then execute the following command

Cd / etc/yum.repos.d

Vi rhel6-public.repo

Enter the following in the empty file:

[rhel6]

Name=rhel6

Baseurl= file:///mnt/Server

Enabled=0

Gpgcheck=1

Then press Esc, and then type: X to save exit.

At this point, the yum is configured.

3), install the exact rpm package

Execute the following commands in turn:

Yum install libaio-devel-0.3.107-10.el6.x86_64.rpm

After the command is executed, the following prompt appears:

Is this ok [y/N]:

Enter y this time.

Then execute the following installation command:

Yum install compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm

Yum install elfutils-libelf-devel-0.152-1.el6.x86_64.rpm

Yum install libstdc++-devel-4.4.7-3.el6.x86_64.rpm

Yum install gcc-c++-4.4.7-3.el6.x86_64.rpm

Note that you need to install all the missing packages successfully this time.

After each installation of a rpm, you can click Check Again on the database installation page again until the following interface appears:

Click Ignore All at this point, and then click Next. And click yes in the pop-up box.

13, go to the following interface and click install

14, go to the installation page and wait

15. When the installation progress reaches 94%, the following dialog box pops up, requiring you to execute two scripts.

16, execute the script

Open a new window on the desktop and run the following command when prompted:

Sh / u01/oraInventory/orainstRoot.sh

Sh / u01/oracle/product/11.2.0/root.sh

Note: the order of execution of these two commands cannot be reversed. If you are prompted for input during the execution of the command, enter directly.

17. After running, click OK, then enter the following interface, click close

At this point, complete the installation of the database software.

6, create the database

You need to create a monitor first.

1, enter the following command on the command line:

Su-oracle

Netca

Launch the monitoring creation interface, select the first Listener configuration, and click Next

2. Select Add and click Next

3. You need to enter the name of the monitor here, keep it by default, and click Next

4. Select the protocol used for monitoring, keep the default, and click Next

5. Select the port used for listening, use the default 1521, and click Next

6. Do not create other listeners, select no, and click Next

7, click Next

8, click Finish

The monitor has been created.

Next, create the database

1, enter the following command on the command line:

Dbca (Note: like netca above, this command needs to be executed under the oracle user)

The following screen appears, click Next

2. Select Create a Database and click Next

3. Select General Purpose or Transaction Processing and click Next

4. Enter the database name: ora11g, and click Next

5, keep the default, click Next

6. Select use the Same Administrative Password for All Accounts

The password is set to oracle

Click Next and click yes in the pop-up dialog box

7, keep the default, click Next

8, keep the default, click Next

9. Check Sample Schemas and click Next

10, keep the default, click Next

11, click Next

12, select Create Database, click Finish, and click OK in the pop-up box

13, you can go to the database creation page and wait

14, installation is complete, click Exit in the pop-up page

At this point, the database is created successfully.

15, test

Enter the following command on the command line:

Sqlplus / as sysdba

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report