Steps to Enable fast_start failover (automatic) in Data Guard(DG) Broker

Assumption:
You have setup the data guard and broker successfully and the apply is working properly

Steps

Steps to Setup Data Guard Broker (DG BROKER) in Oracle 12c RAC Database with ASM

You have setup the data guard in your primary & standby database and apply is working properly. Steps to Setup Data Guard
Primary Configuration
1.      Create the directory structure in Primary ASM as follows. Login as grid/oracle whichever is the owner of the ASM

Steps to Setup / Configure Data Guard and Broker on Oracle 12c RAC ASM Multi Node Database

Assumptions
Primary
Scan              : CLUSCANPROD01
DB Name           : ADMPROD
DB Unique Name    : ADMPROD
Instances         : ADMPROD1 & ADMPROD2
PORT              : 1521
Version & Storage : Oracle 12c with ASM

ORA-16693: requirements not met for enabling fast-start failover

Error Description
Even after setting up all parameters, the data guard enable fast_start failover gives following error.
DGMGRL> enable fast_start failover
Error: ORA-16693: requirements not met for enabling fast-start failover

RMAN Restore Failed RMAN-06100: no channel to restore a backup or copy of datafile n

Problem Description
Rman restore command failed with following error.
RMAN-06100: no channel to restore a backup or copy of datafile

RMAN> run {
set newname for database to new;
restore database;
}

Fix OEM emctl Error: Backend WLS or EM application seems to be down

Problem Description
Unable to launch the OEM as it gives error Backend WLS or EM application seems to be down 
Solution Description
Looks like somewhere it is stuck even though it’s process running on the server. We have to stop all related process and refresh properly. Here is the steps.

Fix ORA-15045 ORA-15120 ORA-27090: Unable to reserve kernel resources for as

Error Description
Alter system command fails with ORA-27090: Unable to reserve kernel resources for as

SQL> alter system set db_securefile=PERMITTED scope=both sid='*';
alter system set db_securefile=PERMITTED scope=both sid='*'
*
ERROR at line 1:

How to Install Wireshark in RedHat Linux

These are the basic 3 steps to install wireshark software in RedHat Linux. One of the basic use of wireshark software is we can monitor the port packet transfer to verify the encryption etc.
Note: you will have to enable the xwindows (xming) in your server to pop up the wireshark software.

Fix (wireshark:29484): Pango-WARNING **: failed to choose a font, expect ugly output. engine-type='PangoRenderFc', script='latin'

Error Description:
Wireshark software fails with following error.
# wireshark

(wireshark:29484): Pango-WARNING **: failed to choose a font, expect ugly output. engine-type='PangoRenderFc', script='latin'

Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Error Description
Dgmgrl Create configuration command failed with following error

DGMGRL> CREATE CONFIGURATION 'DG_Conf' AS PRIMARY DATABASE IS 'CMLPROD' CONNECT IDENTIFIER IS 'CMLPROD';

Golden Gate ggsci start manager: ERROR: Parameter file mgr.prm does not exist.

Error Description
Oracle GoldenGate ggsci start manager command fails with following error.
[oracle@Node1 gogarep]$ ./ggsci

GGSCI (Node1) 1> start manager

Unable to Bring Up RAC Clusterware: ORA-15081: failed to submit an I/O operation to a disk, ORA-27072: File I/O error

Error Description
ASM instance is down with following error on one oracle RAC node.

Thu Sep 22 00:43:44 2016
Errors in file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_18791.trc:
ORA-15081: failed to submit an I/O operation to a disk
ORA-27072: File I/O error

