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

Oracle Study-- AIX 6.1 install Oracle 10gR2

1. System hardware platform

# prtconf | more

System Model: IBM,9131-52A Machine Serial Number: 10367FG Processor Type: PowerPC_POWER5 Processor Implementation Mode: POWER5 Processor Version: PV_5_2 Number Of Processors: 2 Processor Clock Speed: 1898 MHz CPU Type: 64-bit Kernel Type: 64-bit LPAR Info: 1 10-367FG Memory Size: 1904 MB Good Memory Size: 1904 MB Platform Firmware level: SF240_219 Firmware Version: IBM SF240_219 Console Login: enable Auto Restart: true Full Core: false Network Information Host Name: aix210 IP Address: 192.168.210 Sub Netmask: 255.255.255.0 Gateway: Name Server: Domain Name: Paging Space Information Total Paging Space: 2048MB Percent Used: 2%

2. System software environment

# oslevel-r

6100-01

# lslpp-l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools

Fileset Level State Description-Path: / usr/lib/objrepos bos.adt.base 6.1.1. 0 COMMITTED Base Application Development Toolkit bos.adt.lib 6.1.0.0 COMMITTED Base Application Development Libraries bos.adt.libm 6.1.1.0 COMMITTED Base Application Development Math Library bos.perf.libperfstat 6.1.1.0 COMMITTED Performance Statistics Library Interface bos.perf.perfstat 6.1.1.0 COMMITTED Performance Statistics Interface bos.perf.proctools 6.1.1.0 COMMITTED Proc Filesystem ToolsPath: / etc/ Objrepos bos.adt.base 6.1.1.0 COMMITTED Base Application Development Toolkit bos.perf.libperfstat 6.1.1.0 COMMITTED Performance Statistics Library Interface bos.perf.perfstat 6.1.1.0 COMMITTED Performance Statistics Interface

-if you lack the required software, you can install it from the aix 6.1 system disk!

3. Create Oracle users and groups (install, dba)

# id oracle

Uid=300 (oracle) gid=300 (oinstall) groups=301 (dba)

# chown-R oracle:dba / U01

# su-oracle

$mkdir-p / u01/app/oracle

-and modify Oracle users' restrictions on resource access!

4. Root users check the environment before installation

#. / rootpre.sh

. / rootpre.sh output will be logged in / tmp/rootpre.out_16-03-02.15

Saving the original files in / etc/ora_save_16-03-02.15 purl 44purl 46....

Copying new kernel extension to / etc....

Loading the kernel extension from / etc

Oracle Kernel Extension Loader for AIX

Copyright (c) 1998 and 1999 Oracle Corporation

Successfully loaded / etc/pw-syscall.64bit_kernel with kmid: 0x20883000

Successfully configured / etc/pw-syscall.64bit_kernel with kmid: 0x20883000

The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Configuring POSIX Asynchronous I/O....

Posix Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Checking if group services should be configured....

Nothing to configure.

-the detection indicates that "Asynchronous Igamo" is not enabled. After query, it will automatically enable Asynchronous Icano when there is a request for it under AIX 6.1s.

Check the system Icano condition:

# ioo-a | grep aio

Aio_active = 0; aio is not started

Aio_maxreqs = 65536

Aio_maxservers = 40

Aio_minservers = 10

Aio_server_inactivity = 300

Posix_aio_active = 0; aio is not started

Posix_aio_maxreqs = 65536

Posix_aio_maxservers = 30

Posix_aio_minservers = 3

Posix_aio_server_inactivity = 300

5. Oracle users install Oracle software

$. / runInstaller

*

Your platform requires the root user to perform certain pre-installation

OS preparation. The root user should run the shell script 'rootpre.sh' be

Fore

You proceed with Oracle installation. Rootpre.sh can be found at the top

Level

Of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle

Installation.

Answer 'n'to abort installation and then ask root to run 'rootpre.sh'.

*

Has' rootpre.sh' been run by root? [YBO] (n)

Y

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

Preparing to launch Oracle Universal Installer from / tmp/OraInstall2016-03-02. 04-50-31PM. Please wait... $Mar 2, 2016 4:50:50 PM java.util.prefs.FileSystemPreferences$2 run

INFO: Created user preferences directory.

Mar 2, 2016 4:50:54 PM java.util.prefs.FileSystemPreferences$3 run

INFO: Created system preferences directory in java.home.

-you can see the warning message. Oracle 10gR2 does not support aix 6.1by default!

-Oracle installed successfully!

6. Create listener

$netca

Oracle Net Services Configuration:

$lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0-Production on 02-MAR-2016 17:21:19

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=aix210) (PORT=1521)

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0-Production

Start Date 02-MAR-2016 17:21:11

Uptime 0 days 0 hr. 0 min. 8 sec

Trace Level off

Security ON: Local OS Authentication

SNMP ON

Listener Parameter File / u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File / u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=aix210) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC0)

Services Summary...

Service "PLSExtProc" has 1 instance (s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for this service...

The command completed successfully

7. Create a database

$dbca

8. Log in to the database to access

$sqlplus'/ as sysdba'

SQL*Plus: Release 10.2.0.1.0-Production on Wed Mar 2 17:31:46 2016

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options

SQL > select status from v$instance

STATUS

-

OPEN

SQL > show parameter name

NAME TYPE VALUE

-

Db_file_name_convert string

Db_name string prod

Db_unique_name string prod

Global_names boolean FALSE

Instance_name string prod

Lock_name_space string

Log_file_name_convert string

Service_names string prod

SQL > select name from v$datafile

2 union all

3 select name from v$controlfile

NAME

/ u01/app/oracle/oradata/prod/system01.dbf

/ u01/app/oracle/oradata/prod/undotbs01.dbf

/ u01/app/oracle/oradata/prod/sysaux01.dbf

/ u01/app/oracle/oradata/prod/users01.dbf

/ u01/app/oracle/oradata/prod/example01.dbf

/ u01/app/oracle/oradata/prod/control01.ctl

/ u01/app/oracle/oradata/prod/control02.ctl

/ u01/app/oracle/oradata/prod/control03.ctl

8 rows selected.

Looking at the asynchronous Iripple O information, you can see that the system asynchronous Iripple O has been enabled:

# ioo-a | grep aio

Aio_active = 1

Aio_maxreqs = 65536

Aio_maxservers = 40

Aio_minservers = 10

Aio_server_inactivity = 300

Posix_aio_active = 1

Posix_aio_maxreqs = 65536

Posix_aio_maxservers = 30

Posix_aio_minservers = 3

Posix_aio_server_inactivity = 300

-at this point, the installation of Oracle 10gR2 on AIX 6.1 was successful!

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.