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

AIX7.1 installation oracle 11g

2025-03-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Environment configuration:

1)。 Operating system version:

# oslevel-s

7100-01-06-1241

Mirror rootvg:

# lsdev-Cc disk-# View the allocation of the system disk

Hdisk0 Available 07-08-00 SAS Disk Drive

Hdisk1 Available 07-08-00 SAS Disk Drive

Hdisk2 Available 07-08-00 SAS Disk Drive

# chdev-l hdisk1-a pv=yes-- # configure hdisk1 as PV

Hdisk1 changed

# extendvg-f rootvg hdisk1-- # configure hdisk1 into rootvg (you can add the-f parameter to force the operation added to rootvg)

# mirrorvg rootvg

0516-1804 chvg: The quorum change takes effect immediately.

0516-1126 mirrorvg: rootvg successfully mirrored, user should perform

Bosboot of system to initialize boot records. Then, user must modify

Bootlist to include: hdisk1 hdisk0.

# bosboot-a-d / dev/hdisk1-- # add boot information to the new disk

Bosboot: Boot p_w_picpath is 53276 512 byte blocks.

# bootlist-m normal hdisk0 hdisk1-- change the boot order

# lsvg-l rootvg

Rootvg:

LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT

Hd5 boot 1 2 2 closed/syncd N/A

Hd6 paging 33 66 2 open/syncd N/A

Hd8 jfs2log 1 2 2 open/syncd N/A

Hd4 jfs2 2 4 2 open/syncd /

Hd2 jfs2 5 10 2 open/syncd / usr

Hd9var jfs2 1 2 2 open/syncd / var

Hd3 jfs2 39 78 2 open/syncd / tmp

Hd1 jfs2 1 2 2 open/syncd / home

Hd10opt jfs2 1 2 2 open/syncd / opt

Hd11admin jfs2 1 2 2 open/syncd / admin

Lg_dumplv sysdump 6 12 2 open/syncd N/A

Livedump jfs2 1 2 2 open/syncd / var/adm/ras/livedump

Install the CDE graphical interface:

# smit install_bundle

Installation path selection / dev/cd0

INPUT device / directory for software [/ dev/cd0]

Select CDE as the installation option, such as

# Bundle (Locations)

AllDevicesKernels

Alt_Disk_Install

App-Dev

CC_EVAL.DocServices

CC_EVAL.Graphics

CDE

DocServices

GNOME

Finally, select the installation settings, such as.

* INPUT device / directory for software / dev/cd0

* BUNDLE CDE

* SOFTWARE to install [all]

……

ACCEPT new license agreements? Yes

Enter and insert the second CD with the installation prompt until the final installation is completed.

Start CDE

A. Automatically start AIX when CDE starts. Log in as the root user and execute on the command line:

# / usr/dt/bin/dtconfig-e

B. Start CDE on the command line:

# / etc/rc.dt;exit

# / usr/dt/bin/dtlogin-daemon

C. Confirm that CDE has been started:

# ps-ef | grep dtlogin

# netstat-an | grep 177

2)。 Modify the system time and time zone:

3)。 Create oracle users and user groups:

# id oracle

Uid=202 (oracle) gid=201 (oinstall) groups=402 (dba), 403 (oper)

4) create the directory where the oracle database is installed:

Create datavg

# mkdir / u01

# mklv-t jfs2-y lv_databack datavg 100G

-t is the logical volume type

-y is the name of the logical volume

Datavg is the specified volume group

# crfs-v jfs2-d lv_databack-A yes-m / databack

-v is the type of file system

-d is the name of the logical volume

-An is automatically mounted after the system restart

-m is the mounted directory

# mount / u01

# df-g / U01

Filesystem GB blocks Free Used Iused Iused Mounted on

/ dev/lv_u01 100.00 83.91 17% 42585 1%

$mkdir-p / u01/app/oracle/product/11.2.0/db_1

Modify directory permissions

Modify the oracle environment variable:

Export ORACLE_SID=ORCL

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export PATH=$PATH:$ORACLE_HOME/bin

Effective:

$. / .profile

5) bind the Nic:

Before binding:

# lsdev-Cc adapter

Ent0 Available 01-08 2-Port 10 Base-TX PCI-X Adapter 100 Base-TX PCI-X Adapter (14108902)

Ent1 Available 01-09 2-Port 10 Base-TX PCI-X Adapter 100 Base-TX PCI-X Adapter (14108902)

Binding method: smitty etherchannel

After binding, more ent2 network cards are added.

# lsdev-Cc adapter | grep ent

Ent0 Available 01-08 2-Port 10 Base-TX PCI-X Adapter 100 Base-TX PCI-X Adapter (14108902)

