ORACLE FOR AIX INSTALL GUIDE

ORACLE FOR AIX INSTALL GUIDE

AIX 4.3 ORACLE 8I

AIX

SHATAO2000@[Link]

SANDYBILLOWS
HTTP://[Link]
HTTP://[Link]
2003

[Link] 1
 ORACLE FOR AIX INSTALL GUIDE

UNIX Oracle

Oracle
AIX Oracle 8i
1
Oracle 8i
z

z AIX

z Oracle Oracle
z
Oracle
z Oracle 8i 2 8.1.7 CDROM

2
Oracle 8i
2 8.1.7 for AIX
z Oracle 8i 64 disk1 disk2
z Oracle 8i

1 Oracle 8i
1 Typical
Oracle Oracle

2 Mininal

Oracle
3 Custom

2 Oracle 8i
1

2
Oracle 8i

3
Oracle
8i

[Link] 2
 ORACLE FOR AIX INSTALL GUIDE

3
Oracle 8i 2 8.1.7

Oracle

1
Oracle 8i AIX

1
Oracle 8i 256MB Oracle 1GB
2
2GB
3 CDROM
AIX CDROM ISO9660 CDROM
2
Oracle

Oracle

3 Oracle 8i
z 1.4GB
z 1.1GB
z 3GB
4 Oracle 8i
z 350MB
z 260MB
z 150MB
z 470MB
5
Oracle 8i AIX

z AIX 4.3.3
z make,ar
z CDE
z
Oracle 8i CDROM AIX
Netscape Navigator4.0 PDF Adobe

[Link] 3
 ORACLE FOR AIX INSTALL GUIDE

Acrobat Reader 3.0 Oracle 8i 2 8.1.7 for AIX

AIX Windows
4
a) Oracle 8i
Oracle 8i
Oracle inter Media8.1.7
interMedia Text 10MB

b)

Java JRE 1.1.8

Oracle Jserver 8.1.7( Java (JVM) Java )

Oracle 8i CDROM Java
Oracle 8.1.7
Oracle 8 [Link]
Oracle 8i 8.1.5
Pro*C/C++ 8.1.7
GNU C egcs-1.1.2
c)

Net 8
Net 8 8.1.7 Oracle 8i 2 8.1.7
Net 8 8.1.7
1
Oracle Advanced Security Export Edition 8.1.7
Oracle
Oracle TCP/IP with SSL Protocol Support 8.1.7
SSL 3.0
2 Oracle
Oracle Net 8 Net 8

Oracle 8.1.7 Net 8 8.1.7 Oracle 8i

Oracle
3
SSL
Oracle Wallet Manager version2.1 Oracle

Oracle SSL
Oracle 8i 2 8.1.7 for AIX ,Oracle
SSL
5 AIX
AIX Oracle 8i Oracle

[Link] 4
 ORACLE FOR AIX INSTALL GUIDE

8i 28.1.7 , $ORACLE_HOME/relnotes
README ,README doc
HTML Oracle 8i CDROM README doc
admin/doc
1 ORACLE_HOME
Oracle 8i 2(8.1.7) 8.1.5 Oracle
ORACLE_HOME . Oracle 8i 2(8.1.7) 8.1.5
ORACLE_HOME ,Oracle 8.1.7
8.1.5 , , 8.1.7 8.1.5
.
Oracle Oracle8i 2(8.1.7)
ORACLE_HOME .
2 Java JRE
Oracle 8i JRE Oracle Java Oracle

JRE Oracle
JRE
oraInventory
OraInventory
/var/opt/oracle/[Link]
ORACLE_HOME $ORACLE_HOME/JRE
JRE JRE Oracle

1
2 Oracle
Oracle
X-Windows X

Oracle 8i Oracle
Oracle

3
Oracle 8i
Oracle Oracle
4
Oracle OFA Oracle Oracle
Oracle 8i

[Link] 5
 ORACLE FOR AIX INSTALL GUIDE

Oracle
8i
z AIX
z root
z Oracle
z Oracle
z Net 8
z
1 AIX
AIX Oracle 8i 1-9

1-9 AIX

Oracle 8i
AIX SHMMAX0.5*( ),

Oracle 8i
. ,

