Oracle

View cluster node status The command is olsnodes.-I displays the VIP for each node,-N Displays the number of each node in the RAC cluster-P Displays the private IP address used by each node-S shows the status of each node (activive or inactive)

As a result of this experiment, I will copy the last virtual machine directly, and then install the graphical interface inside the Oracle to delete, re-install again, so here to modify some configuration. The first thing to change is our IP

Oracle 11g RAC CRS process restart times wrong1 The above error occurred while creating a RAC clusterDelete the/etc/oracle/scls_scr/rac1/oracle/cssfatal file on the Node1 machineRun/u01/app/grid/product/11.2.0/grid/root.sh2 The above error occurred

ExportExp Username/[email protected] File=db.dmpImportImp username/[email protected] file=h:\db.dmp full=yNote: Before importing, please clear views, sequences, TablesYou can also export using the bat fileThe contents of the bat file are as follows:@

Implementation results:For example, the following data[PHP]GroupID PersonID Name1 a Super Admin2 B Administrator2 C Testers3 A Super Admin4 B Administrator5 B Administrator5 C Testers5 a Super Admin5 D Leadership6 C Testers6 B Administrator7 A Super

http://www.cnblogs.com/opaljc/archive/2013/04/09/3009898.html Outer connection has the following three kinds (generally no left, right, full and other keywords are internal connection): 1. Left OUTER join (based on left table table, left table full

http://zhanghong.iteye.com/blog/8659371. Create a database table firstSql> CREATE TABLE Customer (2 ID Number (8) NOT null primary key,3 name VARCHAR2 (20),4 Age Number (3),5 gender VARCHAR2 (8)6);2. Create sequence:Create sequence customer_sequence

In Oracle, sequence is the so-called serial number, which is automatically incremented each time it is taken, and is typically used where serial numbers need to be sorted.   1, create sequence   you first have to have create sequence or

The Oracle Replace function replaces a value in a string with a different value.For example, you can replace each occurrence of a letter with a matching number. The format of REPLACE is as follows:REPLACE (char, search_string [, replace_string]) if

Note: This article is original article, reproduced please indicate the source:http://blog.csdn.net/msdnchina/article/details/38435999First, confirm what FGA audit strategy,From the SELECT * from dba_audit_policies you can query the audit policy,

ORACLE database space bare device is out of the problem, startOracle failure, workaroundProblem phenomenon:StartOracle reported the following error:Database mounted.Ora-01122:database File 6 failed verification checkOra-01110:data file 6:

FGA audits have these features:This article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/384090571.select * from Table_xxx where 1=2--the statement is not audited into dba_fga_audit_trail,

Use of the To_date () function in a 1.Oracle database: Insert a record into the EMP table:Sql>InsertInto EMPValues1234,‘Lizelu‘,‘BOSS‘,1234,‘1980-12-06‘,10000.0,0,30);InsertInto EMPValues1234,‘Lizelu‘,‘boss " ' 1980-12-06 ", Span style= "color: #8000

Oracle establishes tablespaces and usersSteps to establish a tablespace and User: Create user username identified by "password"; authorization: Grant create session to username; Grant CREATE table to username; Grant create

An error occurred while deleting the temporary table empty ora-25152. Deleting a temporary tablespace or shrinking a temporary tablespace often results in table space occupation. Next we will handle this situation, First, find the locked sid:SELECT

ORA-27102: handling of outofmemory errors Problem description: Originally, SGA 4G and PGA 2G. Alter system set sga_max_size = 30G scope = spfile; Alter system set sga_target = 30G scope = spfile; After, SQL> shutdown immediateDatabase

Oracle Database In-Memory: breaks through the row and column restrictions to achieve real-time analysis Two weeks ago, Oracle released Oracle Database In-Memory globally. Oracle Database In-Memory will be provided as an optional accessory for

Oracle 11g Set User Password case sensitivity test, oracle11g The 11g password is case sensitive by setting a parameter. The following is an experiment: C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_test@10.10.15.25 _ ggSQL * Plus:

Oracle checks the locked table and the locked process, and kills the process. oracle -- 1. view the locked table SELECT p.spid, a.serial#, c.object_name, b.session_id, b.oracle_username,b.os_user_nameFROM v$process p, v$session a, v$locked_object b,

View and modify the maximum number of connections in ORACLEZookeeper Step 1: On the cmd command line, enter sqlplus Step 2: Enter the user name and password as prompted 1. view the processes and sessions Parameters SQL> show parameter processes NAME