oracle错误汇总1
这是遇见的第一个整个库正常,但某张表查询报错的情况
某张表数据可以查,但一排序查就报错
select * from acct_daily_bak;
select * from acct_daily_bak order by open_time desc;
ORA-01578: ORACLE data block corrupted (file # 7, block # 27489)
ORA-01110: data file 7: '/u01/app/oracle/oradata/TESTDB/datafile/o1_mf_kyc_acc_dlzsz7mt_.dbf'
ORA-06512: at line 2
ORA-01578: ORACLE data block corrupted (file # 7, block # 27489)
ORA-01110: data file 7: '/u01/app/oracle/oradata/TESTDB/datafile/o1_mf_kyc_acc_dlzsz7mt_.dbf'
01578. 00000 - "ORACLE data block corrupted (file # %s, block # %s)"
*Cause: The data block indicated was corrupt. This was a physical
corruption, also called a media corruption. The cause is unknown
but is most likely external to the database. If ORA-26040 is also
signaled, the corruption is due to NOLOGGING or UNRECOVERABLE
operations.
*Action: The general method to repair a media corrupt block is to restore
a backup and recover the backup. For databases in ARCHIVELOG
mode, use block media recovery or media recovery. In some situations,
you can also drop the segment and re-create it. For example, you can
drop an index and re-create the index.
可以参照oracle存储结构一文
根据上面的报错重新配置oem就可以了
emca -config dbcontrol db
[oracle@rac01 ~]$ emca -config dbcontrol db STARTED EMCA at Nov 1, 2017 6:27:40 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: kyc1 Database Control is already configured for the database kyc1 You have chosen to configure Database Control for managing the database kyc1 This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: y Listener ORACLE_HOME [ /oracle/app/oracle/product/11.2.0/db_1 ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /oracle/app/oracle/product/11.2.0/db_1 ]: ASM SID [ +ASM ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASM user password: ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /oracle/app/oracle/product/11.2.0/db_1 Local hostname ................ rac01 Listener ORACLE_HOME ................ /oracle/app/oracle/product/11.2.0/db_1 Listener port number ................ 1521 Database SID ................ kyc1 Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /oracle/app/oracle/product/11.2.0/db_1 ASM SID ................ +ASM ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ ASMSNMP ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Nov 1, 2017 6:30:09 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /oracle/app/oracle/cfgtoollogs/emca/kyc/emca_2017_11_01_18_27_39.log. Nov 1, 2017 6:30:10 PM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 5541 is already in use. Nov 1, 2017 6:30:10 PM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 5521 is already in use. Nov 1, 2017 6:30:10 PM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 5500 is already in use. Nov 1, 2017 6:30:10 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Nov 1, 2017 6:30:31 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Nov 1, 2017 6:32:06 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Nov 1, 2017 6:32:06 PM oracle.sysman.emcp.ParamsManager getLocalListener WARNING: Error retrieving listener for rac01 Nov 1, 2017 6:32:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Nov 1, 2017 6:32:22 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Nov 1, 2017 6:32:22 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Nov 1, 2017 6:32:36 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Nov 1, 2017 6:32:36 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://rac01:5500/em <<<<<<<<<<< Nov 1, 2017 6:32:40 PM oracle.sysman.emcp.EMDBPostConfig invoke WARNING: ************************ WARNING ************************ Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /oracle/app/oracle/product/11.2.0/db_1/rac01_kyc/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. *********************************************************** Enterprise Manager configuration completed successfully FINISHED EMCA at Nov 1, 2017 6:32:40 PM [oracle@rac01 ~]$
scanip不能自动漂移
[oracle@rac02 ~]$ srvctl status scan SCAN VIP scan1 is enabled SCAN VIP scan1 is running on node rac02 [oracle@rac02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 1 18:51:39 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; 外网1机 外网2机,老版的sqldeveloper可以看到报错 ORA-01089: 正在执行立即关闭 - 不允许进行任何操作 01089. 00000 - "immediate shutdown in progress - no operations are permitted" *Cause: The SHUTDOWN IMMEDIATE command was used to shut down a running ORACLE instance, so your operations have been terminated. *Action: Wait for the instance to be restarted, or contact your DBA.
=============================
Oracle RAC的VIP和SCAN IP
http://www.cnblogs.com/mawanglin2008/articles/3472395.html