connect access to oracle 11g

Dataguard is an important solution officially recommended by Oracle for the MongoDB architecture. Currently, RAC + Local federation uard + Remote Federation uard has become a common HA architecture in the industry. Switchover and failover are the most common operation scenarios for RAC and replica uard.Failover is an unplanned switchover action. Generally, the Primary database Primary has a hardware and software fault. If you cannot continue to provid

a new administrative task in the Maintenance window. Access Counsel (Access Advisor) 11G's access advice can give zoning advice, including recommendations for new interval partitions (interval partitioning). An interval partition is equivalent to an automated version of a range partition (range partitioning), and she can automatically create a partition of the

Service, global memory services) and the Enquenceservice process management use the data Block synchronization interconnect between cluster nodes.Here are some questions to consider: The block is not read in all instances, and when the first instance reads, what is the lock, plus what lock? If there is another instance to read this block at this point, almost at the same time, then how can Oracle arbitrate, how to get one read, and the oth

11g: Download Oracle 11g for Linux (x86, 32-bit ).Don't rush to decompress it. I will tell you where to decompress it later.Step 3Modify the default settings of X server.System-> Administration-> Login Window(System-> Management-> logon window), select the "Security" tab, and deselect the "Deny TCP connections to the Xserver" check, restart Xserver (or restart t

only applicable to SYS users. Iii. Oracle 10g, 11g and dblink As described above, we can see that the password verification policies for Oracle 10g and 11G are different. Therefore, if dblink is created between libraries of different versions, the password will become a problem, the password may be incorrect. The spe

Database 11G RAC cluster installation (vii) ORACLE ENTERPRISE LINUX 5.7 Databases 11G RAC database installation (eight) Basic test and use of database 11G RAC under ORACLE ENTERPRISE LINUX 5.7 (ix) Cache Fusion principleThe background process for RAC has been d

logfile;(Db1) SQL> select max (sequence #) from v $ archived_log;MAX (SEQUENCE #)--------------12(Db2) SQL> select max (sequence #) from v $ archived_log;MAX (SEQUENCE #)--------------12 It can be seen from the above that the log is successfully switched and the logging uard is running normally. 11. Master-slave switchover test:Db1 --- primary/db2 --- standby = db2 -- primary/db1 -- standby [Oracle @ db1 ~] $ Lsnrctl stop(Db1) SQL> alter database com

DbconsoleEmctl Start DbconsoleGo to the browser again to refresh the EM, found that the button is no longer garbled5:1521 11,582 ports not open cause other machines to access the Web control side and not connect to OracleReference: http://blog.csdn.net/jemlee2002/article/details/70429916:kdump failed to startIn a desktop environment, deactivate Kdump directly7 Common operation methods and commands (for Lin

. Step 2 Downloads Oracle 11g:download Oracle 11g for Linux (x86, 32-bit). Now do not rush to extract, a while I will tell you where the decompression. Step 3 modifies the default settings for x server, the system-> Administration-> Login window for the Point menu, the Security tab, and cancel the Deny TCP connections to the Xserver (Deny TCP connection to x serv

SQL> set autotrace on; Sesql SQL> select count (*) from Dave; Count (*) ---------- 300000 Execution Plan ---------------------------------------------------------- Plan hash value: 1718719579 ------------------------------------------------------------------- | ID | operation | Name | rows | cost (% CPU) | time | ------------------------------------------------------------------- | 0 | SELECT statement | 1 | 7421 (1) | 00:01:30 | | 1 | sort aggregate | 1 | | 2 | table