(주)누리웨어 | 화상연동/Web,APP 구축및서비스/LMS/평생교육/학점은행/기업교육/연수관리/설문구축/

2 03 2017

Oracle 용량확인

테이블스페이스 정보 조회 SELECT * FROM DBA_TABLESPACES; Oracle 테이블 스페이별 용량

select substr(a.tablespace_name,1,30) tablespace,
round(sum(a.total1)/1024/1024,1) "TotalMB",
round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1) "UsedMB",
round(sum(a.sum1)/1024/1024,1) "FreeMB",
round((round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1))/round(sum(a.total1)/1024/1024,1)*100,2) "Used%"
from
(select tablespace_name,0 total1,sum(bytes) sum1,max(bytes) MAXB,count(bytes) cnt
from dba_free_space
group by tablespace_name
union
select tablespace_name,sum(bytes) total1,0,0,0
from dba_data_files
group by tablespace_name) a
group by a.tablespace_name
order by tablespace;

select substr(a.tablespace_name,1,30) tablespace,

round(sum(a.total1)/1024/1024,1) "TotalMB",

round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1) "UsedMB",

round(sum(a.sum1)/1024/1024,1) "FreeMB",

round((round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1))/round(sum(a.total1)/1024/1024,1)*100,2) "Used%"

from

(select tablespace_name,0 total1,sum(bytes) sum1,max(bytes) MAXB,count(bytes) cnt

from dba_free_space

group by tablespace_name

union

select tablespace_name,sum(bytes) total1,0,0,0

from dba_data_files

group by tablespace_name) a

group by a.tablespace_name

order by tablespace;

테이블스페이스별 현황 확인 쿼리문(MB 단위)

SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024 AS MBytes, RESULT/1024 AS USE_MBytes FROM
(
SELECT E.TABLESPACE_NAME,E.FILE_NAME,E.BYTES, (E.BYTES-SUM(F.BYTES)) RESULT
FROM DBA_DATA_FILES E, DBA_FREE_SPACE F
WHERE E.FILE_ID = F.FILE_ID
GROUP BY E.TABLESPACE_NAME, E.FILE_NAME, E.BYTES
) A;

SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024 AS MBytes, RESULT/1024 AS USE_MBytes FROM

(

SELECT E.TABLESPACE_NAME,E.FILE_NAME,E.BYTES, (E.BYTES-SUM(F.BYTES)) RESULT

FROM DBA_DATA_FILES E, DBA_FREE_SPACE F

WHERE E.FILE_ID = F.FILE_ID

GROUP BY E.TABLESPACE_NAME, E.FILE_NAME, E.BYTES

) A;

테이블스페이스별, 파일별 현황 확인 쿼리문(바이트 단위)

SELECT    A.TABLESPACE_NAME "테이블스페이스명",
          A.FILE_NAME "파일경로",
           (A.BYTES - B.FREE)    "사용공간",
            B.FREE                 "여유 공간",
            A.BYTES                "총크기",
            TO_CHAR( (B.FREE / A.BYTES * 100) , '999.99')||'%' "여유공간"
      FROM
       (
         SELECT FILE_ID,
                TABLESPACE_NAME,
                FILE_NAME,
                SUBSTR(FILE_NAME,1,200) FILE_NM,
                SUM(BYTES) BYTES
           FROM DBA_DATA_FILES
         GROUP BY FILE_ID,TABLESPACE_NAME,FILE_NAME,SUBSTR(FILE_NAME,1,200)
       ) A,
       (
         SELECT TABLESPACE_NAME,
                FILE_ID,
                SUM(NVL(BYTES,0)) FREE
           FROM DBA_FREE_SPACE
        GROUP BY TABLESPACE_NAME,FILE_ID
       ) B
      WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME
         AND A.FILE_ID = B.FILE_ID;

SELECT A.TABLESPACE_NAME "테이블스페이스명",

A.FILE_NAME "파일경로",

(A.BYTES - B.FREE) "사용공간",

B.FREE "여유 공간",

A.BYTES "총크기",

TO_CHAR( (B.FREE / A.BYTES * 100) , '999.99')||'%' "여유공간"

FROM

