ITPub博客

启动Oracle报错ORA-27102: out of memory、Linux-x86_64 Error: 28: No space left on device

oracle 11g登陆报错'ORA-12162: TNS:net service name is incorrectly specified'

在Oracle 12c中，执行sqlplus报错sqlplus: error while loading shared libraries: /opt/64bit/oracle/12.1.0.2/lib/libclntsh.so.12.1: file too short

Oracle 11g 安装RAC时报错'Exception in thread "main" java.lang.NoClassDefFoundError'

Oracle 11g删除数据文件时报错'ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected'

Oracle 11g报错"ORA-00845: MEMORY_TARGET not supported on this system"

Oracle 11g报错ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"

Oracle 11G安装报错"ORA-00401: the value for parameter compatible is not supported by this release

Oracle报错ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directory

Oracle 11g 报错ORA-01102: cannot mount database in EXCLUSIVE mode

Oracle sqlplus连接数据库报错"SP2-1503:无法初始化oracle调用界面,SP2-1502: oracle 不能正常工作"

Oracle分区表增加分区报错“ORA-14760:不允许对间隔分区对象执行 ADD PARTITION”

使用RMAN进行异机恢复的时候，执行STARTUP NOMOUNT报错：[oracle@backup-recovery ~]$ export ORACLE_SID=gtfdb;[oracle@backup-recovery ~]$ rman nocatalogRecovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 22 16:16:04 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rig...

生产上的一套 11G 物理备库出现故障，存放数据文件和归档日志的挂载盘发生故障，导致出现数据块错误。数据库报警日志中的错误如下： ORA-10562: Error occurred while applying redo to data block (file# 28, block# 1336760)ORA-10564: tablespace TS_TRAN_INDEX...

登录一台测试数据库报错[oracle@PTFDB1 ~]$ sqlplus tran/PreTran13588SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 11 18:24:43 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.ERROR:ORA-00257: archiver error. Connect internal only, until freed.报错的原因是归档满了，...

删除用户时报错，提示有此用户的会话在连接。SQL> drop user tran cascade;drop user tran cascade*ERROR at line 1:ORA-01940: cannot drop a user that is currently connected查询会话信息，查询不到此用户的会话信息。SQL> select * from v$session where username='ACCT';no rows selected判断有...