oracle dba commands

Common commands for oracle 11g RAC Management 1) Check cluster status: [grid @ rac02 ~] $ Crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online 2), all Oracle instances-(Database status ): [grid @ rac02 ~] $ Srvctl status database-d racdb Instance racdb1 is running on

.clear screenClear Screen2), File Operation command1.start and @Description: Run SQL scriptCase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptCase: Sql>edit D:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file.Case: Sql>spool d:\b.sql and input sql>spool offegSql>spool D:\b.sql;Sql>select * from EMP;Sql>spool off;3), interactive commands1.Note: You can overr

.exitDescription: The command disconnects from the database and exits the Sql*plus5.clear screenClear Screen 2), File Operation command1.start and @Description: Run SQL scriptCase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptCase: Sql>edit D:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file.Case: Sql>spool d:\b.sql and input sql>spool offegSql>spool D:\b.

.clear screenClear Screen2), File Operation command1.start and @Description: Run SQL scriptCase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptCase: Sql>edit D:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file.Case: Sql>spool d:\b.sql and input sql>spool offegSql>spool D:\b.sql;Sql>select * from EMP;Sql>spool off;3), interactive commands1.Note: You can overr

the line, and I bon Voyage installation success, there is no problem, really heart plug, do not solve the problem where the experience, but since the writing, first occupy a position, After the other machine installation encountered problems can continue to add. I use the win10 installed, here Point next, will report what: "[INS-13001] environment does not meet the minimum requirements" warning, as if the product is win10 after the come out, can not recognize, regardless, ignore continue to

.clear screenClear Screen2), File Operation command1.start and @Description: Run SQL scriptCase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptCase: Sql>edit D:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file.Case: Sql>spool d:\b.sql and input sql>spool offegSql>spool D:\b.sql;Sql>select * from EMP;Sql>spool off;3), interactive commands1.Note: You can overr

Label: use of the EXP and IMP commands of Oracle We usually import and export Oracle data, and before Expdb,impdb (10G), we use exp export, IMP command to implement the import. Open the cmd window, implement IMP,EXP is mainly SQLPLUS.EXE call Imp.exe,exp. EXE to complete the. Here are a few examples of commonly used EXP,IMP

Commands for adding log groups and log members in oracle 1. Adding a log group: alter database add logfile group 4'/oradata/oracle/oradata/oracle_sid/redo04.log 'size 100 M; 2. Change the log group size (First, check the archiving status: SQL> select group #, thread #, members, archived, status from v $ log; www.2cto.com GROUP # THREAD # members arc status ------

Oracle SQL * Plus is a client tool that interacts with Oracle. In SQL * Plus, you can run the SQL * Plus command and the SQL * Plus statement. The DML, DDL, and DCL statements we usually call are SQL * Plus statements. After they are executed, they can be stored in a memory area called SQL Buffer, in addition, only one recently executed SQL statement can be saved. We can modify the SQL statement stored in S

Common commands and functions of Oracle SQL * plus, oracleplus Common commands: Connect to sqlplusRun cmd in the command line to enter. For example, to log on in sys mode, the command is as follows:(1). sqlplus "sys/zhb126 as sysdba" (2). sqlplus/nolog connect sys/zhb126 as sysdba (3). sqlplus scott/tiger Start a database instance Startup -- start the control fil

/gravity /center ">Found two commands together, namely student and where are connected together. So when you use the a command to add a command to the buffer to hit two return, the first carriage return is a command must take the carriage return, the second carriage return is added as the beginning of the new code to the buffer, for example:Q: Suppose the buffer has 3 rows of SQL commands, you need to join

Common Oracle backup commands, oraclebackup 1. Set the backup tag 1. backup database tag = 'full _ bak1 '; Note: Each tag must be unique. The same tag can be used for multiple backups to restore only the latest backups. 2. Set the backup set size (all results of one backup set are regarded as a backup set. Pay attention to the backup set size) Backup database maxsetsize = 100 m tag = 'datafile1 '; Note: ma

How to run Oracle commands in SUSE Linux:Suid/guid:Non-Oracle users are required to run oracle commands such as sqlplus. Solution:If you want to set s u I d, set the one before the corresponding permission bit to 4; if you want to set g u I d, set the one before the corresp

SQL Introduction SQL supports the following categories of commands: 1. Data definition Language (DDL) 2. Data Manipulation Language (DML) 3. Transaction Control Language (TCL) 4. Data Control Language (DCL) Here are the detailed notes for these four SQL languages: Oracle learning note Three SQL life Order (ii): SQL Action Language category when you create a table for an

Tags: network services Super SQL script Pool parameter strong file Ora hangOne, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without t

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3), gene

/backup/rman/***.log ' unavailable Change Backupset Delete--Remove backup set 16 (sync Delete)Delete Expired backupset (Archivelog all); --Delete invalid Delete Expired--Deleting a failed backupDelete obsolete--delete backups older than the backup policy date (expired) --Recovery checkRestore database validate;Validate Backupset 218; Restore Database preview;Restore tablespace users preview;Restore datafile 5 Preview; --Command blockrun{2> shutdown immediate;3> startup Mount;4> Allocate channel

Label:One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3)

Label:1. Start the Oracle database:To switch to an Oracle User:[Email protected] ~]# su-oracleEntering the Sqlplus environment, the Nolog parameter indicates no login:[Email protected] ~]$ Sqlplus/nologLog in in Administrator mode:[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.3.0 Production on Fri Apr 17 10:13:07 2015Copyright (c) 1982, Oracle. A

Oracle SQL * PLUS commands 1. Common Oracle SQL * Plus commands (1) Environment commands SET command format: SET The SHOW command can display the SQL * Plus environment parameter values. (2) common functionsSQL> set linesize x SQL> SET PAGESIZE y SET the row width to X and t