Oracle Products (playlist)

Solving “ORA-03113: end-of-file on communication channel” while starting up Oracle Database 11g

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

Case:
While trying to open db 11g on linux machine we encounter the error ORA-03113: end-of-file on communication channel.


Investigation and solution:
Returning back to the alert log file we can see the following lines:

Solving "ORA-00210: cannot open the specified control file" Missing Control File in Oracle 11g

Missing control file in Oracle DB 11g

Trying to do some practices as we used in 10g, trying to start the db after restoring a missing control file, so we remove the main control file in datafiles directory and try to shutdown the database, In 10g the database closed with no errors, but in 11g it generates the following ORA-00210 error.

Smart Guide for Your IT - Oracle EM 12c Intro

Startup, Shutdown & Initialization file

Hello everyone,

In this article you can find some useful commands regarding managing the startup and shutdown process of an oracle database along with managing initialization files.

-- Commands used to startup and shutdown the database
> startup
> startup nomount

Managing Database & Instance Structure

Hello everyone,

In this article I will summarize some of the commands used during managing database & Instance.

-- Some Parameters used during this article

> show parameter db_name
> show parameter instance_name
> show parameter db_unique_name

Using SQL*Plus commands

Hello everyone,



In this post I will summarize some of useful sql*plus commands that i use frequently.

-- To run a OS command from withen SQL*Plus prompt [two methods]
> host os_command