SHMMIN 1
SHMMNI 100
SHMSEG 10
SEMMNI 100
SEMMSL 10 Oracle
PROCESSES( )
PROCESSED [Link] ,
$ORACLE_HOME/dbs .
Oracle
50
SEMMNS Oracle PROCESSES ,
, 10.
“ Oracle 8i UNIX ”
SEMOPM 100
SEMVMX 32767
( : ,
. Oracle 8i ,
, .
, ,
)
Oracle : ,

[Link] 6
 ORACLE FOR AIX INSTALL GUIDE

. (OFA)
, . ,
. AIX OFA , Oracle 8i
Oracle OSDBA AIX .
AIX dba,OSOPER , OSDBA
Oracle ORACLE_HOME Oracle
oinstall AIX .
oraInventoty ORACLE_HOME . Oinstall
AIX Oracle
AIX Oracle AIX ,
oinstall OSDBA .
Oracle
Oracle , umask 022
Oracle_BASE OFA ,
“ORACLE_BASE”

2 root
root Oracle 8i
z Oracle 8i AIX
z
z AIX
z Oracle AIX
z Oracle AIX

/var/opt/oracle/[Link] ,
root root [Link]
1 Oracle 8i AIX
UNIX IPC Oracle 8i SGA
SGA
1 ipcs

2
z SHMMAX
z SHMMIN
z SHMMNI
z SHMSEG
z SEMMNI
z SEMMSL
z SEMMNS
z semop SEMOPM
z SEMVMX

[Link] 7
 ORACLE FOR AIX INSTALL GUIDE

SHMMAX*SHMSEG

