Monday, May 7, 2012

Oracle RMAN Database Backup Failed: Error: "error writing input to command"

Oracle RMAN Database Backup Failed: Error: "error writing input to command"


Solution:

Set the permission to 6750 (nmo & nmb) 
$chmod 6750 nmo
$chmod 6750 nmb

Oracle RMAN Database Backup Failed: "ERROR: NMO not setuid-root"

Oracle RMAN Database Backup Failed:   "ERROR: NMO not setuid-root"

Solution:
Change the ownership of the following files to root.
nmo & nmb
$cd $ORACLE_HOME/bin
$chown root nmo
$chown root nmb 

Unable to connect to the Discoverer Server: null..

Unable to connect to the Discoverer Server (10g or Higher):


Could not initialize class

oracle.disco.model.xml.ModelElementToClassMapper

Please contact your Oracle Application Server administrator
 
Solution:
Clear the temporary internet files and cookies and java cache


Steps to clear java cache:



1.Go to Start > Settings > Control Panel and click the Java icon.

2. Click on 'Settings'
3. Delete files

4. Close all browsers

5.Open new browser and test it
 
OR 
close all browsers and delete all files from "C:\Users\<>\AppData\LocalLow\Sun\Java\Deployment\cache".
 
 
(<> replace this with your windows login name)

DIP_GEN_AUTHENTICATION_FAILURE

DIP_GEN_AUTHENTICATION_FAILURE (Third party ldap is using Microsft ADS)

Profile:Error in Mapping EngineODIException: DIP_GEN_AUTHENTICATION_FAILURE


javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 532, vece^@]

at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:2988)

at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2934)

at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2735)

at com.sun.jndi.ldap.LdapCtx.connect(LdapCtx.java:2649)

at com.sun.jndi.ldap.LdapCtx.(LdapCtx.java:290)

at com.sun.jndi.ldap.LdapCtxFactory.getUsingURL(LdapCtxFactory.java:175)

at com.sun.jndi.ldap.LdapCtxFactory.getUsingURLs(LdapCtxFactory.java:193)

at com.sun.jndi.ldap.LdapCtxFactory.getLdapCtxInstance(LdapCtxFactory.java:136)

at com.sun.jndi.ldap.LdapCtxFactory.getInitialContext(LdapCtxFactory.java:66)

at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:662)

at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:243)

at javax.naming.InitialContext.init(InitialContext.java:219)

at javax.naming.ldap.InitialLdapContext.(InitialLdapContext.java:133)

at oracle.ldap.odip.gsi.LDAPConnector.connectLdap(LDAPConnector.java:318)

at oracle.ldap.odip.gsi.ActiveChgReader.initialise(ActiveChgReader.java:209)

at oracle.ldap.odip.engine.AgentThread.readerInitialise(AgentThread.java:461)

at oracle.ldap.odip.engine.AgentThread.mapInitialise(AgentThread.java:510)

at oracle.ldap.odip.engine.AgentThread.execMapping(AgentThread.java:376)

at oracle.ldap.odip.engine.AgentThread.run(AgentThread.java:238)

Solution:
Unlock the microsoft Active directory sever referenced username and verify the synchronization is working or not.

Wednesday, May 2, 2012

Unusable State of Index

Unusable State of Index


Unusable state of indexes will cause poor performance of database.

How to find Unusable Index:
select Index_name from dba_indexes where status='UNUSABLE'

How to make index Usable:
alter index  <index name> rebuild

How to create above alter statement dynamically:
select  'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where status='UNUSABLE'