ITPub博客

环境说明：   RAC 启动数据库报 ORA-00119: invalid specification for system parameter REMOTE_LISTENER   。 检查 listener.ora 与 tnsnames.ora 没有发现问题 。[root@node1 bin]# ./srvctl start database -d devdbPRCR-1079 : Failed to start resource ora.devdb.dbCRS-5017: The r...

[oracle@phydb admin]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-SEP-2014 02:33:08Copyright (c) 1991, 2009, Oracle.  All rights reserved.Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...TNS-12537: TNS:connection closed TNS-...

问题： 闪回恢复区大小不够，rman默认备份路径报错。RMAN> backup database;Starting backup at 01-DEC-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=39 device type=DISKchannel ORA_DISK_1: starting full datafile backup setc...

问题描述：当父表有子表的外键约束时，无法直接truncate父表。报ORA-02266: unique/primary keys in table referenced by enabled foreign keys。这里使用另一种办法来解决这个问题：先把外键失效，truncate表之后再把外键生效。SQL> truncate table machine_room;truncate table machine_room      &nb...