1 / 9

Oracle 구성

Oracle 구성. Internet Application Server Database Server. IAS. Database Server. Oracle Universal Installer. 설치 Net8 Configuration Assitant 로 tnsname.ora 설정해 줄 것 ! SID misdb 기계 misdb.mju.ac.kr Port 1521 Protocol tcp. SQLPlus (1). Text 용 /DOS 용

aaron-velazquez
Download Presentation

Oracle 구성

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle 구성 • Internet Application Server • Database Server

  2. IAS

  3. Database Server

  4. Oracle Universal Installer • 설치 • Net8 Configuration Assitant로 tnsname.ora 설정해 줄 것 ! • SID misdb • 기계 misdb.mju.ac.kr • Port 1521 • Protocol tcp

  5. SQLPlus (1) • Text 용/DOS용 • sqlplus shpark/shpark1234@misdb • Windos 용 • Sqlplusw shpark/shpark1234@misdb • Web 용 • http://localhost:5560/isqlplus

  6. SQLPlus (2)

  7. SQLPlus (3) • 편집 • List • Delete • Input • 숫자 (라인 번호) • 파일 작업 • Save • Get • Start / @

  8. 실습 • Oracle client 설치 • 각자 계정으로 연결하여 암호를 재 설정할 것! • Alter user 각자ID identified by 새암호; • Example_db.zip 을 다운 받아 • Demobld7.sql 내용 확인 후 • Batch SQL 문장을 수행하도록 ! • 몇 개의 명령문을 수행해 보도록! • Select * from tab; • Des(ribe) emp; 등

  9. 숙제 1 • 경영정보 혹은 다른 DB관련 과목에서 수행한 MS Access, MS SQO 서버 혹은 MySQL프로젝트를 Oracle 10g로 이식하시오!! • 작업은 각자의 misdb 계정에 수행하고 • 제출은 작업에 사용한 SQL script 파일을 e-mail로 shpark.advdb@gmail.com제출하시길~~~

More Related