Oracle PROCESSES
10 Oracle
[Link] PROCESSES
Oracle_SID=A PROCESSES=100
Oracle_SID=B PROCESSES=100
Oracle_SID=C PROCESSES=200
SEMMNS
SEMMNS=[ A=100 + B=100 ]+[ C=200 *2]+[# of instances=3 *10]=630

2
Oracle 8i
OFA

Oracle 8i /pm
P m 1-10

/u01 /u02
/u03
/u04

3 AIX
Oracle SYSDBA SYSOPER
AIX Oracle 8i AIX
OSDBA OSOPER Oracle Oracle
2 AIX
smit mkgroup dba
SYSOPER
Oracle Oracle SYSDBA SYSOPER AIX
dba Oracle 8i Oracle dba
Oracle
4 Oracle AIX
smit mkgroup oinstall oinstall
Oracle oraInventory Oracle
oinstall
Oracle AIX Oracle AIX
Oracle 8i Oracle
smit mkuser Oracle

[Link] 8
 ORACLE FOR AIX INSTALL GUIDE

z Oracle
z GID oinstall
z GID dba
z Oracle
ORACLE_HOME
z shell
/bin/sh /bin/ksh /bin/bsh Bourne
shell /bin/sh

Oracle Oracle Oracle 8i

root Oracle
ORACLE_HOME Oracle
Oracle Oracle oinstall
3 Oracle
Oracle
z
z
z
1
Oracle umask 022 group other

1 umask
2 umask 022 Oracle .profile .login

$umask 022

$ su root
Password:
# smit mkgroup
oracle oracle
5GB ‘/oracle’ oracle
Oracle Server
# smit mkuser

[Link] 9
 ORACLE FOR AIX INSTALL GUIDE

(2)
Oracle , DISPLAY PATH
1-11

Oracle

1-11

DISPLAY Oracle Yes

PATH shell Yes

ORACLE_BASE Oracle YES
ORACLE_HOME Oracle YES
NLS_LANG YES
ORA_NLS33 No
ORACLE_SID Oracle YES
ORACLE_DOC No

1 DISPLAY
Oracle DISPLAY IP X
IP
X-Windows
IP X
0

[Link] 10
 ORACLE FOR AIX INSTALL GUIDE

Failed to connect to server

Connection refused by server Can`t open display Xlib
X Bourne/Korn shell C shell Bourne
Korn shell
Oracle
$DISPLAY=workstation_name 0.0
$export DISPLAY
,
$ xhost+ server_name
C shell
Oracle
% setenv DISPLAY workstation_name 0.0

%xhost+server_name
2)PATH
SHELL
$ORACLE_HOME/bin, /usr/bin, /etc /bin
3)ORACLE_BASE
ORACLE_BASE Oracle OFA
/oracle/oracle/app/oracle, /oracle/oracle/app/oracle
OFA ORACLE_BASE,
4) ORACLE_HOME
ORACLE_HOME Oracle
$ORACLE_BASE/produce/release,
/oracle/oracle/app/oracle/product/8.1.7
ORACLE_HOME Oracle 8i 8.1.5
Oracle
5 NLS_LANG
US7ASCII
NLS_LANG( ) [Link],
NLS_LANG AMERICAN_AMERICA.ZHS16GBK
Oracle 8i
6) ORA_NLS33
US7ASCII
ORA_NLS33 ORA_NLS33
$ORACLE_HOME /ocommons/admin/data Oracle 8i

7 ORACLE_SID
ORACLE_SID Oracle
sid
ORACLE_SID
8 ORACLE_DOC
ORACLE_DOC ORACLE_DOC,

[Link] 11
 ORACLE FOR AIX INSTALL GUIDE

3
Oracle
.bashrc, profile .login
SHELL SHELL

oracle , vi oracle
.profile
vi .profile

ORACLE_HOME=/oracle/oracle/app/oracle/product/8.1.7
ORACLE_SID=bais
ORACLE_DOC=$ORACLE_HOME/doc
ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data
ORACLE_TERM=vt100
TMPDIR=/oracle/oracle/tmp
ORACLE_OWNER=oracle
NLS_LANG=American_America.ZHS16GBK
export ORACLE_TERM
export ORACLE_SID
export ORACLE_DOC
export ORACLE_HOME
export NLS_LANG
export ORACLE_OWNER
export TMPDIR

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$ORACLE_HOME/bin:/usr/bin/
X11:/sbin:.
export PATH TERM
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.

oracle /oracle/oracle/tmp
/oracle/oracle/doc
$ mkdir /oracle/oracle/tmp
$ mkdir /oracle/oracle/doc

— oracle CD-ROM ROOT

su - root
# mkdir /cdrom
# mount -rv cdrfs /dev/cd0 /cdrom
# exit

[Link] 12
 ORACLE FOR AIX INSTALL GUIDE

4 Oracle

1 Pro*C/C++ Precompiler
2 C PATH
2
1 Net 8
Net 8 Net 8

$ lsnrctl status
listener , listener_name .

$ lsnrctl stop
“ Net 8 Net 8
2 Oracle

3 TCP/IP
TCP/IP Oracle 8i
ftp
$ ftp remote_server_name
ftp>put test_filename
ftp>get test_filename
5) Net 8
Net 8 (GUI) , Oracle
/ .Net 8 Oracle

Oracle Net 8
Net 8 Net 8
Net 8 *

*
$ORACLE_HOME/network/admin
5

1-12

[Link] 13
 ORACLE FOR AIX INSTALL GUIDE

1-12

Oracle 8i Net 8
Oracle 8i Net 8 Net8
1 1 [Link]: listener
2 , ( 1521
TCP/IP) Oracle 8i IPC

(2)[Link]: (
).

(3)[Link]: [Link]
(EXTPROC_CONNECTION_DATA)
Oracle Oracle 8i
Net 8
(4)[Link]: Oracle 8i
( : LDAP
.LDAP )
Oracle 8i Net 8 :
Oracle8i ,
( ,
Net 8 . ORACLE_HOME,
Net 8 .

( ,
[Link] ).
, (
, , SID,
)
Net 8 Net 8

1)[Link]
,

(2)[Link]
( ).

(3)[Link]
,
(4)[Link]
.

[Link] 14
 ORACLE FOR AIX INSTALL GUIDE

Oracle Oracle 8i ,
Net 8
(5)[Link]

7)

1-13

1-13

Oracle 8i Net 8 Oracle 8i

1
2
3
Oracle 8i

Net 8
Oracle 8i

Net 8 Net 8

1 [Link]

2 [Link]

3 [Link]

Oracle 8i Net 8

Net 8
Oracle_HOME,
( ,
[Link] ). ,
( , ,
SID, )Net 8
Net 8
(1)[Link]
(OPS$)
( ).

[Link] 15
 ORACLE FOR AIX INSTALL GUIDE

(2)[Link]
,
(3)[Link]
,
.
8)
Oracle Oracle 8i
Oracle 8i 1-14 Oracle 8i

1-14 Oracle 8i

OLTP SELECT INSERT

UPDATE DELETE

DSS

1 DB_BLOCK_BUFFERS
2 DB_BLOCK_SIZE
3 PROCESSES
4 SHARED_POOL_SIZE
5
9)
Oracle GUI OLTP
Oracle 8i
Oracle 8i Oracle Oracle

Oracle Oracle
Oracle 8i Oracle 8i
OLTP

1 Oracle

1
2 Oracle interMedial
3
4
5 NOARCHIVE LOG

[Link] 16
 ORACLE FOR AIX INSTALL GUIDE

6 SID
Oracle Oracle

Oracle 8i
2
Yes

No
Oracle SQL

Oracle 8i Oracle
Oracle
Oracle
Oracle 8i Oracle interMedia

3 Available Products Oracle

Yes Oracle

Oracle
OLTP
interMedia

1
2
3
4
5
6
3
Oracle

1 CD
Oracle Oracle 8i
interMedia
SID
2
Oracle OLTP
Oracle
interMedia

Oracle Jserver IIOP

OLTP 20

[Link] 17
 ORACLE FOR AIX INSTALL GUIDE

Oracle Oracle 8i

z Oracle
z
2 Oracle
Oracle Oracle
8icdrom Oracle

Oracle 8.0.x Oracle

8.1 ORACLE_HOME . , 8.1
8.0.x ORACLE_HOME .
(1) Oracle 8i CDROM
Oracle 8i CDROM ISO 9660 CDROM root
CDROM umount
Oracle 8i CDROM CDROM root
CDROM

$ su root
# mkdir /cdrom
CDROM root :
# mount -rv cdrfs /dev/cd0 /cdrom
# exit
: CDROM
$ su root
# mkdir /cdrom
# mount -rv cdrfs /dev/cd0 /cdrom
# exit

(2) Oracle
:
root .
:
1) oracle
2) CDROM :

$su
# cd /cdrom
# ./[Link]
#exit

3) “./runInstaller”

[Link] 18
 ORACLE FOR AIX INSTALL GUIDE

Oracle

Welcome Next
File Locations Source

Destination Oracle 8i Oracle_HOME .

, Oracle_HOME .
Oracle 8i 1(8.1.5) ,
2(8.1.7).Oracle 2(8.1.7)
ORACLE_HOME .
:
8.1.x Oracle_HOME,
. Oracle 8i Oracle
ORACLE_HOME , . ,
ORACLE_HOME Oracle 8i.
, “Next .
Oracle 8i , “Unix Group
Name” ; , .
“UNIX Group Name” , Oracle .
“ Oracle AIX ”
oinstall .
“Next” , /etc Oracle ,
root
/tmp/OraInstall/[Link]. , “Retry”
. , Available Products . ,
Oracle 8i , “Next” .
:
, A “Oracle 8i ”.
, ,
, : Oracle 8i Oracle 8i
* Oracle 8i
Installation Types
Next

Typical Mininal Custom

1
Oracle Oracle
Oracle Upgrade or Migrate an
Existing Database Oracle
Oracle 8i 2 8.1.7 .
“Next” . Mininal, “Starter Database” .
Tyoical, ( Oracle 8i ).
“Yes” Oracle 8i ; “No”
. Oracle , SQL

[Link] 19
 ORACLE FOR AIX INSTALL GUIDE

.
“Next” . Oracle “ AIX ”
dba dba AIX OSDBA ,
“Privileged Operating System Groups” , .
AIX OSOPER ,
Next” Database Identification Window”
SID

[Link]
bais [Link]
SID
SID
SID bais 8

Next” Summary”

Install”
[Link] [Link]
— root [Link]
$su
#
# cd $ORACLE_HOME
# ./[Link]

Configuration Tools”

Net8 Net8
ORACLE
oracle8I yes” ORACLE8i 8.1.7

ORACLE
Oracle 8i release 8.1.7

Configuration Tools”
Next” End of Installation”
Eixt” ORACLE Next Install”
Next Install” ORACLE File locations”

1
“Available Products”
Next”

[Link] 20
 ORACLE FOR AIX INSTALL GUIDE

Summary”

Install” [Link]
[Link] End of Installation”
ORACLE
ORACLE
„ ORACLE8i

A ORACLE8i
Installation Types” , Next”

Administrator, Programmer, or Application User(

) Custom
1
Next Summary”

Install” [Link]
[Link] End of Installation”
ORACLE
ORACLE
ORACLE

2
Installation Types”

Summary”

Install” [Link]
[Link] End of Installation”
End of Installation”
ORACLE
ORACLE
2 [Link]
ORACLE_HOME [Link] ORACLE
[Link] root ORACLE
root
# cd $ORACLE_HOME
# ./[Link]
ORACLE [Link]
[Link]
[Link] Oracle
[Link] OK
[Link]

[Link] 21
 ORACLE FOR AIX INSTALL GUIDE

[Link] bin
[Link]
3
oraInventory
OraInventory
/var/opt/oracle/[Link] oraInventory

oraInventory/logs/[Link]
[Link]
installActions2001-07-15_01-[Link]
4

Oracle
De-install Products
Remove
ORACLE_HOME

5
Oracle
Oracle 8i

Oracle
1
Oracle 8i 2 8.1.7 CDROM Oracle

Oracle 8i CDROM
$cd /cdrom/stage/Response/
$cp [Link] local_directory

Oracle 8i CDROM
1-15

Oracle 8i CDROM

[Link] Oracle 8i
[Link] Oracle 8i
[Link] Oracle 8i
[Link] Oracle 8i

[Link] 22
 ORACLE FOR AIX INSTALL GUIDE

[Link] Oracle 8i
[Link] Oracle 8i
[Link] Oracle
Net 8 [Link] Net 8

(2)
, “ Oracle ”
. ,

$ ./runInstaller[-silent]-response File filename

, -silent
DISPLAY DIAPLSY
[Link]
oraInvetory/logs/
oraInvetory/logs/[Link] . “
”

Oracle Oracle
8i
z root
z Oracle
z Oracle
z Oracle
z
z Oracle
1 root
root AIX

1 AIX
smit mkuser AIX

[Link] 23
 ORACLE FOR AIX INSTALL GUIDE

DBA OSDBA
SQL*plus

SQL>SELECT username FROM dba_users;

.
(2)
NCSC C2 ITSEC E3
Oracle 8i, , Oracle .
,

z Oracle Oracle
z Oinstall oraInventory

z Oracle oinstall Oracle

Oracle

1-16 Oracle
1-16 Oracle
/
redo 640 ,
rw-r---- redo
.dbf .log .ctl Oracle
oinstall
$ORACLE_HOME/bin 751 Oracle
rwxr-x--x
Oracle 6751 setuid setgid 6,
rws-r-s--x Oracle dba
$ORACLE_HOME/bin/oracle ,
$ORACLE_HOME/bin/dbsnmp
751 Oracle ,
rwxr-x--x
$ORACLE_HOME/lib/ 755
rwxr-xr-x
$ORACLE_HOME/lib/ 644
rw-r—r--
$ORACLE_HOME/rdbms/log 751
rwxr-x--xx Oracle oinstall
751
$ORACLE_HOME/sqlplus rwxr-x--x Oracle oinstall
$ORACLE_HOME/rdms

[Link] 24
 ORACLE FOR AIX INSTALL GUIDE

$ORACLE_HOME/sqlplus 644
$ORACLE_HOME/rdms rw-r--r--

$ORACLE_HOME/network/trace 777 777

rwxrwxrwx
730 730
rwx-wx--- Oracle oinstall

administration 644 SQL SYS

-rw-r—r--
$ORACLE_HOME/rdbms/admin

$ORACLE_HOME/sqlplus/admin

3
Oracle
Oracle

dbshut dbstart $ORACLE_HOME/bin

dbshut dbstart oratab

dbstart sid1 sid2
sid3 dbshut sid1 sid2 dbshut
dbstart
dbshut dbstart
init

dbstart dbshut
/etc/oratab
oratab
●Oracle_SID Oracle_HOME {Y|N}
Y N dbstart dbshut
sid
Y
● /etc/rc.d/init.d dbora

● dbora
dbstart
#!/bin/sh
#Set ORA_HOME to be equivalent to the Oracle_HOME
#from which you wish to execute dbstart and
#dbshut

[Link] 25
 ORACLE FOR AIX INSTALL GUIDE

#set ORA_OWNER to the user id of the owner of the

#Oracle database in ORA_HOME
ORA_HOME=/oracle/oracle/app/oracle/product/8.1.7
ORA_OWNER=oracle
If[! –f$ORA_HOME/bin/dbstar]
Then
Echo”Oracle startup:cannot start”
Exit
Fi
Case”$1”in
Start’
#Start the Oracle databases:
#The following commond assumes that the Oracle login will not prompt
the
#user for any values
su - $ORA_OWNER –c $ORA_HOME/bin/dbstart &;;’stop’
#Stop the Oracle database:
#The following command assumes that the Oracle login will not prompt
the
#user for any values
su - $ORA_OWNER –c $ORA_HOME/bin/dbshut &
esac
dbora
#ln –s/etc/rc.d/init.d/dbora /etc/rc.d/rc0.d/K10dbora
#ln –s/etc/rc.d/init.d/dbora /etc/rc.d/rc0.d/S99dbora
2. Oracle
Oracle
● AIX
● oratab
● Oracle
●
1 AIX
Oracle AIX Oracle
●
Oracle 8i Oracle .profile .login
1-17

Bourne Korn shell

variable_name=value export variable_name
C shell
setenv variable_name value

Oracle

[Link] 26
 ORACLE FOR AIX INSTALL GUIDE

CKPT PMON DBWR

1-17

LD_LIBBARY_PATH $ORACLE_HOME/lib

ORACLE_BASE /oracle/oracle/app/oracle

ORACLE_HOME $ORACLE_BASE/product/8.1.7

ORACLE_SID Oracle ,
, oraInventory/
[Link]
OraInventory_location
/var/opt/oracle/[Link]
PATH $ORACLE_HOME/bin PATH
PATH
CLASSPATH CLASSPATH JRE_location
$ORACLE_HOME/jlib $ORACLE_HOME/product/jlib
JRE_location ORACLE_HOME/JRE
TNS_ADMIN Net 8 Net 8

TOW_TASK TWO_TASK [Link] Net 8

,

●LD_LIBRARY_PATH
Oracle , LD_LIBRARY_PATH
ORACLE_HOME/lib
●ORACLE_BASE
Oracle ,OFA :
/oracle/oracle/app/oracle

●ORACLE_HOME
Oracle ,
:
$ORACLE_BASE/product/release
/oracle/oracle/app/oracle/product/8.1.7
●ORACLE_SID
Oracle sid, Oracle sid
Oracle

●PATH
Oracle
$ORACLE_HOME/bin /bin /usr/bin
[Link] bin , /usr/local/bin/
●CLASSPATH

[Link] 27
 ORACLE FOR AIX INSTALL GUIDE

CLASSPATH Java CLASSPATH

CLASSPATH
JRE
$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/product/jlib
product Oracle_HOME rdbms
network JRE Java
●TNS_ADMIN
Net 8
($ORACLE_HOME/network/admin), TNS_ADMIN Net 8

Oracle [Link]
TNS_ADMIN
$TNS_ADMIN/[Link]
/etc
$ORACLE_HOME/network/admin/
[Link] ,
Net 8
●TWO_TASK
/ , TWO_TASK
TWO_TASK
Oracle Net 8
Adminstator Oracle 8i for AIX
● oraenv coraenv
oraenv coraenv Oracle
oraenv C shell coraenv

Oracle .bashrc profile

.login ORACLE_SID
oraenv coraenv
Bourne Korn shell
AENV_ASK=NO
export ORAENV_ASK
./usr/local/bin/oraenv
C shell
set ORAENV_ASK=NO
source/usr/local/bin/coraenv
unset ORAENV_ASK
Oracle
oraenv coraenv
Bourne Korn shell
# /bin/sh
echo”The SIDs on this machine are ”
cat/etc/oratab|awk-F ’{print $1}’|grep-v”#”
ORAENV_ASK=”YES”

[Link] 28
 ORACLE FOR AIX INSTALL GUIDE

source/usr/local/bin/coraenv
(2) Oracle
Oracle

Bourne Korn shell .profile

usr/local/bin/coraenv
C shell .login
source/usr/local/bin/coraenv
ORACLE_BASE ORACLE_HOME PATH

3 oratab
Oracle
/etc/oratab

Oracle_SID Oracle_HOME {Y|N}

Y NO dbstart dbshut Oracle

4 Oracle
Oracle 8i Oracle 8i
Oracle 8i 2 8.1.7 CDROM /cdrom/patch
README
5
[Link]
$ORACLE_BASE/admin/sid/pfile [Link]
$ORACLE_HOME/dbs

6 [Link]
Oracle [Link]
AIX [Link]
[Link]
ORACLE_HOME

rollback
[Link] back_segments

#rollback_segments= r0 r1 r2 r3

rollback_segments= r0 r1 r2 r3
[Link] Oracle 8i for AIX

[Link]

[Link] 29
 ORACLE FOR AIX INSTALL GUIDE

Oracle

●Net 8
●Oracle
●
●
●Oracle
●Oracle
[Link] 8
Oracle Net 8
Net 8 Net 8 Oracle
Net 8 Net 8
Net 8 Net 8
Net 8

root /etc/services Net 8

listener 1521/tcp #Net 8 listener

1521 Net 8
/etc/services

$lsbrctl start
listener listener_name

$ listener start
Oracle
SQL*plus
$sqlplus username/password@bais
SQL*plus , TCP/IP
Net 8
1 Oracle
1 Oracle InterMedia
interMedia LD_LIBRARY_PATH
$ORACLE_HOME/ctx/lib
Oracle interMedia
10MB
interMedia
Oracle interMedia Oracle interMedia
DRSYS Oracle interMedia
DRSYS

[Link] 30
 ORACLE FOR AIX INSTALL GUIDE

2 Oracle
Oracle Oracle

dnassist Oracle
$ORACLE_HOME/bin/dbassist
Modify Database
Oracle SID
Finish

PUBLIC
3
Oracle 8i
Oracle 8i 2 Oracle 8i

i. Oracle 8i Oracle 8i

Oracle

ii. RECOVERY_CATALOG_OWNER
iii. RECOVERY_CATALOG_OWNER Oracle
create catalog
2
(MTS) Oracle
SHARED_POOL_SIZE LARGE_POOL_SIZE
Oracle SHARED_POOL_SIZE Oracle

[Link] SHARED_POOL_SIZE
SHARED_POOL_SIZE 1KB
3 Oracle

Oracle 8i Oracle PL/SQL

●Pro*C/C++
$ ORACLE_HOME/precomp/admin [Link]
Proc*C/C++

[Link]
Proc*C/C++Precompiler
4 Oracle

TNS_ADMIN [Link]
/etc $ORACLE_HOME/network/admin

[Link] 31
 ORACLE FOR AIX INSTALL GUIDE

root

su – oracle –c ”lsnrctl start”

AIX /etc/rc.d/init.d/dbora
/ TWO_TASK
TWO_TASK
[Link]

$Isnrctl start

$Isnrctl staus
Oracle SQL*Plus
$sqlplus username/password@bais
Net 8

5
Oracle Net 8 Oracle

Oracle
2 Net 8
Net 8 Net 8 Net 8 Oracle
Net 8
Oracle
Net 8 Oracle

Oracle 8i Net 8
Net 8
$Oracle_HOME/network/admin

Net 8
$netasst
Net 8 Net 8

3 Oracle
Oracle
Oracle
shell

ORACLE

[Link] 32
 ORACLE FOR AIX INSTALL GUIDE

$dbassist
ORACLE dbassist -help -h

6 ORACLE
ORACLE NET8
ORACLE
ORACLE ORACLE ORACLE
NET8
ORACLE ORACLE
1 ORACLE
$dbassist.
2 Delete a Database”.
3 Next”
4
5 ”Finish”
6
ORACLE

ORACLE / deinst
NET8
$ netca /deinst
ORACLE ORACLE

welcome” De-install Products”

Installed Products” Inventory”

Inventory” Remove”

SQL*NET

— oracle $ORACLE_HOME/network/admin
[Link] [Link]
— [Link]

listener =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=TCP)
(HOST=[Link]) /* (Server IP ) */
(PORT=1521)
)
)

[Link] 33
 ORACLE FOR AIX INSTALL GUIDE

STARTUP_WAIT_TIME_listener = 0
CONNECT_TIMEOUT_listener = 10
SID_LIST_listener =
(SID_LIST=
(SID_DESC=
(SID_NAME=bais)
(ORACLE_HOME=/oracle/oracle/app/oracle/product/8.1.7)
)

[Link]

bais = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=TCP)
(HOST=[Link]) /* (Server IP ) */
(PORT=1521)
)
)
(
CONNECT_DATA = (SID=bais)
)
)

—
$ sqlplus system/manager@bais
SQL*NET

Windows 98 SQL*NET

Windows 98
SQL*NET Client
SQL*NET TCP/IP
TCP/IP Adapter
SQL*Plus
Sql*net easy configuration SQL*NET

[Link] 34