http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
각 운영체제에 맞는 파일 다운로드(File 1, File 2 전부)
(설명은 Windows 32bit)
2. 오라클 설치
다운 받은 파일 압축 풀기(같은 폴더에....)
설치파일 관리자 권한으로 설치 및 설치 방법은 인터넷 검색해보길... 캡처를 못해서...
3. 리너스, TNS 설정
오라클이 설치된 폴더의 listener.ora, tnsnames.org 수정
listener.org
===============================================================================
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = ORCL)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = Oracl11g)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
===============================================================================
tnsnames.org
===============================================================================
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
===============================================================================
오라클이 설치된 폴더와 HOST 수정(127.0.0.1은 해당 PC를 지칭)
4. 서비스 시작, 중지
오라클 관련 서비스를 실행하면 무겁기 때문에 사용하는 경우에만 서비스 실행.
Oracle_Start.bat
===============================================================================
net start OracleDBConsoleorcl
net start OracleOraDb11g_home1TNSListener
net start OracleVssWriterORCL
net start OracleJobSchedulerORCL
net start OracleServiceORCL
===============================================================================
* OracleDBConsoleorcl - 오류나도 도트 등 사용 시 문제 없음(EM)
Oracle_Stop.bat
===============================================================================
net stop OracleServiceORCL
net stop OracleJobSchedulerORCL
net stop OracleVssWriterORCL
net stop OracleOraDb11g_home1TNSListener
net stop OracleDBConsoleorcl
===============================================================================
5. Toad 실행
토드 접속 화면
댓글 없음:
댓글 쓰기