Online DBA

<<Back to Oracle RAC Main Page  Finding  the listeners log File simplest way to find the log file for a listener (whether its scan listener , management listener or database listener) is to use  show log_file command from lsnrctl interface as shown below $lsnrctl LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 29-AUG-2019 08:57:50 Copyright (c) 1991, 2014, Oracle.  All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> set current_listener LISTENER_SCAN1 Current Listener is LISTENER_SCAN1 LSNRCTL>  show log_file Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) LISTENER_SCAN1 parameter "log_file" set to /log/diag/tnslsnr/node1/listener_scan1/alert/log.xml The command completed successfully LSNRCTL> set current_listener LISTENER Current Listener is LISTENER LSNRCTL> show log_file Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) LISTENER parameter "log_file...

<<Back to Oracle Backup & Recovery Main Page RMAN Crosscheck Failing with ORA-20079 and ORA-17629 [ORCL1TP] rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Wed Aug 28 11:18:51 2019 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved. connected to target database: ORCL1TP (DBID=1327454762) RMAN> connect catalog rman@rcat.oracle.com recovery catalog database Password: connected to recovery catalog database RMAN> crosscheck archivelog all; ORA-20079: full resync from primary database is not done doing automatic resync from primary resyncing from database with DB_UNIQUE_NAME ORCL1TPS RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of crosscheck command at 08/28/2019 11:20:05 RMAN-03014: implicit resync of recovery catalog failed RMAN-0300...

<<Back to Oracle DataGuard Main Page  Finding Observer Server Details DGMGRL> show configuration verbose; Configuration - DG_ORCLDB   Protection Mode: MaxAvailability   Members:   ORCLDBP - Primary database     ORCLDBs - (*) Physical standby database   (*) Fast-Start Failover target   Properties:     FastStartFailoverThreshold      = '300'     OperationTimeout                = '30'     TraceLevel                      = 'USER'     FastStartFailoverLagLimit       = '30'     CommunicationTimeout            = '180'     ObserverReconnect  ...

<<Back to Oracle RAC Main Page Step by Step Instruction to Patch Oracle RAC Cluster Version 11.2.0.4 Step0: download and read the readme.txt for the patch. The installation instruction and rollback instruction is provided in readme file. Here is the extract and simplified version of Oracle  RAC patching procedure Step1: Ensure the Latest OPatch utility is Available Check Current OPatch Utility Version Verify if the required  OPatch utility as mentioned in readme.txt is available. $export ORACLE_HOME=/ora_app/product/11.2.0.4/dbhome_1 $export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch $opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded. Upgrade  OPatch Utility to The Latest Version Download the latest OPatch utility version as mentioned in readme.txt. Ensure to upgrade the OPatch utility in all OH homes and GI home on all nodes Latest OPatch utility for your version is available for Download from My Oracle Support patch ...

<<Back to Linux Main Page How to grep multiple values from the output of a command on Linux I wanted to grep the list of patches I applied today. I have 3 patch numbers and I wanted to check if they are now present. To grep multiple values from the output of a command you can use below command $ opatch lsinventory -oh /ora_grid/product/11.2.0.4/grid |grep -e '29141201' -e '29497421' -e '29509309' Patch  29509309     : applied on Fri Aug 23 10:12:00 CEST 2019 Patch description:  "ACFS Patch Set Update : 11.2.0.4.190716 (29509309)" Patch  29497421     : applied on Fri Aug 23 10:10:59 CEST 2019 Patch description:  "Database Patch Set Update : 11.2.0.4.190716 (29497421)" Patch  29141201     : applied on Fri Aug 23 10:10:33 CEST 2019 Patch description:  "OCW Patch Set Update : 11.2.0.4.190416 (29141201)"

<<Back to DB Administration Main Page #opatch auto -h Executing /ora_grid/product/11.2.0.4/grid/perl/bin/perl /ora_grid/product/11.2.0.4/grid/OPatch/crs/patch11203.pl -h -paramfile /ora_grid/product/11.2.0.4/grid/crs/install/crsconfig_params /ora_grid/product/11.2.0.4/grid/OPatch/crs/../../srvm/admin/getcrshome: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory Can't locate crspatch.pm in @INC (@INC contains: /ora_grid/product/11.2.0.4/grid/OPatch/crs /crs/install /ora_grid/product/11.2.0.4/grid/OPatch/crs /ora_grid/product/11.2.0.4/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /ora_grid/product/11.2.0.4/grid/perl/lib/5.10.0 /ora_grid/product/11.2.0.4/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /ora_grid/product/11.2.0.4/grid/perl/lib/site_perl/5.10.0 /ora_grid/product/11.2.0.4/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /ora_grid/product/11.2.0.4/grid/perl/lib/5.10.0/x86_64-linux-thread-mult...

<<Back to DB Administration Main Page There are situations when the need arise to change the database name. The requirement could be one of the following Change the DBID and Database Name (DB_NAME) both Change  Only the Database ID Change Only the Database Name The goal of this post is demonstrate you how to change only the database name without affecting the DBID of the database. Changing Only the Database Name of Oracle Database Background Info: I want to change the TEST1D database to ORCL1D Old Database Name: TEST1D Changed Database Name: ORCL1D Old Database Name: TEST1D Changed Database Name: ORCL1D Step0: Ensure the application is down and no user is connected to database SQL> select distinct username, count(1) from v$session where username not in ('SYS','SYSTEM','DBSNMP') group by username no rows selected Step1: Prepare for full database backup SQL> alter system checkpoint; SQL> alter system...