Patch Information GI PSUs are cumulative and include the Database PSU and associated CPU program security content. This is Jan 2018 PSU having Patch number 27107360 for 11gR2. OPatch Utility Information You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2 […]
All posts by Anuradha Mudgal
MONITORING ALERT LOG
Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob. Being DBA we all are aware of the importance of Alert Log. For managing the backup […]
First Look of OEM 18c
In this article, we will try to find the new things with Oracle OEM 18c. I already installed Oracle OEM18c. After deploying the agent, we log in with sys user. First thing, we can able to see Forward Listener in Oracle 18c, which can explain in later posts. After that, we can see more parameter […]
Installing Oracle 18c Database on Cloud in 3-clicks
This article shows how to create Oracle 18c database in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Database Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter Cloud18c. – From the Software Release list, […]
Benchmarking in Oracle Database
After a long time, I am going to write a theoretical topic which adds some different knowledge in our DBA career. I hope it will help our viewers to have deep knowledge about the database. Today I am going to explain about benchmarking in the database. Being a part of IT we have little idea about […]
ORA-01450: maximum key length (3215) exceeded
Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem. 06:19:09 [SYS][TEST]>> ALTER index TEST.IDX_NEW rebuild online; ALTER index […]
How to find database growth on a Monthly wise
Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful. select to_char(CREATION_TIME,’RRRR’) year, to_char(CREATION_TIME,’MM’) month, round(sum(bytes)/1024/1024/1024) GB from v$datafile group by to_char(CREATION_TIME,’RRRR’), to_char(CREATION_TIME,’MM’) order by 1, 2; Output […]
Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”
There is a known issue with clonedb.pl script, you might end-up with “Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir” Especially if you are using perl Vv5.10.1. Actual Line: print OUTFILE1 “dbms_dnfs.clonedb_renamefile(‘$lne’,’$clonedbdir/\ora_data_$cldbname$i.dbf’); \n”; lets Verify You will get the Error when this Line of code executed and “\o” is the […]
High Water Mark USAGE
Before start this article we must know about “HWM” . After did lots of R&D i found the technical definition Explanation in Detail: (http://www.dba-oracle.com/t_high_water_mark.html) . The high water mark (HWM) for an Oracle table is a construct that shows the table at its greatest size. Just as a lake has a high-water mark after a draught, an Oracle […]
Database Design – Hardware Requirements
Database Design is the most important part of the IT project. This is the second post regarding Database Design. Normally we just think about software and some basic terms of hardware while we think about the database. Now let’s have deep look at Hardware Requirements. This post explains the technical terms which must keep in mind […]