(

SELECT FILE_ID,

TABLESPACE_NAME,

FILE_NAME,

SUBSTR(FILE_NAME,1,200) FILE_NM,

SUM(BYTES) BYTES

FROM DBA_DATA_FILES

GROUP BY FILE_ID,TABLESPACE_NAME,FILE_NAME,SUBSTR(FILE_NAME,1,200)

) A,

(

SELECT TABLESPACE_NAME,

FILE_ID,

SUM(NVL(BYTES,0)) FREE

FROM DBA_FREE_SPACE

GROUP BY TABLESPACE_NAME,FILE_ID

) B

WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME

AND A.FILE_ID = B.FILE_ID;

테이블 용량 조회

<span class="kwd">SELECT</span><span class="pln">
   owner</span><span class="pun">,</span><span class="pln"> table_name</span><span class="pun">,</span><span class="pln"> TRUNC</span><span class="pun">(</span><span class="pln">sum</span><span class="pun">(</span><span class="pln">bytes</span><span class="pun">)/</span><span class="lit">1024</span><span class="pun">/</span><span class="lit">1024</span><span class="pun">/</span><span class="lit">1024</span><span class="pun">)</span><span class="pln"> GB
</span><span class="kwd">FROM</span>
<span class="pun">(</span><span class="kwd">SELECT</span><span class="pln"> segment_name table_name</span><span class="pun">,</span><span class="pln"> owner</span><span class="pun">,</span><span class="pln"> bytes
</span><span class="kwd">FROM</span><span class="pln"> dba_segments
</span><span class="kwd">WHERE</span><span class="pln"> segment_type </span><span class="kwd">in</span>  <span class="pun">(</span><span class="str">'TABLE'</span><span class="pun">,</span><span class="str">'TABLE PARTITION'</span><span class="pun">)</span>
<span class="kwd">UNION</span> <span class="kwd">ALL</span>
<span class="kwd">SELECT</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">table_name</span><span class="pun">,</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">owner</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">bytes
</span><span class="kwd">FROM</span><span class="pln"> dba_indexes i</span><span class="pun">,</span><span class="pln"> dba_segments s
</span><span class="kwd">WHERE</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_name </span><span class="pun">=</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">index_name
</span><span class="kwd">AND</span><span class="pln">   s</span><span class="pun">.</span><span class="pln">owner </span><span class="pun">=</span><span class="pln"> i</span><span class="pun">.</span><span class="pln">owner
</span><span class="kwd">AND</span><span class="pln">   s</span><span class="pun">.</span><span class="pln">segment_type </span><span class="kwd">in</span> <span class="pun">(</span><span class="str">'INDEX'</span><span class="pun">,</span><span class="str">'INDEX PARTITION'</span><span class="pun">)</span>
<span class="kwd">UNION</span> <span class="kwd">ALL</span>
<span class="kwd">SELECT</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">table_name</span><span class="pun">,</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">bytes
</span><span class="kwd">FROM</span><span class="pln"> dba_lobs l</span><span class="pun">,</span><span class="pln"> dba_segments s
</span><span class="kwd">WHERE</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_name </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">segment_name
</span><span class="kwd">AND</span><span class="pln">   s</span><span class="pun">.</span><span class="pln">owner </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner
</span><span class="kwd">AND</span><span class="pln">   s</span><span class="pun">.</span><span class="pln">segment_type </span><span class="kwd">IN</span> <span class="pun">(</span><span class="str">'LOBSEGMENT'</span><span class="pun">,</span><span class="str">'LOB PARTITION'</span><span class="pun">)</span>
<span class="kwd">UNION</span> <span class="kwd">ALL</span>
<span class="kwd">SELECT</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">table_name</span><span class="pun">,</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">bytes
</span><span class="kwd">FROM</span><span class="pln"> dba_lobs l</span><span class="pun">,</span><span class="pln"> dba_segments s
</span><span class="kwd">WHERE</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">segment_name </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">index_name
</span><span class="kwd">AND</span><span class="pln">   s</span><span class="pun">.</span><span class="pln">owner </span><span class="pun">=</span><span class="pln"> l</span><span class="pun">.</span><span class="pln">owner
</span><span class="kwd">AND</span><span class="pln">   s</span><span class="pun">.</span><span class="pln">segment_type </span><span class="pun">=</span> <span class="str">'LOBINDEX'</span><span class="pun">)</span>
<span class="com">---WHERE owner in UPPER('&amp;owner')</span>
<span class="kwd">GROUP</span> <span class="kwd">BY</span><span class="pln"> table_name</span><span class="pun">,</span><span class="pln"> owner
</span><span class="kwd">HAVING</span><span class="pln"> SUM</span><span class="pun">(</span><span class="pln">bytes</span><span class="pun">)/</span><span class="lit">1024</span><span class="pun">/</span><span class="lit">1024</span> <span class="pun">&gt;</span> <span class="lit">10</span>  <span class="com">/* Ignore really small tables */</span>
<span class="kwd">ORDER</span> <span class="kwd">BY</span><span class="pln"> SUM</span><span class="pun">(</span><span class="pln">bytes</span><span class="pun">)</span> <span class="kwd">desc</span>

