If you a create ASM disk-group over SAN or NAS storage and that ASM disk-group disappears, then follow below steps to get those DG's remounted. login as: root email@example.com's password: [root@myasm-12cr2-node1 ~]# oracleasm listdisks ASM LUN1 LUN2 LUN3 LUN4 LUN5 LUN6 LUN7 LUN8 [root@myasm-12cr2-node1 ~]# oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM… Continue reading How to remount an unmounted ASM Diskgroup?
Today we are going to see and learn about starting and shutting down an Oracle Database. Pre-requisites:- There are few pre-requisites before we attempt to start or stop a database. The database should exist on the Linux host. ORACLE_SID, ORACLE_HOME, CLASS_PATH and PATH environment variables must be set. How to validate pre-requisites? run command "cat… Continue reading How start and Stop Oracle Database on a Linux host
To configure RMAN CATALOG and Register any Oracle Database to RMAN CATALOG follow below steps:- Definition:- RMANDB = RMAN CATALOG database name ORCL = Target Database we will register with RMAN CATALOG Step 1 Create tablespace, create user and grant permissions on RMANDB. SQL> create tablespace rmancatalog 2 datafile '<PATH>/rmancat.dbf'… Continue reading Configure Oracle Database RMAN Catalog and Register Database to RMAN catalog
Follow below steps to configure static Oracle Database listener. Currently, I do not have any listener configured on my setup and "lsnrctl status" is not showing any result. [grid@ib-auto-sco-asm154 ~]$ lsnrctl status LSNRCTL for Linux: Version 18.104.22.168.0 - Production on 29-AUG-2018 20:03:33 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ib-auto-sco-asm154)(PORT=1521))) STATUS of… Continue reading Configure Oracle Database Static Listener