//
archives

Oracle Database Toubleshooting

This category contains 6 posts

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options This issue happened when I was trying to backup the archive log file on an Oracle RAC database Solutions The cause of the issue is because the NFS volume hasn’t been mounted correctly. umount the /backup01 on both … Continue reading

ORA-01102 – cannot mount database in EXCLUSIVE mode

Set up an Oracle Database on ODA today for testing, but got an error as below Well, login to sqlplus to start it manually. Ennnnnn, back to node1 testodadb01, the instance 1 startup successfully After I read the trace file, I realized that the database is not in cluster mode: Okey Dokey, let’s fix it.

java.sql.SQLRecoverableException: No more data to read from socket cause by connection pool running out

java.sql.SQLRecoverableException: No more data to read from socket caused by connection pool running out Issues Currently, in Oracle database server is built on more than one tablespace for different systems, both systems at the same time in the course of a project being developed in a test run, appeared from time to time the connection … Continue reading

ORA-00569: Failed to acquire global enqueue

‘ORA-00569: Failed to acquire global enqueue’ error when running the archivelog files backup Following error appeared on the RMAN process To fix this issue First, look the ASM instance log file. In this case, the log file is alert+ASM.log To run multiple instances of RAC environment for ASM instance, 200M SGA is clearly too small, … Continue reading

ORA-15055: unable to connect to ASM instance and ORA-12547: TNS:lost contact

ORA-15055: unable to connect to ASM instance and ORA-12547: TNS:lost contact After completed to installation of the Oracle RAC, I got following error when I try restart the database Check the alert log file, I found following errors Errors in file /oragi/app/oracle/diag/rdbms/rac/rac1/trace/rac1_asmb_31756.trc: Check the asm instance,the status of the asm diskgroup shows online: Check the … Continue reading

ORA-15045: ASM file name is not in reference form

Error Message: Cause: The permissions issue of the ‘oracle’ bin program is the cause of the problem. Solution: The following steps should solve this problem