capture log wrap due to ASMsetup: ASMQuerySetup:OCIError OCI_ERROR, Code 1034: ORA-01034: ORACLE (4342492)

Capture stops and starts due to log wrap; however, the archive logs that capture is looking for exist in the archive directory.

While ASM instance is available, except owner no other users can log into ASM instance.

ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
 

Certain Oracle binaries are missing sticky bit after the directory was restored from the backup or some changes.

$ cd $ORACLE_HOME/bin
$ ls -l oracle
-rwxr-x--x 1 oracle dba 119582976 Feb 3 2008 oracle

$ ls -l oradism
-r-xr-x--- 1 oracle oinstall 119582976 Feb 3 2008 oracle

add sticky bit to the binary according to it previous setting.

For example,

chmod 6751 oracle

chomd 6550 oradism

chown root:oinstall oradism

To check for sticky bit

cd $ORACLE_HOME

find . -perm -6000