Chapter 1

Transcription

1 3 Oracle 설치

2 Objectives Download Oracle 11g Release 2 Install Oracle 11g Release 2 Download Oracle SQL Developer Install Oracle SQL Developer Create a database connection 2

3 Download Oracle 11g Release 2 Visit the Oracle site Visit the following webpage, create an Oracle account, log in with the created account, and download the appropriate Oracle Database depending on the OS of your computer. Click the Accept License Agreement radio button. 3

4 Scroll down Download Oracle 11g Release 2 Choose Enterprise Edition... for download 4

5 Download Oracle 11g Release 2 For 32-bit Windows7 Download File 1 you will have the file, win32_11gr2_database_1of2.zip Download File 2 you will have the file, win32_11gr2_database_2of2.zip Unzip File 1 and File 2 Move the folder from File 2 to File 1 두번째 (2of2) 압축파일을해제한폴더에포함된 database/stage/components 폴더에있는파일들을첫번째 (1of2) 압축파일을해제한폴더에포함된 database/stage/components 폴더에복사해넣습니다. 5

6 Install Oracle 11g Release 2 Execute setup.exe included in database folder 전자메일과 My Oracle Support 에는입력하지않음 uncheck My Oracle support를통해보안갱신수신 Click 다음 버튼 전자메일주소가지정되지않음 대화창이뜨면예 버튼을누른다 6

7 Install Oracle 11g Release 2 데이터베이스생성및구성 을선택후 다음 버튼을누른다 7

8 Install Oracle 11g Release 2 데스크톱클래스 를선택후 다음 버튼을누른다 8

9 Install Oracle 11g Release 2 디렉토리를찾기쉽게하기위해 C:\ 드라이브에바로 Oracle 폴더를생성하기위해맨처음칸인 Oracle Base(S) 에폴더경로를 C:\Oracle 로적는다. 소프트웨어위치, 데이터베이스파일위치는자동으로변경됩니다. 전역데이터터베이스이름의경우는 orcl 로입력 관리비밀번호와비밀번호확인은대소문자와숫자포함해서 8 자리이상으로변경 9

10 Install Oracle 11g Release 2 완료 버튼을누르면설치가시작된다 10

11 Install Oracle 11g Release 2 비밀번호관리 버튼을누른다 11

12 Install Oracle 11g Release 2 SYSTEM, SYS 사용자만제외하고체크되어잠겨있다. 교재에서는 SCOTT 계정을가지고설명해놓은것이많으므로 SCOTT 계정도 ( 패스워드는 tiger) 체크를풀어잠김을해제한후 확인 버튼을누른다. Database Configuration Assistant' 화면에서 확인 버튼을누른다. 12

13 Install Oracle 11g Release 2 닫기 ' 버튼을눌러설치를마친다. 13

14 Download Oracle SQL Developer Visit the Oracle site Download the latest Oracle SQL Developer ownloads/index.html This download does not include the JDK. You can connect to and use any JDK 7 or above. Ensure you have a JDK installed, if not, download JDK 7 or above 14

15 Install Oracle SQL Developer Extract sqldeveloper.zip into any folder Within that folder, open the sqldeveloper folder Double-click sqldeveloper.exe You will be prompted to enter the path to the Java JDK home. This only occurs the first time you launch SQL Developer. click Browse and find java.exe. For example, the path might have a name similar to C:\Program Files\sqldeveloper\jdk\jre\bin\java.exe If you do not have the icon located on your desktop, perform the following steps to create a shortcut to launch SQL Developer directly from your desktop. Open the directory where the SQL Developer is located right-click sqldeveloper.exe (on Windows) and select Send to >Desktop (create shortcut). 15

16 Install Oracle SQL Developer

17 Install Oracle SQL Developer On the desktop, you will find an icon named Shortcut to sqldeveloper.exe. Double-click the icon to open SQL Developer 3.0. To rename it, select the icon and then press F2 and enter a new name. Double-click the icon to open SQL Developer 17

18 Create a database connection 18

19 Create a database connection In the Connections navigator, right-click Connections and select New Connection. The New / Select Database Connection dialog opens. Enter the connection details. 19

20 click Test. Create a database connection Check for the status of the connection on the left-bottom side (above the Help button). It should read Success. 20

21 Click Test. Create a database connection Check for the status of the connection on the left-bottom side (above the Help button). It should read Success. 21

22 Click Connect. Then click Save. Create a database connection The connection was saved and you see the newly created connection in the Connections list. When a connection is opened, a SQL Worksheet is opened automatically. The SQL Worksheet allows you to execute SQL against the connection you have opened. 22