SELECT

owner, table_name, TRUNC(sum(bytes)/1024/1024/1024) GB

FROM

(SELECT segment_name table_name, owner, bytes

FROM dba_segments

WHERE segment_type in ('TABLE','TABLE PARTITION')

UNION ALL

SELECT i.table_name, i.owner, s.bytes

FROM dba_indexes i, dba_segments s

WHERE s.segment_name = i.index_name

AND s.owner = i.owner

AND s.segment_type in ('INDEX','INDEX PARTITION')

UNION ALL

SELECT l.table_name, l.owner, s.bytes

FROM dba_lobs l, dba_segments s

WHERE s.segment_name = l.segment_name

AND s.owner = l.owner

AND s.segment_type IN ('LOBSEGMENT','LOB PARTITION')

UNION ALL

FROM dba_lobs l, dba_segments s

WHERE s.segment_name = l.index_name

AND s.owner = l.owner

AND s.segment_type = 'LOBINDEX')

---WHERE owner in UPPER('&owner')

GROUP BY table_name, owner

HAVING SUM(bytes)/1024/1024 > 10 /* Ignore really small tables */

ORDER BY SUM(bytes) desc

17 01 2017

썸네일 이미지 생성

Haeng Ho Kang | Programming, Java | 0

import javax.imageio.ImageIO; import javax.media.jai.JAI; import javax.media.jai.RenderedOp; //썸네일 이미지 파일 File save = new File(saveFile); //load파일은 원본이미지 파일 RenderedOp 객체 생성 RenderedOp rOp = JAI.create(“fileload”, loadFile); //BufferImage 객체를 얻어옴 BufferedImage im = rOp.getAsBufferedImage(); //줌이 5이면 원본 이미지의 1/5 크기가 된다 float zoom = 1f; if(im.getWidth() > 200) { zoom = ((float)im.getWidth()) / 200f; } int […]

23 12 2016

오라클 테이블 컬럼 검색하여 일괄 속성변경

Haeng Ho Kang | Uncategorized | 0

select ‘alter table ‘||TABLE_NAME||’ modify(컬럼명 VARCHAR2(32));’ AS query, COLUMN_NAME, DATA_TYPE, DATA_LENGTH from ALL_TAB_COLUMNS where COLUMN_NAME LIKE ‘%USR_ID’ and data_length != 20 컬럼 속성 길이나 컬럼 속성을 변경 쿼리(alter table)를 뽑아 일괄 실행하여 변경한다.(티베로DB도 동일한 방법으로 사용할 수 있다.)

15 12 2016

ERwin 을 사용 comment를 Logical 로 사용방법

Haeng Ho Kang | TOOL, erwin | 0

1.Physical에서 전체 선택하고 harden physical Names를 선택 2.완료되면 Phyiscal -> Logical로 변경후 메뉴에서 Model>Domain Dictionary를 선택하고 Name Inherited by Attribute항목에 다음을 복사 %if(%>(%Len(%ColumnComment),0)){%ColumnComment}%ELSE{%ColName} OK를 눌러 창을 닫는다 3.다시 Model > Attributes 를 선택후 Reset을 클릭하면 아래의 화면이 나옴 Reset all attributes in model 선택하고 Select Propertiers to Reset 에서 Name만 선택하고 OK 를 누르고 […]

6 12 2016

Unix – HP-UX 명령어

Haeng Ho Kang | OS, Linux/Unix | 0