Ent1 Available 01-09 2-Port 10 Base-TX PCI-X Adapter 100 Base-TX PCI-X Adapter (14108902)

Ent2 Available EtherChannel / IEEE 802.3ad Link Aggregation

6) hosts file:

# cat / etc/hosts | grep oracle

192.168.1.98 oracle

7) expand the swap partition:

Chps-s 3 hd6 switching partition

# lsps-a

Page Space Physical Volume Volume Group Size Used Active Auto Type Chksum

Hd6 hdisk0 rootvg 16896MB 1 yes yes lv 0

Basic conditions for installation:

The following operating system filesets are required for AIX 7.1:

Bos.adt.base

Bos.adt.lib

Bos.adt.libm

Bos.perf.libperfstat

Bos.perf.perfstat

Bos.perf.proctools

XlC.rte.11.1.0.2 or later

Gpfs.base 3.3.0.11 or later

Other system settings

Default:

Fsize =-1

Core =-1

Cpu =-1

Data =-1

Rss =-1

Stack =-1

Nofiles =-1

2.4 system parameter file

Lsattr-EH-l sys0-a ncargs checks the value of the kernel parameter ncargs

Lsattr-EH-l sys0-a maxuproc checks the value of the kernel parameter maxuproc

Ioo-o aio_maxreqs checks the value of the kernel parameter maxreqs in AIX7.1

Modify the command:

Chdev-l sys0-a ncargs=256

Chdev-l sys0-a maxuproc=16384

Ioo-o aio_maxreqs=65536 checks the value of the kernel parameter maxreqs in AIX6.1

Modify the command:

No-p-o tcp_ephemeral_low=9000

No-p-o tcp_ephemeral_high=65500

No-p-o udp_ephemeral_low=9000

No-p-o udp_ephemeral_high=65500

No-p-o udp_sendspace=655360

No-p-o udp_recvspace=655360

No-p-o tcp_sendspace=655360

No-p-o tcp_recvspace=655360

No-p-o rfc1323=1

No-p-o sb_max=1310720

No-r-o ipqmaxlen=512

Upload oracle installation image:

Jar xvf mirror .ZIP.

Installation

If you encounter an INS-30060 error, the solution: # chmod 775R / tmp/CVU_11.2.0.3.0_oracle,

Installation completed:

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 29 14:17:59 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL >! oslevel

7.1.0.0

Add: resolve the error in the NFS file of AIX mount LINUX:

# showmount-e 192.168.1.13

Export list for 192.168.1.13:

/ var/ftp/software *. *

# mount 192.168.1.13:/var/ftp/software / software

Mount: 1831-008giving up on:

192.168.1.13:/var/ftp/software

Vmount: Operation not permitted.

Solution:

# nfso-o nfs_use_reserved_follvports=1

Setting nfs_use_reserved_ports to 1

# mount 192.168.1.13:/var/ftp/software / software

# df-g / software

Filesystem GB blocks Free Used Iused Iused Mounted on

192.168.1.13:/var/ftp/software 1574.90 948.00 73951 1 per cent / software

=

# mkgroup -'A' id='2000' adms='root' finstall

# mkgroup -'A' id='2001' adms='root' fdba

# mkgroup -'A' id='2002' adms='root' foper

# mkuser id='2010' pgrp='finstall' groups='fdba,foper' home='/home/fol' fol

# id fol

Uid=2010 (fol) gid=2000 (finstall) groups=2001 (fdba), 2002 (foper)

# passwd fol

Changing password for "fol"

Fol's New password:

Enter the new password again:

# chdev-l hdisk30-a pv=yes

Hdisk30 changed

# mkvg-f-y datavg hdisk30

Datavg

Boot self-start

# chvg-ay datavg

# mkdir / fol

# mklv-t jfs2-y follv datavg 100G

Follv

# crfs-v jfs2-d follv-A yes-m follv

File system created successfully.

104854196 kilobytes total disk space.

New File System size is 209715200

Mkdir-p / fol/app/oracle/product/11.2.0/db_1

Chown-R fol:finstall / fol/app/oracle

# chown-R fol:finstall / fol/app/oracle

# chmod-R 775 / fol/app/

Export ORACLE_SID=CWFOLB

Export ORACLE_BASE=/fol/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export PATH=$PATH:$ORACLE_HOME/bin

. / runInstaller-invPtrLoc / fol/app/oracle/oraInst.loc

Mklv-t jfs2-y foldata datavg 450G

Crfs-v jfs2-d foldata-A yes-m / foldata

Mklv-t jfs2-y folarch datavg 250g

Crfs-v jfs2-d folarch-A yes-m / folarch

Mklv-t jfs2-y folback datavg 150G

Crfs-v jfs2-d folback-A yes-m / folback

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