IE on Windows 10 Error: SSL Network Extender Service is down and could not be started. Consider rebooting the computer. (#323)

Error Description:
Unable to connect Check Point using internet explorer on windows 10. It gives error SSL Network Extender Service is down and could not be started. Consider rebooting the computer. (#323) 

Fix ORA-01504: database name 'RESTRICT' does not match parameter db_name 'DBNAME'

Error Description
startup mount restrict; command failed with following error message

SQL> startup mount restrict;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

12c RAC Data Guard DGMGRL: show configuration failed with Error: ORA-01017: invalid username/password

Error Description
In 12c RAC database Data guard broker show configuration command failed with Error: ORA-01017: invalid username/password
Solution Description

Oracle Installation OUI Warning “Package: nfs-utils-1.2.3-15”

Error Description:
Oracle Universal Installer gives following warning message while installing the Oracle grid clusterware.
Packages: Package: nfs-utils-1.2.3-15

OEM 12c Cloud Control - Add Host, Target, Cluster, ASM Instance, Database Manually

As a pre requisites add these entries in respective server.

1.      Add below entry to the /etc/sudoers file in the server where the agent to be installed or pushed.  

Fix Oracle UI Returns Error: PRVF-0002 : Could not retrieve local node name

Error Description
Oracle Universal Installer (runInstaller Command) fails with following error message.
PRVF-0002 : Could not retrieve local node name

DGMGRL Edit Configuration and Switch Over fails with Error: ORA-16627

Error Description
DGMGRL edit configuration to Max Availability and switch over command fails with following error message.
DGMGRL> edit configuration set protection mode as Maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

CRS-4638 CRS-4535 CRS-4530 CRS-4534 CRS-2674: Start of 'ora.cssd' on 'Node2' failed

Error Description
Cluster is up and running in one node but when I try to start the cluster in second node gives following error messages.
crsctl check crs command failed with following error messages.

GoldenGate ggsci command failed with error while loading shared libraries: libnnz12.so, libons.so, libclntsh.so.12.1, libclntshcore.so.12.1

Error Description
GoldenGate ggsci command invoke failed with following error message.
[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory
[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libons.so: cannot open shared object file: No such file or directory

GoldenGate Start Extract Command Failed with OGG-00868 ORA-01291: missing logfile

Error Description:
GoldenGate start extract command getting abend and ggserr.log log shows the following error message.
2016-09-22 12:07:42  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, ext_pinf.prm:  Error code 1291, error message: ORA-01291: missing logfile
 (Missing Log File <unknown>. Read Position SCN: 0.34113731 (34113731)).

GoldenGate Start Extract Pump Failing / Abending with OGG-01224 TCP/IP error 111 (Connection refused)

Problem Description
GoldenGate start extract pump command getting abend and ggserr.log log shows the following error message.
2016-09-22 12:31:39  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pmp_dest.prm:  TCP/IP error 111 (Connection refused), endpoint: Node 1:7810.

GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 28,365

Problem Description
GoldenGate GGSCI Register or Unregister Extract failed with following error.
2016-09-21 09:40:57  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_STS because of the following SQL error: OCI Error 28,365.

GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 24,034

Problem Description 
GoldenGate GGSCI Register or Unregister Extract failed with following error.
GGSCI (Node1 as PPS_OWNER@KPMUAT1) 27>register extract EXT_CPIF database

2016-09-21 14:21:51  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_CPIF because of the following SQL error: OCI Error 24,034.

GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 26,665

Problem Description:
GoldenGate GGSCI Register or Unregister Extract failed with following error.
GGSCI (Node 1 as PCS_OWNER@KPMUAT1) 10> register extract EXT_STS database

2016-09-21 14:02:11  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_STS because of the following SQL error: OCI Error 26,665.

How Stop / Start Multiple Database Instances Under One Oracle Home in Single srvctl Command?

There are different situations (e.g: patching) to shutdown or startup multiple databases instance under one ORACLE HOME under one RAC node.  

Syntax:

Perl script (rootcrs.pl) execution failed: Can't locate Env.pm in @INC (@INC contains:

Error Description:
Perl script execution failed with following errors.
[root@Node1 install]# ./rootcrs.pl -unlock
Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl

Fix IMPDP ORA-39006 ORA-39213

Problem Description
Impdp failed with following error message
[oracle]$ impdp  DIRECTORY=dmp_dir DUMPFILE=exp.dmp LOGFILE=imp.log REMAP_SCHEMA=source:target

Import: Release 12.1.0.2.0 - Production on Fri Sep 2 04:39:17 2016

Oracle SQL Query to Find Only the Directory Names of the Datafiles

SQL Query:

select substr(file_name,1,instr(file_name,'/',-1,1 )) from dba_data_files;

Example:
Datafile Names:
SQL> select file_name from dba_data_files;

Fix Opatch: Missing command :fuser Prerequisite check "CheckSystemCommandAvailable" failed.

Error Description:
Opatch failed with following error message
Missing command :fuser
Prerequisite check "CheckSystemCommandAvailable" failed.

Oracle 12c: How to Create ASM Cluster file System (ACFS) Using ASM Configuration Assistant (ASMCA)

Login to grid user and set ASM instance parameters.  
[grid@Rac1 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM1
The Oracle base has been set to /u01/app/grid
[grid@Rac1 ~]$ env|grep ORACLE

Fix: /usr/bin/ld: warning: libstdc++.so.5, needed by libsc_ca.so, not found

Opatch apply gives warning as following.
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:

Fix ORA-12712: new character set must be a superset of old character set

Problem Description:
Database character set change is erroring out with following error message.
ALTER DATABASE CHARACTER SET AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set

Where You Can Find the Oracle 11g 12c DBCA Installation / Trace Logs

Sometimes it is confusing to find out the oracle DBCA installation logs or trace files from the file system as it won’t display path during the installation.
By default, oracle DBCA installation, trace log files go to

DBMS_MACADM Package to Disable / Enable Database Vault in Oracle 12c

SQL Query to Check Database Vault is enable or not.
SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER            VALUE                    CON_ID

---------------------- ------------------------ ----------
Oracle Database Vault  TRUE                     0

Disabling Steps:

Fix: ORA-15081: failed to submit an I/O operation to a disk; Unmounting ASMlib driver filesystem: failed

Error Description
Oracle clusterware configuration failed with ORA-15081 and PROC-26: Error while accessing the physical storage. Also oracleasm exit command failed with “Unable to unmount ASMlib driver filesystem”

ORA-01105 ORA-19808: Database Instance Startup Failed with ORA-01105: mount is incompatible with mounts by other instances

Error Description
For RAC database one instance is running and when I try to start the second instance I am getting following errors
[oracle@node1 script]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 20 12:07:53 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

[INS-40719] IP address configured for Single Client Access Name (SCAN): is already assigned to another system

Error Description:
Oracle grid/clusterware installation / reinstallation throws following error with SCAN configuration.
[INS-40719] IP address configured for Single Client Access Name (SCAN): is already assigned to another system

Install Oracle GoldenGate 12.2.0.1.1 on Linux – Step by Step Instructions

Download the software from any of these links.

Download Steps
Step 1. Login to edelivery.oracle.com with your credentials.

How to Remove / Deinstall Oracle Grid Infrastructure / Clusterware Software from RAC Nodes on Linux

Steps
1.  Login as grid (clusterware owner)
2.  Go to software directory where the runInstaller located

3.  ./runInstaller -deinstall –home <GRID_HOME>
Example
[grid@node110 grid]$ ./runInstaller -deinstall -home /u01/app/12.1.0/grid
Checking for required space in /tmp directory ...
Space check on /tmp directory passed
Bootstrapping the deinstall components

How to Remove / Deinstall Oracle Database Software from RAC Nodes on Linux?

Steps
      1.  Login as oracle
2    2. Go to software directory where the runInstaller located
      3. ./runInstaller -deinstall –home <ORACLE_HOME>

Example
[oracle@node110 database]$ ./runInstaller -deinstall -home

wget Command: Download Oracle Software from www.Oracle.com

Step 1: Connect to the oracle.com download page using your OTN credentials and accept the license agreement.
Step 2: Click on the software which you wanted to download. Example Linux x86-64 File1. This will start downloading the software to the local PC/laptop.

How to Install and Check Required rpms for Oracle 12c on Linux 7

Required packages list you can get it Here
Install Command:
yum install binutils \
compat-libcap1 \
gcc \
gcc-c++ \
glibc \

ARCHIVE_LAG_TARGET: Why So Many Archive Log Getting Generated Even Without Any Transaction in Oracle Database

One day I noticed one of my databases is generating lot of archive logs though it is an idle database. There is no transaction happening in this database for a long time. I came to know when I tried to clone the database to a different server. The recovery is taking so much of time with these archive logs. One thing I noticed is this archive logs are small in size. 

How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet

If Oracle wallet is enabled in your oracle database and if you forget to enable the wallet after opening the database you will get following error.
ORA-28365: wallet is not open
In case if you try to access RMAN backup you will get following error message
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open
There is one data dictionary view v$encryption_wallet for the same to check. 

Oracle: SQL Query to Find out Index Name, Column Name for Table

It is common requirement for a developer or DBA to find out the index name, column name for the table. Sometimes the index would be composite index. So in that case we have to find out that also like how many columns associated with the index and their order. There are 2 data dictionary views for the same. DBA_INDEXES and DBA_IND_COLUMNS. DBA_INDEXES gives just index names associated with the table and DBA_IND_COLUMNS gives the associated columns and their order.

How to Backup and Recovery Using Backup as Oracle RMAN Image Copy

RMAN image copy backup will take more space than the normal RMAN backup as it takes the entire datafile file as backups. But some situations we can use this method to backup and restore the database. Here is the method and RMAN command syntax for the same.
1.   Backup the database

Query to Find Out The Total File Size And Data Occupied Size Of Oracle Database

1. Here is the query to find out the total file size of a Oracle database

select b.name,
( select sum(bytes)/1024/1024/1024 DF_size from dba_data_files ) +
( select nvl(sum(bytes),0)/1024/1024/1024 TF_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024 RLF_size from sys.v_$log ) +

Sql Query to Get Hostname, IP Address and Terminal from Oracle Database

If your user doesn't have DBA privilege then you can use SYS_CONTEXT function to get the hostname and IP address.

Option a. sys_context
SQL> SELECT SYS_CONTEXT
('USERENV', 'SERVER_HOST') from dual;

SYS_CONTEXT('USERENV','SERVER_HOST')
---------------------------------------
proddb001

Stop / Disable automatic ads web page opening in Chrome / IE browsers (giraffetraffic.com , go.oclasrv.com)

In last few days I have been facing a problem in my browsers like automatically some WebPages are opening without asking anything. It is quite disturbing during the serious browsing and it is slow down my system performance also. The websites are like http://giraffetraffic.com/, go.oclasrv.com etc. sometime it opens the corner popup in the web pages.

How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?

Above two links will help you to configure and check the usage of the Flash Recovery Area (FRA) in Oracle. Now here is the method to resize the FRA in oracle database.
You can use below mentioned commands to see the already allocated space for the FRA.

Oracle SQL Script to Get Daily Thread Wise Archive Log Generation Report

SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF

SELECT TRUNC(completion_time)  "Generation Date" , thread#,count(*)
FROM gv$archived_log
GROUP BY TRUNC(completion_time),thread#
ORDER BY TRUNC(completion_time)


Kerala PSC Thulasi: New Declaration is required. You are not eligible to apply for this post

Nowadays when we apply for a Kerala PSC post using Thulasi website, we are getting a message saying “You are not eligible to apply for the Post”. Reason for the rejection is “New declaration is required.”

How to Get SQLPLUS Query Output to a Shell Script Variable

Most of the time during the shell scripting we get requirement to get the database table query result values to a shell script variables. Here is one example to get a single column values to a variable. If you have multiple column outputs then we will have to concatenate into a single column and pass it to the shell script variable. You can use awk or scripting commands to make it separate.

Linux Screen Command: re Attach an Already Attached Session

Here are some useful tips to use screen command in Linux user logins. Linux screen command is very useful command to keep the session logged in without any failure even if any kind of network failure etc.
  1. Invoke a Screen session
Login to your a/c
 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google