In this article we will demonstrate how to clone a RAC database to a single instance Non ASM database on a new host using RMAN backup from the RAC database.
STEPS
- Take backup from the RAC database or use an existing backup from the RAC database.
- Create a PFILE for the new single instance using the PFILE from the RAC database.
- Copy backup and the PFILE to the new host.
- Modify the PFILE.
- Use modified PFILE to STARTUP NOMOUNT the database on the new host
- Invoke RMAN and restore the control file.
- Catalog RMAN backup pieces.
- Determine the point up to which media recovery should run on the restored database.
- Determine datafiles needed for restore.
- Prepare Restore/Recovery Script.
- Execute Restore/Recovery Script.
- Rename redologs and open database with the RESETLOGS option.
- Remove the redolog groups for redo threads of other intances.
- Remove the undo tablespaces of other instances and create new temporary tablespace(s).
- Create Password File.
- Configure the tnsnames.ora file for remote connections.
Take backup from the RAC database or use an existing backup from the RAC database.
Take appropriate RMAN backup of the RAC database. When the controlfile is restored on the new host from the autobackup piece, it will have the information of the last backup.
By default CONTROLFILE AUTOBACKUP is on for oracle 19c ,so the backup will include the Control File and the SPFILE
RMAN> SHOW CONTROLFILE AUTOBACKUP;
RMAN configuration parameters for database with db_unique_name RACDB are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
In this demonstration, we will backup to this location ‘u02/bkp/RACDBBACKUP’ .You can change it in your case.
RMAN> run {
allocate channel c1 type disk ;
allocate channel c2 type disk ;
backup format '/u02/bkp/RACDBBACKUP/%U' check logical as compressed backupset database plus archivelog format '/u02/bkp/RACDBBACKUP/%U';
}
Create a PFILE for the new Single Instance using the PFILE from the RAC database.
Connect to RAC database and create a copy of the PFILE.
SQL> create pfile='/u02/bkp/RACDBBACKUP/initTESTDBora' from spfile;
Copy backup and the PFILE to the new host.
You can use scp or rsync command on LINUX
Login to new host and create dirctory to hold backup from source.
We will use this location (‘/home/oracle/tmp’).
$ mkdir -p /home/oracle/tmp On source DB, copy backup to new host. Enter new host password for oracle user when prompted.
$ rsync -avzh --progress /u02/bkp/RACDBBACKUP [email protected]:/home/oracle/tmpModify the PFILE
On the new host change directory to location
$ cd /home/oracle/tmp Content of parameter file from the RAC database
$ vi initTESTDBora
RACDB2.__data_transfer_cache_size=0
RACDB1.__data_transfer_cache_size=0
RACDB2.__db_cache_size=79456894976
RACDB1.__db_cache_size=79456894976
RACDB2.__inmemory_ext_roarea=0
RACDB1.__inmemory_ext_roarea=0
RACDB2.__inmemory_ext_rwarea=0
RACDB1.__inmemory_ext_rwarea=0
RACDB2.__java_pool_size=1879048192
RACDB1.__java_pool_size=1879048192
RACDB2.__large_pool_size=1073741824
RACDB1.__large_pool_size=1073741824
RACDB2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
RACDB1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
RACDB2.__pga_aggregate_target=33822867456
RACDB1.__pga_aggregate_target=33822867456
RACDB2.__sga_target=101200166912
RACDB1.__sga_target=101200166912
RACDB2.__shared_io_pool_size=268435456
RACDB1.__shared_io_pool_size=268435456
RACDB2.__shared_pool_size=17716740096
RACDB1.__shared_pool_size=17716740096
RACDB2.__streams_pool_size=536870912
RACDB1.__streams_pool_size=536870912
RACDB2.__unified_pga_pool_size=0
RACDB1.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/RACDB/adump'
*.audit_trail='OS'
*.cluster_database=true
*.compatible='19.0.0'
*.control_files='+DATA/RACDB/CONTROLFILE/current.261.1088082857','+REDO/RACDB/CONTROLFILE/current.263.1097817489'
*.cursor_sharing='Force'
*.db_block_size=8192
*.db_cache_advice='OFF'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+REDO'
*.db_name='RACDB'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=86570434560
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=RACDBXDB)'
*.fast_start_mttr_target=300
RACDB1.instance_number=1
RACDB2.instance_number=2
*.local_listener='-oraagent-dummy-'
RACDB1.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SRVORADB1_vip)(PORT=1521))))'
RACDB2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SRVORADB2_vip)(PORT=1521))))'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=2000
*.processes=5000
*.remote_dependencies_mode='SIGNATURE'
RACDB1.remote_listener='SRVORADB-SCAN:1521'
RACDB2.remote_listener='SRVORADB-SCAN:1521'
*.remote_login_passwordfile='exclusive'
*.result_cache_max_size=0
*.session_cached_cursors=400
*.sga_target=96351m
*.skip_unusable_indexes=FALSE
*.standby_file_management='AUTO'
RACDB2.thread=2
RACDB1.thread=1
*.undo_retention=1800
RACDB2.undo_tablespace='UNDOTBS2'
RACDB1.undo_tablespace='UNDOTBS1'
NB.
Modify the following parameters depending on the directory structure of the new host: audit_file_dest, background_dump_dest, control_files, core_dump_dest, log_archive_dest_1, user_dump_dest etc
Take note of RAC specific paramaters such as cluster_database_instances, cluster_database etc
For the parameter undo_tablespace, use any one undo tablespace name
Our final PFILE will look like this.
$ vi initTESTDB.ora
TESTDB.__large_pool_size=1073741824
TESTDB.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
TESTDB.__pga_aggregate_target=33822867456
TESTDB.__sga_target=101200166912
TESTDB.__shared_io_pool_size=268435456
TESTDB.__shared_pool_size=5502926848
TESTDB.__shared_pool_size=17716740096
TESTDB.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/testdb/adump'
*.audit_trail='OS'
*.compatible='19.0.0'
*.control_files='/u01/app/oracle/oradata/TESTDB/control01.ctl','/u01/app/oracle/recovery_area/TESTDB/control02.ctl'
*.cursor_sharing='Force'
*.db_block_size=8192
*.db_cache_advice='OFF'
*.db_domain='test.com'
*.db_name='RACDB'
*.db_recovery_file_dest='/u01/app/oracle/recovery_area'
*.db_recovery_file_dest_size=82560m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
*.fast_start_mttr_target=300
*.local_listener='LISTENER_TESTDB'
TESTDB.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.10.130)(PORT=1521))))'
*.nls_date_format='DD-MON-RRRR'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=2000
*.optimizer_dynamic_sampling=1
*.optimizer_index_caching=90
*.optimizer_index_cost_adj=50
*.processes=5000
*.remote_dependencies_mode='SIGNATURE'
*.remote_login_passwordfile='EXCLUSIVE'
*.service_names='TESTDB.test.com'
*.session_cached_cursors=400
*.skip_unusable_indexes=FALSE
*.undo_retention=1800
*.undo_tablespace='UNDOTBS1'
NB.
Maintain *.db_name=’RACDB’ in the modified PFILE to prevent the error ORA-01103: database name ‘RACDB’ in control file is not ‘TESTDB’
You can change the db_name later with the nid utility.
Create directories on new host as specified in the modified PFILE.
$ mkdir -p /u01/app/oracle/admin/testdb/adump
$ mkdir -p /u01/app/oracle/oradata/TESTDB
$ mkdir -p /u01/app/oracle/recovery_area/TESTDB
Use modified PFILE to STARTUP NOMOUNT the database on the new host
$ echo $ORACLE_SID
TESTDB
[oracle@uatdb-dr archivelog]$
$ sqlplus "/ as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 23 07:57:31 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/home/oracle/tmp/initTESTDB.ora';
SQL> create spfile from pfile='/home/oracle/tmp/initTESTDB.ora';
Shutdown and startup in nomount mode
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>
SQL> startup nomount
SQL> exit
Invoke RMAN and restore the control file
Restore the control file specifying the location where the control file autobackup piece is on the new host.
$ rman target / nocatalog
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jan 23 08:06:33 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (not mounted)
using target database control file instead of recovery catalog
RMAN> restore controlfile from '/home/oracle/tmp/RACDB_CF_c-2926977461-00';
Starting restore at 23-JAN-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=866 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/u01/app/oracle/oradata/TESTDB/control01.ctl
output file name=/u01/app/oracle/recovery_area/TESTDB/control02.ctl
Finished restore at 23-JAN-21
RMAN>
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN>
Catalog RMAN backup pieces
RMAN> catalog start with '/home/oracle/tmp/RACDBBACKUP' noprompt;
Determine the point up to which media recovery should run on the restored database.
RMAN> list backup of archivelog all;
List of Archived Logs in backup set 5554
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 97923 28458168179 23-JAN-21 28458510206 23-JAN-21
Backup Set Copy #1 of backup set 5554
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:03 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5554 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5554 1 EXPIRED /u02/bkp/RACDBBACKUP/RACDB_ARC_882h9jb3_s264_p1
Backup Set Copy #2 of backup set 5554
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:03 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5554 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5566 1 AVAILABLE /home/oracle/tmp/RACDB_ARC_882h9jb3_s264_p1
BS Key Size
------- ----------
5555 940.22M
List of Archived Logs in backup set 5555
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 113031 28458401845 23-JAN-21 28458510067 23-JAN-21
Backup Set Copy #1 of backup set 5555
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:14 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5555 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5555 1 EXPIRED /u02/bkp/RACDBBACKUP/RACDB_ARC_892h9jb3_s265_p1
Backup Set Copy #2 of backup set 5555
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:14 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5555 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5565 1 AVAILABLE /home/oracle/tmp/RACDB_ARC_892h9jb3_s265_p1
BS Key Size
------- ----------
5556 1.16G
List of Archived Logs in backup set 5556
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 113030 28458270621 23-JAN-21 28458401845 23-JAN-21
Backup Set Copy #1 of backup set 5556
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:31 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5556 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5556 1 EXPIRED /u02/bkp/RACDBBACKUP/RACDB_ARC_8a2h9jb3_s266_p1
Backup Set Copy #2 of backup set 5556
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:31 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5556 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5564 1 AVAILABLE /home/oracle/tmp/RACDB_ARC_8a2h9jb3_s266_p1
BS Key Size
------- ----------
5557 1.16G
List of Archived Logs in backup set 5557
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 113029 28458168051 23-JAN-21 28458270621 23-JAN-21
Backup Set Copy #1 of backup set 5557
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:38 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5557 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5557 1 EXPIRED /u02/bkp/RACDBBACKUP/RACDB_ARC_8g2h9jh0_s272_p1
Backup Set Copy #2 of backup set 5557
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:38 23-JAN-21 YES ARC_BKP_23_JAN_2021
List of Backup Pieces for backup set 5557 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
5563 1 AVAILABLE /home/oracle/tmp/RACDB_ARC_8g2h9jh0_s272_p1
Check the last archive sequence for all redo threads and select the archive sequence having LEAST “Next SCN” among them. In our case sequence 97923 of thread 1 has Next SCN of 28458510206 while sequence 113031 of thread 2 has Next SCN of 28458510067. Since squence 113031 of thread 2 has least Next SCN we will recover upto this point. (If you are keen to have recovery run until some specific time you can always give SET UNTIL TIME)
Determine datafiles needed for the recovery
RMAN> report schema;
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DATA/RACDB/DATAFILE/system.259.1088082715
2 0 PLATO *** +DATA/RACDB/DATAFILE/plato.328.1107727809
3 0 SYSAUX *** +DATA/RACDB/DATAFILE/sysaux.258.1088082751
4 0 UNDOTBS1 *** +DATA/RACDB/DATAFILE/undotbs1.257.1088082765
5 0 UNDOTBS2 *** +DATA/RACDB/DATAFILE/undotbs2.271.1088083275
7 0 USERS *** +DATA/RACDB/DATAFILE/users.269.1088082767
8 0 PREP_GEM *** +DATA/RACDB/DATAFILE/prep_gem.329.1107727867
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA/RACDB/TEMPFILE/temp.270.1088082865
RMAN>
Prepare Restore Script
On new host, create script.
$ cd /home/oracle/tmp
$ vi rman_restore.sh
Populate file with content below :
Modify to suite your situation.
#!/bin/bash
ORACLE_SID=TESTDB; export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin
#
# Show the full DATE and TIME details
NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
# LOG Location
LOG_LOC=/home/oracle/tmp
TODAYTAG=`date +%d-%b-%Y`
LOG_FILE=${LOG_LOC}/duplicate_testdb_${TODAYTAG}.log
${ORACLE_HOME}/bin/rman msglog=${LOG_FILE} <<EOF
connect target /
run {
set until sequence 113032 thread 2;
set newname for datafile 1 to '/u01/app/oracle/oradata/TESTDB/system.259.1088082715';
set newname for datafile 2 to '/u01/app/oracle/oradata/TESTDB/plato.328.1107727809';
set newname for datafile 3 to '/u01/app/oracle/oradata/TESTDB/sysaux.258.1088082751';
set newname for datafile 4 to '/u01/app/oracle/oradata/TESTDB/undotbs1.257.1088082765';
set newname for datafile 5 to '/u01/app/oracle/oradata/TESTDB/undotbs2.271.1088083275';
set newname for datafile 7 to '/u01/app/oracle/oradata/TESTDB/users.269.1088082767';
set newname for datafile 8 to '/u01/app/oracle/oradata/TESTDB/prep_gem.329.1107727867';
restore database;
switch datafile all;
recover database;
}Since we determined previously that media recovery should run until sequence 113031 hence we use SET UNTIL SEQUENCE 113032 (+1) above. You also need to use SET NEWNAME clause to restore datafiles to a location on the new host which is different from the production path.
Finally, SWITCH DATAFILE ALL clause updates these new datafile locations in the controlfile.
Save the script and make it executable
$ cd /home/oracle/tmp
$ chmod 775 rman_restore.sh
Execute restore/recovery script.
We will run the script in the backgroud using the nohup command. The & at the end of the command ensures that the process runs in the background.
$ nohup ./rman_restore.sh > db_rman_restore.log 2>&1 &
check the log location specific in the script and tail it’s content. The log file is of this partern duplicate_testdb_${TODAYTAG}.log
$ tail -f duplicate_testdb_23-Jan-2021.log
sample_output
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 23-JAN-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=865 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=991 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/TESTDB/system.259.1088082715
.
.
.
.
media recovery complete, elapsed time: 00:00:38
Finished recover at 23-JAN-21
RMAN>
RMAN>
RMAN>
Recovery Manager complete.
Rename redo logs and open database with the RESETLOGS option
SQL> select member from v$logfile;
MEMBER
----------------------------------------------------------
+REDO/RACDB/ONLINELOG/group_1.261.1155982427
+REDO/RACDB/ONLINELOG/group_2.262.1155982441
+REDO/RACDB/ONLINELOG/group_3.263.1155982451
+REDO/RACDB/ONLINELOG/group_4.265.1106677459
+REDO/RACDB/ONLINELOG/group_5.281.1106677315
+REDO/RACDB/ONLINELOG/group_6.282.1106676965SQL> alter database rename file '+REDO/RACDB/ONLINELOG/group_1.261.1155982427' to '/u01/app/oracle/oradata/TESTDB/group_1.261.1155982427';
Database altered.
SQL> alter database rename file '+REDO/RACDB/ONLINELOG/group_2.262.1155982441' to '/u01/app/oracle/oradata/TESTDB/group_2.262.1155982441';
Database altered.
SQL> alter database rename file '+REDO/RACDB/ONLINELOG/group_3.263.1155982451' to '/u01/app/oracle/oradata/TESTDB/group_3.263.1155982451' ;
Database altered.
SQL> alter database rename file +REDO/RACDB/ONLINELOG/group_4.265.1106677459' to '/u01/app/oracle/oradata/TESTDB/group_4.265.1106677459' ;
Database altered.
SQL> alter database rename file +REDO/RACDB/ONLINELOG/group_5.281.1106677315' to '/u01/app/oracle/oradata/TESTDB/group_5.281.1106677315' ;
Database altered.
SQL> alter database rename file +REDO/RACDB/ONLINELOG/group_6.282.1106676965' to '/u01/app/oracle/oradata/TESTDB/group_6.282.1106676965' ;
Database altered.
Open the database with the resetlogs option.
SQL> alter database open resetlogs;
Database altered.
Remove the redolog groups for redo threads of othe intances.
SQL> select THREAD#, STATUS, ENABLED from v$thread;
THREAD# STATUS ENABLED
---------- ------ --------
1 OPEN PUBLIC
2 CLOSED PUBLIC
SQL> select group# from v$log where THREAD#=2;
GROUP#
----------
4
5
6
SQL> alter database disable thread 2;
Database altered.
SQL> alter database drop logfile group 4;
Database altered.
SQL> alter database drop logfile group 5;
Database altered.
SQL> alter database drop logfile group 6;
Database altered.
SQL> select THREAD#, STATUS, ENABLED from v$thread;
THREAD# STATUS ENABLED
---------- ------ --------
1 OPEN PUBLIC
Remove the undo tablespaces of other instances and create new temporary tablespace(s).
SQL> show parameter undo_tablespace
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
undo_tablespace string UNDOTBS1
SQL>
SQL> select tablespace_name from dba_tablespaces where contents='UNDO';
TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2
SQL> drop tablespace UNDOTBS2 including contents and datafiles;
Tablespace dropped.
SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';
TABLESPACE_NAME
------------------------------
TEMP
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------
+DATA/RACDB/TEMPFILE/temp.270.1088082865
SQL>
SQL> create temporary tablespace TEMP1 tempfile '/u01/app/oracle/oradata/TESTDB/temp.270.1088082865' size 500M;
Tablespace created.
SQL> alter database default temporary tablespace TEMP1;
Database altered.
SQL> drop tablespace TEMP including contents and datafiles;
Tablespace dropped.Create password File
SQL> show parameter REMOTE_LOGIN_PASSWORDFILE
NAME TYPE VALUE
------------------------------------ -------------------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
$ cd $ORACLE_HOME/dbs
$ orapwd file=orapwTESTDB password=sys_password ignorecase=n
$ sqlplus / as sysdba
SQL> startup
Configure the tnsnames.ora file for remote connections.
Check listener for the service name.
$ lsnrctl statusEdit tnsnames.ora with the following entries:
cd $ORACLE_HOME/network/admin
$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.10.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB.test.com)
)
)
Test the connection
$ tnsping TESTDB