oracle 11g book

Why cannot I enable ADG for Oracle 11g slave database? Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby database was in the mount stage. This was a 11gR2 database, and it was a waste of time without ADG. I felt too much to do this.So I tried to start the open stag

After installing the OEM grid control 11g, reinstall the agent on a monitoring server and the agent will not be able to work. The error "EMD upload error: uploadXMLFiles skipped" will be reported during the emctl upload check ". As follows: [Oracle @ codb2 ~] $ Emctl upload Oracle Enterprise Manager 11g Release 1 Grid

Listener.log log for this time period of the Oracle server to see what causes the lock.6.6 Unlocking Database UsersUnder SQL input: Alter user username account unlock;Note: This command can only be performed by a user with DBA authority.6.7 User Profile 6.7.1 action User profile effective switchView: Enter in sql: Show parameter resource;Name is the value of the corresponding value column of the Resource_limit row, and True indicates on, false to clo

This article mainly describes which services are Oracle 11g must be opened and detailed introduction of these services, the need for friends can refer to the followingAfter successfully installing the Oracle 11g database, you will find that your computer is running slower, that your computer is running faster with a lo

Oracle 11g client Configuration First download several compressed packages from OTN For: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html Then select different downloads based on your platform. I installed them in rhel5, so I chose Linux x86 and downloaded the following two packages: Instantclient-basic-linux32-11.1.0.7.zip basic package that provides OCI, occi and JDBC-OC

If you need to install more database servers, it is still very slow and cumbersome to install the database software graphically. Oracle 11g provides a way to clone the installation.The steps are as follows: Use the normal method to install Oracle on Server A. Pack the $oracle_home on the A machine, db_home1.zip. Prepare the environment of B machi

or ASM. Block devices and bare devices will no longer be supported in Oracle12. Oracle strongly recommends using at least 3 voting disks in a different location. When using ASM to manage voting disks, you need to be aware of the redundancy levels of disk groups and failure groups. Note that all copies of voting disk are in one disk group, and you cannot distribute voting disks across multiple disk groups. When using an externally redundant disk group

Two test samples were made in the art of simulating Oracle performance diagnostics. The book says not to bear relies_on. Cache (Result_cache relies_on (test1,test2)). The test proved incorrect, and the function F1 () did not use relies_on, but the changes on the table affected the function. C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday

Oracle 11g's dependence judgment reaches the field level, oracle11g In Oracle 10 Gb, the dependency only reaches the object level. That is to say, once the object accessed by the Stored Procedure changes, Oracle sets the stored procedure to INVALID. Therefore, after you perform DDL operations on the table, you need to re-compile the stored procedure. In

/opt/oracle/product/OraHome# Chown-R oracle. dba/opt/oraInventory# Chown oracle. dba/var/opt/oracle# Chmod-R 775/opt/oracle# Chmod-R 755/var/opt/oracleSet oracle environment variables# Su-orac