end-of-file on communication channel

end-of-file on communication channel

Database does not start (idle instance)

end-of-file on communication channel:

One of the course of this error is due to database fail to write the log when its in the stage of opening;

Solution check the database if its running in ARCHIVELOG or NOARCHIVELOG

to check use

select log_mode from v$database;

if its on ARCHIVELOG try to change into NOARCHIVELOG

by using sqlplus

  • startup mount
  • alter database noarchivelog;
  • alter database open;

if it works for this

Then you can adjust your flashrecovery area its possibly that your flashrecovery area is full -> then after confirm that your flashrecovery area has the space you can alter your database into the ARCHIVELOG

    • Related Articles

    • BOM Xploder - "ORA-00942 table or view does not exist" for non-SYSADM users

      If you refresh BOM Xploder with your connection configured to an Oracle Visual database for a user other than SYSADM, you may receive the following error: There are two steps required to fix this. First, make sure that BOM Xploder is updated to at ...

    • Supported Bank File Types (NACHA, EFT)

      Attached file formats are the default output files from the ACH application that conform to NACHA standards. These files can be downloaded by customers and submitted to banks for verification. IE, if a Bank says they accept CCD as an ACH format, then ...

    • Windows Server end of support and Microsoft 365 Apps

      Windows Server end of support and Microsoft 365 Apps Article 07/08/2022 Important Microsoft 365 Apps isn't supported on Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, or Windows 2022. Using Microsoft 365 Apps on older, ...

    • SmartViews - Access to the database file is not allowed

      This is a folder permission issue. Make sure the folder permissions allow users modify rights. This should be done on the Smartviews folder which is the parent folder. If this is Terminal server, that will need to be done by an admin account.

    • Moving VISUAL Quality reports to new location

      Description: Moved VISUAL Quality reports to a new location. Update the VISUAL Quality SQLBase or Oracle database after moving the VISUAL Quality reports to a new location. Symptom: Invalid file name Resolution: Here's a procedure for reinstalling ...