server dedicated

Oracle Data Guard (2) Physical Standby 1. check whether the Primary database is archivelog mode SQL> select log_mode from v $ database; if the result is not "ARCHIVELOG", run the following command: SQL> shutdown immediate; SQL> startup mount; SQL>

ORA-12545 Errors often occur when a remote client connects to the RAC database over a uniform service name. After querying METALINK, it was a small bug in Oracle. Environment: ORACLE11GR2RAC Database ORA-12545 Errors often occur when a remote client

[Oracle] Data Guard-Create physical Standby experiment environment Primary: Host: jabdw1241SID: O01DMS0DB_UNIQUE_NAME: O01DMS0Standby: Host: jabdw1242SID: O01DMS0DB_UNIQUE_NAME: O01DMS0DR 1. primary configuration and operations 1) confirm that

Brief Introduction to Oracle TNS  What is TNS? TNS is a part of Oracle Net. It is a tool used to manage and configure the connection between the Oracle database and the client. In most cases, to communicate with the database, TNS must be

Oracle 11g slave uard Duplicate physical standby database configuration (1) physical standby database creation Configuration# Ver: 1.5 fifth Modification# Modify: 2013.8.16# Author: koumm Read more: Configure Oracle 11g replicuard test and create a

In some specific circumstances, sometimes you need to connect to the specified instance in RAC from the client, instead of dynamically selecting the client Load_balance or forwarding the server listener Based on the load situation. In this case, you

I. Software Download and environment configuration 1. download the software to http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html download the following three packages: Current address: Copy to c: \ instantclient_10_

 I haven't figured out the swap dedicated for sharing, found this article http://blog.csdn.net/tianlesoftware/archive/2010/06/26/5695784.aspx , Let me practice, indeed understand a lot. Most of the following links are converted from this link. You

Environmental Status:Two virtual hosts A and b:1. A machine has installed ASM storage for Oracle 11g instance reference: HTTP://WWW.CNBLOGS.COM/JYZHAO/P/4332410.HTML2. b machine installed system, configuration and directory structure are consistent

oracle11g R2 "Single Instance fs→ Single instance FS"Environment used in this demo case: Primary Standby OS Hostname Pry Std OS Version RHEL6.5 RHEL6.5 DB Version

DatabaseListener.ora# Listener.ora Network Configuration file:c:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener = (sid_list = ( Sid_desc = (sid_name = Clrextproc)

has not been dedicated to share the interchange to find out this article http://blog.csdn.net/tianlesoftware/archive/2010/06/26/5695784.aspx, let me practice a, do understand a lot. Most of the following are transferred from the link, the collection,

Linux under oracle11g DG Build (III): Surround Standby Library construction operationsEnvironment Name Main Library Standby Library Host Name Bjsrv Shsrv Software version number

Dataguard provides support for high availability of enterprise data, data security, and disaster recovery, typically consisting of a dataguard configuration of a primary db with several physical or logical standby db.System environmentOperating

Database version: 11.2.0.4Server version: RedHat6.4Main Library Primary: Installing database software and examplesStandby standby: Install only database softwareFirst, the pre-erection of the main standby storage environment:Main Library

Linux under oracle11g DG Build (iii): Around the standby library to build operationsEnvironment Name Main Library Standby Library Host Name Bjsrv Shsrv Software version RedHat

This is the first article on my Blog. It was already a document I wrote a year and a half ago. At that time, it was very hard to implement a project, from knowing DG to implementing it, everything is fresh, and everything needs to be checked.

ORA-12523: TNS: Listeners cannot find routines for client connection, ora-12523tns Today, when you connect to a new test server using PL/SQL Developer, you encounter a ORA error: ORA-12523: TNS: The Listener cannot find a routine for client

Environment Description:Main Library: ip:10.143.183.31 sid:primary1 establish GI, ASM, Oracle database software, Oracle databaseLibrary: ip:10.143.183.33 sid:standsty1 build GI, ASM, Oracle database software, no need to build Oracle databaseASM Disk

C # The string connecting to the Oracle database is as follows: Data Source = gdbzh; user id = zhangf; Password = guangy; It should be pointed out in particular what is the value of data source and where to obtain it (the last two can be seen