Showing posts with label Oracle Errors. Show all posts
Showing posts with label Oracle Errors. Show all posts

Thursday, August 17, 2023

oracle errors and how to resolve them

 fix for ORA-03113 end-of-file on communication channel:-

1. SQLPLUS / AS SYSDBA

2. startup mount;

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.
SQL> alter database clear unarchived logfile group 3;

SQL> shut immediate;
SQL> startup ;

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...