오라클 실행시키는 방법 > Mysql

본문 바로가기
사이트 내 전체검색

Mysql

오라클 실행시키는 방법

페이지 정보

profile_image
작성자 HARULIFE
댓글 0건 조회 3,277회 작성일 20-11-24 11:55

본문

[root@localhost ~]# su - oracle
[oracle@db /home/oracle]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-APR-2011 16:57:59

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /ORACLE/app/oracle/oracle/product/10.2.0/db_4/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /ORACLE/app/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora
Log messages written to /ORACLE/app/oracle/oracle/product/10.2.0/db_4/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                20-APR-2011 16:58:01
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /ORACLE/app/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora
Listener Log File        /ORACLE/app/oracle/oracle/product/10.2.0/db_4/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@db /home/oracle]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 20 16:58:19 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect orcl as sysdba
Enter password: [엔터]
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1220820 bytes
Variable Size            109055788 bytes
Database Buffers          490733568 bytes
Redo Buffers                7163904 bytes
Database mounted.

Database opened.
SQL>

댓글목록

등록된 댓글이 없습니다.

회원로그인

회원가입

사이트 정보

회사명 : HARULIFE / 대표 : HARULIFE
주소 : 검도 홍시 방구 해동 123-45
사업자 등록번호 : 123-45-67890
전화 : 02-123-4567 팩스 : 02-123-4568
통신판매업신고번호 : 제 방구 - 123호
개인정보관리책임자 : HARULIFE

  • 게시물이 없습니다.

접속자집계

오늘
487
어제
495
최대
670
전체
130,482
Copyright © 소유하신 도메인. All rights reserved.