Changing Hostname, ORACLE ASM

      No Comments on Changing Hostname, ORACLE ASM

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

Leave a Reply

Your email address will not be published. Required fields are marked *