oracle 本来可以用,新建了个库后,新库不能用,我把它删了,原来的库ORCL用sqlplus ,plsql 以及用oralce 的net manager 测试都登录报错误,
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
怎样解决呀?在baidu,google里都没有可行的方法
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。注销(SQLNET.AUTHENTICATION_SERVICES= (NONE),没有效果,改变shared_pool_size=10000000也不行
那个remote_logIn_passwordfile参数。设置成EXCLUSIVE再重新启动数据库 也不行
CMD 中 sqlplus /nolog
connect /as sysdba 结果报ORA-01031: insufficient privileges。 难道只能重装吗?
我的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=83886080
###########################################
# 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 # 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) 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
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
怎样解决呀?在baidu,google里都没有可行的方法
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。注销(SQLNET.AUTHENTICATION_SERVICES= (NONE),没有效果,改变shared_pool_size=10000000也不行
那个remote_logIn_passwordfile参数。设置成EXCLUSIVE再重新启动数据库 也不行
CMD 中 sqlplus /nolog
connect /as sysdba 结果报ORA-01031: insufficient privileges。 难道只能重装吗?
我的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=83886080
###########################################
# 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 # 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) 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
tsnping orcl ,可以通
------------------------------------------C:\Documents and Settings\joan>tnsping orclTNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-11月-
2008 16:39:18Copyright (c) 1997, 2003, Oracle. All rights reserved.Used parameter files:
D:\oracle\product\10.1.0\Db_4\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_
NAME = orcl)))
OK (10 msec)---------------------------------------------------C:\Documents and Settings\joan>lsnrctl statusLSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-11月-2008 16:4
0:50Copyright (c) 1991, 2004, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 13-11月-2008 16:38:42
Uptime 0 days 0 hr. 2 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.1.0\Db_4\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.1.0\Db_4\network\log\listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfullyC:\Documents and Settings\joan>
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)#
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
=================================
数据库宕掉了,想办法弄起来。呵呵