oracle basic commands with example

Abstract: This article describes how to install the oracle9.2.0 database in the RedHat Linux9 environment. Keyword: oracle9i RedHat Linux9 Kernel Parameter environment variable Oracle817 is always used in the RedHat linux7.1 environment. Sort out

 Routine basic maintenance commands for Oracle RAC Status of all instances and services $ Srvctl status database-d orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2 Status of a single instance $ Srvctl status

Summary of Common commands for executing scripts in Oracle databases and common commands in oracle 1. Execute an SQL script file Copy codeThe Code is as follows:Sqlplus user/pass @ servicename Or Copy codeThe Code is as follows:SQL> start

Oracle's architecture is broadly divided into two parts: Instance (instance) and database. Instance (example) : The SGA is mainly included in Oracle Instance and some processes (for example: Pmon, Smon, Dbwn, LGWR, CKPT, etc.). If a user's

Oracle9i was released on Oracle Open World in October 2000, introducing many new features for Oracle databases, application servers, and development tools. Oracle9i is the industry's first complete and simple software infrastructure for a new

Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4 I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC

Status of all instances and services $ Srvctl status database-D orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2 Status of a single instance $ Srvctl status instance-D orcl-I orcl2Instance orcl2 is running

Summary of Common commands used to execute scripts in oracle databases and common commands used in oracle 1. Execute an SQL script file The Code is as follows:Sqlplus user/pass @ servicename OrSQL> start file_namesOrSQL> @ file_name  We can save

Created: Article attributes: original Article submission: T_Torchidy (jnchaha_at_163.com) Oracle web Environment Injection Technology## BY Jianxin# Http://www.loveshell.net/# Preface I am not a professional database administrator, nor a researcher

[Oracle entry series] Chapter 2 _ Oracle entry-v512 workshop Editor: Xuan Yu Install Oracle Oracle service   Send me an email Uninstall Oracle Oracle terminology V512 Studio Basic oracle tools Oracle