oracle 11g tutorial

How to fix the standby database after ORACLE 11G replica uard Failover, and restore uardfailoverProblem scenarios after failover:Due to the failover test, a standby database has been changed to the primary database. How can I change this new primary database (the original standby database) back to the standby database?Both are primary, p1, and p2. How can I set one primary database 1 to p1, And the other pr

authentication delay Ah, will be stuck in the database, the user is not connected up. Go to block the password delay verification: sql> ALTER SYSTEM SET EVENT = ' 28401 TRACE NAME ' CONTEXT FOREVER, Level 1 ' SCOPE = spfile; System altered. Sql> create Pfile from SPFile; File created. Sql> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Sql> startup

How to export an empty table in Oracle 11g Because of the new features created by the delay segment of Oracle 11g, Oracle does not allocate data segments when there is no data insertion, leading to exp being unable to export the empty table of the

The Oracle installation and configuration process is closely related to the operating system, storage, and network. Especially in Linux and AIX environments, the configuration process is relatively complex. A link error may cause a series of faults in the future.In addition, the steps and methods for executing the same installation project vary greatly with the Oracle version. For example, Data Guard has th

In the 64-bit Windows 8 Enterprise Edition environment, we connected the oracle11g server for two days. We will share the process for your reference. Local Environment: 1. SERVER: Oracle 11g R2 64-bit, installation path E:/org12 Download: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html 2. Client: (1) Instant Client, lightweight, installation path E:/oracle11/Clie

Install oracle 11g in RHEL6.2 x86_64By Gong ChangyuIf you encounter any problems during the installation process, you can discuss them and learn together. If there are any errors, please let us know. Thank you.1. First modify the/etc/sysctl. conf file to add parameters.[Root @ redz-server ~] # Cat>/etc/sysctl. conf > # Oracle need parameters> Fs. aio-max-nr = 104

then press ENTER. As soon as the installation is complete, you will be prompted to execute 2 shell scripts with root privileges. Perform/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh and/home/oracle/orainventory/as indicated by their pathOrainstroot.sh, there will be a message when the installation is complete. Execute command: CD /home/

open;Six check to see if it takes effectSelect Archiver from V$instance;alter system switch logfile;Ls/oracle/archive3) Configure delay segment creation offalter system set DEFERRED_SEGMENT_CREATION=FALSE;4) Change Password default policyAlter profile default limit Password_life_time Unlimited--=========== 7: Test port# # Test 1521 and 22 ports availableYum-y Install TelnetTelnet 10.1.1.74 1521SSH [email protected]--=========== 8: Other configuration

In Oracle, various components (listeners, database instances, and various configuration tools) are installed and run with Log and Trace files generated. Before Oracle 11g, the information was scattered in the Oracle component directory. At 11g,

Environment: RHEL 6.4 + Oracle 11.2.0.4 1. Copy missing files 2. Compiling bbed 3. bbed Use test Reference 1. Copy missing filesThere are a few related files missing in 11g, but we can actually copy the relevant files from 10g to 11g corresponding directories:$ORACLE_HOME/rdbms/lib/sbbdpt.o$ORACLE_HOME/rdbms/lib/ssbbded.o$ORACLE_HOME/rdb

Oracle 11g change log group size Oracle 11g change log group size 1. Create a New log Group 1. alter database add logfile group 4 ('/u01/app/oracle/oradata/jian/redo04.log') size 1024 k; 2. alter database add logfile group 5 ('/u01/app/o