-
编辑 删除
oracle11gRAC环境使用RMAN备份方案
configure channel 1 device type disk connect 'sys/oracle@testdb1';初始：[oracle@zx ~]$ rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 16 18:20:57 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: zx (DBID=2731354802)RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameters for database with db_unique_name zx are:CONFIGURE R
-
编辑 删除
WARNING: inbound connection timed out (ORA-3136)连接超时问题
1、alter_SID.log日志：aaaMon Mar 9 02:18:40 2009ksvcreate: Process(q002) creation failedMon Mar 9 02:32:29 2009WARNING: inbound connection timed out (ORA-3136)Mon Mar 9 02:33:02 2009WARNING: inbound connection timed out (ORA-3136)Mon Mar 9 02:33:19 2009WARNING: inbound connection timed out (ORA-3136)2、sqlnet.log日志Fatal NI connect error 12170.VERSION INFORMATION:TNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - ProductionTCP/IP
-
编辑 删除
ORA-07445:oracle_[type: SIGSEGV, Address not mapped to object]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x113E2AA20] [PC:0x1022E64AC, pfrinstr_CALL()+300] [flags: 0x0, count: 1]Errors in file /u01/app/oracle/diag/rdbms/epms/EPMS1/trace/EPMS1_ora_31392036.trc (incident=142208):ORA-07445: [pfrinstr_CALL()+300] [SIGSEGV] [ADDR:0x113E2AA20] [PC:0x1022E64AC] [Address not mapped to object] []Incident details in: /u01/app/oracle/diag/rdbms/epms/EPMS1/incident/incdir_142208/EPMS1_ora_31392036_i142208.trcUse ADRCI or Support Workbenc
-
编辑 删除
oracle 11g rac expdp导出时报错：ORA-31694、ORA-31617、ORA-19505、ORA-27037
rac expdp导出时报错：ORA-31693: Table data object "scott"."dept" failed to load/unload and is being skipped due to error:ORA-31617: unable to open dump file "/home/oraclerac/dump_dir/oravs_expdp_05.dmp" for writeORA-19505: failed to identify file "/home/oraclerac/dump_dir/oravs_expdp_05.dmp"ORA-27037: unable to obtain file status错误原因：在RAC环境下如果PARALLEL参数设置大于1，进程会在RAC的各个节点上进行导出，如果导出目录不共享的话就会报错。解决方法：1、设置为共享的directory；2、导出语句添加cluster=n选项，指定只在本地导出；
-
编辑 删除
Oracle 11g linstener启动后隔几秒钟自动关闭
Oracle 11g linstener启动后隔几秒钟自动关闭新安装的Oracle 11.2.0.1.0数据库，数据库能正常启动，但监听器启动后，过几秒钟自动关闭。 解决方法： 1、查看监听器日志文件报错信息； 2、在监听器linstener.ora文件中增加SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF参数； 3、重新启动数据库监听器或者reload数据库监听器。
-
编辑 删除
Oracle RAC 修改 IP 地址
RAC 修改IP 这个操作本身也只有几步操作， 但是它涉及到OCR。 所以要格外小心。一般来说，如果不是必须要修改的话，尽量不要去修改OCR 的东西。 稳定第一。
-
编辑 删除
linux挂载新硬盘，开机自动挂载
linux挂载新硬盘，开机自动挂载。
-
编辑 删除
df: `/root/.gvfs': Permission denied
在使用Oracle账户检查本地磁盘情况时，总是出现df: `/root/.gvfs': Permission denied信息提示。[sql] view plain copy print?在CODE上查看代码片派生到我的代码片[oracle@rac1 ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rootvg-LogVol00 9.9G 8.3G 1.2G 88% / tmpfs 2.0G 1.3G 740M 63% /dev/shm /dev/sda1 194M 32M 152M 18% /boot /dev/mapper/rootvg-LogVol01 9.9G 286M 9.1G 3% /home
