About oralce9iR2 for Linux dbstart setting and dbshut script

Source: Internet
Author: User

I checked the shell script $ Oracle_HOME \ bin \ dbstart and found a bug.

He thinks PFILE =$ {ORACLE_HOME}/dbs/init $ {ORACLE_SID }. ora, but after oracle9i is installed by default, the init $ ORACLE_SID.ora file is not in the $ ORACLE_HOME/dbs directory, because 9i has used spfile as the parameter file at startup, therefore, the dbs directory contains only the pfileinit $ ORACLE_SID.ora file. The init $ ORACLE_SID.ora file is in the pfile directory. So I took the test and then executed dbstart. OK.

But there is still a problem. The last two lines of my/etc/oratab file are like this.

*:/U01/oracle/product/9.2.0: Y
Oralinux:/u01/oracle/product/9.2.0: Y

Why is there a line with the * number? The dbshut or dbstart script reads the comments rows in this file cyclically. Therefore, if there is a line *, two lines of errors will be reported before running dbstart and dbshut, the servicename cannot be found (because the "*" is used as an empty sid in the script). Just remove this line. However, if this line is removed, the system will prompt you to enter ORACLE_HOME every time you log on to linux with an oracle user because you need to run oraenv in the oracle user profile, how to write the specific oraenv, I will not see it, it is certainly a line of * will not ask.

In addition, although both dbstart and dbshut can be run, it still does not automatically open the database when linux is started. Why? I have created the dbora script in/etc/init. d.

Of course, it won't start on your own, because what you changed in oratab is to allow the database to use dbstart and dbshut. If you want to start the database at/etc/rc at system startup. add the startup script to local.

Here is an RPM package for configuring Oracle startup scripts, which was changed from SUSE Linux. It can be used on RedHat 7.x.

Check the files in the file and you will know how to set them.

View brief information about the software package:
Rpm-qpi xxx. rpm

View the package file list:
Rpm-qpl xxx. rpm

This is only the way to view the software package before installation.

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.