This error means that RMAN found an
inconsistent block during the backup of a datafile. It is quite likely that on second attempt to read the block, RMAN is able to find a consistent image of the block, hence no further action would be required. But, if you need to perform a block
recovery, this
article will be worth reading. Alert log file will show message similar
to the following when this error is reported.
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Thursday, July 5, 2018
Monday, July 2, 2018
ASM Disk not Accessible and not Appearing in V$ASM_DISK
If you are using ASMLib
for your ASM storage and it is working perfectly fine; then, after adding a new ASM Disk you suddenly realize that although new disk is being
listed by “oracleasm listdisks” command, it is still not appearing in V$ASM_DISK view. As
a result, you are not able to add this new disk in your diskgroup because disk
is not accessible to ASM instance. One reason of this could be that ASMLib
configuration is not as it should be. Reasons could be: OS patching, oracleasm kernel
driver update etc.
Saturday, June 30, 2018
Installing Oracle 12c R2 Grid Infrastructure on Linux 6 and Linux 7
You need to install
12c R2 Grid Infrastructure (for a standalone server) software in order to use
ASM and/or Oracle Restart feature. In the following I will explain how to
install GI for a standalone server on Linux 6
and Linux 7. You
must use at least Linux 6.4 for installation on Linux 6. For this installation,
I am using Oracle Linux 7.
There are only a couple of differences between the installation procedures on Linux 6 and Linux 7 which I will mention along the way.
There are only a couple of differences between the installation procedures on Linux 6 and Linux 7 which I will mention along the way.
Sunday, June 10, 2018
Creating Weblogic Domain for Weblogic Server
After the installationof weblogic server, next step is to create a new weblogic domain. If
you have installed weblogic server with examples, there will be a domain already
configured during the installation and an application deployed. For the creation
of other domain(s), you may follow the steps explained in this article.
Sunday, June 3, 2018
Installing Weblogic Server 12.2 on Linux 6 Linux 7 and Windows
Saturday, May 26, 2018
Starting and Stopping Weblogic Server
After you have created a weblogic domain for Fusion Middleware, or a weblogic domain for Weblogc Server, next step is to start the weblogic components that include node
manager, administration server and managed server.
Starting Node Manager
First we start the node manager. Use following method to start the node manager. For this example, $DOMAIN_HOME is pointing to /home/oracle/config/domainsWednesday, May 23, 2018
Creating Weblogic Domain for Fusion Middleware
After we have installed the Fusion Middleware
and completed its initial configuration, next step is to configure a weblogic
domain. A weblogic domain is a logically related group of weblogic resources.
Once we create a domain, and Administration Server instance is also gets
created that is used to manage this domain. After this, we can add Managed
Servers using this Administration Server by logging into the Administration
Server using an admin user account through a console. Web Applications are then
deployed on to the managed server(s). We can create multiple managed servers to
work as a cluster for load balancing and fault tolerance
Friday, May 11, 2018
Initial Configuration of Fusion Middleware after the Installation
After completing Fusion Middleware installation installation,
next step is initial configuration of the it. If you have done Fusion
Middleware Installation, you would need to configure certain schemas (this is
not needed for Weblogic and Coherence installation using generic installer)
before you can create domains and start using Fusion Middleware. Click here for the official
documentation.
Following are the schemas that need to be created
Following are the schemas that need to be created
Monday, May 7, 2018
ORA-02095: specified initialization parameter cannot be modified
This is a generic error
message that may be returned while setting an initialization parameter. There
are a few other error messages that we may face and in this article, I would
discuss those error messages as well. The most common reason of this error
message is modifying a parameter using ALTER SYSTEM command that is not
dynamically modifiable. In this case, we need to set the parameter in spfile,
or pfile, and then a re-bounce of the instance would set the value of this
parameter in the instance.
Tuesday, May 1, 2018
Installing Oracle Fusion Middleware 12.2 on Linux 6, Linux 7 and Windows
Oracle Fusion
Middleware contains many products, tools, and services, and provides facility
of using Java EE and developer tools, integration services, identity services,
business intelligence and several other Oracle products.
In this article I would demonstrate how to install Oracle Fusion Middleware 12.2 (I am using 12.2.1.2.0 for this article) on Linux 6 and Linux 7. Following is the official document that I used while writing this article.
In this article I would demonstrate how to install Oracle Fusion Middleware 12.2 (I am using 12.2.1.2.0 for this article) on Linux 6 and Linux 7. Following is the official document that I used while writing this article.
Subscribe to:
Posts (Atom)
Popular Posts - All Times
-
This error means that you are trying to perform some operation in the database which requires encryption wallet to be open, but wallet is ...
-
Finding space usage of tablespaces and database is what many DBAs want to find. In this article I will explain how to find out space usage ...
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
You may also want to see this article about the ORA-12899 which is returned if a value larger than column’s width is inserted in the col...
-
This document explains how to start and stop an Oracle cluster. To start and stop Grid Infrastructure services for a standalone installatio...
-
If database server CPU usage is showing 100%, or high 90%, DBA needs to find out which session is hogging the CPU(s) and take appropriate ...
-
If you want to know how we upgrade an 11g database to 12c using DBUA, click here . For upgrading 12.1.0.1 to 12.1.0.2 using DBUA, ...
-
By default AWR snapshot interval is set to 60 minutes and retention of snapshots is set to 8 days. For better and precise investigation of...
-
SWAP space recommendation from Oracle corp. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the s...
-
This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on O...