摘要:
故障: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的大 阅读全文
摘要:
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可以连接低版本的数... 阅读全文
摘要:
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 ... 阅读全文
摘要:
一般情况存在大量并发的时候,就会使用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 阅读全文