access control

ORACLE of the two concepts: user, and the difference between schema and contact

Today, the official ORACLE re-read the document "concepts", read the schema of the basic concepts of the understanding of its mode for even the official documentation on the schema like this explanation: "A schema is a collection of da ...

ORACLE instance startup and shutdown

Instance starts through three modes: rn NOMOUNT MOUNT OPEN rn -------------------------------------------------- ------------------------------ rn Read the parameter file, the background process, database structure, access control, attach the file to ...

Oracle10203RAC Environmental Remove node (3)

In front of several articles describes the Oracle 10203 for Solaris sparc pairs of nodes in a RAC environment, add a node process. Described here to delete node operation. This is a description of the update Oracle software environment. Oracle10203RA ...

ORACLE 10gR2 RAC upgrade to 10.2.0.4-(2) installation of clusterware patch set

Second, install the clusterware patch set First, in order to oracle user logs on to Windows interface (If the root user su to the oracle after landing, then the next, pay attention to set the environment variable DISPLAY, or in the implementation of ...

Redo log files related to operation

5. Increase the redo log 1. Increase the log group When the warning paper appeared checkpoint not complete, it should increase the log group. Increase the log group is intended to ensure that the DBWR process and the ARCH process will not impede the ...

ORACLE database of the Chinese Academy of Sciences summed up video tutorial

rn Three default user and password: sys change_on_install [as sysdba] system manager scott tiger Start: Listener: lsnrctl start Database instance: oradim-startup-sid orcl Landing: sqlplus / as sysdba Create a user: create user lisi indentified by lisi; Sy

Practical Skills: xhost settings in Linux under the method steps: Display settings

The first step: using root login linux, start vnc service; The second step: In accordance with the vnc port, set export DISPLAY = localhost: 1 (1 that the first tty in vnc on start), vnc startup information see Annex 1; The third step: the implementa ...

RAC student guide of the Chinese notes

RAC student guide of the Chinese notes Rac student guide 1. Architecture Cluser hardware structure Nodes, interconnect, shared file system Nodes A node is a server that can also be smp numa in a cluser, you need two or more nodes. Each node supports a rac
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments