oracle on linux system boot process under

2010-06-11  来源:本站原创  分类:Database  人气:147 

1. Start oracle

Set environment variables: instance id and oracle_home:
export ORACLE_SID = test

export ORACLE_HOME = xxx

Start:

su oracle
sqlplus / nolog
sql> conn / as sysdba
sql> startup (usually with no additional parameters, as long as the set up environment variables)
This oracle service started successfully

Close:

sqlplus / nolog
sql> shutdown of its parameters: shutdown has four parameters, the meaning of the four parameters as follows:

Normal users need to wait for all disconnected
Immediate wait for the user to complete the current statement
Transactional wait for the user to complete the current transaction
Abort without any waiting, direct closure of the database
normal need to disconnect all connected users close the database after the implementation of the task, sometimes looks as if the command is not running the same! In the implementation of this command does not allow new connections
immediate implementation in the user complete the statement being executed after the disconnect users connected, and not allow new users to connect.
transactional matters in support of implementation of the complete current after disconnect and allow new users to connect to the database.
abort the implementation of force disconnect and close the database directly.
The first three methods do not return to user data is lost. The fourth has not the case, not recommended!

Start close listener:

lsnrctl start (boot monitor) close the oracle
$ Lsnrctl stop (close listener, before that, should first close the application)

相关文章
  • oracle on linux system boot process under 2010-06-11

    1. Start oracle Set environment variables: instance id and oracle_home: export ORACLE_SID = test export ORACLE_HOME = xxx Start: su oracle sqlplus / nolog sql> conn / as sysdba sql> startup (usually with no additional parameters, as long as the set

  • Linux host boot process 2011-06-12

    When the Linux host is activated, the entire boot process can be simply described as follows: Turn on the computer, start reading the cure to the motherboard BIOS the above procedures, and the host of the self-test; Achieved through the BIOS program

  • Android root file system boot process 2010-07-15

    In the Android system startup, the kernel boot parameters will generally Set "init = / init", so, if the kernel Chenggong mount this file system, the first run is this the root directory init Program . This process is going on? We only RFSC (Rea

  • linux grub boot process 2011-07-07

    http://apps.hi.baidu.com/share/detail/16068846

  • Speed ​​up the Linux boot process 2011-01-10

    This document Copyleft owned yfydz all use under the GPL, can be freely copied, reproduced, reprinted, please maintain the integrity of the document, for any commercial purposes is strictly prohibited. msn: [email protected] Source: http://yfydz.

  • LINUX system to understand the log 2010-04-29

    1. Log Introduction Logs for security is very important, and he records the system all sorts of things happen every day, you can check the error occurred through his reasons, or attack those who attacked traces. The main function of the log are: audi

  • Unix / Linux system in the shell 2011-01-12

    For the initial contact with Unix / Linux system, classmates, Unix / Linux system and Windows system, the biggest difference is that operating Unix / Linux systems more often than using the GUI graphical interface but the use of shell command line. T

  • Linux 2.6 kernel boot process analysis 2010-09-29

    Linux 2.6 kernel boot process analysis To an article on the Linux kernel compilation process, the next generation of the kernel this paper to introduce the Linux kernel boot process. In this paper, an example x86, x86 and embedded systems more than a

  • Overview of the Linux boot process 2011-03-18

    Power from the machine to a Linux system is booted up the process. . . . . Open the PC power user, the first boot device set in the BIOS (usually hard drive) to boot loader, boot device to install LILO or GRUB boot loader start booting Linux. First,

  • linux system study notes 2011-07-30

    notes a linux system, commonly used commands 1.Linux classification system shell: Bourne shell (sh), C shell (csh), Korn shell (ksh) Note: sh is the first use of the unix shell, is very good at programming, but the exchange between users in treatment

  • Linux, find the process using ps and kill to terminate the command with the Detailed 2010-12-06

    Taking advantage of free, collect some linux practical skills for future investigation: Linux under the process of using ps to find and use kill command to terminate Detailed Using the linux operating system, will inevitably encounter some software "

  • Troubleshooting the RHCE exam, linux system can not boot or possible error conditions (change) 2010-03-19

    Troubleshooting the RHCE exam, linux system can not boot or possible error condition ############################################### # # ############################################### # # # # # Of: sheep ( [email protected] ) # # # Home: http://bluef

  • unix / linux system, see the process of memory 2010-04-16

    Abstract: This paper describes time process management concepts and process management tools introduced; paper focused on process management tools classification description and application examples, including ps, pgrep, top, kill, pkill, killall, ni

  • linux boot process troubleshooting 2010-05-15

    Sector disorder problem if there is no damage to the root directory: Suppose you place the wrong disk blocks in / dev/hda7 this one, then at boot time, the screen should tell you: press root pass word or ctrl + D: This Please enter the root password

  • [Change] x window system theory, the boot process 2010-08-03

    A) Basic operation principle X Window System using C / S structure, but our common C / S different. Common C / S structure, called the party to provide services for the server, the server-side (such as the HTTP service, FTP service, etc.), use of ser

  • linux boot process to start the service 2010-11-04

    1) redhat startup mode and the execution order is: Init program loads the kernel execution / Etc / rc.d / rc.sysinit # init executed by the first script / Etc / rc.d / rc $ RUNLEVEL # $ RUNLEVEL to the default mode of operation / Etc / rc.d / rc.loca

  • Linux boot process [transfer] 2010-11-09

    After powering the machine, BIOS start testing the system parameters, such as memory size, date and time, disk devices, and equipment used to direct these disks in the order, under normal circumstances, BIOS is configured to first check all floppy or

  • [Zz] Linux boot process to load hardware modules 2010-12-07

    Source unknown. Read the Linux kernel boot code that I want to write directly RTL8019AS power network card driver (2.4.18 kernel only support the CS8900A). Since the write driver, I wanted to know how it was like to be loaded, curiosity drove me to g

  • Linux boot process analysis (to) 2011-01-09

    Original link: http://bbs.phpchina.com/thread-82640-1-15.html In this paper, RedHat9.0 and the i386 platform as an example, analysis of the power from the user to open the command prompt appears until the screen throughout the Linux boot process. And

  • linux boot process service 2010-11-04

    1) redhat startup mode and the execution order is: Load the kernel executing the program init / Etc / rc.d / rc.sysinit # first performed by the init script / Etc / rc.d / rc $ RUNLEVEL # $ RUNLEVEL the default mode of operation / Etc / rc.d / rc.loc