Oracle介绍与安装

LogoLogoLogoLogoOracle10gOracle10gOracle10gOracle10g介绍与安装中软国际卓越培训中心www.5retc.comwww.5retc.comwww.5retc.comwww.5retc.com�数据库描述语言�数据库操纵/查询�数据库翻译程序�数据库管理程序数据库概论：DBMSDBMSDBMSDBMS组成�存储、检索、修改数据�保证数据的一致性�解决并发问题�支持对数据库操作的接口�进行数据管理数据库概论：DBMSDBMSDBMSDBMS功能�层次型�网状型�关系型�对象-关系型数据库数据库的发展过程分布式数据库系统结构分布式数据库系统结构CMGDBMSLDBMSLDBMSGDBMSCMGDBMSLDBMSLocalDatabaseCMGDBMSCM计算机网络计算机网络LocalDatabaseLocalDatabaseLDBMS全局数据字典全局数据字典全局数据字典OracleOracleOracleOracle分布式数据库系统结构SQL*NETDBRDBMSTOOLSTOOLSRDBMSSQL*NETRDBMSTOOLSDBDBSQL*NETTOOLSSQL*NET计算机网络计算机网络PCPCPCPC局部数据库局部数据库全局数据全局数据字典字典局部数据库局部数据库全局数据全局数据字典字典局部数据库局部数据库全局数据全局数据字典字典OracleOracleOracleOracleClient/ServerClient/ServerClient/ServerClient/Server数据库结构NetworkOracleOracleOracleOracleServerServerServerServerPCPCPCPCPC数ServerClientServerClientServerClientServerClient据集中管理C/SC/SC/SC/S是面向连接OracleOracleOracleOracleBrowser/ServerBrowser/ServerBrowser/ServerBrowser/Server数据库结构NetworkOracleOracleOracleOracleServerServerServerServerPCPCPCPCPCWebBrowserWebBrowserWebBrowserWebBrowserServerServerServerServer非面向连接BrowserBrowserBrowserBrowserWebWebWebWebServerServerServerServerOracleWebOracleWebOracleWebOracleWebServerServerServerServerOracleWebOracleWebOracleWebOracleWebServerServerServerServer企业网络企业网络INTERNETINTERNETINTERNETINTERNETINTERNETINTERNETINTERNETINTERNETFiles/PagesOracleServerOracleServerOracleServerWebBrowserWebBrowserWebBrowserWebBrowser通过通过WebWebWebWebWebWebWebWeb访问各种数据访问各种数据OracleOracleOracleOracle数据库三层应用体系结构OracleOracleOracleOracleOracleOracleOracleOracle网络连接网络连接配置及配置及LoginLoginLoginLoginLoginLoginLoginLogin界面界面((((((((Oracle10gNetOracle10gNetOracle10gNetOracle10gNetOracle10gNetOracle10gNetOracle10gNetOracle10gNetServicesServicesServicesServicesServicesServicesServicesServices配置配置))))))))OracleDatabase10g新特性创建本地网络服务名创建本地网络服务名Oracle10gNetServices配置添加添加Oracle10gNetServices配置11111111、确定数据库服务名、确定数据库服务名Oracle10gNetServices配置2.2.2.2.2.2.2.2.确定网络协议确定网络协议((((((((TCP/IPTCP/IPTCP/IPTCP/IPTCP/IPTCP/IPTCP/IPTCP/IP)Oracle10gNetServices配置3.3.3.3.3.3.3.3.确定主机名或确定主机名或IPIPIPIPIPIPIPIP地址地址4.4.4.4.4.4.4.4.确定确定ListenerPortListenerPortListenerPortListenerPortListenerPortListenerPortListenerPortListenerPort号号Oracle10gNetServices配置5.5.5.5.5.5.5.5.测试测试TESTTESTTESTTESTTESTTESTTESTTESTOracle10gNetServices配置6.6.6.6.6.6.6.6.确定网络服务名确定网络服务名Oracle10gNetServices配置完成完成Oracle10gNetServices配置OracleNetworkConfigurationOracleOracleOracleOracleOracleOracleOracleOracle网络网络配置及配置及LoginLoginLoginLoginLoginLoginLoginLogin界面界面((((((((手工配置手工配置OracleOracleOracleOracleOracleOracleOracleOracle网络配置文件网络配置文件))))))))ClientClientServerServertnsnamestnsnamestnsnamestnsnames....oraoraoraoralistener.listener.listener.listener.listener.listener.listener.listener.oraoraoraoraoraoraoraoratnsnamestnsnamestnsnamestnsnames....oraoraoraoraClientClient端：端：tnsnamestnsnames..oraora(Net8)(Net8)OracleOracleOracleOracle.world=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)((((HOST=SUN3000)HOST=SUN3000)HOST=SUN3000)HOST=SUN3000)(PORT=1521))(CONNECT_DATA=(SID=ora8i)(SID=ora8i)(SID=ora8i)(SID=ora8i))))))ClientClient端：端：tnsnamestnsnames..oraora(Oracle8(Oracle8ii))OracleOracleOracleOracle=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)()()()(HOST=Sun4500HOST=Sun4500HOST=Sun4500HOST=Sun4500)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ora8i)(SERVICE_NAME=ora8i)(SERVICE_NAME=ora8i)(SERVICE_NAME=ora8i)))#使用Oracle8i数据库服务名：Service_Names#Service_Names缺省为数据库服务名tnsnamestnsnamestnsnamestnsnamestnsnamestnsnamestnsnamestnsnames........oraoraoraoraoraoraoraora(Oracle9iNetServices)(Oracle9iNetServices)ORA9i=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sun4500)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ora9i.tsinghua.edu.cn)))tnsnamestnsnamestnsnamestnsnamestnsnamestnsnamestnsnamestnsnames........oraoraoraoraoraoraoraora(Oracle10(Oracle10ggNetServices)NetServices)SUN6500=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=166.111.7.248166.111.7.248166.111.7.248166.111.7.248)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ora10g.ora10g.ora10g.ora10g.ciccicciccic.training..training..training..training.tsinghuatsinghuatsinghuatsinghua....eduedueduedu....cncncncn)))SQL*PLUS登录界面1.1.1.1.1.1.1.1.通常登录通常登录SQL*PLUS登录界面2.2.2.2.2.2.2.2.通常登录通常登录@@@@oracleoracleoracleoracleSQL*PLUS登录界面3.3.3.3.3.3.3.3.简化登录简化登录((((((((注册后注册后))))))))Oracle10Oracle10Oracle10Oracle10Oracle10Oracle10Oracle10Oracle10gggggggg数据库产品组成数据库产品组成Oracle10g数据库产品：OracleDatabase10gStandardEditionOneOracleDatabase10gStandardEditionOracleDatabase10gEnterpriseEdition(EE)OracleDatabase10gPersonalEditionOracleDatabase10gOracleDatabase10gOracleDatabase10gOracleDatabase10gAdministratorRuntimeCustomInstantClientOracleClientOracleClientOracleClientOracleClientOracle10g数据库产品：OracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleDatabase10gCompanionCDOracleOracleDatabaseDatabaseCompanionCompanionCDCD提供以下功能提供以下功能::••JPublisherJPublisher••LegatoLegatoSingleSingleServerServerVersionVersion••Nativ