DataGuard:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Please check service name and db_uniquie_name on the Production server. alter system set log_archive_dest_3='SERVICE=  < NAME >  VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) LGWR ASYNC DB_UNIQUE_NAME= <Name>' ;

Advertisements

Speed of crsctl stop crs vs. crsctl stop cluster

a single step process  $ crsctl start crs Start it in a two-step process.  Here we start the HA service (HAS):  $ crsctl start has then, you start the clusterware stack by with crsctl start cluster:  $ crsctl start cluster -all

Rollback applied patch ?

Sometimes a patch is applied to the system may need to take back because of its effect. In this case, rollback is performed as follows. $ORACLE_HOME/OPatch/opatch rollback -id Patch_id For example : $ORACLE_HOME/OPatch/opatch rollback -id 2435623

How to Find Character Set?

Oracle recommends Unicode AL32UTF8 as the database character set. Character Set Control: SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; PARAMETER                     VALUE ------------------------------ ------------------------------ NLS_CHARACTERSET       AL32UTF8 It should return the value AL32UTF8. Another option is to run the following SQL … Continue reading How to Find Character Set?

Cloning an Oracle Home DB 12C

Perform the following to clone an Oracle home If you install patches, then check their status using the following $ cd $ORACLE_HOME/OPatch $ opatch lsinventory [oracle@ermankara OPatch]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/12.1.2/db Central Inventory : /u01/app/oraInventory    … Continue reading Cloning an Oracle Home DB 12C

Creating Control File in oracle database

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/oracle/dbscripts/control_file.sql'; Database altered. SQL>exit Now open your control_file.sql [oracle@ermankara dbscripts]$ cat control_file.sql STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "DB12CC" NORESETLOGS  NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ( '/data/DB12CC/onlinelog/o1_mf_1_dq1dsxry_.log', '/reco/DB12CC/onlinelog/o1_mf_1_dq1dsxvb_.log' ) SIZE 50M BLOCKSIZE 512, GROUP 2 ( '/data/DB12CC/onlinelog/o1_mf_2_dq1dsy3t_.log', '/reco/DB12CC/onlinelog/o1_mf_2_dq1dsy5p_.log' … Continue reading Creating Control File in oracle database

Database 12c Opatch Failed error code 73 Solution

Problem description: Applying opatch failled: [oracle@ermankara 24732082]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/12.1.2/db Central Inventory : /u01/app/oraInventory from           : /u01/app/oracle/product/12.1.2/db/oraInst.loc OPatch version    : 12.2.0.1.9 OUI version       : 12.1.0.2.0 Log … Continue reading Database 12c Opatch Failed error code 73 Solution