REHL8 oracle 19C RAC安装中的坑
- 检查共享的NFS权限
[root@nymtx ~]# id grid
uid=6001(grid) gid=5001(oinstall) groups=5001(oinstall),5003(asmdba),5004(asmoper),5005(asmadmin)
[root@nymtx ~]# id oracle
uid=6002(oracle) gid=5001(oinstall) groups=5001(oinstall),5002(dba),5003(asmdba),5005(asmadmin)
gird 和Oracle同属 asmadmin 组,所以asmadmin要有写限,用以下命令加权限
chmod g+s /asm/*
问题如下:
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=266 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/19c/assistants/dbca/templates/Seed_Database.dfb
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /oracle/app/oracle/19c/assistants/dbca/templates/Seed_Database.dfb
ORA-19504: failed to create file "+DATA"
ORA-17502: ksfdcre:5 Failed to create file +DATA
ORA-15081: failed to submit an I/O operation to a disk
ORA-17500: ODM err:KGNFS WRITE FAIL:Permission denied
failover to previous backup
creating datafile file number=1 name=+DATA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/01/2020 01:07:32
ORA-01180: can not create datafile 1
2.DNS 问题是一个BUG可以直接忽略
3.以下IP不需要指定网卡,写在/etc/hosts 中就可以
192.168.1.83 nymtxvip.inno.com nymtxvip
192.168.1.84 hzmtxvip.inno.com hzmtxvip
192.168.1.85 mtscan.inno.com mtscan
4.出现问题要查找日志
/oracle/app/oracle/diag/rdbms/mtxdb/mtxdb1/trace/alert_mtxdb1.log
/oracle/app/oracle/cfgtoollogs/dbca/mtxdb/trace.log_2020-07-01_08-26-16AM
[root@nymtx mtxdb]# pwd
/oracle/app/oracle/cfgtoollogs/dbca/mtxdb
[root@nymtx mtxdb]# tail -n 100 trace.log_2020-07-01_08-26-16AM
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Completed background operations
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Initializing view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Completed initializing view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Displaying view
[completionPage.flowWorker] [ 2020-07-01 09:01:15.652 CST ] [SQLEngine.getConnectCommand:1064] Connecting using conn string: mtx-scan/mtxdb.inno.com
[completionPage.flowWorker] [ 2020-07-01 09:01:15.652 CST ] [SQLEngine.reInitialize:825] Reinitializing SQLEngine...
[completionPage.flowWorker] [ 2020-07-01 09:01:15.655 CST ] [OracleHome.getVersion:1066] OracleHome.getVersion called. Current Version: 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.655 CST ] [OracleHome.getVersion:1134] Current Version From Inventory: 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.655 CST ] [OracleHome.getVersion:1066] OracleHome.getVersion called. Current Version: 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [OracleHome.getVersion:1134] Current Version From Inventory: 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [OracleHome.getVersion:1066] OracleHome.getVersion called. Current Version: 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [OracleHome.getVersion:1134] Current Version From Inventory: 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [SQLPlusEngine.getCmmdParams:226] m_home 19.0.0.0.0
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [SQLPlusEngine.getCmmdParams:227] version > 112 true
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [SQLEngine.getEnvParams:629] NLS_LANG: AMERICAN_AMERICA.ZHS16GBK
[completionPage.flowWorker] [ 2020-07-01 09:01:15.656 CST ] [SQLEngine.initialize:376] Execing SQLPLUS/SVRMGR process...
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Completed displaying view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Loading view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Completed loading view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Localizing view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor loadView
INFO: Completed localizing view
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Waiting for completion of background operations
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.FlowWorker waitForCompletion
INFO: Finishing all forked tasks at state completionPage
INFO: Jul 01, 2020 9:01:15 AM oracle.install.commons.flow.FlowWorker waitForCompletion
INFO: Waiting for completion all forked tasks at state completionPage
[completionPage.flowWorker] [ 2020-07-01 09:01:15.705 CST ] [SQLEngine.initialize:413] m_bReaderStarted: false
[completionPage.flowWorker] [ 2020-07-01 09:01:15.705 CST ] [SQLEngine.initialize:417] Starting Reader Thread...
[completionPage.flowWorker] [ 2020-07-01 09:01:15.713 CST ] [SQLEngine.initialize:465] Waiting for m_bReaderStarted to be true
[completionPage.flowWorker] [ 2020-07-01 09:01:15.955 CST ] [CompletionPage$1.call:444] Connected to the database
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.FlowWorker waitForCompletion
INFO: All forked task are completed at state completionPage
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Completed background operations
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor startAction
INFO: Executing action at state completionPage
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor startAction
INFO: Completed executing action at state
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Waiting for completion of background operations
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Completed background operations
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Waiting for completion of background operations
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor completeBackgroundOperations
INFO: Completed background operations
INFO: Jul 01, 2020 9:01:16 AM oracle.install.commons.flow.AbstractFlowExecutor nextState
INFO: Moved to state
