Posts

Showing posts with the label Auto startup and shutdown oracle database services on linux

Oracle Database Error Solutions & DBA Knowledge Base

Welcome to Oracle Database Error Solutions, a professional technical knowledge base dedicated to helping Oracle Database Administrators, Oracle E-Business Suite administrators, developers, and IT professionals troubleshoot Oracle Database and Oracle Linux issues with confidence.

This website provides practical, real-world troubleshooting guides based on hands-on Oracle administration experience. You'll find detailed solutions for Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, Oracle Linux administration, Oracle E-Business Suite (EBS), cloning, performance tuning, patching, installation, and day-to-day DBA tasks.

Whether you're resolving ORA-27101, ORA-28040, ORA-01555, ORA-12154, ORA-01017, or other Oracle errors, our step-by-step articles are designed to save you time and help you solve problems efficiently.

Auto startup and shutdown oracle database services on linux

Image
Auto startup and shutdown oracle database services on linux          Description:             I have oracle database 11gR2 on enterprise Linux 5.7. I want that all database services and listener should be stopped automatically when Linux going to shutdown. And after startup Linux all database services and listener start automatically. Solution:             To auto startup and shutdown all database services:    Following parameter in /etc/oratab file should be Y: orcl:/d01/app/oracle/product/11.2.0/dbhome_1:Y   Set the following parameter in $ORACLE_HOME/bin/dbstart :           ORACLE_HOME=/d01/app/oracle/product/11.2.0/dbhome_1;           export ORACLE_HOME           ORACLE_HOME_LISTNER=$ORACLE_HOME ...