start/stop start : 파워스위치를 3초정도 길게 누른다. stop : shutdown -hy 0(0초이내 즉시 재부팅) 재부팅 : shutdown -ry 강제종료 : shutdown -h 0 디스크의 용량 # bdf 명령 실행 중지 ctrl + c 대신 delete 키를 누름 패치목록 확인 #swlist -l product 프로세스 갯수 #ps -ef | wc os bit #getconf KERNEL_BITS IP확인 #netstat -in […]

29 11 2016

IText Pdf

Haeng Ho Kang | Uncategorized | 0

http://zero-gravity.tistory.com/251 참고

16 11 2016

HP-UX 에서 Apache + Tomcat 설치

Haeng Ho Kang | OS, Server, Linux/Unix, Web | 0

설치된 OS버젼을 확인

root@dev_was [/opt/hpws]# swlist -l bundle QPKBASE
# Initializing...
# Contacting target "dev_was"...
#
# Target: dev_was:/
#

QPKBASE B.11.31.1603.421a Base Quality Pack Bundle for HP-UX 11i v3, March 2016

root@dev_was [/opt/hpws]# swlist -l bundle QPKBASE

# Initializing...

# Contacting target "dev_was"...

# Target: dev_was:/

QPKBASE B.11.31.1603.421a Base Quality Pack Bundle for HP-UX 11i v3, March 2016

개별 환경 변수 설정의 경우는 cd ~ 해당 홈디렉토리 의 vi .profile 예 저장하시면 되구요 전체 공용 계정별 환경변수 저장은 vi /etc/profile에 설정 하면됩니다. 다운로드 https://h20392.www2.hp.com/portal/swdepot/displayProductsList.do?category=NSM 설치하기

root@dev_was [/tmp]# swinstall -s ./HP_UX_11.31_HPUXWS22ATW-B408-11-31-64.depot

1	root@dev_was [/tmp]# swinstall -s ./HP_UX_11.31_HPUXWS22ATW-B408-11-31-64.depot

설치선택화면 설치선택완료화면(선택하고 Actions>Mark for Install 그다음 Actions>install하면 설치합니다. 설치중 화면 대화형 창이 뜨면 Space Bar로 apache를 선택 2)위의 명령어로 설치하면

root@dev_was [/opt/hpws22]# pwd
/opt/hpws22

root@dev_was [/opt/hpws22]# ls -al
total 112
drwxr-xr-x 8 bin bin 8192 Jul 16 2015 .
dr-xr-xr-x 93 bin bin 8192 Nov 16 13:56 ..
drwxr-xr-x 2 bin bin 96 Nov 16 15:46 LICENSES
-r--r--r-- 1 bin bin 3853 Dec 16 2008 README
drwxr-xr-x 22 bin bin 8192 Jul 16 2015 apache
drwxr-xr-x 8 bin bin 8192 Nov 16 15:46 hp_docs
drwxr-xr-x 13 bin bin 8192 Nov 16 15:46 tomcat
dr-xr-xr-x 2 bin bin 96 Jul 16 2015 util
drwxr-xr-x 19 bin bin 8192 Jul 16 2015 webmin

root@dev_was [/opt/hpws22]# pwd

/opt/hpws22

root@dev_was [/opt/hpws22]# ls -al

total 112

drwxr-xr-x 8 bin bin 8192 Jul 16 2015 .

dr-xr-xr-x 93 bin bin 8192 Nov 16 13:56 ..

drwxr-xr-x 2 bin bin 96 Nov 16 15:46 LICENSES

-r--r--r-- 1 bin bin 3853 Dec 16 2008 README

drwxr-xr-x 22 bin bin 8192 Jul 16 2015 apache

drwxr-xr-x 8 bin bin 8192 Nov 16 15:46 hp_docs

drwxr-xr-x 13 bin bin 8192 Nov 16 15:46 tomcat

dr-xr-xr-x 2 bin bin 96 Jul 16 2015 util

drwxr-xr-x 19 bin bin 8192 Jul 16 2015 webmin

위에서 […]

16 11 2016

HP-UX 에 기본정보 확인 명령어

Haeng Ho Kang | OS | 0

버젼 확인

root@dev_was [/opt/hpws]# uname -a
HP-UX dev_was B.11.31 U ia64 1073980350 unlimited-user license

