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 1 2 JDKJRENext Close 1 3 1 2 1 2 JDKJDK 3 JAVAHOMECLASSPATHPath JAVAHOMEJDK
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 madangeclipseeclipseeclipseexe 2 3 1 ojdbc6jarjdk C:\Program Files\Java\jre7\lib\ext C4 Eclipse eclipse workspace UsethisasthedefaultanddonotaskagainOK WelcometoEclipse IDE httpwwweclipseorgdownloadseclipsedownloads EclipseStandard432OS32 64 1 2
FileNewJavaProject ProjectnameHelloWorldNextFinish 1 2 3 4 5 PackageExplorerHelloWorldPackage HelloWorldsrc NewPackageNametestpackFinish 2 3 srctestpackhelloworldclass PackageExplorerHelloWorldsrctestpack NewClassNameHelloWorldFinish 3 2 1 ClassHelloWorldjava HelloWorldclass 1
2 1 Windows2003ServerWindows2008ServerWindowsVistaWindows7 OracleSQLServerDB2UDBMySQLODBCSybase CPUIntelPentium4 RAM2GB 2GB httptomcatapacheorgdownloadtomcat80 3 4 BinaryDistributions32bit64bit WindowsServiceInstaller C5 TomcatApacheJSP JSP
NextIAgree 1 2 1 2 Next Next InstallFinish 2 1 2 1 3 Nextjava jrejdkjre http://localhost:8080/ C:\Program Files\Java\jdk1.7.0_55\jre
mdtestjspc:\programs Files\Apache Software Foundation\Tomcat 8.0\webapps\Root mdtestjsp http://localhost:8080/mdtest.jsp servicesmsc ApacheTomcat80Tomcat8
D Submit D1 6ERwinERwin CaseToolComputerAddedSofterEngineering ERwinDataModeler CommunityEdition25 ERwinDMR95CommunityEdition D2 CAhttperwincomProductsCAERwinData ModelerCommunityEditionCommunityEdition DownloadNow CommunityEdition 1 2
D3 ERwinexeInstall Iagree Next 2 1 3 Iagree Next Next Next 1 2 InstallFinish
E 1 2 E1STARTUPSHUTDOWN CAERwinERwinDataModelerr9ERwin DataModelerCAErwinDataModelerLicensingOK Windows ERwin SHUTDOWNSTARTUP STARTUP SHUTDOWNOPENNOMOUNTMOUNT OPEN E1 DBSTARTUP STARTUPDBASTARTUP ListenerTNSTransparentNetworkSubstrateTNS DBASTARTUPSQLPlus
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
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
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
3 7 Windows TCP1521 httpwwworaclecomdownloadsoracleinstantclient OS 1 2 2 1 1120111gR2 12gR1InstantClientPackageBasic AcceptLicenseAgreement
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.KO16MSWIN949 Path Cinstantclient121 https://localhost:1158/em 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 orcliphost192168110tns orcllineorclsidtns localhostpc localhostip192168110 https1921681101158em E3em ementerprisemanager em PC
systemmanager1 cmdcmd ORACLEEnterpriseManagerDB