데이터베이스_오라클_부록(최종).indd

Size: px

Start display at page:

Download "데이터베이스_오라클_부록(최종).indd"

서일 학
5 years ago
Views:

version7update55windowsosi586os JDKJava87 Tomcat WAS Web Application Server JSP C2JDK Java Sun

1 C httpwwworaclecomdownloads DownloadsJavaJavaSE C1 5JDK JDKJavaDevelopmentKit Eclipse IDE JavaSEJavaSE7u55JDKDOWNLOAD JavaSEDevelopmentKitAcceptLicenseAgreement OS jdk7u55windowsi586exe7u55 version7update55windowsosi586os JDKJava87 Tomcat WAS Web Application Server JSP C2JDK Java Sun Microsystems 1995 Oracle 8 Windows7WindowsVistaWindowsXPWindowsServer2008 CPUIntel100IntelPentium166MHz RAM64MB 98MB NextNext

2 2 1 2 JDKJRENext Close JDKJDK 3 JAVAHOMECLASSPATHPath JAVAHOMEJDK

C1 JAVAHOME CProgramFilesJavajdk17055 CLASSPATH

JDBCJavaDatabaseConnectivityDBMS InterfaceDBMSSQL

3 C1 JAVAHOME CProgramFilesJavajdk17055 CLASSPATH JAVAHOMEjrelibext Path JAVAHOMEbin C3JDBC JDBCJavaDatabaseConnectivityDBMS InterfaceDBMSSQL APIApplicationProgramInterface JDBCojdbc6jar JDKHelloWorldjava Hello WorldJDK Java wwworaclecomdownloadsdriversjdbcdriversjdbcdriver DownloadsDBjdbcAcceptLicenseAgreementojdbc6jar ojdbc6jar jdk HelloWorldjava C:\madang

$C\madangC\ 1 2$

4 C\madangC\ 1 2 madangeclipseeclipseeclipseexe ojdbc6jarjdk C:\Program Files\Java\jre7\lib\ext C4 Eclipse eclipse workspace UsethisasthedefaultanddonotaskagainOK WelcometoEclipse IDE httpwwweclipseorgdownloadseclipsedownloads EclipseStandard432OS

5 FileNewJavaProject ProjectnameHelloWorldNextFinish PackageExplorerHelloWorldPackage HelloWorldsrc NewPackageNametestpackFinish 2 3 srctestpackhelloworldclass PackageExplorerHelloWorldsrctestpack NewClassNameHelloWorldFinish ClassHelloWorldjava HelloWorldclass 1

6 2 1 Windows2003ServerWindows2008ServerWindowsVistaWindows7 OracleSQLServerDB2UDBMySQLODBCSybase CPUIntelPentium4 RAM2GB 2GB httptomcatapacheorgdownloadtomcat BinaryDistributions32bit64bit WindowsServiceInstaller C5 TomcatApacheJSP JSP

7 NextIAgree Next Next InstallFinish Nextjava jrejdkjre C:\Program Files\Java\jdk1.7.0_55\jre

8 mdtestjspc:\programs Files\Apache Software Foundation\Tomcat 8.0\webapps\Root mdtestjsp servicesmsc ApacheTomcat80Tomcat8

9 D Submit D1 6ERwinERwin CaseToolComputerAddedSofterEngineering ERwinDataModeler CommunityEdition25 ERwinDMR95CommunityEdition D2 CAhttperwincomProductsCAERwinData ModelerCommunityEditionCommunityEdition DownloadNow CommunityEdition 1 2

10 D3 ERwinexeInstall Iagree Next Iagree Next Next Next 1 2 InstallFinish

11 E 1 2 E1STARTUPSHUTDOWN CAERwinERwinDataModelerr9ERwin DataModelerCAErwinDataModelerLicensingOK Windows ERwin SHUTDOWNSTARTUP STARTUP SHUTDOWNOPENNOMOUNTMOUNT OPEN E1 DBSTARTUP STARTUPDBASTARTUP ListenerTNSTransparentNetworkSubstrateTNS DBASTARTUPSQLPlus

$STARTUPSHUTDOWNSYSDBA C:\Users\madang>sqlplus /AS SYSDBA SQLSELECT$ $FROMVINSTANCE SQLPlusidle C:\Users\madang>sqlplus /AS SYSDBA SHUTDOWNDB$

12 SHUTDOWNSTARTUP SQL> SHUTDOWN IMMEDIATE; cmdsqlplus STARTUPSHUTDOWNSYSDBA C:\Users\madang>sqlplus /AS SYSDBA SQLSELECT FROMVINSTANCE SQLPlusidle C:\Users\madang>sqlplus /AS SYSDBA SHUTDOWNDB SHUTDOWN [NORMAL TRANSACTIONAL IMMEDIATE ABORT ] NORMALDB TRANSACTIONALDB IMMEDIATEDB ABORT DB

13 DBSTARTUPSTARTUPDB STARTUP [FORCE] [RESTRICT] [OPEN [RECOVER] [database] MOUNT NOMOUNT ] DB FORCEDB RESTRICTDB OPEN RECOVER NOMOUNTDB MOUNTCONTROLFILE DBSTARTUPDB HealthCheckHealthCheckDB DBATool Oracle SQL> STARTUP SQL> Exit E2OracleInstantClient TNSDBMS

$oralistenerbakora C:\app\madang\product\11.2.$

14 DBDB DB 11glistener OralceDB11ghome1TNSListener listenerorasidnameorcl SIDHOSTlocalhostDB madangpclistenerora listener oralistenerbakora C:\app\madang\product\11.2.0\dbhome_1\NETWORK\ADMIN listenerora OralceDB11ghome1TNSListener cmd listener C:\Users\madang> lsnrctl status

15 3 7 Windows TCP1521 httpwwworaclecomdownloadsoracleinstantclient OS gR2 12gR1InstantClientPackageBasic AcceptLicenseAgreement

$1 2 C\$

16 1 2 C\ C\instantclient121 E1ORACLEHOMETNSADMINNLSLANG Path C\instantclient121

$E1 em em ORACLE_HOME C:\instantclient_12_1 TNS_ADMIN C:\instantclient_12_1 NLS_LANG KOREAN_KOREA.$

17 E1 em em ORACLE_HOME C:\instantclient_12_1 TNS_ADMIN C:\instantclient_12_1 NLS_LANG KOREAN_KOREA.KO16MSWIN949 Path Cinstantclient121 DBtnsnames orapcc\instantclient_12_1 tnsnamesora Oracle 11g r2 C:\app\madang\product\11.2.0\dbhome_1\NETWORK\ADMIN Oracle 11g XE C:\oraclexe\app\oracle\product\11.2.0\server\NETWORK\ADMIN tnsnamesorahost HOSTIPSIDServicename orcliphost tns orcllineorclsidtns localhostpc localhostip https em E3em ementerprisemanager em PC

18 systemmanager1 cmdcmd ORACLEEnterpriseManagerDB

데이터베이스_오라클_부록(최종).indd

데이터베이스_오라클_부록(최종).indd E 데이터베이스관리 1 2 E.1 데이터베이스시작과종료 (STARTUP & SHUTDOWN) 오라클은윈도우운영체제에서시스템서비스로돌아가는일종의응용프로그램이다. 이는 6 설치가완료되었으면 [ 시작 ]-[CA]-[ERwin]-[ERwin Data Modeler r9]-[erwin Data Modeler] 을실행한다. [CA Erwin Data Modeler Licensing]