ORA-0???
灰帽DBA
这个作者很懒,什么都没留下…
展开
-
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 482ORA-12008: error in materialized view refresh pathORA-12170: TNS:原创 2014-05-20 20:45:09 · 3058 阅读 · 0 评论 -
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$version;BANNER------------------------------------------原创 2014-05-22 11:27:29 · 3430 阅读 · 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.OraTransmit:ORA-00376: file 202 cannot be read at thi原创 2014-05-27 14:46:30 · 5801 阅读 · 2 评论 -
ORA-10635: Invalid segment or tablespace type
...原创 2014-02-11 13:48:38 · 1887 阅读 · 0 评论 -
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两台主机可以互相访问,但使用grid的图形界面Test的时候缺无法通过见下图baidu的不小资料,这种情况引发有很原创 2015-02-03 22:36:57 · 11152 阅读 · 1 评论 -
ORA-16014:ORA-00312:
ERROR [main] (cn.com.jdls.foundation.dao.DAOManager:_$2:1420) - 无法拿到数据库[swzxw]的连接!错误信息[Exception message:数据库[swzxw]连接不上!]Exception at getConnectionByDatabaseName:数据库[swzxw]连接不上!java.sql.SQLException原创 2011-12-22 19:48:31 · 1480 阅读 · 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: unable to extend temp segment by 128 in tablespace TEM原创 2012-02-26 22:03:05 · 22316 阅读 · 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.2Generic UNIX当检查oracle实例后台进程不存在这时启动启动数据库报错: ORA-01081: "cannot start already-running OR原创 2012-04-24 09:31:46 · 15118 阅读 · 0 评论 -
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 line 1:ORA-07391: sftopn: fopen error, unable to open t原创 2012-06-24 16:35:51 · 7477 阅读 · 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 installActions2012-06-29_12-08-50AM.log SEVERE: [FATAL] HXZG原创 2012-06-28 16:26:17 · 10671 阅读 · 1 评论 -
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/rdbms/audit查看下权限,属主,为了避免麻烦直接赋予aufit目录 777权限退出DBCA直接们再原创 2012-09-18 13:40:06 · 5618 阅读 · 0 评论 -
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], []
今天建库的时候忽然报错ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] 梗是让我无语,没办法只好检查参数配置,按照文档一步步检查,最后检查了下profile文件的配置 [root@servU_01 db_1]# more /home/oracle/.bash_pr原创 2012-09-18 13:59:34 · 2735 阅读 · 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果断出现ORA-09925错误[oracle@tips ~]$ sqlplus / as sysdba原创 2012-11-25 20:38:44 · 33637 阅读 · 1 评论 -
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 orclPRCR-1071 : Failed to register or update resource ora.orcl.dbPRCR-100原创 2013-03-19 17:43:19 · 13506 阅读 · 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: installation error: XSL stylesheets not loaded correctl原创 2015-02-03 22:23:43 · 1761 阅读 · 0 评论