ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run

Oracle cluster check

27 March 2023   0 Comment

None of the ASM Ctl commands are working and are idle.when checked with ps -ef, you can see that the ASM instance is working and the database is also working well.But we have a problem, the Cluster high availability services are not working. -> asmcmd lsdgASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM […]

Read More

Oracle GoldenGate Best Practices 101

How Problems with Oracle GoldenGate

26 March 2023   0 Comment

CONTENTSSECTION 1-) GOLDENGATE INSTALLATION • Goldengate Installation• Extract Process• GGSCI commands• Parameter Files• As400 Extract Example• Oracle Extract Example• Pump Example• Replicate Process• GGSCI commands• Parameter files• Replicate Example• Manager Operation• GGSCI commands• Parameter File• Manager Example• Useful commands SECTION 2-) USE OF GOLDENGATE • Goldengate Daily Usage• INFO• STATS• Using Extracta. As400 ExampleI. infoii. […]

Read More

ORA-09817: Write to audit file failed, ORA-01013: user requested cancel of current operation

How to fix Oracle

25 March 2023   0 Comment

ERROR at line 1:ORA-09817: Write to audit file failed.SVR4 Error: 49: Disc quota exceededAdditional information: 9ORA-01013: user requested cancel of current operation Solution You should check your disk space. Example cd /u01/app/oracle/admin/orcl/adump/ rm *.aud or solaris -> find /u01/app/oracle/admin/orcl/adump/ -name *.aud -mtime +0 -exec rm -rf {} \;

Read More