今天ORACLE服务突然起不来了 用PL/SQL连本机的数据库连不上 点了之后就死机
找不到原因 然后重装ORACLE 重装的时候在DATABASE CONTROL 85%的卡了很久 然后配置失败
之后用SQLPLUS 还是 PL/SQL连本机的数据库依然是输完用户名 密码就死机
CONN /AS SYSDBA进去新建用户 然后IMP库的时候 显示了一下IMPORT界面 也死了
在网上查了许多资料 但是都不能解决这个问题 求教了 忘CSDN的大牛们指点
附本机LISTENERSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
)
找不到原因 然后重装ORACLE 重装的时候在DATABASE CONTROL 85%的卡了很久 然后配置失败
之后用SQLPLUS 还是 PL/SQL连本机的数据库依然是输完用户名 密码就死机
CONN /AS SYSDBA进去新建用户 然后IMP库的时候 显示了一下IMPORT界面 也死了
在网上查了许多资料 但是都不能解决这个问题 求教了 忘CSDN的大牛们指点
附本机LISTENERSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
)
解决方案 »
- 关于多表查询的存储过程如何返回
- 9i对blob字段全文检索的问题 请各位指教
- oracle 11g 数据导入10G问题?
- 游标与存贮过程
- 怎么关掉它,求救,急。。。
- XP系统下怎么装ORACLE?
- 在sqlplus里执行存储过程出现字符缓冲区太小,怎么解决?哪位帮帮忙
- ASP 连接oracle9i是的错误!没有权限: 'CreateObject' 的错误!
- 请问大家有没有用过Oracle Designer?有没有这方面的书?
- 触发器问题,很简单,请指教。把‘FOR EACH ROW’去掉就不出错了。在线等待
- 关于equals的作用。。。
- ORACLE 存储过程中select语句的where条件带IF判断,怎么写?
操作系统是什么
查找警告日志的位置:在sqlplus下show parameter dump;在BDUMP那个目录下
日志如下
Mon Apr 20 01:22:44 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 202375168
PMON started with pid=2, OS id=2068
PSP0 started with pid=3, OS id=3512
MMAN started with pid=4, OS id=456
DBW0 started with pid=5, OS id=292
LGWR started with pid=6, OS id=2936
CKPT started with pid=7, OS id=644
SMON started with pid=8, OS id=1756
RECO started with pid=9, OS id=388
MMON started with pid=10, OS id=940
Mon Apr 20 01:22:44 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=3996
Mon Apr 20 01:22:44 2009
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Apr 20 01:22:44 2009
Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
Mon Apr 20 01:22:44 2009
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Mon Apr 20 01:22:46 2009
Successful mount of redo thread 1, with mount id 1212378852
Mon Apr 20 01:22:46 2009
Completed: Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
Mon Apr 20 01:22:46 2009
Stopping background process MMNL
Mon Apr 20 01:22:47 2009
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=832
MMNL started with pid=11, OS id=3696
Mon Apr 20 01:22:49 2009
ALTER SYSTEM enable restricted session;
Mon Apr 20 01:22:49 2009
alter database "orcl" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 534906
Mon Apr 20 01:22:49 2009
Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2512.trc:
ORA-00313: ??????? 1 (???? 1) ???
ORA-00312: ???? 1 ?? 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
我做了个试验,手工删除redo1.log
sql>startup nomount;
sql>alter database mount;
sql>alter database open;
*
第 1 行出现错误:
ORA-00313: ??????? 1 (???? 1) ???
ORA-00312: ???? 1 ?? 1: 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG'查看日志文件与上面的提示可以看到是redo01.log文件丢了Mon Apr 20 10:30:18 2009
Errors in file d:\oracle\admin\orcl\bdump\orcl_lgwr_5220.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
sys@ORCL(192.168.21.110)> select * from v$logfile;
行将被截断
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------------------------------------
3 ONLINE D:\ORACLE\ORADATA\ORCL\REDO03.LOG
2 STALE ONLINE D:\ORACLE\ORADATA\ORCL\REDO02.LOG
1 ONLINE D:\ORACLE\ORADATA\ORCL\REDO01.LOG其实执行一下下面的语句重新创建一下就可以了
sys@ORCL(192.168.21.110)> alter database clear unarchived logfile group 1; 数据库已更改。已用时间: 00: 00: 01.70
sys@ORCL(192.168.21.110)> alter database open;数据库已更改。已用时间: 00: 00: 18.48你试一下吧
sql>startup nomount;
sql>alter database mount;
执行STARTUP NOMOUNT;报ORA-01081:无法启动已经运行的ORACLE-请先关闭