RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC)

RMAN Database Restore from ASM to File System RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC) 0. Environment On Source Server 1. Backup database 2. Create pfile from spfile 3. Push backup files/pfile to target server On Target Server 4. Edit pfile 5. Create Required Folders 6. Add the entry in oratab 7. Startup Nomount 8. Restore controlfile 9. Mount database 10. Catalog backup pieces 11. Restore/recover database 12. Change dbname/DBID uisng NID 13. Modify DB_NAME in init file and start the database 14. Add TNS entry 15. Verify 0. Environment Source: DB: SBPROD, Diskgroup: DATA Node: YesBrac1, DB Version: 11.2.0.3 Target: DB: YESBTEST, File System: /u01 Node: YesBrac2, DB Version: 11.2.0.3 On Source SERVER ================== Step 1: Backup database w148p – source [oracle@YesBrac1 ~]$ cat open0.rcv run { allocate channel t1 type disk; backup incremental level 0 database format '/u01/share/backup/database_%d_%u_%s'; release channel t1; } sql 'alter system archive log current'; run { allocate channel a1 type disk; backup archivelog all format '/u01/share/backup/arch_%d_%u_%s'; release channel a1; } run { allocate channel c1 type disk; backup current controlfile format '/u01/share/backup/Control_%d_%u_%s'; release channel c1; } exit [oracle@YesBrac1 ~]$ [oracle@YesBrac1 ~]$ . oraenv ORACLE_SID = [SBPROD] ? [oracle@YesBrac1 ~]$ rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 6 17:11:07 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: SBPROD (DBID=3870074951) RMAN> @open0.rcv RMAN> run { 2> allocate channel t1 type disk; 3> backup incremental level 0 database format '/u01/share/backup/database_%d_%u_%s'; 4> release channel t1; 5> } using target database control file instead of recovery catalog allocated channel: t1 channel t1: SID=36 device type=DISK Starting backup at 06-OCT-16 channel t1: starting incremental level 0 datafile backup set channel t1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA1/SBPROD/datafile/system.258.924538565 input datafile file number=00002 name=+DATA1/SBPROD/datafile/sysaux.257.924538565 input datafile file number=00005 name=+DATA1/SBPROD/datafile/example.256.924538565 input datafile file number=00003 name=+DATA1/SBPROD/datafile/undotbs1.260.924538565 input datafile file number=00004 name=+DATA1/SBPROD/datafile/users.263.924538565 channel t1: starting piece 1 at 06-OCT-16 channel t1: finished piece 1 at 06-OCT-16 piece handle=/u01/share/backup/database_SBPROD_0drhmou2_13 tag=TAG20161006T171130 comment=NONE channel t1: backup set complete, elapsed time: 00:00:25 channel t1: starting incremental level 0 datafile backup set channel t1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel t1: starting piece 1 at 06-OCT-16 channel t1: finished piece 1 at 06-OCT-16 piece handle=/u01/share/backup/database_SBPROD_0erhmour_14 tag=TAG20161006T171130 comment=NONE channel t1: backup set complete, elapsed time: 00:00:01 Finished backup at 06-OCT-16 released channel: t1 RMAN> sql 'alter system archive log current'; sql statement: alter system archive log current RMAN> run { 2> allocate channel a1 type disk; 3> backup archivelog all format '/u01/share/backup/arch_%d_%u_%s'; 4> release channel a1; 5> } allocated channel: a1 channel a1: SID=36 device type=DISK Starting backup at 06-OCT-16 current log archived channel a1: starting archived log backup set channel a1: specifying archived log(s) in backup set input archived log thread=1 sequence=1 RECID=1 STAMP=924541640 input archived log thread=1 sequence=2 RECID=2 STAMP=924541917 input archived log thread=1 sequence=3 RECID=3 STAMP=924541917 channel a1: starting piece 1 at 06-OCT-16 channel a1: finished piece 1 at 06-OCT-16 piece handle=/u01/share/backup/arch_SBPROD_0frhmouu_15 tag=TAG20161006T171157 comment=NONE channel a1: backup set complete, elapsed time: 00:00:01 Finished backup at 06-OCT-16 released channel: a1 RMAN> run { 2> allocate channel c1 type disk; 3> backup current controlfile format '/u01/share/backup/Control_%d_%u_%s'; 4> release channel c1; 5> } allocated channel: c1 channel c1: SID=36 device type=DISK Starting backup at 06-OCT-16 channel c1: starting full datafile backup set channel c1: specifying datafile(s) in backup set including current control file in backup set channel c1: starting piece 1 at 06-OCT-16 channel c1: finished piece 1 at 06-OCT-16 piece handle=/u01/share/backup/Control_SBPROD_0grhmouv_16 tag=TAG20161006T171159 comment=NONE channel c1: backup set complete, elapsed time: 00:00:01 Finished backup at 06-OCT-16 released channel: c1 RMAN> exit Recovery Manager complete. [oracle@YesBrac1 ~]$ Step 2: Create pfile from spfile SQL> select name, open_mode from v$database; NAME OPEN_MODE --------- -------------------- SBPROD READ WRITE SQL> create pfile='/home/oracle/initYESBTEST.ora' from spfile; File created. SQL> Step 3: Push backup files/pfile to target server [oracle@YesBrac1 ~]$ cd /u01/share/backup/ [oracle@YesBrac1 backup]$ scp * oracle@YesBrac2:/u01/share/backup/SBPROD arch_SBPROD_0frhmouu_15 100% 2002KB 2.0MB/s 00:00 Control_SBPROD_0grhmouv_16 100% 9568KB 9.3MB/s 00:00 database_SBPROD_0drhmou2_13 100% 1082MB 40.1MB/s 00:27 database_SBPROD_0erhmour_14 100% 9600KB 9.4MB/s 00:00 [oracle@YesBrac1 backup]$ [oracle@YesBrac1 ~]$ scp initYESBTEST.ora oracle@YesBrac2:/home/oracle initYESBTEST.ora 100% 877 0.9KB/s 00:00 [oracle@YesBrac1 ~]$ On Target Server ================= Step 4: Edit pfile initYESBTEST.ora [oracle@YesBrac2 ~]$ cat initYESBTEST.ora YESBTEST.__db_cache_size=419430400 YESBTEST.__java_pool_size=16777216 YESBTEST.__large_pool_size=16777216 YESBTEST.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment YESBTEST.__pga_aggregate_target=520093696 YESBTEST.__sga_target=754974720 YESBTEST.__shared_io_pool_size=0 YESBTEST.__shared_pool_size=251658240 YESBTEST.__streams_pool_size=33554432 *.audit_file_dest='/u01/app/oracle/admin/YESBTEST/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u01/app/oracle/oradata/YESBTEST/control01.ctl','/u01/app/oracle/oradata/YESBTEST/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='SBPROD' <--- -i="" -p="" .="" 11.2.0.3.0="" 17:43:53="" 1982="" 2011="" 2016="" 5:="" 6:="" 6="" 7:="" add="" admin="" adump="" all="" an="" app="" as="" base="" c="" cat="" connected="" copyright="" create="" db_1:n="" diagnostic_dest="/u01/app/oracle" dispatchers="(PROTOCOL=TCP) (SERVICE=YESBTESTXDB)" entry="" esbrac2="" etc="" folders="" grep="" idle="" in="" instance.="" log_archive_dest_1="LOCATION=+FRA" log_archive_format="%t_%s_%r.dbf" lus:="" memory_target="1262485504" mkdir="" nomount="" oct="" on="" open_cursors="300" oracle.="" oracle="" oracle_sid="[cat]" oradata="" oraenv="" oratab="" processes="150" product="" production="" release="" remains="" remote_login_passwordfile="EXCLUSIVE" required="" reserved.="" rights="" sql="" sqlplus="" startup="" step="" sysdba="" the="" thu="" to="" u01="" unchanged="" undo_tablespace="UNDOTBS1" value="" with="" yesbtest:="" yesbtest=""> startup nomount pfile='/home/oracle/initYESBTEST.ora'; ORACLE instance started. Total System Global Area 1269366784 bytes Fixed Size 2227984 bytes Variable Size 838861040 bytes Database Buffers 419430400 bytes Redo Buffers 8847360 bytes SQL> SQL> create spfile from pfile='/home/oracle/initYESBTEST.ora'; File created. SQL> shut immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Global Area 1269366784 bytes Fixed Size 2227984 bytes Variable Size 838861040 bytes Database Buffers 419430400 bytes Redo Buffers 8847360 bytes SQL> SQL> show parameter pfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/11.2.0/db_1/dbs/spfileYESBTEST.ora SQL> [oracle@YesBrac2 ~]$ ps -ef | grep pmon oracle 3687 1 0 13:39 ? 00:00:01 asm_pmon_+ASM oracle 3874 1 0 17:45 ? 00:00:00 ora_pmon_YESBTEST oracle 4006 32731 0 17:46 pts/1 00:00:00 grep pmon [oracle@YesBrac2 ~]$ Step 8: Restore controlfile [oracle@YesBrac2 ~]$ rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 6 17:46:55 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: SBPROD (not mounted) RMAN> restore controlfile from '/u01/share/backup/SBPROD/Control_SBPROD_0grhmouv_16'; Starting restore at 06-OCT-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=24 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/app/oracle/oradata/YESBTEST/control01.ctl output file name=/u01/app/oracle/oradata/YESBTEST/control02.ctl Finished restore at 06-OCT-16 RMAN> Step 9: Mount database RMAN> sql 'alter database mount'; sql statement: alter database mount released channel: ORA_DISK_1 RMAN> SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- SBPROD MOUNTED SQL> Step 10: Catalog the backup pieces RMAN> catalog start with '/u01/share/backup/SBPROD/'; searching for all files that match the pattern /u01/share/backup/SBPROD/ List of Files Unknown to the Database ===================================== File Name: /u01/share/backup/SBPROD/database_SBPROD_0drhmou2_13 File Name: /u01/share/backup/SBPROD/arch_SBPROD_0frhmouu_15 File Name: /u01/share/backup/SBPROD/database_SBPROD_0erhmour_14 File Name: /u01/share/backup/SBPROD/Control_SBPROD_0grhmouv_16 Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/share/backup/SBPROD/database_SBPROD_0drhmou2_13 File Name: /u01/share/backup/SBPROD/arch_SBPROD_0frhmouu_15 File Name: /u01/share/backup/SBPROD/database_SBPROD_0erhmour_14 File Name: /u01/share/backup/SBPROD/Control_SBPROD_0grhmouv_16 RMAN> Step 11: Restore database RMAN> list backup of archivelog all; List of Backup Sets =================== BS Key Size ------- ---------- 3 1.95M List of Archived Logs in backup set 3 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 1 1176811 06-OCT-16 1199528 06-OCT-16 .. 1 3 1200733 06-OCT-16 1200748 06-OCT-16 <-- 11g="" 1="" 3="" 4="" a="" all="" allocate="" and="" app="" b="" cat="" channel="" d1="" d2="" database="" datafile="" datafiles="" device="" disk="" do="" fewture="" file="" for="" group_1.262.924539537="" group_2.261.924539539="" group_3.264.924539539="" logs="" names="" newname="" of="" online="" onlinelog="" oracle="" oradata="" prevent="" recover="" recovery="" redo="" rename="" restore="" rman="" rman_recovery.rcv="" run="" sequence="" set="" sql="" switch="" tape="" tempfile="" the="" to="" type="" u01="" until=""> @rman_recovery.rcv RMAN> run { 2> # allocate a channel to the tape device 3> ALLOCATE CHANNEL d1 DEVICE TYPE disk; 4> ALLOCATE CHANNEL d2 DEVICE TYPE disk; 5> # rename the datafiles and online redo logs 6> SET NEWNAME FOR DATABASE TO '/u01/app/oracle/oradata/YESBTEST/%b'; 7> SET NEWNAME FOR tempfile 1 TO '/u01/app/oracle/oradata/YESBTEST/%b'; 8> SQL "ALTER DATABASE RENAME FILE ''+DATA1/SBPROD/onlinelog/group_3.264.924539539'' 9> to ''/u01/app/oracle/oradata/YESBTEST/group_3.264.924539539''" ; 10> SQL "ALTER DATABASE RENAME FILE ''+DATA1/SBPROD/onlinelog/group_2.261.924539539'' 11> to ''/u01/app/oracle/oradata/YESBTEST/group_2.261.924539539''" ; 12> SQL "ALTER DATABASE RENAME FILE ''+DATA1/SBPROD/onlinelog/group_1.262.924539537'' 13> to ''/u01/app/oracle/oradata/YESBTEST/group_1.262.924539537''" ; 14> # Do a SET UNTIL to prevent recovery of the online logs 15> SET UNTIL SEQUENCE 4; 16> # restore the database and switch the datafile names 17> restore database; 18> switch datafile all; 19> switch tempfile all; 20> # recover the database 21> RECOVER DATABASE; 22> } allocated channel: d1 channel d1: SID=26 device type=DISK allocated channel: d2 channel d2: SID=24 device type=DISK executing command: SET NEWNAME executing command: SET NEWNAME sql statement: ALTER DATABASE RENAME FILE ''+DATA1/SBPROD/onlinelog/group_3.264.924539539''to ''/u01/app/oracle/oradata/YESBTEST/group_3.264.924539539'' sql statement: ALTER DATABASE RENAME FILE ''+DATA1/SBPROD/onlinelog/group_2.261.924539539''to ''/u01/app/oracle/oradata/YESBTEST/group_2.261.924539539'' sql statement: ALTER DATABASE RENAME FILE ''+DATA1/SBPROD/onlinelog/group_1.262.924539537''to ''/u01/app/oracle/oradata/YESBTEST/group_1.262.924539537'' executing command: SET until clause Starting restore at 06-OCT-16 channel d1: starting datafile backup set restore channel d1: specifying datafile(s) to restore from backup set channel d1: restoring datafile 00001 to /u01/app/oracle/oradata/YESBTEST/system.258.924538565 channel d1: restoring datafile 00002 to /u01/app/oracle/oradata/YESBTEST/sysaux.257.924538565 channel d1: restoring datafile 00003 to /u01/app/oracle/oradata/YESBTEST/undotbs1.260.924538565 channel d1: restoring datafile 00004 to /u01/app/oracle/oradata/YESBTEST/users.263.924538565 channel d1: restoring datafile 00005 to /u01/app/oracle/oradata/YESBTEST/example.256.924538565 channel d1: reading from backup piece /u01/share/backup/database_SBPROD_0drhmou2_13 channel d1: errors found reading piece handle=/u01/share/backup/database_SBPROD_0drhmou2_13 channel d1: failover to piece handle=/u01/share/backup/SBPROD/database_SBPROD_0drhmou2_13 tag=TAG20161006T171130 channel d1: restored backup piece 1 channel d1: restore complete, elapsed time: 00:01:25 Finished restore at 06-OCT-16 datafile 1 switched to datafile copy input datafile copy RECID=6 STAMP=924545382 file name=/u01/app/oracle/oradata/YESBTEST/system.258.924538565 datafile 2 switched to datafile copy input datafile copy RECID=7 STAMP=924545382 file name=/u01/app/oracle/oradata/YESBTEST/sysaux.257.924538565 datafile 3 switched to datafile copy input datafile copy RECID=8 STAMP=924545382 file name=/u01/app/oracle/oradata/YESBTEST/undotbs1.260.924538565 datafile 4 switched to datafile copy input datafile copy RECID=9 STAMP=924545382 file name=/u01/app/oracle/oradata/YESBTEST/users.263.924538565 datafile 5 switched to datafile copy input datafile copy RECID=10 STAMP=924545382 file name=/u01/app/oracle/oradata/YESBTEST/example.256.924538565 renamed tempfile 1 to /u01/app/oracle/oradata/YESBTEST/temp.291.924538685 in control file Starting recover at 06-OCT-16 starting media recovery channel d1: starting archived log restore to default destination channel d1: restoring archived log archived log thread=1 sequence=2 channel d1: restoring archived log archived log thread=1 sequence=3 channel d1: reading from backup piece /u01/share/backup/arch_SBPROD_0frhmouu_15 channel d1: errors found reading piece handle=/u01/share/backup/arch_SBPROD_0frhmouu_15 channel d1: failover to piece handle=/u01/share/backup/SBPROD/arch_SBPROD_0frhmouu_15 tag=TAG20161006T171157 channel d1: restored backup piece 1 channel d1: restore complete, elapsed time: 00:00:01 archived log file name=+FRA/SBPROD/archivelog/2016_10_06/thread_1_seq_2.450.924545383 thread=1 sequence=2 archived log file name=+FRA/SBPROD/archivelog/2016_10_06/thread_1_seq_3.451.924545383 thread=1 sequence=3 media recovery complete, elapsed time: 00:00:00 Finished recover at 06-OCT-16 released channel: d1 released channel: d2 RMAN> **end-of-file** RMAN> sql 'alter database open'; sql statement: alter database open RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of sql command on default channel at 10/06/2016 18:10:27 RMAN-11003: failure during parse/execution of SQL statement: alter database open ORA-01589: must use RESETLOGS or NORESETLOGS option for database open RMAN> sql 'alter database open RESETLOGS'; sql statement: alter database open RESETLOGS RMAN> exit Recovery Manager complete. [oracle@YesBrac2 ~]$ SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u01/app/oracle/oradata/YESBTEST/group_3.264.924539539 /u01/app/oracle/oradata/YESBTEST/group_2.261.924539539 /u01/app/oracle/oradata/YESBTEST/group_1.262.924539537 SQL> SQL> select name, open_mode, db_unique_name, dbid from v$database; NAME OPEN_MODE DB_UNIQUE_NAME DBID --------- -------------------- ------------------------------ ---------- SBPROD READ WRITE SBPROD 3870074951 SQL> Step 12: Change Database name and DB ID SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 1269366784 bytes Fixed Size 2227984 bytes Variable Size 838861040 bytes Database Buffers 419430400 bytes Redo Buffers 8847360 bytes Database mounted. SQL> [oracle@YesBrac2 ~]$ . oraenv ORACLE_SID = [YESBTEST] ? The Oracle base remains unchanged with value /u01/app/oracle [oracle@YesBrac2 ~]$ nid target=sys dbname=YESBTEST DBNEWID: Release 11.2.0.3.0 - Production on Thu Oct 6 18:16:38 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Password: Connected to database SBPROD (DBID=3870074951) Connected to server version 11.2.0 Control Files in database: /u01/app/oracle/oradata/YESBTEST/control01.ctl /u01/app/oracle/oradata/YESBTEST/control02.ctl Change database ID and database name SBPROD to YESBTEST? (Y/[N]) => Y Proceeding with operation Changing database ID from 3870074951 to 2222709898 Changing database name from SBPROD to YESBTEST Control File /u01/app/oracle/oradata/YESBTEST/control01.ctl - modified Control File /u01/app/oracle/oradata/YESBTEST/control02.ctl - modified Datafile /u01/app/oracle/oradata/YESBTEST/system.258.92453856 - dbid changed, wrote new name Datafile /u01/app/oracle/oradata/YESBTEST/sysaux.257.92453856 - dbid changed, wrote new name Datafile /u01/app/oracle/oradata/YESBTEST/undotbs1.260.92453856 - dbid changed, wrote new name Datafile /u01/app/oracle/oradata/YESBTEST/users.263.92453856 - dbid changed, wrote new name Datafile /u01/app/oracle/oradata/YESBTEST/example.256.92453856 - dbid changed, wrote new name Datafile /u01/app/oracle/oradata/YESBTEST/temp.291.92453868 - dbid changed, wrote new name Control File /u01/app/oracle/oradata/YESBTEST/control01.ctl - dbid changed, wrote new name Control File /u01/app/oracle/oradata/YESBTEST/control02.ctl - dbid changed, wrote new name Instance shut down Database name changed to YESBTEST. Modify parameter file and generate a new password file before restarting. Database ID for database YESBTEST changed to 2222709898. All previous backups and archived redo logs for this database are unusable. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully. [oracle@YesBrac2 ~]$ Please note database will go down automatically Step 13: Change DB_NAME and start the database [oracle@YesBrac2 ~]$ cat initYESBTEST.ora YESBTEST.__db_cache_size=419430400 YESBTEST.__java_pool_size=16777216 YESBTEST.__large_pool_size=16777216 YESBTEST.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment YESBTEST.__pga_aggregate_target=520093696 YESBTEST.__sga_target=754974720 YESBTEST.__shared_io_pool_size=0 YESBTEST.__shared_pool_size=251658240 YESBTEST.__streams_pool_size=33554432 *.audit_file_dest='/u01/app/oracle/admin/YESBTEST/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u01/app/oracle/oradata/YESBTEST/control01.ctl','/u01/app/oracle/oradata/YESBTEST/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='YESBTEST' <--- diagnostic_dest="/u01/app/oracle" dispatchers="(PROTOCOL=TCP) (SERVICE=YESBTESTXDB)" esbrac2="" log_archive_dest_1="LOCATION=+FRA" log_archive_format="%t_%s_%r.dbf" memory_target="1262485504" open_cursors="300" oracle="" processes="150" remote_login_passwordfile="EXCLUSIVE" sql="" undo_tablespace="UNDOTBS1"> startup nomount pfile='/home/oracle/initYESBTEST.ora'; ORACLE instance started. Total System Global Area 1269366784 bytes Fixed Size 2227984 bytes Variable Size 838861040 bytes Database Buffers 419430400 bytes Redo Buffers 8847360 bytes SQL> SQL> create spfile from pfile='/home/oracle/initYESBTEST.ora'; File created. SQL> shut immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> SQL> startup; ORACLE instance started. Total System Global Area 1269366784 bytes Fixed Size 2227984 bytes Variable Size 838861040 bytes Database Buffers 419430400 bytes Redo Buffers 8847360 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database open resetlogs; Database altered. SQL> select name, open_mode, db_unique_name, dbid from v$database; NAME OPEN_MODE DB_UNIQUE_NAME DBID --------- -------------------- ------------------------------ ---------- YESBTEST READ WRITE YESBTEST 2222709898 SQL> SELECT NAME FROM V$TEMPFILE; NAME ------------------------------------------------------------------------- /u01/app/oracle/oradata/YESBTEST/temp.291.924538685 SQL> Step 14: Add TNS entry YESBTEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YESBTEST) ) ) [oracle@YesBrac2 admin]$ tnsping YESBTEST TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 06-OCT-2016 18:21:42 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YESBTEST))) OK (60 msec) [oracle@YesBrac2 admin]$ Step 15: Verify [oracle@YesBrac2 ~]$ ps -ef | grep tns root 9 2 0 13:36 ? 00:00:00 [netns] oracle 3421 1 0 13:38 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit oracle 5018 3554 0 18:22 pts/2 00:00:00 grep tns [oracle@YesBrac2 ~]$ lsnrctl status LISTENER | grep -i YESBTEST Service "YESBTEST" has 1 instance(s). Instance "YESBTEST", status READY, has 1 handler(s) for this service... Service "YESBTESTXDB" has 1 instance(s). Instance "YESBTEST", status READY, has 1 handler(s) for this service... [oracle@YesBrac2 ~]$ [oracle@YesBrac2 ~]$ sqlplus scott/tiger@YESBTEST SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 6 18:22:52 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application YESBTESTing options SQL> Please create password file in $ORACLE_HOME/dbs/ for this database.