天天看點

Oracle Study之--AIX 6.1安裝Oracle 10gR2

1、系統硬體平台

#prtconf |more

2、系統軟體環境

<b>#oslevel  -r</b>

<b>6100-01</b>

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

------ 如果缺少所需的軟體,可以從aix 6.1系統盤1#安裝!

3、建立Oracle使用者群組(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

----并修改Oracle使用者對資源通路的限制 !

4、root使用者做安裝前的環境檢測

# ./rootpre.sh

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

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

Copying new kernel extension to /etc....

Loading the kernel extension from /etc

 Oracle Kernel Extension Loader for AIX 

       Copyright (c) 1998,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.

Checking if group services should be configured....

Nothing to configure.

---- 檢測提示“異步I/O"沒有被啟用,經查詢,在AIX 6.1下會當有I/O請求時,自動啟用異步I/O 。

檢視系統I/O情況:

# ioo -a |grep aio

                    aio_active = 0                      ;aio未啟動

                   aio_maxreqs = 65536

                aio_maxservers = 40

                aio_minservers = 10

         aio_server_inactivity = 300

              posix_aio_active = 0                       ;aio未啟動

             posix_aio_maxreqs = 65536

          posix_aio_maxservers = 30

          posix_aio_minservers = 3

   posix_aio_server_inactivity = 300

5、Oracle使用者安裝Oracle軟體

$ ./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? [y/n] (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.

Oracle Study之--AIX 6.1安裝Oracle 10gR2
Oracle Study之--AIX 6.1安裝Oracle 10gR2
Oracle Study之--AIX 6.1安裝Oracle 10gR2

------  可以看到警告資訊,Oracle 10gR2預設不支援aix 6.1 !

Oracle Study之--AIX 6.1安裝Oracle 10gR2
Oracle Study之--AIX 6.1安裝Oracle 10gR2

----  Oracle安裝成功 !

6、建立listener

$ netca

Oracle Net Services Configuration:

Oracle Study之--AIX 6.1安裝Oracle 10gR2

$ 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、建立資料庫

$ dbca

Oracle Study之--AIX 6.1安裝Oracle 10gR2

8、登陸資料庫通路

$ 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&gt; select status from v$instance;

STATUS

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

OPEN

SQL&gt; 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&gt; 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.

檢視異步I/O資訊,可以看到系統異步I/O已被啟用:

                    aio_active = 1

              posix_aio_active = 1

----- 至此,在AIX 6.1上安裝Oracle 10gR2成功 !

本文轉自 客居天涯 51CTO部落格,原文連結:http://blog.51cto.com/tiany/1746861,如需轉載請自行聯系原作者