1.解決此錯誤的辦法,可能有表空間,不夠擴展,并不一定是ARCHIVETEMP
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
ORA-1652: unable to extend temp segment by 128 in tablespace ARCHIVETEMP
ORA-1652: unable to extend temp segment by 128 in tablespace ARCHIVETEMP
[root@emd3wfdb bdump]# tail -1000 alert_wfdb.log |grep ORA
ORA-01555 caused by SQL statement below (Query Duration=21626 sec, SCN: 0x0000.19050882):
ORA-1652: unable to extend temp segment by 128 in tablespace ARCHIVETEMP
ORA-1652: unable to extend temp segment by 128 in tablespace ARCHIVETEMP
2.解決此錯誤,是大小寫的問題temp_depcode TEMP_DEPCODE
ORA-20000: ORA-20000: Unable to analyze TABLE "HR"."TEMP_DEPCODE", insufficient privileges or does not exist
3.ln -s /u01/hremploy/arch/ ./arch 軟連接目錄
4.OPTIMIZER_INDEX_COST_ADJ 50/100 cost變化參數
3.sec_case_sensitive_logon 密碼大小寫的參數 (11G上的)
4.cursor_sharing
5.PROFILE
resource_limit 必須更改為true,否則無效
SESSIONS_PER_USER -------登陸會話的上限
6.crs使用案例
crs_stop -f ora.ecsrac02.vip
crs_start ora.ecsrac02.vip
crs_start ora.ecsrac02.LISTENER_ECSRAC02.lsnr
7.修改參數archive_lag_target調整日誌切換時間!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25850100/viewspace-704076/,如需转载,请注明出处,否则将追究法律责任。