Assumption:
You have setup the data guard and broker successfully and the apply is working properly.
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 / Configure Data Guard and Broker on Oracle 12c RAC ASM Multi Node Database
Assumptions
Primary
Scan : CLUSCANPROD01 DB Name : ADMPROD
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.
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
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
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
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.
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
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.
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.
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
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
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
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.
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.
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.
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.
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 26,665
Problem Description:
GoldenGate GGSCI Register or Unregister Extract failed with following error.
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
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.
Perl script (rootcrs.pl) execution failed: Can't locate Env.pm in @INC (@INC contains:
Error Description:
Perl script execution failed with following errors.
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
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)
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.
- Invoke a Screen
session
Login to
your a/c
