If your database upgrade by database upgrade
assistant is caught by a glitch, a dialogue box may appear with options of
“Ignore”, or “Abort”. There could be a situation whereby you can ignore the
error and continue with the upgrade process. But, before you could do this, you
would need to resolve the problem that encountered, before clicking the Ignore
button to continue.
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.
Friday, July 27, 2018
Sunday, July 15, 2018
Installing Oracle 12c R2 Database Software on Linux 6 and Linux 7
In this article I would explain how to install Oracle 12c R2
database software on Linux 6 and Linux 7. If you want to use ASM as storage and/or Oracle Restart
feature, you would need to install 12c
R2 Grid Infrastructure before
proceeding to install RDBMS software. You must be using at least Linux 6.4 for
installation on Linux 6.
Friday, July 6, 2018
ORA-16191: Primary log shipping client not logged on standby
Password file difference is one of the
biggest causes of log shipping failure from primary database to the standby.
Follow this
document to resolve ORA-1619. Following is what would appear in the
alert log file if log shipping fails because of password file differences
between primary site and standby site.
Thursday, July 5, 2018
Fractured block found during backing up datafile
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.
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
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...