untitled

Transcription

1 Oracle on Windows etc Windows Server System Center / OTN Japan + Oracle Database.NET Developer Center / OTN Japan Oracle / OTN Japan 1

2 / Oracle on Windows 2 2

3 Oracle Direct Seminar < >

4 Agenda.NET + Oracle Appendix:.NET 4

5 Visual Studio Oracle Data Access Components Oracle Developer Tools for Visual Studio.NET (ODT) Microsoft Visual Studio C++ / C# VB.NET (ASP/ASP.NET) MTS/COM IIS Oracle Database Extensions for.net (ODE.NET) Oracle Data Provider for.net (ODP.NET) Oracle Services for MTS Visual Studio 2005, 2008.NET Framework 2.0/3.x 5

6 ODP.NET NET Oracle 6

7 ODP.NET 2002 VS.NET , 2008.NET Framework 1.0 ADO.NET Oracle 7

8 ODP.NET ODP.NET Oracle CD ace C OTN-J h/dotnet/index.html Oracle ODT ODP.NET ODP.NET VS.NET 8

9 OTN-J.NET Developer Center 9

10 Oracle Data Access Components (ODAC) ODP.NET, ODT ODAC 10

11 Oracle Data Access Components (ODAC) Oracle Universal Installer GUI 11

12 Agenda.NET + Oracle Appendix:.NET 12

13 ODT Visual Studio Oracle 13

14 ODT Oracle Explorer DB PL/SQL PL/SQL Data Window Oracle Query Window SQL*Plus 14

15 ODT Oracle PL/SQL Oracle Oracle Oracle 15

16 Oracle Oracle Oracle Oracle 16

17 PL/SQL PL/SQL 17

18 PL/SQL Visual Studio PL/SQL 18

19 ODAC ODT Server Explorer Oracle Database SQL*Plus 19

20 ODAC ODT Server Explorer Visual Studio 2005 Server Explorer ODT Visual Studio 2005 Oracle Database SQL Visual Studio 20

21 ODAC ODT GUI.NET Custom Class(C#,VB.NET, C++ ) SQL*Plus EDIT HOST SQL*Plus SQL 21

22 ODT ODT Oracle CD CD OTN-J Oracle EXE setup.exe exe setup.exe OUI ODT ODP.NET VS.NET 22

23 ODT Visual Studio 23

24 ODAC ODT Oracle Visual Studio Automatic Database Diagnostic Monitor(ADDM) SQL Tuning Adviser ADDM AWR ( ) ) / SQL SQL 24

25 ODAC ODT SQL Tuning Adviser 25

26 ODAC ODT Oracle Performance Analyzer 26

27 ODE.NET.NET 27

28 Oracle Database Extensions for.net Microsoft Visual Studio.NET 2005 C++ / C# VB.NET Oracle Database Extensions for.net (ODE.NET) DLL (foo.dll) PL/SQL Oracle Developer Tools for Visual Studio.NET (ODT) 28

29 ODE.NET Oracle Instance PL/SQL Oracle CLR Host Microsoft.NET CLR 29

30 .NET Oracle Project.NET 30

31 .NET 1. Oracle 2..NET 3..NET DLL PL/SQL SYS SYSTEM 31

32 .NET Oracle Deployment Wizard for.net.net 32

33 ODAC ODE.NET.NET Stored Procedure Nullable type.net Framework 2.0 Nullable Type 33

34 Agenda.NET + Oracle Appendix:.NET 34

35 ODP.NET 35

36 OUI ODP.NET Oracle Client Oracle GUI DB Server, Client GUI Silent install Microsoft SMS Instant Client XCopy 36

37 Instant Client XCopy Install Step 1: Unzip and copy IC files to disk Step 2: install.bat t Oracle Home 3 Step 3: Windows PATH Step 4: NLS_LANG 37

38 XCopy Install.bat 38

39 Instant Client XCopy Instant Client xcopy SQL*Plus OCI OCCI ODBC JDBC-OCI Instant Client xcopy ODP.NET Oracle Providers for ASP.NET Oracle Provider for OLE DB OO4O Oracle Services for MTS 39

