Pre-Tasks
If you root then execute su – oracle
Then > . oraenv
Write down: +ASM
Before start with the Oracle Restart process you must stop the listener:
[[email protected] ~]# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE DB ora.FRA.dg ora....up.type ONLINE ONLINE DB ora....ER.lsnr ora....er.type ONLINE ONLINE DB ora.asm ora.asm.type ONLINE ONLINE DB ora....stro.db ora....se.type OFFLINE OFFLINE ora.cssd ora.cssd.type ONLINE ONLINE DB ora.db11g.db ora....se.type ONLINE OFFLINE ora.diskmon ora....on.type ONLINE ONLINE DB
[[email protected] ~]# lsnrctl stop listener LSNRCTL for Linux: Version 19.3.0.0.0 - Production on 09-MAG-2019 22:44:16 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completed successfully
[[email protected] ~]# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE DB ora.FRA.dg ora....up.type ONLINE ONLINE DB ora....ER.lsnr ora....er.type OFFLINE OFFLINE ora.asm ora.asm.type ONLINE ONLINE DB ora....stro.db ora....se.type OFFLINE OFFLINE ora.cssd ora.cssd.type ONLINE ONLINE DB ora.db11g.db ora....se.type ONLINE OFFLINE ora.diskmon ora....on.type ONLINE ONLINE DB
Remove Configuration
Remove the existing configuration calling Oracle Restart as root (with ORACLE_HOME set to the grid home), set GRID environment:
[[email protected] ~]# echo $ORACLE_HOME copy to clipboard [[email protected] ~]# echo $ORACLE_SID
[[email protected] ~]# export ORACLE_HOME= from upper [[email protected] ~]# export ORACLE_SID=+ASM
[[email protected] ~]# $ORACLE_HOME/perl/bin/perl -I $ORACLE_HOME/perl/lib -I $ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl -deconfig 2013-04-17 22:44:26: Checking for super user privileges 2013-04-17 22:44:26: User has super user privileges 2013-04-17 22:44:26: Parsing the host name Using configuration parameter file: /u01/app/19.3.0.0/grid/crs/install/crsconfig_params CRS resources for listeners are still configured CRS-2529: Unable to act on 'ora.cssd' because that would require stopping or relocating 'ora.asm', but the force option was not specified CRS-4000: Command Stop failed, or completed with errors. CRS-2586: Deletion of a running resource 'ora.cssd' requires the force option CRS-4000: Command Delete failed, or completed with errors. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'DB' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'DB' CRS-2673: Attempting to stop 'ora.FRA.dg' on 'DB' CRS-2677: Stop of 'ora.DATA.dg' on 'DB' succeeded CRS-2677: Stop of 'ora.FRA.dg' on 'DB' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'DB' CRS-2677: Stop of 'ora.asm' on 'DB' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'DB' CRS-2677: Stop of 'ora.cssd' on 'DB' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'DB' CRS-2677: Stop of 'ora.diskmon' on 'DB' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'DB' has completed CRS-4133: Oracle High Availability Services has been stopped. Successfully deconfigured Oracle Restart stack
Change Hostname
It’s the moment to change the hostname of your Server
/etc/sysconfig/network
Edit this file and set the new name
vim /etc/sysconfig/network NETWORKING=yes HOSTNAME=DB-TEST-NEW
or use nmtui tool
/etc/hosts
Update /etc/hosts as appropriate
vim /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.50.4 DB-TEST-NEW DB-TEST-NEW.local.lan
ifcfg-ethX
Change the IP address. Copy first file to .bak
[[email protected] ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE="eth0" HWADDR="00:1F:4C:02:B3:03" ONBOOT="yes" IPADDR=192.168.100.10 NETMASK=255.255.255.0 GATEWAY=192.168.100.1
listener.ora
Change the hostname in the listener configuration file. Copy file first to .bak
cat $ORACLE_HOME/network/admin/listener.ora # listener.ora Network Configuration File: /u01/app/19.3.0.0/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = DB-TEST-NEW.local.lan)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /u01/app/grid ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
Reboot to pickup the changes
Recreate the Configuration
After change the HOSTNAME and Restart the configuration is the moment to re-configure your Grid and Oracle installations.
GRID
Call Oracle Restart as root (with ORACLE_HOME set to the grid home) to configure your GRID installation, set GRID environment:
[[email protected] ~]# export ORACLE_HOME= from upper [[email protected] ~]# export ORACLE_SID=+ASM
[[email protected] ~]# $ORACLE_HOME/perl/bin/perl -I $ORACLE_HOME/perl/lib -I $ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl 2019-05-17 22:48:56: Checking for super user privileges 2019-05-17 22:48:56: User has super user privileges 2019-05-17 22:48:56: Parsing the host name Using configuration parameter file: /u01/app/19.3.0.0/grid/crs/install/crsconfig_params LOCAL ADD MODE Creating OCR keys for user 'oracle', privgrp 'oinstall'.. Operation successful. CRS-4664: Node DB-DES successfully pinned. Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting DB-DES 2013/04/17 22:49:15 /u01/app/19.3.0.0/grid/cdata/basedatosregistro-des/backup_20130417_224915.olr Successfully configured Oracle Grid Infrastructure for a Standalone Server
Listener,ASM,DB,Services
Exit from root user and log-on as oracle or su – oracle (with ORACLE_HOME set to the grid home) add the listener, ASM, database and services into the Oracle Restart configuration.
[[email protected] ~]$ . oraenv +ASM
LISTENER
Add the listener and start it
[[email protected] ~]$ srvctl add listener [[email protected] ~]$ srvctl start listener
ASM diskgroups
The ASM diskgroups (+DATA & +FRA) are not automatically added back to the Oracle Restart configuration add the candidate disks and start ASM:
[[email protected] ~]$ srvctl add asm -d '/dev/sd[a-h]1' [[email protected] ~]$ srvctl start asm
As you can see no diskgroups are added
[[email protected] ~]$ asmcmd lsdg
You must add it manually:
[[email protected] ~]$ sqlplus /nolog SQL> conn / as sysasm SQL> alter diskgroup data mount; SQL> alter diskgroup fra mount; SQL> exit
– If this doeasn’t work, run from GUI asmca and find candidate
/dev/oracleasm/disks/* and mount
If you don’t see disk groups:
[[email protected] ~]$ oracleasm deletedisk DATA1
and run from GUI asmca and find candidate
/dev/oracleasm/disks/* and mount
As shown by the output of srvctl status below, the diskgroup +DATA & +FRA is running on DB-TEST-NEW
[[email protected] ~]$ srvctl status diskgroup -g data Disk Group data is running on DB-DES [[email protected] ~]$ srvctl status diskgroup -g fra Disk Group fra is running on DB-DES
[[email protected] ~]$ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 30718 27014 0 27014 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 30718 25474 0 25474 0 N FRA/
Database
Add the database to Oracle Restart, and configure:
[[email protected] ~]$ srvctl add database -d DB19C -o $ORACLE_HOME -n DB19C -p +DATA/DB-DES/spfileDB19C.ora -a DATA,FRA
[[email protected] ~]$ srvctl config database -d DB19C Database unique name: DB19C Database name: DB19C Oracle home: /u01/app/19.3.0.0/grid Oracle user: oracle Spfile: +DATA/DB-DES/spfileDB19C.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Disk Groups: DATA,FRA Services:
Finally start your Database:
[[email protected] ~]$ srvctl start database -d DB19C