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.

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'

Verify checksum on R12 Media

Verify checksum on R12 Media

Linux:
md5sum utility already installed on your machine , if not available please install it.
go to the staging folder
eg: $cd /prodtmp/Stage12
      $md5sum --check md5sum_Linux32.txt > md5sum_result.txt

When the md5sum command failed error: "Failed open or read" try to make it a unix file using:
$dos2unix <checksum file> <cheksum file>

Oracle R12 media check sum txt file can be downloaded from metalink link

Oracle EBusiness Suite R12.1.x Rapid Installmd5 Checksums[802195.1]

How to kill an oracle session

How to kill an oracle session

conn as / sysdba or any dba user.

SQL> Alter system kill session  'sid,serial#' immediate;

OS level:


Windows:
orakill ORACLE_SID spid


The UNIX /Linux :
To kill the session on UNIX or Linux operating systems, first identify the session, then substitute the relevant SPID into the following command.

find out running oracle process
$ps -ef | grep ora

$kill -9 unix/linux process id

How to find a locked Objects in database

How to find a locked Objects in database

Run the following query from dba user

select c.owner, c.object_name, c.object_type,b.sid, b.serial#, b.status, b.osuser, b.machine
from v$locked_object a , v$session b, dba_objects c
where b.sid = a.session_id
and a.object_id = c.object_id