oracle 8i personal edition practice n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle 8i personal edition Practice PowerPoint Presentation
Download Presentation
Oracle 8i personal edition Practice

Loading in 2 Seconds...

play fullscreen
1 / 35

Oracle 8i personal edition Practice - PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on

Oracle 8i personal edition Practice. 장성봉 Http://ejavaschool.com.ne.kr. Environment and Notice. O/S : windows 2000 server Database server : Oracle8.1.7 personal edition Notice : OTN 에 가입하면 각종 utility 평가판과 personal version 사용 가능 각종 정보를 얻기 위해 OTN 에 가입하는 것이 효과적임.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle 8i personal edition Practice' - quasim


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle 8i personal edition practice

Oracle 8i personal edition Practice

장성봉

Http://ejavaschool.com.ne.kr

environment and notice
Environment and Notice
  • O/S : windows 2000 server
  • Database server : Oracle8.1.7 personal edition
  • Notice : OTN에 가입하면 각종 utility 평가판과 personal version 사용 가능
  • 각종 정보를 얻기 위해 OTN에 가입하는 것이 효과적임.
slide11
Oracle8i Personal Edition select Oracle8i Personal Edition Release 3 Version 8.1.7 for Microsoft Windows NT/2000
slide24
종료
  • 이후 과정은 자동으로 설치되고 종료시키면 설치 끝.
  • 주의사항 : 다음 사항을 기억해야 함.
  • 전역DB이름 : orcl
  • SID 이름 : orcl
  • sys 계정 : change_on_install
  • system 계정 : manager
  • scott 계정 : tiger
listener lsnrctl
Listener (LSNRCTL) 란 ?
  • Oracle Listener는 네트워크를 통해 client에서 Oracle Server로 연결하기 위한 Oracle Network Manager이다.
  • 서버가 client의 요청을 듣게(listen) 하는 것을 말한다. 이러한 Listener의 상태를 관리하는 툴이 LSNRCTL이다.
  • C:\Oracle\Ora81\network\admin 안에 listener.ora file 수정해야 함.
slide34
Edit 방법
  • # : 주석처리
  • Host : 컴퓨터의 위치 지정
  • #(ADDRESS = (PROTOCOL = TCP)(HOST = jangsb)(PORT = 1521))
  • (ADDRESS = (PROTOCOL = TCP)(HOST = 211.192.65.58) (PORT = 1521))
  • #(ADDRESS = (PROTOCOL = TCP)(HOST = jangsb)(PORT = 2481))
  • (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1) (PORT = 1521))
  • -- > 저장 후 : Oracle\ora81\bin\ LSNRCTL start