How To Find Out The List Of Patches Applied Without Using Inventory

Jul 23, 2012

I have been asked this question once.

How will you find out the list of patches applied to Oracle Database Home without using commands like opatch lsinventory -detal etc...

I think registry$history is a view from where we can find out the list of patches applied.

But I think it will not include all the bug fixes,stand alone or one-off patches.It will mainly list out the CPU patches applied(correct me if I am wrong).

View 10 Replies


ADVERTISEMENT

Enterprise Manager :: Software Inventory Utility To Find Database Installs

Jun 18, 2010

Does EM have a utility that I can get to scan a set of host machines and their disks and tell me what oracle products are installed? Sort of like that common inventory tool used on windows desktops, but just for Oracle products.

If not EM then any third party tool or some other Oracle tool?

View 2 Replies View Related

Find List Of Tables Inserted / Updated In Last 6 Month

Oct 7, 2012

I tried to find out recently updated table list. I couldn't find anything.

CODE>> JUST SAMPLE  TRANSACTIONS >>

SQL> conn sam
Enter password:
Connected.

SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$y1TXhcjGApvgQAB/AQBOpA==$0 TABLE
TAB1                           TABLE
[code]........

View 1 Replies View Related

Security :: Find A List Of Roles And Privileges In Database?

Feb 24, 2011

How can I list all the roles and privileges of roles in Oracle? Can I get the details of the activities they perform?

View 12 Replies View Related

SQL & PL/SQL :: Query To Find List Of Tables Contains Particular Data In Schema?

Feb 3, 2012

I want to list the tables in a schema which contains a particular value or data.

View 2 Replies View Related

Networking And Gateways :: Find List Of Database Links?

Jul 2, 2011

There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.

View 2 Replies View Related

PL/SQL :: Find A Check List To Use Against PROD / DEV / TEST Environments?

Jan 21, 2013

outlining 'key' differences between databases / configuration / hardware that can potentially make a difference to what results you get when running sql / pl/sql - I am trying to find a check list to use against PROD / DEV / TEST environments.

View 2 Replies View Related

Server Administration :: How To Find Out List Of DB_LINKS That Uses User Account In Database

Jun 6, 2011

How to find out list of DB_LINKS that uses user account in database ?

View 9 Replies View Related

Server Administration :: How To Find And Close Open Cursor List Without Restarting

May 28, 2013

In my environment found maximum open cursor exceeds error. So how can I found the open cursor list and how can I close that cursor without restarting. Any SQL commands to close the open cursor.

View 4 Replies View Related

Download Latest Critical Patches?

May 3, 2011

I want download latest critical patches of 11.1.0.7.0, 11.1.0.6.0. how can i download

View 1 Replies View Related

Windows :: Which User Is MANDATORY To Use When Installing Oracle Patches

Nov 22, 2010

We have almost 400 production two-node RAC clusters in the environment I manage - all these sites have databases where the database name is exactly the same, so using Grid Control right now isn't in the cards (and yes - I am working on assigning them all a unique name ). We want to use IBM's BIGFIX to deploy patch 32 on top of 10.2.0.3 for Windows Itanium. BigFix runs as a user different from that used to install the Oracle software originally. There is nothing in the patch notes to suggest that you must use a certain Windows user to install the patch - so the question is, does it matter what Windows User I use as long as they are an 'Administrator' equivalent?

how do you perform mass updates/patches in your Windows server environments? I am looking for examples outside of Grid Control - which I know would work if only my predecessor didn't name these databases the same .

View 6 Replies View Related

While Applying Patches In Oracle Home Space Not Sufficient

Mar 18, 2011

Im applying patch which is an upgrade to 10.2.0.5 from 10.2.0.3. Its a 2 node RAC. While applying patches the installer mentioned space are sufficient, but while applying patches it throws message that in oracle home space not sufficient. Im able to apply patches in cluster home successfully. How much space required in oracle home for this patch? There is no information mentioned the document as well.

View 2 Replies View Related

Real Application Clusters :: 10.2.0.5 - Windows Bundle Patches?

May 29, 2013

My client asked me to "apply the newest patch" on his RAC 10.2.0.5 environment on Windows.

I've downloaded 10.2.0.5 Patch 20 (the newest version).

My question is: Should i apply it using OPatch to both: ORACLE_HOME and CRS_HOME? or only in ORACLE_HOME? What with 10.2.0.5.2 CRS Patch? Should i apply earlier CPU patches?

View 1 Replies View Related

Reports & Discoverer :: ORA-0999 - Unimplemented Error Patches Enquiry

Aug 25, 2010

Recently, my client side report runtime experience the following bug:

--> ORA-0999:UnImplemented Error

When user attempts to convert the generated report into PDF format.

I had found out from the net that by applying the following:
Patch 18 for Windows Client/Server Forms 6i.

The Ora-0999 bug will be resolved. True enough the bug has been resolved.

However, I had chanced a post recently and this raised my concern on whether I had done the patching correctly.

From the post it stated that,

Quote:Forms 6i ( stand alone ) is currently desupported/extended support. So patch 17 is the last one.

2. Forms 6i is still supported for Ebusiness Suite. Hence patche 18 is the latest patch for form 6i with fixes specific to ebusiness suite. There might be an another patch for forms6i later but specific to ebusiness suite. This is because Forms 6i is supported for EB.

If you are not using Forms along with EB then I dont think the new patches are useful. So remaining at patch 17 is recommended.

Link: [URL]

FYI, I had only selected the custom installation with only the Report Runtime to be patch over the previous version.

View 4 Replies View Related

Forms :: Dynamic LOV For Sub-Inventory Field?

Jul 20, 2010

I have one requirement.I am populating LOV dynamically for the subinventory field in the order form through custom.pll.

