The automatic running script of Oracle10g under Solaris10

Source: Internet
Author: User
Solaris10 uses SMF (Service Management Facility) to centrally manage various systems and network services. It aims to reduce the difficulty of system management and reduce the probability of system errors. Practice

Solaris 10 uses SMF (Service Management Facility) to centrally manage various systems and network services. It aims to reduce the difficulty of system management and reduce the chance of system errors. Practice

Solaris 10 uses SMF (Service Management Facility) to centrally manage various systems and network services. It aims to reduce the difficulty of system management and reduce the chance of system errors. Practice has shown that it is still very troublesome to configure and manage services through the SMF management platform. For example, to configure a third-party software customized and installed by a user to SMF for management, we need to do a lot of work. In addition, if a service fails, it will involve both the service itself and the SMF, which increases the difficulty of recovery. Personal bias: the goal of system management is the simpler the better-easy deployment, simple maintenance, and fast recovery. The solaris 10 system has an Oracle 10 Gb, which is used as an example to configure an Oracle automatic run script.

First introduce the system environment:

SunOS sery 5.10 Generic_118855-33 i86pc i386 i86pc

Oracle version racle Database 10g Enterprise Edition Release 10.2.0.2.0-Prod

Oracle installation path/opt/Oracle/product/10.2/db_1

Dbstart path/opt/Oracle/product/10.2/db_1/bin/dbstart

Oracle comes with a script dbstart, which is used to create an automatic running script. Before starting an Oracle instance, run the script dbstart:

-Bash-3.00 $ dbstart

Oracle_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener

Usage:/opt/Oracle/product/10.2/db_1/bin/dbstart Oracle_HOME

The prompt "ORACL_HOME_LISTNER" is not set, and the usage of this command is given. Use ps-aef | grep ora to check whether Oracle-related processes are up. Oh, no! Modify the file dbstart and find the ORACL_HOME_LISTNER line (Fortunately, there is only one row). Its default value is "$1", which indicates accepting a location parameter, since the program needs to manually add the location parameter Oracle_HOME, we may replace "$1" with "Oracle_HOME", that is, Oracle_HOME_LISTNER = $1-à Oracle_HOME_LISTNER = $ Oracle_HOME, save and run the script dbstart,

-Bash-3.00 $ dbstart

-Bash-3.00 $ ps-aef | grep ora | grep-v grep

Oracle 964 552 0 06:40:17 pts/1 ps-aef

Oracle 552 546 0 06:08:08 pts/1-bash

Oracle 696 1 0 06:22:25? /Opt/Oracle/product/10.2/db_1/bin/tnslsnr LISTENER-inherit // LISTENER

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.