How do i find out the information regarding the latest patch installed for ORACLE_HOME..
OR
If given a patch number, how do i find out whether it's applied to ORACLE_HOME
I would like to retrieve only the latest repair information based on the latest date regardless of the other information, so I would like to query only items 3 and 5 in the following example.
drop table a;
create table a(
seq number,
custom_id number,
repair_id number,
repair_date date);
[code]........
what is
ORACLE_HOME
ORACLE_BASE
difference between ORACLE_HOME and ORACLE_BASE
I saw big size .core file is generated in $ORACLE_HOME/dbs folder even when no dump dest parameter is set to dbs folder. How to check what causing this genrarating of these files.
PROD1 /oravl01/oracle/11.1.0.7/dbs > ls
1 core.11528 core.15973 core.22231 core.26792 core.29496 core.5262 initCCLCLMP.ora
controlfile.binary.PROD1.Fri core.12504 core.15981 core.2262 core.27129 core.29802 core.5847 initdw.ora
controlfile.binary.PROD1.Mon core.12520 core.1617 core.23115 core.27196 core.30793 core.6176 init.ora
controlfile.binary.PROD1.Sat core.1256 core.1626 core.23276 core.27531 core.30877 core.6221 initTESTCRM.ora
controlfile.binary.PROD1.Sun core.12594 core.16364 core.23681 core.27560 core.30885 core.6535 orapwPROD1
[code]....
To one of my server i can see listener log are on normal location i.e. $ORACLE_HOME/network/log and on other server listener log is DIAG home. how to move listener log from ORACLE_HOME to DIAG_HOME.
oracle > lsnrctl status LISTENER
LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 29-JUN-2012 10:20:14
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 11.2.0.2.0 - Production
Start Date 03-MAY-2012 08:09:57
Uptime 57 days 0 hr. 10 min. 16 sec
[code]...
identify the latest Critical Patch Update for 10g RAC. My DB server is 10g RAC 2 node cluster running on IBM Aix Pseries servers. The version is 10.2.0.3.
View 1 Replies View RelatedYesterday i installed oracle 11g r2 by default i installed database Oracle with the installation .but today i tried to create the database with the name green tat also completed successfully..the problem is in startup
export oracle_sid=green
sqlplus '/ as sysdba'
startup
database mounted
select instance_name from v$instance; But it SHowing the instance name as Oracle...i tried with the other method also
export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba
database mounted
select instance_name from V$parameter;
and it shows instance name as green..i tried to see the datafile location for green database
select file_name from dba_data_files; it shows the orcl datafile locations.
I need to figure out which Oracle Database packages are installed on a certain server.
First problem: no Enterprise Manager available. So I need some command line tools or SQL statements.
I've already found some with them I was able to spot RAC, partitioning and so on. But I'm still missing a option/command to spot
- diagnistic pack
- tuning pack
- web logic
- web server
My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem.
View 20 Replies View RelatedI am reffering to one off patch "10402264" .I have to apply tihs patch to my 11.2.0.2.4 database.Is there any chart oracle provide to check if 10402264 is covered in any PSUs? or i have to go to each PSU readme and check "Bugs fixed" ?
i wish i could get somthing like this
11.2.0.2 One-off# PSU4 PSU5 11.2.0.3.0
10402264 NO YES YES
Or any other best practive
We're thinking of moving from 10.2.0.3 to 10.2.0.5 in our production Oracle RAC. The 10.2.0.5 patch is quite new and I was wondering if any of you have upgraded to this patch in any of your environments and if you experienced any issues afterwards?
View 2 Replies View RelatedI installed oracle 11.2.0.2 RAC and want to apply the PSU patch. I would like to know whether its better to apply the April 2011 PSU or July release.
View 1 Replies View RelatedI installed Oracle 10.2.0.1.0 in RH Linux 4.5. After that applied patch for 10.2.0.4.0. Everything went smoothly, but at the last steps I unknowingly clicked next button. I dont know whether some scripts is to be run as I did during installation of 10.1.0.4.0. If it is to be done I didn't do that.
How can I proceed now? If some scripts to be run where is the location? Will it cause any issue if I running it after completing the update?
where i can download the patch documentation. Is it available in the metalink (my oracle support)? if yes then is there any other way i can get hold of it?
View 6 Replies View RelatedI want to upgrade 10.2.0.1 to 10.2.0.5.
Can I straightly apply 10.2.0.5 or need to sequentially apply one by one?
can we apply 11.1.0.7 Patch Set on a 10.2.0.3 database server? i mean are patch sets cumulative or do i have to install the patch specific to my release the issue is i have the below error with rman: RMAN-03009: failure of delete command on ORA_DISK_1 channel at ORA-19633: control file record is out of sync with recovery catalog
View 7 Replies View RelatedI am using Oracle 11g (11.2.0.1.0) and I want to apply January patch on 11.2.0.1.0. I have applied 3 patches. I have single Instance with ASM and Grid.
Grid home: /opt/grid/11.2.0/grid
Oracle Home: /opt/oracle/product/11.2.0/db
1. O patch (6880880)
2. Grid patch (9655006)
3. Oracle Patch (10248516)
I have followed the following steps.
1. Applied Opatch on grid.
unzip p6880880_112000_LINUX.zip -d /opt/grid/11.2.0/grid
2. Validated the Oracle Inventory.
/opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/grid/11.2.0/grid
3. Shut down the databases.
4. Run the prepatch script
./9655006/custom/server/9655006/custom/scripts/prepatch.sh
5. Shutdown the ASM.
6. Ran the below command to stop CSS etc.
/opt/grid/11.2.0/grid/crs/install/roothas.pl -unlock
7. Applied grid patch.
/opt/grid/11.2.0/grid/OPatch/opatch napply -oh /opt/grid/11.2.0/grid -id 9655006
8. Applied Opatch on Oracle home
9. Applied Oracle patch
/opt/oracle/product/11.2.0/db/OPatch/opatch napply -oh /opt/oracle/product/11.2.0/db -id 10248516
8. Run the postpatch script
./9655006/custom/server/9655006/custom/scripts/postpatch.sh
9. Run the following script to enable CSS etc.
/opt/grid/11.2.0/grid/crs/install/roothas.pl -patch
/opt/grid/11.2.0/grid/bin/crsctl check has
/opt/grid/11.2.0/grid/bin/crsctl check css
10. If CSS is not online ran the below command.
/opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
/opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
/opt/grid/11.2.0/grid/bin/crsctl stop has
/opt/grid/11.2.0/grid/bin/crsctl start has
11. Up the ASM and Databases. Ran the postinstall in GRID and Oracle.
@catbundle.sql psu apply
12. Ran the below command on grid and Oracle.
/opt/grid/11.2.0/grid/OPatch/opatch lsinventory
/opt/oracle/product/11.2.0/db/OPatch/opatch lsinventory
1. Let me know steps which are followed are right because I didnot see the version change after connecting to database? (for example 11.2.0.1.0 after applying I can see 11.2.0.1.4 but not changed the version). How should I know the patch is applied properly?
2. Is the above steps are applicable to HA setup.
I applied the Jan 09 CPU to my database this past Saturday and now my daily schema export is not running properly:
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
[code]...
I am running a 10g oracle DB on AIX the application running is SAP.
Now I will be applying the following patch
8201796:OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#10)
But I find the following patches are already applied to the system which happens to be included in 8201796
6934892,7228971,7278117.
Do i need to remove the above patches individually before applying 8201796 or will it automatically do the needful during installation.
I have installed grid and oracle 11g on linux environment. I want to installation January patch related to grid and oracle 11g. This is the first time i m going to install the oracle 11g.
View 4 Replies View RelatedHow to set Path environment variable if we want to use OPatch utility for patch upgradation.
View 2 Replies View RelatedWe are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.
Following files are active :
E:oracleproduct10.2.0inoraclient10.dll
E:oracleproduct10.2.0inorapls10.dll
E:oracleproduct10.2.0inoracommon10.dll
E:oracleproduct10.2.0inorageneric10.dll
E:oracleproduct10.2.0inoraplp10.dll
[code]........
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ]
in the Oracle Home
--------------------------------------------------------------------------------
Its not an rac. We stopped all the services running on this server.
OPatch failed with error code = 74
I am getting unexpected issue while fetching records from dba_ts_quotas & DBA_USERS Views.
FYI..
select username,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users
where username='DWHODS'
USERNAMEDEFAULT_TABLESPACETEMPORARY_TABLESPACE
DWHODS DWHODS_TBS_DATADWHODS_TEMP_DATA
select tablespace_name, username, bytes / 1024 / 1024 "Used MB",
[code].....
View dba_ts_quotas is giving tablespace name "USERS" where DBA_USERS showing default tablespace name "DWHODS_TBS_DATA".
I know that you can view all constraints in a table using $USER_CONSTRAINTS or $USER_INDEXES view. What i find difficult is that the information in those views is not really well presented.
I find it very hard to follow. For example, just to find out which columns are foreign keys and which tables they refer to is really tedious. Is there a simpler way to view all the constraints especially foreign keys of a table and including which table columns they refer to in the child table.
I like to see a diagramatic representaion of all the tables involved so i like to see both the parent and the child tables, which columns are related and using which FKs etc. is there an easier way to view this information?
How Can We Get Hardware Information In Oracle Database 8i for example harddisk size,volume,processor etc. i want database run only specified harddisk
View 1 Replies View RelatedI wanted to know the checkpoint information and the interval of checkpoint for my instance.I have checked alert.log file for the same.
Is there is any other way or any view exists to get that information?
10g and 11g
SLES 10
My boss has assigned me a task to check/audit a existing PROD + other databases which was configured (in a server or servers) by previous dba who have left with no documentation.I am just given the server ip and root password.
-How do you attack this kind of task?
-How do you know how many databases were installed in a given server/machine?
-How do you get all the oracle_home being defined or used?
Is /etc/oratab enough to start with?Is oraInventory enough to know all the databases installed? Is this keyword unique, and kind be search using "find / -name "oraInventory"?Do I need to find the existent of the "oracle" exec in all "bin" since this is the unique identifier of an OracleHome?
We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.
My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:
Failed to load the following objects: APPSTAND, etc etc.
Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?
We need to apply the the 11.2.0.2 database server patch and this is a 12i Ebusiness suite env. Do we need to take any precautions(other than stopping the apps) on the APPS side when we are applying the patch on the database?
View 2 Replies View RelatedI have HP server with Windows 2008 Server R2 64bit. I installed latest 64-bit version of Oracle Database 10.2.0.4 and everything works fine and later installed the patch 10.2.0.5 (64 bits) as the Oracle maintains that with the R2 version of the system it is necessary to correct work.
Now, after uploading the patch database starts and closes after about 15 minutes - an additional log file is changed to the binary version which do not see anything.
how to solve problem? The move to Oracle 11 drops.
This is the link to my alert log file (it's strange after 10.2.0.5 patch installation):
[URL].......
I attached my spfile.ora file too:
[URL].......