Posts

ORA-15137: The ASM cluster is in rolling patch state

When the patch are available in opatch lsinventory cross the all the nodes,we need to perform the below steps As root: GI_HOME/bin:> crsctl stop crs -f As root: GI_HOME/crs/install:> ./rootcrs.sh -unlock As GI owner: GI_HOME/bin: patchgen commit -pi 19769480,20299023,20831110,21359755 As root: GI_HOME/crs/install:> ./rootcrs.sh -patch As root: GI_HOME/bin:> kfod op=patches 
Post a Comment
Read more

ORA-00600: internal error code, arguments: [qctVCO:csform] ORA-64131 ORA-01403 Errors After Upgrade From 11.2.0.1 To 11.2.0.3 (Doc ID 1394206.1) when database is running in the Chinese language

Solution APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 or 11.2.0.4 [Release 11.2] Information in this document applies to any platform. ***Checked for relevance on 24-Jul-2013*** SYMPTOMS After upgrading the database from 11.2.0.1.0 to 11.2.0.2 or 11.2.0.3.0, XDB upgraded successfully but now there are XDB errors of: Tue Jan 10 13:22:01 2012 XDB installed. XDB initialized. .. ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [2], [213], [], [], [], [] ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary ORA-01403: no data found And the following object(s) are invalid in the database: SYS ALL_XSC_SECURITY_CLASS_DEP VIEW SYS ALL_XSC_SECURITY_CLASS VIEW SYS ALL_XSC_PRIVILEGE VIEW SYS ALL_XSC_AGGREGATE_PRIVILEGE VIEW SYS ALL_XSC_SECURITY_CLASS_STATUS VIEW Attempts to recompile these objects also fail with the above errors. CAUSE T...
Post a Comment
Read more

ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01403: no data found

ORA-39065: unexpected master process exception in DISPATCH ########################## ## Error ########################## ORA-39065: unexpected master process exception in DISPATCH ### Full Error ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01403: no data found ORA-39097: Data Pump job encountered unexpected error 100 ########################## #  Error Occurred ########################## Error occured while trying to run a datapump export for estimate the size of the dumpfile in 11.2.0.4.0 version ########################## ## Command Executed ########################## expdp \'/ as sysdba\' estimate_only=y **************************************** Step By Step Analysis ****************************************************** ######################################### # 1) Reproduce the Error ######################################### $ expdp \'/ as sysdba\' estimate_only=y Export: Release 11.2.0.4.0 - Production on W...
Post a Comment
Read more

EXPDP – ORA-39006,ORA-39213 Metadata processing is not available

==> Environmental Details : O/S :Windows Server 2008 64 bits Oracle Version : 11.2.0.1 ==> Error Details : While Taking full database export using “EXPDP” i was getting below mentioned error : ############################################### C:\> expdp directory=pump_dir=expdp_test.dmp logfile=expdp_test.log full=y Export: Release 11.2.0.1.0 – Production on Thu Feb 27 10:48:09 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username : system/oracle123 as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available ############################################### Soultion login  to sys C:\sqlplus sys as sysdba SQL> execute dbms_metadata_util.load_stylesheets ...
Post a Comment
Read more

query for checking space tablespace and used tablepace in oracle database

select a.tablespace_name as tablespace_name ,a.total_mb,b.used_mb ,a.total_mb-b.used_mb  as free_space from (select d.tablespace_name, sum(d.bytes/1024/1024) as total_mb from dba_data_files d group by d.tablespace_name) a, ( select s.tablespace_name,sum(s.bytes/1024/1024) as used_mb from dba_segments s group by tablespace_name)  b  where a.tablespace_name=b.tablespace_name order by tablespace_name select a.tablespace_name as tablespace_name ,a.total_mb,b.used_mb ,a.total_mb-b.used_mb as  free ,free_space  as free_space from (select tablespace_name, sum(bytes/1024/1024) as total_mb from dba_data_files group by tablespace_name) a, ( select tablespace_name,sum(bytes/1024/1024) as used_mb from dba_segments group by tablespace_name)  b, (select tablespace_name,sum(bytes/1024/1024) as free_space from dba_free_space group by tablespace_name)  c where a.tablespace_name=b.tablespace_name and b.tablespace_name=c.tablespace_name order by tablesp...
Post a Comment
Read more

Oracle Local Registry (OLR) in RAC - 11gR2

In 11gR2, addition to OCR, we have another component called OLR installed on each node in the cluster. It is a local registry for node specific purposes. The OLR is not shared by other nodes in the cluster. It is installed and configured when clusterware is installed. Why OLR is used and why was it introduced. In 10g, we cannot store OCR’s in ASM and hence to startup the clusterware, oracle uses OCR but what happens when OCR is stored is ASM in 11g. OCR should be accessible to find out the resources that need to be started or not. But, if OCR is on ASM, it can’t read until ASM (which itself is the resource of the node and this information is stored in OCR) is up.  To answer this, Oracle introduced a component called OLR. Ø     It is the first fi le used to startup the clusterware when OCR is stored on ASM. Ø     Information about the resources that needs to be started on a node is stored in an OS file called ORACLE LOCAL REGISTRY (OLR). Ø ...
Post a Comment
Read more

Oracle Management Server _ EMGC_OMS1 _1 in windows

12c: EM: OMS Server Fails - error nm home replaced Environment: Oracle Enterprise Manager 12c, Windows 2008 R2 Error: Below error occured on one of the client environment C:\Windows\system32> %OMS_HOME%/bin/emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started Oracle Management Server is Down Please check E://gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details Log file showed below 2013-12-22 10:30:54,300 [main] INFO wls.OMSController main.219 - Executing emctl command : start 2013-12-22 10:30:58,536 [main] INFO commands.BaseCommand getEnvProps.456 - nm home replaced : E:/gc_inst/NodeManager/emnodemanager 2013-12-22 10:30:58,581 [main] INFO commands.StartCommand startOMS.371 - net start return code is 2 2013-12-22 10:30:58,582 [main] ERROR commands.BaseCommand logAndPrint.620 - Windows service OracleManagementServe...
Post a Comment
Read more