Posts by Doyensys

Untitled

                                                Error in  Diskgroup  ASM Solaris  Steps:  1. After…

Read More

Untitled

                  Workflow notification mailer not sending emails in Oracle Apps We often find issues in Oracle Apps where our Workflow notification mailer…

Read More

Untitled

SYSTEM Tablespace is Growing Abnormally in 12c SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was happening in my test environment. We observe that…

Read More

Untitled

Set Autotrace Traceonly giving error SP2-0618 and SP2-0611 in Oracle 18c I was trying few things in Oracle 18c database using command window and needed autotrace enable for the same.…

Read More

Database restoration Failed with ORA-15001,ORA-17502

Database restoration Failed with ORA-15001,ORA-17502 Symptoms : channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to +DATA/TEST1/DATAFILE/system.280.938093005channel ORA_DISK_1: restoring…

Read More

Path is lost with error in ASM

Path is lost with error Symptoms: Errors in file /u01/oracle/product/diag/asm/+asm/+ASM/trace/+ASM_gmon_11519.trc:ORA-27072: File I/O error>>>>>Linux-x86_64 Error: 5: Input/output errorWARNING: Write Failed. group:1 disk:0 AU:1 offset:1044480 size:4096WARNING: Hbeat write to PST disk 0.3915951984…

Read More

PRCR-1013 : Failed to start resource ora.proxy_advm + ORA-09925: Unable to create audit trail file

PRCR-1013 : Failed to start resource ora.proxy_advm + ORA-09925: Unable to create audit trail file Symptoms : # srvctl start asm -proxy -n asmcloud1 PRCR-1013 : Failed to start resource…

Read More

Volume Creation endup with ORA-15221

Volume Creation endup with ORA-15221 Symptoms : ASMCMD> volcreate -G DATA -s 250G volume1ORA-15032: not all alterations performedORA-15479: ASM diskgroup does not support volumesORA-15221: ASM operation requires compatible.asm of 12.1.0.2.0…

Read More

"ORA-01017: invalid username/password; logon denied" while starting up asm

“ORA-01017: invalid username/password; logon denied” while starting up asm Symptoms : I. ASM instance can be started manually using sqlplus “/as sysasm” but the CRSD fails to start Cause :…

Read More

Correct permission for oracle binary from GRID and RDBMS Home and ASM devices to avoid ORA-27041 ORA-15025 ORA-15081

Correct permission for oracle binary from GRID and RDBMS Home and ASM devices.   GRID(oracle binary) RDBMS(oracle binary) ASM Devices permission Correct Permission for role separation -rwsr-s–x 1 grid oinstall…

Read More