Shulou(Shulou.com)05/31 Report--

Most people do not understand the knowledge points of this article "how to configure the centos6.5 oracle boot environment", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "centos6.5 oracle boot environment how to configure" article.

Detailed explanation of the environment configuration of centos 6.5oracle boot self-startup

Environment: centos 6.5g + oracle 11g

Pre-boot problem

In the oracle environment in the virtual machine, every time you restart the system and connect with plsql developer, you will first report an error:

No tns listener

The solution is to switch to the oracle user of the system and execute lsnrctl start, but before execution, because the oracle_home environment variable does not take effect, and the environment variable file takes effect, the steps are as follows:

[oracle@localhost ~] $source .bash _ profile [oracle@localhost ~] $echo $oracle_home/home/oracle/app/oracle/product/11.2.0/dbhome_1 [oracle@localhost ~] $lsnrctl start

After the startup is complete, connect again and report an error:

Oracle did not start. The startup steps are as follows:

[oracle@localhost] $sqlplus / nologsql*plus: release 11.2.0.1.0 production on wed oct 19 14:29:10 2016copyright (c) 1982, 2009, oracle. All rights reserved.sql > conn / as sysdbaconnected to an idle instance.sql > startuporacle instance started.total system global area 776646656 bytesfixed size 2217384 bytesvariable size 490736216 bytesdatabase buffers 281018368 bytesredo buffers 2674688 bytesdatabase mounted.database opened.

Configure self-startup

All of the above processes are configured to boot.

Environmental variables take effect

It may be because my oracle user is not logged in on the desktop, it is switched over from the terminal su, and the .bash_profile file is not running. After I write the contents of the file to the .bashrc file, I can restart it.

Tns snooping and oracle service self-starting

Edit the: / etc/oratab file and change the n on the last line to y

# this file is used by oracle utilities. It is created by root.sh# and updated by the database configuration assistant when creating# a database.# a colon,':', is used as the field terminator. A new line terminates# the entry. Lines beginning with a pound sign,'#', are comments.## entries are of the form:# $oracle_sid:$oracle_home::## the first and second fields are the system identifier and home# directory of the database respectively. The third filed indicates# to the dbstart utility that the database should, "y", or should not,# "n", be brought up at system boot time.## multiple entries with the same $oracle_sid are not allowed.##orcl:/home/oracle/app/product/11.2.0/dbhome_1:y

The path may be different.

Edit the / etc/rc.local file and add the last two lines:

#! / bin/sh## this script will be executed * after* all the other init scripts.# you can put your own initialization stuff in here if you don't# want to do the full sys v style init stuff.touch / var/lock/subsys/localservice smb restartsu-oracle-c 'lsnrctl start'su-oracle-c' dbstart'su-oracle-c 'emctl start dbconsole'

Dbstart is a startup script that comes with the database, so all we have to do is add it to rc.local and let it boot up. But you still need to edit it. Modify the oracle_home_listner of dbstart to point to $oracle_home:

# first argument is used to bring up oraclenet listeneroracle_home_listner=$oracle_home

Restart the virtual machine and find that plsql developer can be connected directly.

The above is about the content of this article on "how to configure the centos6.5 oracle boot environment". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.