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.
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.
Monday, April 23, 2018
ORA-01013: user requested cancel of current operation
If ORA-01013 appears in the alert log file, it would mean that your
application is closing a session forcefully and database records this as action
canceled by the user/application (as name description of this error suggests). It
would mean that most of the time it is not something that can be handled from
the database side to stop this message from appearing in the alert log file. But,
sometimes this error may be because Oracle internally kills some process that
crosses a timeline already defined. In the following I would provide further
detail of this.
Tuesday, April 17, 2018
Error 12154 received logging on to the standby
There are several error
messages related to dataguard environment and many of them have been discussed
in my blog, and you can find links to those articles at the bottom of this
article. In this article, I will explain Error 12154 that I received in one of
my dataguard environments. This error message may appear in the alert log file
of your primary database and it would seem similar to the following.
Error 12154 received logging on to the standby
FAL[client, USER]: Error 12154 connecting to <FAL_SERVER>
for fetching gap sequence
|
Friday, April 13, 2018
Error 1033 received logging on to the standby
Troubleshooting a
dataguard environment is not very straightforward sometimes. If you come to
know that physical standby database is out of sync with the primary database,
first thing is to check the alert log files of primary and standby database to
find out any error messages that might be appearing in the alert log files. For
example, if error 1003 is reported in the alert log file, you may see entries
similar to the following in the primary database’s alert log file.
Mon Feb 06 00:10:40 2017
Error 1033 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby
'MY_STANDBY_DB'. Error is 1033.
|
Monday, April 2, 2018
Starting and Stopping Grid Infrastructure on a Standalone GI Installation
This document
explains how to start and stop an Oracle cluster. To start and stop Grid
Infrastructure services for a standalone installation, there are slightly
different commands. Using same commands as RAC to start and stop the GI
resources would return errors as follows
[root@~]$ /u01/app/11203/grid/bin/crsctl stop crs
CRS-4013: This command is not supported in a
single-node configuration.
CRS-4000: Command Stop failed, or completed with
errors.
[root@ ~]$ /u01/app/11203/grid/bin/crsctl stop
cluster -all
CRS-4013: This command is not supported in a
single-node configuration.
CRS-4000: Command Stop failed, or completed with
errors.
|
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...