首页
技术日记
编程
旅游
数码
登录
标签
ORA
ORA-12519 TNS:no appropriate service handler found
问题描述jdbc连接Oracle失败,报错日志如下:Listener refused the connection with the following error:ORA-12519, TN
ORA
TNS
Handler
Service
admin
3月前
42
0
oracle12C使用expdp备份ORA-25153: Temporary Tablespace is Empty
在上一篇文章中,成功的重建了oracle的控制文件,实例也可以正常启动到open的状态后;马上开始备份数据库,详细步骤如下:1.创建存放备份文件的路径C:UsersAdministrator>sqlpluusas sysdb
备份
ORA
oracle12c
expdp
tablespace
admin
4月前
49
0
ORA-01157: cannot identifylock data file - see DBWR tracefile
起因是测试人员 dbf是在之前数据库运行过程中添加的测试空间文件,测试完毕已经删除删除之后没有问题但是服务器重启的时候 发现数据库无法正常的启动。sqlplus "as sysdba"SQL&g
Identify
Lock
ORA
DBWR
tracefile
admin
4月前
51
0
ORA-01157: cannot identifylock data file 12 - see DBWR trace file
错误信息:ORA-01157: cannot identifylock data file 12 - see DBWR trace fileORA-01110: data file 12: d01oramte
Identify
Lock
ORA
DATA
DBWR
admin
4月前
53
0
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
10g RAC 数据库未归档。解释:alter system archive log current*ERROR at line 1:ORA-00258: manual archiving in NOARCHIVELOG mode mus
manual
archiving
ORA
Identify
log
admin
4月前
41
0
ORA-19505: failed to identify file "oradata1dumpCASCTRL07.DMP EXPDP
expdp 出错$ impdp systemmanager directoryDMP contentMETADATA_ONLY dumpfileCASCTRL01.DMP, CASCTRL02.DMP, CASCTRL03.DMP, C
Identify
file
failed
ORA
quot
admin
4月前
64
0
ORA-01157 cannot identifylock data file 10
数据库报错:ORA-01157: cannot identifylock data file 10 - see DBWR trace fileORA-01110: data file 10: u01appo
Identify
ORA
Lock
file
DATA
admin
4月前
63
0
oracle 启动时出现ORA-01157: cannot identifylock data和ORA-01110: data file 错误
SQL> shutdownORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startupORACLE inst
启动时
错误
ORA
Oracle
Identify
admin
4月前
59
0
ORA-01157: cannot identifylock data file 6 - see DBWR trace file
转载于:ORA-01157: cannot identifylock data file 6 - see DBWR trace file ORA-01110: 解决方法 (gxlcms) ORA-01157: ca
Identify
Lock
ORA
DBWR
Trace
admin
4月前
49
0
ORA-01157: cannot identifylock data file 6 – see DBWR trace file
转自 http:mojijs201403131121index.html http:mojijs ORA-01157: cannot identifylock data file 6 – see DBWR trace f
Identify
Lock
ORA
DBWR
Trace
admin
4月前
51
0
ORA-19505: failed to identify file "orabakexpdpTB201411.dmp"
[oracleerpcrmtest expdp]$ impdp userid" as sysdba" DIRECTORYDATA_EXP parallel8 DUMPFILETB201411.dmp logfile
Identify
file
failed
ORA
dmp
admin
4月前
49
0
【精】ORA-01157: cannot identifylock data file 6 - see DBWR trace file ORA-01110: 解决方法
今天登陆到数据库做了一个小测试后 忘记了用命令删除表空间,直接在Linux下删掉了数据文件,结果,悲剧就开始了。(弄明白了整理出来大家共同study)实验环境
解决方法
Identify
Lock
ORA
DATA
admin
4月前
56
0
ORA-01157: cannot identifylock data file 201 ORA-01110: data file 201:
错误现象:查询表空间使用情况的时候提示如下信息:ORA-01157: cannot identifylock data file 201 - see DBWR trace fileORA-01
Identify
Lock
ORA
DATA
file
admin
4月前
54
0
oracle ORA-01157: cannot identifylock data file 64
有人误在RAC端创建本地数据文件数据库后台告警Errors in file orasoftoraclediagrdbmsptdbptdb1traceptdb1_dbw0_4838.trc:ORA-01157: cann
Identify
Oracle
ORA
file
Lock
admin
4月前
47
0
ORA-01157: cannot identifylock data file
Wed Apr 11 22:13:53 2012Errors in file d:oracleproduct10.2.0adminsdhbdumpsdh_dbw0_1552.trc:ORA-01157: cannot iden
Identify
ORA
file
DATA
Lock
admin
4月前
60
0
oracle启动报错ORA-01157: cannot identifylock data file 7 - see DBWR trace file ORA-01110: data file 7:
[oraclelocalhost ~]$ sqlplusas sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 20 09:27:31 2017Copyright (
报错
Identify
Oracle
ORA
Lock
admin
4月前
54
0
DG 上 ORA-01157: cannot identifylock data file 处理办法
早上发现一个DG的MRP应用直接停了,看回前些天的日志,发现原来是新加的数据文件没有在这个DG上生产,造成这个原因是,这是一个级联DGÿ
办法
ORA
DG
Identify
file
admin
4月前
50
0
【Oracle】ORA-01157: cannot identifylock data file 201 - see DBWR trace file
今天数据库在查询数据的时候显示了这个错误:ORA-01157: cannot identifylock data file 201 - see DBWR trace fileORA-01110: data file
Identify
Lock
Oracle
ORA
DBWR
admin
4月前
48
0
ORA-01157: cannot identifylock data file 7 - see DBWR trace file
ORA-01157: cannot identifylock data file 7 - see DBWR trace fileORA-01110: data file 7: oradatatest01.dbf问题出现原因&
Identify
Lock
ORA
DBWR
Trace
admin
4月前
44
0
RAC环境中ORA-01157: cannot identifylock data file 9 - see DBWR trace file
在RAC环境中,在某一节点创建本地文件系统的表空间,随后在另外的一个节点的alter日志里发现如下错误Linux-x86_64 Error: 2: No such file or director
环境
Identify
RAC
ORA
DBWR
admin
4月前
45
0
1
2
3
4
»