'Database'에 해당되는 글 5건

  1. 2008.10.23 SQLTools++
  2. 2008.05.11 Database Security 관련 Site
  3. 2008.04.20 MS-SQL 관련 사이트
  4. 2008.01.06 Site List
  5. 2007.12.23 Oracle의 시작과 중지 절차

SQLTools++

DataBase/Oracle 2008.10.23 15:47
오늘 소개할 tool은 SQLTools++....
DBA가 아닌 나로서는 예전에 postgres, mysql이나 들어가서 뚝딱뚝딱하던게 고작...
Toad, SQLgate등 FrontEnd가 있긴 하지만..
이 툴은 무료로 사용이 가능하단 점이..

내가 DB 전문가가 아니라서 아직은 많이 모르지만.. 그래도 괜찮다고 생각이 든다.

http://sourceforge.net 에 가서 "oracle frontend"로 검색을 했더니 저 툴이 나오더군..

아래 그림은 툴을 이용해 접속한 화면..
사용하기 위해서는 Oracle Client가 깔려 있어서 OCI.dll을 사용할 수 있어야 한다.


신고
Posted by She쥐포s
http://www.databasesecurity.com/index.htm
신고
Posted by She쥐포s
- MS SQL Server Community Site(한글, 회원가입 필요)
    http://www.sqlleader.com
- ib96 mssql 무료 강좌 Site(한글, 회원가입 필요, 현재 가입후 강좌이용 가능)
    http://sqlto.ib96.com
- SQL 2000  평가판 download
    http://www.microsoft.com/downloads/details.aspx?displaylang=ko&FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335
- MS SQL Server 2000 서비스팩 3a
    http://www.microsoft.com/downloads/details.aspx?displaylang=ko&FamilyID=90DCD52C-0488-4E46-AFBF-ACACE5369FA3
- MS SQL Server 2000 서비스팩 4
    http://www.microsoft.com/downloads/details.aspx?displaylang=ko&FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5
신고
Posted by She쥐포s

Site List

보안 2008.01.06 23:18

○ Vulnerability
    - http://packetstormsecurity.org/
    - http://www.elsenot.com/
    - http://milw0rm.com/
    - http://www.osvdb.org/

○ Education & Study
    - http://www.hackerhighschool.org/

○ Tool
    - http://www.nagiosexchange.org/
    - http://www.ntop.org/
    - http://www.splintered.net/sw/flow-tools/
    - http://www.google.com/search?hl=en&q=prtg

○ Article for Log Level Security
    - http://support.microsoft.com/kb/282791/en-us
    - http://support.microsoft.com/kb/314980/en-us
    - http://support.microsoft.com/kb/300549/en-us
    - http://support.microsoft.com/kb/262177/en-us
    - http://support.microsoft.com/kb/310399/en-us
    - http://msdn2.microsoft.com/en-us/library/aa392285.aspx

○ Database Security
    - http://www.petefinnigan.com/

○ MS Security Info
    - http://securityadmin.info/

○ Security Videos
    - http://security-freak.net/videos.html

○ Other Sources
    - http://chaosreader.sourceforge.net/
    - http://gentoo-wiki.com/HOWTO_setup_a_gentoo_bridge
    - http://www.wireshark.org/
    - http://cmrr.ucsd.edu/people/Hughes/CmrrSecureEraseProtocols.pdf
    - http://tinyurl.com/24vuj8
    - http://tinyurl.com/35mbc9
    - http://www.nber.org/sys-admin/overwritten-data-guttman.html
    - http://www.DaveKleiman.com/Files
    - http://tinyurl.com/8zblp
    - http://tinyurl.com/iqx3
    - http://www.giac.net/certified_professionals/practicals/gcfa/265.php
    - http://www.payam.com.au/hard-disk-data-recovery.htm
    - http://ocw.mit.edu/OcwWeb/web/courses/courses/index.htm
    - http://csrc.nist.gov/publications/nistpubs/800-88/NISTSP800-88_rev1.pdf
    - https://strikecenter.bpointsys.com/articles/2007/08/26/vista-gadget-patches-in-ms07-048


    -
    -

신고
Posted by She쥐포s

o Oracle 8i 이전
    -  Oracle Start
        root@server:/> su - oracle
        oracle@server:/dbase/oracle8> svrmgrl
        SVRMGRL> connect internal
        SVRMGRL> startup
        oracle@server:/dbase/oracle8> lsnrctl start

    - Oracle Stop
        root@server:/> su - oracle
        oracle@server:/dbase/oracle8> lsnrctl
        LSNRCTL> set password (패스워드 입력)
        LSNRCTL> stop
        LSNRCTL> exit
        oracle@server:/dbase/oracle8> svrmgrl
        SVRMGRL> connect internal
        SVRMGRL> shutdown immediate

o Oracle 9i 이후
    - Oracle Start
        PROMPT> sqlplus /nolog
        SQL> conn sys/패스워드 as sysdba
        SQL> startup
        PROMPT> lsnrctl start

    - Oracle Stop
        PROMPT> lsnrctl
        LSNRCTL> set password (패스워드 입력)
        LSNRCTL> stop
        PROMPT> sqlplus /nolog
        SQL> conn sys/패스워드 as sysdba
        SQL> shutdown immediate

신고
Posted by She쥐포s