1

Oracle Database (9i)For Sun SPARC Solaris

Installation GuideVersion : 9.2.0.1.0

전자계산소전자계산소 조성환 2006-05-24

2

1. Oracle Database 설치하기• * Oracle 9i Database 를 아래 사이트에서 다운 받으신후 설치하려는 서버에 파일을 올립니다 .

http://www.oracle.com/technology/software/products/oracle9i/index.html

• 참고 Sun SPARC Solaris (64-bit) – Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (64-bit)

Download the Complete Files solaris64_9.2.0.1.0.Disk1.cpio.gz (583,756,222 bytes) solaris64_9.2.0.1.0.Disk2.cpio.gz (603,567,380 bytes) solaris64_9.2.0.1.0.Disk3.cpio.gz (334,964,265 bytes) 

Directions 1. Uncompress the file using "gunzip". Eg.: "gunzip solaris64_9.2.0.1.0.Disk1.cpio.gz" 2. Extract the file resulting from the step above using "cpio". Eg.: "cpio -idmv < solaris64_9.2.0.1.0.Disk1.cpio" 3. Repeat this for solaris64_9.2.0.1.0.Disk2.cpio.gz and solaris64_9.2.0.1.0.Disk3.cpio.gz  

Important Note: Some browsers will uncompress the files but leave the extension the same (gz) when downloading.

If the above steps do not work, try skipping step 1 and go directly to step 2 without changing the filename. Eg. "cpio -idmv < solaris64_9.2.0.1.0.Disk1.cpio.gz"* Disk1 이라는 하위 디렉토리가 만들어짐

3

• 참고로 사전에 아래 작업이 되어 있어야 합니다 . ( 확인 필수 )

* oracle/dba 라는 OS User/Group 생성* oracle User 환경변수 (ksh, .profile) 생성* oracle home directory : /oracle* oracle data directory : /oradata* chown –R oracle:dba /oracle ; chown –R oracle:dba /oradata

* Sun SPARC System 인경우 ( 반드시 ) /etc/system 파일 수정후 서버 rebooting/etc/system 파일관련 참고문서http://www.wowunix.com/cgi-bin/CrazyWWWBoard.cgi?mode=read&num=990&db=solaris&backdepth=1

* oracle User 의 환경변수 (.profile) 는 아래 사이트를 참고하시면 됩니다 . http://www.wowunix.com/set/shell/ksh/

4

설치 (./runInstaller &)( 반드시 oracle OS User 로 X-windows 에 로그인후 Install 하시기 바랍니다 .)

설치중 한글이 깨지는 경우가 가끔 있어 Oracle OS User 환경변수중LANG 설정을 “ C” 로 하신후 설치하시기 바랍니다 .

5

Universal Installer; Next

6

Inventory Location(Default directory : /oracle/oraInventory)

; OK

7

Unix Group Name (dba); Next

8

Excute the /tmp/orainstRoot.sh Script now,and then press “Continue”.

[sol40:/tmp] # ./orainstRoot.shCreating Oracle Inventory pointer file (/var/opt/oracle/oraInst.loc)Changing groupname of /oracle/oraInventory to dba

9

File Locations [Destination](oracle home name and full path)

; Next

10

Select a product to install(Oracle9i Database 9.2.0.1.0)

; Next

11

Installation Types(Select Enterprise Edition)

; Next

12

Database Configuration(General Purpose)

; Next

13

Database Identification* Global Database Name : ORCL

* SID : ORCL; Next

14

Database File Location(Directory for Database files : /oradata)

; Next

15

Database Character Set *제일 중요(Choose Korean KO16KSC5601)

; Next

16

Summary (Configuration Check); Install

17

Setup Privilegesrun /oracle/root.sh

[sol40:/oracle] # ./root.shRunning Oracle9 root.sh script...

The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle

Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...

Creating /var/opt/oracle/oratab file...Adding entry to /var/opt/oracle/oratab file...Entries will be added to the /var/opt/oracle/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.

18

End of Installation

19

참고 - 리스너 생성 및 확인Listener Configuration

(/oracle/network/admin/listener.ora)

[sol40:ORCL] /oracle/network/admin] $ cat listener.ora

# LISTENER.ORA Network Configuration File: /oracle/network/admin/listener.ora# Generated by Oracle configuration tools.

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sol40)(PORT = 1521)) ) ) )

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = /oracle) (SID_NAME = ORCL) ) )

20

Listener start

• [sol40:ORCL] /oracle/network/admin] $ lsnrctl start

• LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 24-MAY-2006 13:14:05

• Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

• Starting /oracle/bin/tnslsnr: please wait...

• TNSLSNR for Solaris: Version 9.2.0.1.0 - Production• System parameter file is /oracle/network/admin/listener.ora• Log messages written to /oracle/network/log/listener.log• Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))• Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sol40)(PORT=1521)))

• Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))• STATUS of the LISTENER• ------------------------• Alias LISTENER• Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production• Start Date 24-MAY-2006 13:14:05• Uptime 0 days 0 hr. 0 min. 0 sec• Trace Level off• Security OFF• SNMP OFF• Listener Parameter File /oracle/network/admin/listener.ora• Listener Log File /oracle/network/log/listener.log• Listening Endpoints Summary...• (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))• (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sol40)(PORT=1521)))• Services Summary...• Service "ORCL" has 1 instance(s).• Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...• Service "PLSExtProc" has 1 instance(s).• Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...• The command completed successfully

21

Listener status

• [sol40:ORCL] /oracle/network/admin] $ lsnrctl status

• LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 24-MAY-2006 13:15:19

• Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

• Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))• STATUS of the LISTENER• ------------------------• Alias LISTENER• Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production• Start Date 24-MAY-2006 13:14:05• Uptime 0 days 0 hr. 1 min. 14 sec• Trace Level off• Security OFF• SNMP OFF• Listener Parameter File /oracle/network/admin/listener.ora• Listener Log File /oracle/network/log/listener.log• Listening Endpoints Summary...• (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))• (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sol40)(PORT=1521)))• (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sol40)(PORT=8080))(Presentation=HTTP)(Session=RAW))• (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sol40)(PORT=2100))(Presentation=FTP)(Session=RAW))• Services Summary...• Service "ORCL" has 2 instance(s).• Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...• Instance "ORCL", status READY, has 1 handler(s) for this service...• Service "ORCLXDB" has 1 instance(s).• Instance "ORCL", status READY, has 1 handler(s) for this service...• Service "PLSExtProc" has 1 instance(s).• Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...• The command completed successfully

22

Listener stop

• [sol40:ORCL] /oracle/network/admin] $ lsnrctl stop

• LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 24-MAY-2006 14:08:56

• Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

• Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))• The command completed successfully