Jump to content

Manual:오라클

From mediawiki.org
This page is a translated version of the page Manual:Oracle and the translation is 25% complete.
Manual:컨텐츠 미디어위키 데이터베이스 레이아웃 oracle 테이블
미디어위키는 버전 1.34 부터 오라클 마이크로소프트 SQL 서버 사용을 더 이상 지원하지 않습니다.

일부 리눅스 배포판에는 이를 설치하기 위한 패키지가 있지만 모든 배포판에 있지는 않습니다.

리눅스에 오라클 XE 설치하기 (수동)

Oracle XE is an entry level database free of charge but with embedded limitations:

[1]

  • will use only CPU resources that are equivalent of 1 CPU/core on your system
  • will use only up to 1 Gb of RAM
  • is limited to 1 server/database instance per machine
  • is limited to 11G of user-space data

Follow the installation procedure is described in the XE installation manual.

Some basic DBA commands can be found on XE DBA Documentation page but in most cases you can use DB control interface that can be accessed trough DB's http port (the one you selected when you ran "oracle-xe configure")

리눅스에 오라클 인스턴트 클라이언트 설치하기 (수동)

Follow the instructions found at Oracle's PHP documentation page.

If you are not using the "hostname/servicename" connection string format (e.g. "localhost/xe"), and instead use an alias from a tnsnames.ora file, then after you have your PHP environment set up add the TNS_ADMIN variable to your PHP startup environment. This variable must contain the location (directory only) where your tnsnames.ora file is located. This file contains TNS definitions of the databases you will be accessing (local or remote). If you have previously set up XE on this machine this variable should point to '/u01/app/oracle/product/11.2.0/xe/network/admin'. Make sure this file is readable by the Apache process.

미디어위키 설치

After you have OCI8 enabled and TNS_ADMIN set in your PHP env you can now install MW normally. TNS name of default XE install is usually 'XE'.