server dedicated

Handle irregular Oracle listening exceptions Environment:Operating System: SunOS 5.10Database Version: Oracle RAC 11.2.0.3.0There are two databases on the host, with node 1 of a RAC located on the host, and another database. The reason why the

Do you know what is standby installation? This very advanced application technology will be explained by me very much. Where is standby's NB installation, next I will go to the infinite fields of standby installation and install oracle 10G with

Recent production database to modify the production user's password, due to user password modification, the creation of dblink between the libraries is invalid, need to rebuild. On the production of a look at Dblink is really a lot, and who built

Tag: TNS try post message limit error triggers journey threadAfter the Dataguard has upgraded the CPU. found that the main repository can not be synchronized, the log error. Therefore, after the upgrade of the main library runs, the post-script

The 3 files Listener.ora, Tnsnames.ora, and Sqlnet.ora are the 3 primary files for the configuration of the Oracle network, where Listener.ora is associated with the database server side, and Tnsnames.ora and Sqlnet.ora these 2 files are not only

I. Official website descriptionWhen we built the DBCA, we were prompted to choose the connection type, there are two types: Dedicated server mode and shared server mode. Private mode is used by default. Such as:The Oracle official documentation

Listener. ora, tnsnames. ora and sqlnet. ora files are the three main files related to oracle network configuration, among which listener. ora is related to the database server, while tnsnames. ora and sqlnet. ora files are not only related to the

Migrate a single oracle instance to RAC through dataguard One instance primary to RAC standbyDataGuard Configuration:     Primary Standby Clusterware Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit 11g R2

Oracle11gdataguard environment configuration Summary1. master database 1.1 parameter file initpowerdes. ora [oracle@oracle_master1 ~]$ cd $ORACLE_HOME/dbs[oracle@oracle_master1 dbs]$ vim

When the client connects to the oracle database through the network in the form of "connect user name/password @ connection string", the listener needs assistance. After the connection is established, even if the listener fails, the established

RedHat build physical Data Guard My environment: Both machines are Red Hat Enterprise Linux Server release 5.4 Database Version: Oracle10g10.2.0 Install oracle software on the primary machine and create the database orcl Only the oralce software is

Create | data | database To create a physical standby database View some information about the primary database and configure the primary database before creating a physical standby database. Place the primary database as force logging mode.

　　SQL Server is a sensitive repository for organizations, and managers need to ensure that only authorized users can access this sensitive information. However, it is not easy to make SQL Server configuration secure without generating an error, and

Active Database DuplicationBrief introduction---------The Active database duplication feature is a new feature introduced from 11g that compares the backup set-based replication database functionality in previous versions.The following is a brief

oracle10g R2 "rac+asm→ Single Instance FS"TenG R2 rac+asmà Single Instance FS DG, it is recommended to disable OMF.Environment used in this demo case: Primary Standby OS Hostname Node1,node2 Std

Customer requirements to build a test library, now the environment is the window under the Oracle RAC, use can use import export best, but currently is the archive mode, using import export is too risky, there is not enough space on the Rman backup

oracle11g R2 "rac+asm→ Single Instance FS"Oneg R2 rac+asmà Single Instance FS DG, it is recommended to disable OMF.Environment used in this demo case: Primary Standby OS Hostname Node1,node2 Std

oracle10g R2 "Single Instance fs→ Single Instance FS"Environment used in this demo case: Primary Standby OS Hostname Pry Std OS Version RHEL5.8 RHEL5.8 DB Version

Groupadd OinstallGroupadd dbaGroupadd OperGroupadd AsmadminGroupadd ASMDBAGroupadd AsmoperUseradd-g oinstall-g dba,asmdba,asmadmin,asmoper GridUSERADD-G oinstall-g DBA,OPER,ASMDBA Oraclepasswd gridpasswd

[ORACLE basics 2] I am not familiar with cross-server table data synchronization in oracle, but I am now scheduled to perform two database tables for Synchronous replication. I don't understand it. I can only start to study and create it. If you