灰帽 DBA

Data &BlockChain and Security Notes Share Everything

INS-06006 Passwordless SSH connectivity not set up between the following node(s)

安装11g RAC的grid时碰见点小插曲 在Test互信的时候报错INS-06006 Passwordless SSH connectivity not set up between the following node(s) 奇怪的是 用grid用户ssh两台主机可以互相访问,但使用gr...

2015-02-03 22:36:57

阅读数:7294

评论数:0

ORA-39212: installation error: XSL stylesheets not loaded correctly

某社保客户在配置DSG复制软件的时候,执行以下语句时报错 Oracle 10G 10.2.0.5.0 RAC HP Unix 平台 SQL> select dbms_metadata.get_ddl('USER','DSG') from dual; ERROR: ORA-39212: i...

2015-02-03 22:23:43

阅读数:1001

评论数:0

ORA-00376: file 202 cannot be read at this time ORA-01110: data file 202故障处理

客户的HP unix系统发生错误,刷卡业务不能正常进行,从报错上看是读不到/oracle目录的某个文件, 但这是套HP unix的10.2.0.5的ASM rac系统,怎么会有文件系统的文件,初步怀疑肯定加数据文件的时候有误操作 1.业务层报错 -900~DDM_SJDIYDJY_JYD.Ora...

2014-05-27 14:46:30

阅读数:4227

评论数:2

ORA-10635: Invalid segment or tablespace type

对DML频繁的表执行shrink操作时报 ORA-10635: Invalid segment or tablespace type 操作系统版本: $ oslevel -s 5300-07-01-0748 数据库版本 : SQL> select * from v$versi...

2014-05-22 11:27:29

阅读数:2138

评论数:0

ORA-12170: TNS:Connect timeout occurred ORA-06512: at "SYS.DBMS_SNAPSHOT"

Oracle job 无法自动运行 报以下大量的错 Errors in file /oracle/admin/orcl/bdump/orcl_j000_2158798.trc: ORA-12012: error on auto execute of job 482 ORA-12008: erro...

2014-05-20 20:45:09

阅读数:1910

评论数:0

ORA-10635: Invalid segment or tablespace type

...

2014-02-11 13:48:38

阅读数:1228

评论数:0

11g ASM单实例 dbca报错 prcr-1006 crs-0259 prcr-1071

11g ASM dbca报错 prcr-1006 crs-0259 prcr-1071 使用ASM方式创建单实例DB时,在运行DBCA时出现 PRCR-1006 : Failed to add resource ora.orcl.db for orcl PRCR-1071 : Failed ...

2013-03-19 17:43:19

阅读数:12186

评论数:0

ORA-09925 Linux-x86_64 Error: 2: No such file or directory

DBCA删除数据库所有实例后,本想用RMAN duplicate方式克隆DB,因此在$ORACLE_BASE目录下创建了相关的目录admin/dupl/adump ,admin/dupl/dpump 在使用sqlplus正常连接空闲实例,手贱却执行了startup命令,oracle果断出现...

2012-11-25 20:38:44

阅读数:21466

评论数:0

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], []

今天建库的时候忽然报错ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] 梗是让我无语,没办法只好检查参数配置,按照文档一步步检查,最后检查了下profile文件的配...

2012-09-18 13:59:34

阅读数:2290

评论数:0

ORA-09925: Unable to create audit trail file 在DBCA时

ORA-09925: Unable to create audit trail file 在DBCA时 删除数据库后,再执行dbca时候报错 ORA-09925: Unable to create audit trail file 起初以为是权限问题, $cd $ORACLE_HOME/rdbm...

2012-09-18 13:40:06

阅读数:4103

评论数:0

RedHat5.5_X64 Linux安装oracle 11.2.0.3 报错

REDHAT linux 安装 11G 11.2.0.3 报错 oracle用户执行./runinstaller后 直接报错 查看日志后 [root@HXZG OraInstall2012-06-29_12-08-50AM]# more installActio...

2012-06-28 16:26:17

阅读数:8894

评论数:1

ORA-07391: sftopn: fopen error, unable to open text file

11G rac 由spfile创建数据库的pfile 报错如下 SQL> create pfile='/u01/inittips1.ora' from spfile; create pfile='/u01/inittips1.ora' from spfile * ERROR at li...

2012-06-24 16:35:51

阅读数:4890

评论数:0

ORA-01081: "cannot start already-running ORACLE - shut it down first"

Applies to: Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.2.0.2.0 - Release: 8.1.7 to 11.2 Generic UNIX 当检查oracle实例后台进程不存在这时启动启动数据库报错...

2012-04-24 09:31:46

阅读数:11030

评论数:0

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01

收集数据库信息时候报ORA-01652错 如下 SQL> EXEC DBMS_STATS.gather_database_stats; BEGIN DBMS_STATS.gather_database_stats; END; * ERROR at line 1: ORA-01652: ...

2012-02-26 22:03:05

阅读数:16631

评论数:0

ORA-16014:ORA-00312:

ERROR [main] (cn.com.jdls.foundation.dao.DAOManager:_$2:1420) - 无法拿到数据库[swzxw]的连接!错误信息[Exception message:数据库[swzxw]连接不上!] Exception at getConnectionB...

2011-12-22 19:48:31

阅读数:1141

评论数:0

提示
确定要删除当前文章?
取消 删除
关闭
关闭