If Dropship flag= 'Y' then populate suninv LOV with D1,d2..values.If it is 'N' then populate suninv LOV with w01,w02,....values.This is done and working fine in the form.But If i save dropship flag='Y' and Subinv value is D1 then it saves the record.Now I am changing Drop ship flag as 'N' then 'D1' value appearing in the SUBINV field.and it allow the save changes.

So How can i refresh Lov at the time of making drop ship flag as 'Y'/'N'?

View 6 Replies View Related

Global And Local Inventory - Patchset?

Apr 21, 2013

1)What is the use of inventory?

2) Global inventory is found by checking the oraInst.loc file. How to find the location of Local inventory?

3)Why is every patchset(11.2.0.2) now a full release?

View 4 Replies View Related

Oracle Inventory / Sql Table Not Pulling Any Data

Aug 14, 2013

There are two oracle inventory tables, I found that used to pull up data before but not anymore . It is

�INVFV_INV_BY_PERIOD_AND_ITEM�

and �MTL_BIS_INV_BY_PERIOD� .

I need to use all the columns/data that are in these two tables. I am not finding any equivalent table. where can I retrieve these information from?

Select * from INVFV_INV_BY_PERIOD_AND_ITEM;
Select * from MTL_BIS_INV_BY_PERIOD;

View 3 Replies View Related

Forms :: Inventory Sale Program In Oracle

Apr 15, 2010

I have made the inventory sale program in oracle. Its working from 7 years. Now its speed is very slow.It take much time to execute query.

View 17 Replies View Related

SQL & PL/SQL :: Count A List Of Number Value And Find Maximum Number?

May 21, 2010

how do I count a list of number value eg 1,1,1,1,3,3,6,4 and find the one with maximum number which is 1

View 5 Replies View Related

Reports & Discoverer :: Create One Inventory Label Report With Barcode?

Sep 18, 2013

I am trying create one Inventory label report with bar code ,This reports working fine stand alone,Once i am added this report on Oracle Apps concurrent Program ,Output came without bar code.

View 6 Replies View Related

Write A Query Based On Inventory On Hand Packed Quantity

Jul 18, 2013

which table do I have to use to get the Inventory On Hand Packed Quantity  based on Oracle EBS Suite using backend? 

View 2 Replies View Related

How To Create Central Inventory For Oracle 11g Running On Windows Server

Dec 26, 2012

--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.

We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.

View 3 Replies View Related

Forms :: Auto Populating Records In Other Fields Based On Inventory Number Field

Jul 13, 2011

I am having a problem with auto populating different fields based on inventory no. field.. This is a bug giving to me to work on and i not able to figure out how to populate the other fields.

How to set any triggers for the items to auto populate and i am suppose to finish this work today.

View 2 Replies View Related

Installation :: 11gr2 Silent Install Error - Unable To Create A New Central Inventory Directory

Apr 2, 2013

I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:

[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.

The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.

I am running this command to install oracle:

/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs

[code]....

View 5 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

How Many Conditions Can Will Be Applied In Where Clause

Oct 3, 2013

How many conditions can will be applied in where clause and what is the maximum length for where condition?

View 6 Replies View Related

Cleanup Of Applied Archived Logs?

Jan 8, 2013

Is there a way to automate deletion of applied archived logs after rollforward?

I'm thinking of crontab, and a script referring to the alert log to get the archived log filename.

Setup:

OS: HP-UX B.11.31 you ia64
DB: Oracle 10g 10.2.0.4.0 (mounted)

View 2 Replies View Related

Patch 13923804 Warnings When Applied

Jul 26, 2012

I applied this patch in our development environment. After validation, I need to apply the same in production, training and publication environments. The detailed information follows :

PowerPC_POWER5 / aix 5300-12
OPatch utility used : 11.2.0.3.0
OUI version : 11.2.0.2.0
Prereq "checkConflictAgainstOHWithDetail" passed.
Composite patch 13923804 successfully applied.
OPatch Session completed with warnings.

Stderr output:

ld: 0711-224 WARNING: Duplicate symbol: p_xargc
ld: 0711-224 WARNING: Duplicate symbol: p_xargv
ld: 0711-224 WARNING: Duplicate symbol: .kghalf
ld: 0711-224 WARNING: Duplicate symbol: .kghalp
ld: 0711-224 WARNING: Duplicate symbol: .bcopy
ld: 0711-224 WARNING: Duplicate symbol: .kghgrw
ld: 0711-224 WARNING: Duplicate symbol: .kghfrf

[code]....

OPatch completed with warnings.

As they are harmless ? Whether I need to rollback ?

View 2 Replies View Related

How To See That Opatch Is Applied Or Not On Database (OFFLINE)

Feb 23, 2013

DB : 11.2.0.2 64bit
OS : RHEL 5.7 64bit

I have applied offline patch *10417948* on my database. How can see that patch applied on database/OH or not? I have applied one online patch few months ago....in that i have applied that patch on each database after installing it...using command :

opatch util enableonlinepatch -connectString SID:sys:manager: -id <opacth-id>

when i execute a command opatch lsinventory -details i got the following output :

+Interim patches (2) :

Patch  10417948  : applied on Sat Feb 23 13:42:49 IST 2013
Unique Patch ID: 14586154
Created on 18 Oct 2012, 06:52:32 hrs PST8PDT
Bugs fixed:
10417948
[code].......

For offline patch is it required to enable patch on every database?

View 2 Replies View Related

Can Logical Database Be Applied From Physical Standby

Jul 24, 2013

I have a setup where i have one physical and logical standby from a primary database. In case of switch over between primary and physical database my logical apply gets stopped. Can a logical database be applied from a physical standby ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved