ORA-27101: shared memory realm does not exist 错误的处理

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/usrnck0709/article/details/80693241

原因:数据库没有装载

解决方法:


ORA-27101 Shared memory realm does not exist

11-13

oracle 本来可以用,新建了个库后,新库不能用,我把它删了,原来的库ORCL用sqlplus ,plsql 以及用oralce 的net manager 测试都登录报错误,rnORA-27101 Shared memory realm does not exist rnORA-01034 ORACLE not available rn怎样解决呀?在baidu,google里都没有可行的方法rnset ORACLE_SID=orcl 实例也重新设置了。服务,监听重新启动了!rnCMD 中tnstping orcl 也可以成功。rn-------------------------------rn我的tnsnames.ora 文件也没看出什么问题rnORCL =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rn )rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = orcl)rn )rn )rn------------------------------------------------------------rnlistener.ora 文件rnrn# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_4\network\admin\listener.orarnrn# Generated by Oracle configuration tools.rnrnrnSID_LIST_LISTENER =rnrn (SID_LIST =rnrn (SID_DESC =rnrn (SID_NAME = PLSExtProc)rnrn (ORACLE_HOME = D:\oracle\product\10.1.0\Db_4)rnrn (PROGRAM = extproc)rnrnrn )rnrnrn (SID_DESC =rnrn (GLOBAL_DBNAME = orcl)rnrn (ORACLE_HOME = D:\oracle\product\10.1.0\Db_4) rnrn (SID_NAME = orcl)rnrn )rnrn )rnrnrnLISTENER =rnrn (DESCRIPTION_LIST =rnrn (DESCRIPTION =rnrn (ADDRESS_LIST =rnrn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))rnrn )rnrn (ADDRESS_LIST =rnrn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rnrn )rnrn )rnrn )rnrn------------------------------------------------------------------------------------rn还有sqlnet.ora 文件rnSQLNET.AUTHENTICATION_SERVICES= (NONE)rnrnNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)rnrn------------------------------------------------------------------rnrnrn按网上说的,CMD 中 connect /as sysdba 结果报ORA-01031: insufficient privileges。rnrn注销(SQLNET.AUTHENTICATION_SERVICES= (NONE),没有效果,改变shared_pool_size=10000000也不行 rn那个remote_logIn_passwordfile参数。设置成EXCLUSIVE再重新启动数据库 也不行 rnCMD 中 sqlplus /nolog rn connect /as sysdba 结果报ORA-01031: insufficient privileges。 rnrn难道只能重装吗? rnrnrn我的init.ora 文件 rnrn############################################################################## rn# Copyright (c) 1991, 2001, 2002 by Oracle Corporation rn############################################################################## rnrn########################################### rn# Job Queues rn########################################### rnjob_queue_processes=10 rnrn########################################### rn# Shared Server rn########################################### rndispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)" rnrn########################################### rn# Miscellaneous rn########################################### rncompatible=10.1.0.2.0 rnrn########################################### rn# Security and Auditing rn########################################### rnremote_login_passwordfile=EXCLUSIVE rnrn########################################### rn# Sort, Hash Joins, Bitmap Indexes rn########################################### rnpga_aggregate_target=25165824 rnsort_area_size=65536 rnrn########################################### rn# Database Identification rn########################################### rndb_domain="" rndb_name=orcl rnrn########################################### rn# File Configuration rn########################################### rncontrol_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") rndb_recovery_file_dest=D:\oracle\product\10.1.0\flash_recovery_area rndb_recovery_file_dest_size=2147483648 rnrn########################################### rn# Pools rn########################################### rnjava_pool_size=50331648 rnlarge_pool_size=8388608 rn############################ rn## shared_pool_size=83886080 rn############################ rnrnshared_pool_size=83886080 rn########################################### rn# Cursors and Library Cache rn########################################### rnopen_cursors=300 rnrn########################################### rn# System Managed Undo and Rollback Segments rn########################################### rnundo_management=AUTO rnundo_tablespace=UNDOTBS1 rnrn########################################### rn# Diagnostics and Statistics rn########################################### rnbackground_dump_dest=D:\oracle\product\10.1.0\admin\orcl\bdump rncore_dump_dest=D:\oracle\product\10.1.0\admin\orcl\cdump rnuser_dump_dest=D:\oracle\product\10.1.0\admin\orcl\udump rnrn########################################### rn# Processes and Sessions rn########################################### rnprocesses=150 rnrn########################################### rn# Cache and I/O rn########################################### rndb_block_size=8192 rndb_cache_size=25165824 rndb_file_multiblock_read_count=16 rnrnrnrn# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\Db_4\network\admin\sqlnet.ora rn# Generated by Oracle configuration tools. rnrn##SQLNET.AUTHENTICATION_SERVICES= (NONE)### rnrnNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) rnrnrnrnlistener.log 也没看出什么错误 rnrnStarted with pid=3676 rnListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) rnrnTIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE rn13-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 rn13-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 rnrnTNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-11月-2008 11:23:49 rnrnCopyright (c) 1991, 2004, Oracle. All rights reserved. rnrnSystem parameter file is D:\oracle\product\10.1.0\Db_4\network\admin\listener.ora rnLog messages written to D:\oracle\product\10.1.0\Db_4\network\log\listener.log rnTrace information written to D:\oracle\product\10.1.0\Db_4\network\trace\listener.trc rnTrace level is currently 0 rnrnStarted with pid=3400 rnListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) rnrnTIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE rnrnTNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-11月-2008 11:24:00 rnrnCopyright (c) 1991, 2004, Oracle. All rights reserved. rnrnSystem parameter file is D:\oracle\product\10.1.0\Db_4\network\admin\listener.ora rnLog messages written to D:\oracle\product\10.1.0\Db_4\network\log\listener.log rnTrace information written to D:\oracle\product\10.1.0\Db_4\network\trace\listener.trc rnTrace level is currently 0 rnrnStarted with pid=3384 rnListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) rnrnTIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE rn13-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 rnrn

没有更多推荐了,返回首页

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试