1 2	root@dev_was [/opt/hpws]# uname -a HP-UX dev_was B.11.31 U ia64 1073980350 unlimited-user license

하드웨어 정보

root@dev_was [/opt/hpws]# machinfo
CPU info:
Intel(R) Itanium(R) Processor 9560 (2.53 GHz, 32 MB)
1 core, 1 logical processor per socket
6.39 GT/s QPI, CPU version D0
Active processor count:
2 sockets
2 cores

Memory: 8186 MB (7.99 GB)
~~~

root@dev_was [/opt/hpws]# machinfo

CPU info:

Intel(R) Itanium(R) Processor 9560 (2.53 GHz, 32 MB)

1 core, 1 logical processor per socket

6.39 GT/s QPI, CPU version D0

Active processor count:

2 sockets

2 cores

Memory: 8186 MB (7.99 GB)

~~~

파티션정보확인

root@dev_was [/opt/hpws]# bdf
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 64487424 25488760 38694240 40% /
/dev/vg00/lvol1 2097152 445160 1639136 21% /stand
/dev/vg00/lvol4 52428800 78982 49077962 0% /was
/dev/vg01/lvol1 524156928 195115 491214207 0% /data01

root@dev_was [/opt/hpws]# bdf

Filesystem kbytes used avail %used Mounted on

/dev/vg00/lvol3 64487424 25488760 38694240 40% /

/dev/vg00/lvol1 2097152 445160 1639136 21% /stand

/dev/vg00/lvol4 52428800 78982 49077962 0% /was

/dev/vg01/lvol1 524156928 195115 491214207 0% /data01

마운트정보확인

root@dev_was [/opt/hpws]# mount -v
/dev/vg00/lvol3 on / type vxfs ioerror=mwdisable,largefiles,delaylog,dev=40000003 on Thu Oct 20 17:06:20 2016
/dev/vg00/lvol1 on /stand type vxfs ioerror=mwdisable,nolargefiles,log,tranflush,dev=40000001 on Thu Oct 20 17:06:22 2016
/dev/vg00/lvol4 on /was type vxfs ioerror=mwdisable,largefiles,delaylog,dev=40000004 on Thu Oct 20 17:06:29 2016
/dev/vg01/lvol1 on /data01 type vxfs ioerror=mwdisable,largefiles,delaylog,dev=40010001 on Thu Oct 20 17:06:29 2016
-hosts on /net type autofs ignore,indirect,nosuid,soft,nobrowse,dev=4000002 on Thu Oct 20 17:06:54 2016

root@dev_was [/opt/hpws]# mount -v

/dev/vg00/lvol3 on / type vxfs ioerror=mwdisable,largefiles,delaylog,dev=40000003 on Thu Oct 20 17:06:20 2016

/dev/vg00/lvol1 on /stand type vxfs ioerror=mwdisable,nolargefiles,log,tranflush,dev=40000001 on Thu Oct 20 17:06:22 2016

/dev/vg00/lvol4 on /was type vxfs ioerror=mwdisable,largefiles,delaylog,dev=40000004 on Thu Oct 20 17:06:29 2016

/dev/vg01/lvol1 on /data01 type vxfs ioerror=mwdisable,largefiles,delaylog,dev=40010001 on Thu Oct 20 17:06:29 2016

-hosts on /net type autofs ignore,indirect,nosuid,soft,nobrowse,dev=4000002 on Thu Oct 20 17:06:54 2016

가상메모리(Swap)공간 사용량 확인

root@dev_was [/opt/hpws]# swapinfo -tm
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 16384 0 16384 0% 0 - 1 /dev/vg00/lvol2
reserve - 703 -703
memory 7786 1685 6101 22%
total 24170 2388 21782 10% - 0 -

root@dev_was [/opt/hpws]# swapinfo -tm

Mb Mb Mb PCT START/ Mb

TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME

dev 16384 0 16384 0% 0 - 1 /dev/vg00/lvol2

reserve - 703 -703

memory 7786 1685 6101 22%

total 24170 2388 21782 10% - 0 -

설치된 OS버젼 확인

root@dev_was [/opt/hpws]# swlist -l bundle QPKBASE
# Initializing...
# Contacting target "dev_was"...
#
# Target: dev_was:/
#

QPKBASE B.11.31.1603.421a Base Quality Pack Bundle for HP-UX 11i v3, March 2016

root@dev_was [/opt/hpws]# swlist -l bundle QPKBASE

# Initializing...

# Contacting target "dev_was"...

# Target: dev_was:/

QPKBASE B.11.31.1603.421a Base Quality Pack Bundle for HP-UX 11i v3, March 2016

위의 11i v3의 경우는 Apache, Tomcat등 HP-UX사이트에서 다운받을때 해당 버젼을 다운받으면 됩니다. ip확인

root@dev_was [/opt/hpws]# netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts Oerrs Coll
lan0 1500 192.168.150.0 192.168.150.110 366806 0 267422 0 0
lo0 32808 127.0.0.0 127.0.0.1 273282 0 273282 0 0

root@dev_was [/opt/hpws]# netstat -in

Name Mtu Network Address Ipkts Ierrs Opkts Oerrs Coll

lan0 1500 192.168.150.0 192.168.150.110 366806 0 267422 0 0

lo0 32808 127.0.0.0 127.0.0.1 273282 0 273282 0 0

IP확인이나 네트웍 관련 명령어 # ifconfig lan # lanscan #nwmgr 사용

15 11 2016

HP UX jdk 설치 및 설정

Haeng Ho Kang | Uncategorized | 0

jdk 설치 (root로 해야 한다) HP-UX 버젼 확인

root@dev_was [/opt/hpws]# uname -a
HP-UX dev_was B.11.31 U ia64 1073980350 unlimited-user license

1 2	root@dev_was [/opt/hpws]# uname -a HP-UX dev_was B.11.31 U ia64 1073980350 unlimited-user license

1.다운로드 http://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=HPUXJAVAHOME HP UX용 다운받는다.(love**/ss!a) 2.기존 설치 버전확인

root@dev_was [/]# swlist -l product |grep -i java
Jdk60 1.6.0.23.00 Java 6.0 JDK
Jdk70 1.7.0.11.00 Java 7.0 JDK
Jdk80 1.8.0.00.00 Java 8.0 JDK
Jre60 1.6.0.23.00 Java 6.0 JRE
Jre70 1.7.0.11.00 Java 7.0 JRE
Jre80 1.8.0.00.00 Java 8.0 JRE

root@dev_was [/]# swlist -l product |grep -i java

Jdk60 1.6.0.23.00 Java 6.0 JDK

Jdk70 1.7.0.11.00 Java 7.0 JDK

Jdk80 1.8.0.00.00 Java 8.0 JDK

Jre60 1.6.0.23.00 Java 6.0 JRE

Jre70 1.7.0.11.00 Java 7.0 JRE

Jre80 1.8.0.00.00 Java 8.0 JRE

3.기존 jdk 삭제할 경우

  root@dev_was [/opt]# swremove -x enforce_dependencies=false Jdk70 Jre70

  root@dev_was [/opt]# rm -rf java7

root@dev_was [/opt]# swremove -x enforce_dependencies=false Jdk70 Jre70

root@dev_was [/opt]# rm -rf java7

4.설치를 위해 swagentd 재시작(오류 발생 방지를 위해서) # export LANG=C # export LC_ALL=C

root@dev_was [/opt]# swagentd -r

1	root@dev_was [/opt]# swagentd -r

5.다운받은 위치로 가서 root@dev_was [/opt]# swinstall -s ./Itanium_JDK_JRE_7.0.18_September_2016_Z7550-63369_java7_17018_ia.depot 위의 화면이 뜨고 여기서 Return키를 눌러 선택하고 […]

12 10 2016

Oracle PK, INDEX등 처리

Haeng Ho Kang | DataBase, Oracle | 0

Primary Key (1)생성 CREATE UNIQUE INDEX 테이블명_UK ON 테이블 (column1, column2) TABLESPACE 테이블스페이스 ; ALTER TABLE 테이블명 ADD ( PRIMARY KEY (column1, column2) USING INDEX 테이블명_UK ENABLE VALIDATE); (2)삭제 alter table 테이블명 drop primary key; drop index 테이블명_UK; INDEX CREATE INDEX IDX_CMM_USER ON TB_CMM_USER(SVCID);

Previous Posts Next posts