<<Back to Oracle RAC Main Page Cloning Oracle RAC Database to Single Instance Database Existing DB ORCL with 2 node (ORCL11 and ORCL12) Closed DB: ORCLN Step1: Add Static Listener Entry Add Static Listener Entry in GRID_HOME/network/admin/listener.ora and reload the listener SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCLN) (ORACLE_HOME = /ora_app/product/19c/dbd1) (SID_NAME = ORCLN) ) ) lsnrctl reload LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-FEB-2026 09:14:16 Copyright (c) 1991, 2023, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [+ASM1] lsnrctl status |grep -i ORCLN Service "ORCLN" has 1 instance(s). Instance "ORCLN", status UNKNOWN, has 1 handler(s) for this service... Step2:Add TNS entry for ORCLN add...
A Blog to share interesting Database Facts and Experience.