您好,登錄后才能下訂單哦!
Oracle Study之--AIX 6.1安裝Oracle 10gR2
1、系統(tǒng)硬件平臺(tái)
#prtconf |more
System Model: IBM,9131-52A Machine Serial Number: 10367FG Processor Type: PowerPC_POWER5 Processor Implementation Mode: POWER 5 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.8.210 Sub Netmask: 255.255.255.0 Gateway: Name Server: Domain Name: Paging Space Information Total Paging Space: 2048MB Percent Used: 2%
2、系統(tǒng)軟件環(huán)境
#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 Tools Path: /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
------ 如果缺少所需的軟件,可以從aix 6.1系統(tǒng)盤(pán)1#安裝!
3、創(chuàng)建Oracle用戶(hù)和組(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用戶(hù)對(duì)資源訪(fǎng)問(wèn)的限制 !
4、root用戶(hù)做安裝前的環(huán)境檢測(cè)
# ./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.
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.
---- 檢測(cè)提示“異步I/O"沒(méi)有被啟用,經(jīng)查詢(xún),在AIX 6.1下會(huì)當(dāng)有I/O請(qǐng)求時(shí),自動(dòng)啟用異步I/O 。
查看系統(tǒng)I/O情況:
# ioo -a |grep aio
aio_active = 0 ;aio未啟動(dòng)
aio_maxreqs = 65536
aio_maxservers = 40
aio_minservers = 10
aio_server_inactivity = 300
posix_aio_active = 0 ;aio未啟動(dòng)
posix_aio_maxreqs = 65536
posix_aio_maxservers = 30
posix_aio_minservers = 3
posix_aio_server_inactivity = 300
5、Oracle用戶(hù)安裝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 10gR2默認(rèn)不支持aix 6.1 !
---- Oracle安裝成功 !
6、創(chuàng)建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、創(chuàng)建數(shù)據(jù)庫(kù)
$ dbca
8、登陸數(shù)據(jù)庫(kù)訪(fǎng)問(wèn)
$ 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.
查看異步I/O信息,可以看到系統(tǒng)異步I/O已被啟用:
# 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
----- 至此,在AIX 6.1上安裝Oracle 10gR2成功 !
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。