-
编辑 删除
启动监听时一直在connecting：TNS-12531: TNS:cannot allocate memory
TPI-TEST:ebdb > lsnrctl start ebdbLSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 13-DEC-2013 01:55:21Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.Starting /home/oracle/app/product/9.2.0/bin/tnslsnr: please wait...TNSLSNR for IBM/AIX RI...
-
编辑 删除
compatible兼容参数不正确导致DG物理备库不能应用日志
日志能传输到过来：SQL> SELECT SEQUENCE#,FIRST_TIME,NEXT_TIME,applied from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# FIRST_TIME NEXT_TIME APP---------- -----...
-
编辑 删除
Shutting down the Oracle ASMLib driver: [ failed ]
在停止ASM服务时报错：/etc/init.d/oracleasm stopDropping Oracle ASMLib disks: [ OK ]Shutting down the Oracle ASMLib driver: [ failed ]查看日志：cat /var/log/oracleasm Unmounting ASMlib driver filesystem: umount: /dev/oracleasm: device is busyumount:...
-
编辑 删除
truncate表后impdp导入该表时加exclude=index参数并不能排除索引数据的导入
SQL> truncate table GCADJUSTMENTMAIN;Table truncated.SQL> SELECT segment_name, SUM (bytes) / 1024 / 1024 2 FROM dba_segments 3 WHERE owner = 'XIEZQ' AND segment_name LIKE 'PK%' or segment_name like 'IDX%' group by segment_name;SEGMENT_NAME &n...
-
编辑 删除
UDI-00010: multiple job modes requested, schema and tables
今天使用network_link参数导入数据，发现报错：[oracle@node1 impdp_net_test]$ impdp xiezq network_link=imp_zb parfile=par_imp_sImport: Release 11.2.0.4.0 - Production on Mon May 5 15:10:24 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Password: Co...
