oracle ORA-27101 Shared memory realm does not exis

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。

评论

4 楼 joanzq 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

3 楼 joanzq 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)

2 楼 joanzq 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

1 楼 joanzq 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。

难道只能重装吗？