ORACLE错误
dba_lily
这个作者很懒,什么都没留下…
展开
-
ORA-12899: value too large for column LabelName (actual: 36, maximum: 32)
1)导入时报错,如图ORA-02374: conversion error loading table "ITMUSER"."K17DOSINF1"ORA-12899: value too large for column LabelName (actual: 36, maximum: 32)ORA-02372: data for row: LabelName : 0X'CFB5C原创 2018-01-29 11:29:13 · 3384 阅读 · 0 评论 -
安装GI报错 CRS-4124 CRS-4000
3.创建用户和用户组[root@oracle ~]# groupadd asmadmin[root@oracle ~]# groupadd asmdba[root@oracle ~]# groupadd asmoper[root@oracle ~]# useradd -g oinstall -G asmadmin,asmdba,asmoper grid[root@oracle ~]# p...原创 2018-06-07 11:25:58 · 682 阅读 · 0 评论 -
ORA-12170: TNS:Connect timeout occurred 解决思路
总是有厂家反映新建的dblink有问题source源地址:10.150.1.1(端口:1522) destination目标地址:10.150.4.4(端口:1521)整体分析思路如下:1、要求查看下创建dblink语句,确认创建语句无误create database link ITPC connect to ITSMUSE identified by "szitsm...原创 2018-03-06 16:26:43 · 32971 阅读 · 1 评论 -
Linux 7.3 安装11g数据库软件报错:Error in invoking target 'agent nmhs' of makefile
linux 7.3环境 解决方案:在makefile中添加链接libnnz11库的参数,$ORACLE_HOME/sysman/lib/ins_emagent.mk,将$(MK_EMAGENT_NMECTL),修改为:\$(MK_EMAGENT_NMECTL) -lnnz11。 修改前可以先备份文件[oracle@centos ~]$ cd $ORACLE_HOME/sysman/l...原创 2018-05-15 14:49:15 · 572 阅读 · 1 评论 -
11g ASM 重启 HAC 报错 CRS-4124: Oracle High Availability Services startup failed.CRS-4000
1、故障描述[grid@szcssjk01 ~]$ crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'szcssjk01'CRS-2673: Attempting to stop 'ora.PMS_CS.lsnr' on 'szc...原创 2018-04-20 15:10:46 · 4497 阅读 · 0 评论 -
ERROR: ORA-01017: invalid username/password; logon denied
1、故障描述数据库连不上$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 3 11:11:12 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-01017: invalid username...原创 2018-04-03 15:35:35 · 1480 阅读 · 0 评论 -
ORA-00020: maximum number of processes (150) exceeded
1、故障描述厂家反映数据库连不上 登上去看,报ORA-00020,数据库连接数达到了数据库的最大连接数[oradba@szpwgddb01:/oracle/app/product/11.2.0/db_1/dbs]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 8 15:09:42...原创 2018-03-08 15:38:19 · 678 阅读 · 0 评论 -
ORACLE No space left on device的解决办法
1、故障现象巡检发现日志报错$ tail -500f alert_ywjk.log Mon Feb 05 09:57:38 2018Non critical error ORA-48180 caught while writing to trace file "/u01/app/oradba/diag/rdbms/ywjk/ywjk/trace/ywjk_ora_28302.trc...原创 2018-03-06 17:06:59 · 10303 阅读 · 0 评论 -
ORA-28007: the password cannot be reused
SQL> select * from dba_profiles where profile='DEFAULT' and resource_type ='PASSWORD';PROFILE RESOURCE_NAME RESOURCE LIMIT----------------------------原创 2018-02-01 15:52:16 · 7236 阅读 · 0 评论 -
ARCH: Archival stopped, error occurred. Will continue retrying
今天收到厂家反馈用户连接不上,问了下是通过主机名连还是ip,因为昨晚配合关闭数据库为了加了备份ip,开启时发现监听没成功提起,把listener.ora的内容里的HOST =主机名 都换成了ip,并把local_listener参数一同改了才正常,厂家确认是用ip连,就登上机器。1)首先查看监听状态$listener status正常2)尝试用同网段连入测试发现原创 2018-02-01 15:21:00 · 1078 阅读 · 0 评论