40 tnsname.ora ODP.NET ONLY tnsnams.ora 40

41 Multiple Oracle Homes(MOH) Multiple Oracle Homes (MOH) Oracle : Oracle Database version example: Oracle : d: oracle10 ora102 Oracle : d: oracle11 ora110 41

42 Multiple Oracle Homes Multiple Oracle Homes : HKLM Software Oracle ALL_HOMES HOMES and HKLM Software Oracle HOME(n) HKLM Software Oracle KEY_ home 42

43 Multiple Oracle Homes Oracle Client Software Oracle Oacece client DLLs s Windows Path Web (IIS) IIS supports separate worker processes in same instance IIS 6 for Windows Server 2003 process Dll Client/Server Oracle Home PATH 43

44 Oracle Homes in.net ODP.NET ODP.NET.NET config files Oracle DLLs Oracle Client ODP.NET DLL 1. Current application directory 2. Application config or web.config 3. Machine.config 4. Windows Registry HKLM Software Oracle ODP.NET <version> DllPath 5. Windows System Path setting 44

45 Agenda.NET + Oracle Appendix:.NET 45

46 ODP.NET 46

47 ODP.NET 1 FetchSize 65,

48 ODP.NET 2 1 Select * from emp DB 1 WEB DB 2 Sl Select t*f from emp 2 WEB DB 48

49 ODP.NET 3 Client = Connection WEB DB Client > Connection WEB DB 49

50 ODP.NET 50

51 ODP.NET FetchSize 64KB 51

52 ODP.NET / BLOB BLOB Oracle Data Provider for.net 11.1 LOB Oracle 11g

53 ODP.NET OracleBulkCopy Oracle Oracle Oracle Data Provider for.net

54 ODP.NET 54

55 Oracle Database Result Cache Oracle Datatbase 11g Inventory Orders Line Items Inventory Orders Line Items Back Orders Pick Lists Back Orders Pick Lists SQL 55

56 Oracle Database Result Cache SQL SGA SGA SQL Select Select A A B B 56

57 Oracle Database Result Cache alter system set RESULT_CACHE_MODE = 'FORCE'; MANUAL FORCE select /*+ result_cache */ first_name, last_name from employees RESULT_CACHE_MODE MANUAL SQL 57

58 ODP.NET SQL Q Where 58

59 ODAC ODP.NET ODP.NET SQL or PL/SQL Application (A) ODP.NET Cache ODP.NET Cache ) ODP.NET Cache 59

60 Oracle Database SecureFiles SecureFiles LOB Oracle Oracle 11g

61 Oracle Database SecureFiles STORE AS SECUREFILE SQL> CREATE TABLE t1 (c1 CLOB) 2 LOB (c1) STORE AS SECUREFILE ; BASICFILE (STORE AS ) BASICFILE SQL> CREATE TABLE t1 (c1 CLOB) 2 LOB (c1) STORE AS BASICFILE ; 61

62 Oracle Database SecureFiles LOB LOB 62

63 ODP.NET 63

64 Oracle Database ODP.NET Pooling=FALSE string no_pool = "User Id=hr; Password=hr; Data Source=oramag; Enlist=false; Pooling=false" Pooling=TRUE string with_pool = "User Id=hr; Password=hr; Data Source=oramag; Enlist=false; Pooling=true" Pooling TRUE 64

65 ODP.NET ONLY Oracle Database OS ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET OS 65

66 Oracle Database Perfmon Windows Perfmon ODP.NET ODP.NET Oracle Data Provider for.net 66

67 .NET Visual Studio 2005, 2008 Oracle Oracle Data Provider for.net(odp.net) NET) Oracle Developer Tools for Visual Studio.NET(ODT) Oracle Database Extensions for.net(ode.net) 67

68 68

69 OTN!! Oracle Technology Network(OTN) OTN OTN Oracle 100% 69

70 OTN!!!! /tec o ogy/g oba /jp/o a d/ot a /. t 70

71 IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database 71

72 Oracle Direct Oracle OaceDirect IT / Web ~ 9:00~12:00 13:00~18:00 72

73 73