How to change hostname/ip for a Grid Infrastructure Oracle Restart Standalone Configuration (SIHA) (document ID 1552810.1)

Source: Internet
Author: User



Therefore perform the next steps after the hostname is updated/changed/modified in the Oracle Restart Configurati On



1) Configure the CSS & Ohas services as root user as follows:


# <11.2 Grid Infrastructure Oracle Home>/crs/install/roothas.pl -deconfig -force

# <11.2 Grid Infrastructure Oracle Home>/crs/install/roothas.pl
# cd <12.1 Grid infrastructure Oracle Home>/crs/install # perl roothas.sh -deconfig -force --This removes any configuration on the system that referenced the old host name.
# cd <12.1 Grid infrastructure Oracle Home> # ./root.sh





Go to the grid home ' s bin directory. Use the Srvctl Add Database command with THE-C single flag to add the database under an Oracle Restart configuration.
Also Use the Srvctl Add command to add the Listener, the Oracle ASM instance, all Oracle ASM disk groups, and any database Services to the Oracle Restart configuration.




2) Please perform the next steps as Oracle or grid OS user (as the grid Infrastructure OS owner):


$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl modify resource "ora.cssd" -init -attr "AUTO_START=1" 





3) Restart the Ohas stack as grid or Oracle OS User (as the grid Infrastructure OS owner):


$> <11.2 grid Infrastructure Oracle home>/bin/crsctl stop has$> <11.2 grid Infrastructure Oracle Home>/bin/crsctl Start has



4) Check the CSS & Ohas state as Grid or Oracle OS user (as the grid Infrastructure OS owner):


$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl check has

$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl check css

$> <11.2 Grid Infrastructure Oracle Home>/bin/ crsctl stat resource

$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl stat res -t



Note:if the CSS & Ohas service did not start, then you'll need to reboot the Linux/unix box and check them again.

5) Recreate the default listener (listener) using port 1521 (or using your desired port), thru the NETCA GUI located on th E New Grid Infrastructure Oracle Home (or manually if you don't have graphical access) as Grid or Oracle OS user (as the Grid Infrastructure OS owner):


$> srvctl Add listener$> Srvctl start Listener





6) Please create the Init+asm.ora file on the <11.2 Grid Infrastructure Oracle Home>/dbs directory with the next par Ameters:


asm_diskgroups= <list of diskgroups>

asm_diskstring= ‘/dev/oracleasm/disks/*‘  

instance_type=‘asm‘

large_pool_size=12M



7) Add The ASM instance as grid or Oracle OS user (as the grid Infrastructure OS owner):


$> <11.2 Grid Infrastructure Oracle Home>/bin/srvctl add asm
$> <12.1 Grid Infrastructure Oracle Home>/bin/srvctl add asm



8) Enable ASM instance Auto Start as grid or Oracle OS user (as the grid Infrastructure OS owner) as follow:


$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl modify resource "ora.asm" -attr "AUTO_START=1" 



9) Make sure the disks is discovered by Kfod as grid or Oracle OS user (as the grid Infrastructure OS owner) as follow:

Example:


$> <11.2 Grid Infrastructure Oracle home>/bin/kfod asm_diskstring='orcl:*' Disks=all



Or


$> <11.2 Grid Infrastructure Oracle home>/bin/kfod asm_diskstring='<full path ASM Disks location>/*' disks=all



If So and then startup the ASM instance as grid or Oracle OS user (as the grid Infrastructure OS owner) as follow:


$> export ORACLE_SID=+ASM

$> <11.2 Grid Infrastructure Oracle Home>/bin/sqlplus “/as sysasm”

SQL> startup pfile=init+ASM.ora --#init file from point #6 SQL> show parameter asm






One) Validate that the candidate disks is being discovered:


Select Path from  V$asm_disk;



Create A new ASM instance SPFile:


Sql> create SPFile from Pfile;



ADD the new ASM SPFile and listener to the new ASM instance resource:


$> <11.2 Grid Infrastructure Oracle home>/bin/srvctl modify ASM-  p <spfile fullpath> $
    > <11.2 Grid Infrastructure Oracle home>/bin/srvctl modify ASM-  L LISTENER





Validate the Ohas (Oracle Restart) services start as follows:


$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl  stop has

$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl  start has

$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl stat res

$> <11.2 Grid Infrastructure Oracle Home>/bin/crsctl stat res -t





How to change hostname/ip for a Grid Infrastructure Oracle Restart Standalone Configuration (SIHA) (document ID 1552810.1)


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.