oracle ORA-27101 Shared memory realm does not exis

浏览 13995 次

锁定老帖子主题：oracle ORA-27101 Shared memory realm does not exis 精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
作者	正文
joanzq 等级: 初级会员性别: 文章: 23 积分: 80 来自: 武汉	发表时间：2008-11-12 最后修改：2008-11-12 相关推荐: oracle not available shared,ORA-01034: ORACLE not available ORA-27101: shared memory realm does not ... oracle -27101,处理错误：ORA-27101: shared memory realm does not exist记实 oracle出现问题无法启动：ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ORA-27101:shared memory realm does not exist 【Oracle报错】ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist 更多相关推荐入门技术 oracle 本来可以用，新建了个库后，新库不能用，我把它删了，原来的库ORCL用sqlplus ，plsql 以及用oralce 的net manager 测试都登录报错误， ORA-27101 Shared memory realm does not exist ORA-01034 ORACLE not available 怎样解决呀？ set ORACLE_SID=orcl 实例也重新设置了。服务，监听重新启动了！ CMD 中tnstping orcl 也可以成功。 ------------------------------- 我的tnsnames.ora 文件也没看出什么问题 ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) ------------------------------------------------------------ listener.ora 文件 # listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_4\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.1.0\Db_4) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = D:\oracle\product\10.1.0\Db_4) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) ) ------------------------------------------------------------------------------------ 还有sqlnet.ora 文件 SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) ------------------------------------------------------------------ 按网上说的，CMD 中 connect /as sysdba 结果报ORA-01031: insufficient privileges。声明：ITeye文章版权属于作者，受法律保护。没有作者书面许可不得转载。推荐链接
返回顶楼

joanzq 等级: 初级会员性别: 文章: 23 积分: 80 来自: 武汉	发表时间：2008-11-12 注销（SQLNET.AUTHENTICATION_SERVICES= (NONE)，没有效果，改变shared_pool_size=10000000也不行那个remote_logIn_passwordfile参数。设置成EXCLUSIVE再重新启动数据库也不行 CMD 中 sqlplus /nolog connect /as sysdba 结果报ORA-01031: insufficient privileges。难道只能重装吗？
返回顶楼	回帖地址 0 0 请登录后投票

joanzq 等级: 初级会员性别: 文章: 23 积分: 80 来自: 武汉	发表时间：2008-11-12 我的init.ora 文件 ############################################################################## # Copyright (c) 1991, 2001, 2002 by Oracle Corporation ############################################################################## ########################################### # Job Queues ########################################### job_queue_processes=10 ########################################### # Shared Server ########################################### dispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)" ########################################### # Miscellaneous ########################################### compatible=10.1.0.2.0 ########################################### # Security and Auditing ########################################### remote_login_passwordfile=EXCLUSIVE ########################################### # Sort, Hash Joins, Bitmap Indexes ########################################### pga_aggregate_target=25165824 sort_area_size=65536 ########################################### # Database Identification ########################################### db_domain="" db_name=orcl ########################################### # File Configuration ########################################### control_files=("D:\oracle\product\10.1.0\oradata\orcl\control01.ctl", "D:\oracle\product\10.1.0\oradata\orcl\control02.ctl", "D:\oracle\product\10.1.0\oradata\orcl\control03.ctl") db_recovery_file_dest=D:\oracle\product\10.1.0\flash_recovery_area db_recovery_file_dest_size=2147483648 ########################################### # Pools ########################################### java_pool_size=50331648 large_pool_size=8388608 ############################ ## shared_pool_size=83886080 ############################ shared_pool_size=10000000 ########################################### # Cursors and Library Cache ########################################### open_cursors=300 ########################################### # System Managed Undo and Rollback Segments ########################################### undo_management=AUTO undo_tablespace=UNDOTBS1 ########################################### # Diagnostics and Statistics ########################################### background_dump_dest=D:\oracle\product\10.1.0\admin\orcl\bdump core_dump_dest=D:\oracle\product\10.1.0\admin\orcl\cdump user_dump_dest=D:\oracle\product\10.1.0\admin\orcl\udump ########################################### # Processes and Sessions ########################################### processes=150 ########################################### # Cache and I/O ########################################### db_block_size=8192 db_cache_size=25165824 db_file_multiblock_read_count=16
返回顶楼	回帖地址 0 0 请登录后投票

joanzq 等级: 初级会员性别: 文章: 23 积分: 80 来自: 武汉	发表时间：2008-11-12 # sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\Db_4\network\admin\sqlnet.ora # Generated by Oracle configuration tools. ##SQLNET.AUTHENTICATION_SERVICES= (NONE)### NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
返回顶楼	回帖地址 0 0 请登录后投票

joanzq 等级: 初级会员性别: 文章: 23 积分: 80 来自: 武汉	发表时间：2008-11-13 listener.log 也没看出什么错误 Started with pid=3676 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 13-11月-2008 11:03:59 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\softs\PLSQL Developer\plsqldev.exe)(HOST=JOAN)(USER=joan))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2428)) * establish * orcl * 0 13-11月-2008 11:23:33 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\softs\PLSQL Developer\plsqldev.exe)(HOST=JOAN)(USER=joan))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2804)) * establish * orcl * 0 TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-11月-2008 11:23:49 Copyright (c) 1991, 2004, Oracle. All rights reserved. System parameter file is D:\oracle\product\10.1.0\Db_4\network\admin\listener.ora Log messages written to D:\oracle\product\10.1.0\Db_4\network\log\listener.log Trace information written to D:\oracle\product\10.1.0\Db_4\network\trace\listener.trc Trace level is currently 0 Started with pid=3400 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-11月-2008 11:24:00 Copyright (c) 1991, 2004, Oracle. All rights reserved. System parameter file is D:\oracle\product\10.1.0\Db_4\network\admin\listener.ora Log messages written to D:\oracle\product\10.1.0\Db_4\network\log\listener.log Trace information written to D:\oracle\product\10.1.0\Db_4\network\trace\listener.trc Trace level is currently 0 Started with pid=3384 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 13-11月-2008 11:24:03 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\softs\PLSQL Developer\plsqldev.exe)(HOST=JOAN)(USER=joan))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2809)) * establish * orcl * 0
返回顶楼	回帖地址 0 0 请登录后投票

论坛首页 → 入门技术版

跳转论坛: