2013年3月12日
ORA-00845 MEMORY_TARGET not supported on this system (oracle11g for asianux3 )
摘要： 故障：ORA-00845: MEMORY_TARGET not supported on this systemOracle 11g的Linux版本在修改了MEMORY_TARGET或者SGA_TARGET后启动可能会报错：SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORA-00845: MEMORY_TARGET not supported on this system这个问题是由于设置SGA的大小超过了操作系统/dev/shm的大 阅读全文
posted @ 2013-03-12 23:22 ArcerZhang 阅读(167) 评论(0) 推荐(0) 编辑
Chapter03-Basic Oracle Net Server Side Configuration
摘要： The Listener ProcessA listener process can listen for more than one database 一个监听进程，可以监听多个数据库； 监听进程可以与database在不同的机器上；Multiple listeners can listen on behalf of a single database to perform load balancing. 一个数据库可以启动多个listenerThe listener can listen for multiple protocolsNote:高版本的listener可以连接低版本的数... 阅读全文
posted @ 2013-03-12 18:03 ArcerZhang 阅读(132) 评论(0) 推荐(0) 编辑
Chapter02-Oracle Net Architecture
摘要： Concepts & TerminologyView Code Database ServicesService Name A logical representation of a database The way a database is presented to clientsConnect Descriptor Location of the database Name of the database serviceListener Receives client connection requests Hands requests to the ... 阅读全文
posted @ 2013-03-12 14:31 ArcerZhang 阅读(141) 评论(0) 推荐(0) 编辑
Chapter01-Netwoking Overview
摘要： 一般情况存在大量并发的时候，就会使用Shared Server模式；为了应对更大规模的并发访问，oracle提供了OCM（Oracle Connection Manager）;Networking OverviewOracle 9i　Network SolutionsConnectivityDirectory ServicesScalabilitySecurityAccessibilityThe connections types can be在安装了oracle server的linux系统中，sqlplus连接oracle server，走的是RPC，进程间通讯；Clinet-Server 阅读全文
posted @ 2013-03-12 14:02 ArcerZhang 阅读(133) 评论(0) 推荐(0) 编辑