Po změně IP adresy a jména serveru. Dokud se server nerestartoval, bylo vše ok, ale potom..
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
[oracle@oracle3 ~]$ crsctl start resource ora.cssd CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Start failed, or completed with errors.
[oracle@oracle3 ~]$ crsctl enable has CLSU-00105: Operating System interface has reported an internal failure CLSU-00103: error location: scrcreate5 CLSU-00104: additional error information: need ha priv CRS-4000: Command Enable failed, or completed with errors. [oracle@oracle3 ~]$ srvctl config asm PRCR-1070 : Failed to check if resource ora.asm is registered Cannot communicate with crsd
Řešení
[root@oracle3 ~]# cd /u01/app/oracle/product/12.1.0/grid/crs/install/ [root@oracle3 install]# ./roothas.pl -deconfig -force Using configuration parameter file: ./crsconfig_params CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Stop failed, or completed with errors. CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Delete failed, or completed with errors. CLSU-00100: Operating System function: opendir failed with error data: 2 CLSU-00101: Operating System error message: No such file or directory CLSU-00103: error location: scrsearch1 CLSU-00104: additional error information: cant open scr home dir scls_scr_getval CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Stop failed, or completed with errors. 2014/12/20 13:55:41 CLSRSC-337: Successfully deconfigured Oracle Restart stack
[root@oracle3 install]# ./roothas.pl Using configuration parameter file: ./crsconfig_params LOCAL ADD MODE Creating OCR keys for user 'oracle', privgrp 'oinstall'.. Operation successful. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-4664: Node oracle3 successfully pinned. 2014/12/20 13:56:22 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'
2014/12/20 13:56:51 /u01/app/oracle/product/12.1.0/grid/cdata/oracle3/backup_20141220_135651.olr 2014/12/20 13:56:52 CLSRSC-327: Successfully configured Oracle Grid Infrastructure for a Standalone Server
[oracle@oracle3 ~]$ crsctl start resource "ora.cssd" CRS-2672: Attempting to start 'ora.cssd' on 'oracle3' CRS-2672: Attempting to start 'ora.diskmon' on 'oracle3' CRS-2676: Start of 'ora.diskmon' on 'oracle3' succeeded CRS-2676: Start of 'ora.cssd' on 'oracle3' succeeded
Následně start ASM
[oracle@oracle3 ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.1.0 Production on Sat Dec 20 14:04:39 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ASM instance started
Total System Global Area 1135747072 bytes Fixed Size 2297344 bytes Variable Size 1108283904 bytes ASM Cache 25165824 bytes ORA-15110: no diskgroups mounted Řešení zde.
Start databáze
[oracle@oracle3 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sat Dec 20 14:08:53 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORACLE instance started.
Total System Global Area 5027385344 bytes Fixed Size 2298736 bytes Variable Size 1040190608 bytes Database Buffers 3976200192 bytes Redo Buffers 8695808 bytes Database mounted. Database opened.