摘要：1.客户反应报表数据很慢，简单查询5分钟都出不来。2.登陆数据库服务器检查日志：Thu Mar 21 16:20:30 2013Errors in file /opt/oracle/diag/rdbms/rptdw/rptdw2/trace/rptdw2_lms0_9538.trc (incident=144231):ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)",&quo 阅读全文

摘要：分成两个步骤，先修改instance_name,在修改db_name修改SID1.全备份数据库RMAN> backup as compressed backupset database include current controlfile plus archivelog delete all input ; (DBID=1698783370)2.改环境变量中的ORACLE_SID vi .bash_profile3.改参数文件名称initSID.ora mv initSBBB.ora initSBDB.ora4.改数据文件和日志文件路径SQL> startup mount pfi 阅读全文

摘要：平台：Linux AS release 5，Oracle11.1.0.7db_name = SBDB1. 设置环境变量export ORACLE_BASE=/opt/oracleexport ORACLE_HOME=/opt/oracle/product/11.1.0/db_1export ORACLE_SID=SBDB2. 建初始化参数文件vi $ORACLE_HOME/dbs/initSBDB.ora#以下为建库必需参数db_name=SBDBdb_unique_name = SBDBdb_block_size=8192memory_target=500Mundo_tablespace=U 阅读全文

摘要：注意节点6，7的磁盘CRSDG的状态明显不正常。oracle@ZJHZ-PS-CMREAD-SV-RPTDW06-DB-SD:~> crsctl status resource -t |less--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------L 阅读全文