在安装了oracle 11g后,发现遇到问题,总是在隔一天后出现,如果时间相对短,重新用工具连接,那么出现ORA-12518 TNS: 监听程序无法分发客户机连接;原来的已连接的web及应用程序都可以访问相关数据库; 如果时间相对长,重新用工具连接,出现:ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
原来已连接的web及应用程序仍都可能访问相关数据库,不知如何解决这个问题
运行环境:windows 2003 32位系统, Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Productionlistener.ora
DIRECT_HANDOFF_TTC_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\app\zhongqi\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
)
)SQLNET.oraSQLNET.AUTHENTICATION_SERVICES= (NONE)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)tnsname.oraORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORA-01034 ORACLE not available
原来已连接的web及应用程序仍都可能访问相关数据库,不知如何解决这个问题
运行环境:windows 2003 32位系统, Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Productionlistener.ora
DIRECT_HANDOFF_TTC_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\app\zhongqi\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
)
)SQLNET.oraSQLNET.AUTHENTICATION_SERVICES= (NONE)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)tnsname.oraORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方案 »
- 如何取前面一段的连续数据,谢谢了(急)!
- oracle.jdbc.driver.T4CConnection@1e1414ed is closed
- 如何定义一个字段,只能接受字母
- 散分帖,oracle的job
- oracle insert into 字段是否有长度限制?
- Oracle 的高手们 强烈解决一下数据库还原的问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1
- oracle创建和控制数据库笔记
- 怎么突破sqlldr的char类型的长度限制
- 9i,我使用console进行备份的时候,它需要具有SYSDBA的用户,我的数据库是MYDB,在那里添加这个用户,并赋予权限???
- SQL优化请教
- ORACLE配置失败
- 错误ORA-06512的问题
看看 local listener 有没有值 ,如果没有 则如下设置(例子)
SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=10.238.2.2)(PORT=1521)(SID=orcl))';
调高memroy_target参数,
alter system set memory_target=1024M
然后重启oracle。
每个链接耗掉的内存使得share memery不够用。
扩一下sga。或者你把链接个数控制下
alter system set memory_max_target=2048M scope=spfile;
然后需要重启数据库后生效。
memory_target=sga+pga,oracle会帮你自动分配合适的sga和pga的大小。
show parameter sessions;
show parameter processes;若是该参数引起,则可以将processes适当扩大,sessions一般设置为processes的1.1倍然后重启数据库再看看...