OBIEE 11g BI Management tool connection OCI 10g/11g data source times wrong [connection failed] OBIEE 11g Client Admin tools Connection to Datasource in Offline Mode fails Wit H Error "The Connection has FailedUsing OBIEE 11g BI management tool to import metadata, when connecting the OCI 10g/
Oracle 11g Audit
The Oracle audit (Audit) function is used to monitor database operations performed by users. audit records can be stored in data dictionary tables (called audit records: SYS. in the AUD $ table, view dba_audit_trail)
Or operating system audit records (default location: $ oracle_base/admin/$ oracle_sid/adump.
Regardless of whether or not the data
Tags: command execution wget Restart Speed Hyper Fusion is open OGGOracle 12c was released for a long time, although several sets of single-instance Oracle 12c have been deployed in the near future, there has been no opportunity to implement 12c RAC in the production environment, of course, can not eliminate the existing 11g
the IP address information associated with the RAC database, for example:192.168.12.231 NODE-RAC1192.168.12.232 NODE-RAC2192.168.12.230 Node-vip1192.168.12.240 NODE-VIP2 (2) View service_names of the RAC Database [[emailprotected] ~]$ sqlplus "/as sysdba" Sql*plus:release 11.1.0.6.0-production on Sun Sep 22:05:53 Copyright (c) 1982, Oracle.all rights reserved.connected to:
The company just launched a set of Oracle 11gR2 RAC. When MEMORY_TARGET memory is set to 12 GB, an error is reported during startup:ORA-00845: MEMORY_TARGET not supported on this system00845,000 00, "MEMORY_TARGET not supported on this system"// * Cause: The MEMORY_TARGET parameter was not supported on this operating system or/dev/shm was not sized correctly on Linux.// * Action: Refer to documentation for
Label: five advantages and disadvantages of Oracle RACdifferent cluster products have their own characteristics, RAC features include the following points: dual-machine parallel. RAC is a parallel mode, not a traditional master and standby mode. That is, all members of the RAC cluster can receive client requests at the
based on a directly available OEL Template
Create an Openfiler VM
Configure VM
Reconfigure the rac vm as needed
ISCSI Optimization
Prepare for Oracle software installation
Set Oracle SSH user equivalence
ASMLIB Configuration
Oracle cluster Installation
The third node acts a
First, unpack the cluster kit;
Gunzip 10201_clusterware_linux_x86_64.gz
CPIO-IDMV
The place where the decompression is placed requires the permission of the Oracle user
Second, start installing the Oracle RAC Cluster Kit,
2.2.1. Shut down the two-node firewall before the installation, SELinux otherwise it cannot be installed by the
2.2.2. Modify the system
. This process is responsible for refreshing (refresh) its own local cache and the OCR cache for other nodes in cluster. For access to the cluster Knowledge Base, the OCR client accesses the local OCR process directly. When the client needs to update OCR, they interact with the process that plays the read-write OCR file through the local OCR process.OCR client applications are: Oracle Universal Installer (OUI), SRVCTL, Enterprise Manager (EM), DBCA, D
Recently, many employees who have installed Oracle 10g RAC on the RHEL 5.X platform do not have much difficulty, but repetitive manual work is still relatively high. Therefore, a semi-automatic installation script is compiled by the way.
Install operating system patches, create database users, and modify user configuration files.
Issues to be resolved:1. The host
/6303583 # Try to start ons successfully Oracle @ bo2dbp: ~> Crs_start ora. bo2dbp. ONS attempting to start' ora. bo2dbp. ONS 'on member 'bo2dbp 'start of 'ora. bo2dbp. ONS 'on member 'bo2dbp 'succeeded. # Author: Robinson # blog: http://blog.csdn.net/?son_06125] summary A. After migrating a virtual machine in the RAC environment, you must first change the path of all disks in the
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
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
Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device)
Because the customer's database needs to be patched, similar test environments are installed. You must first install Oracle RAC 10.2.0.1 and then upgrade it to 10.2.0.5. Because I have many articles about installation, this article only describes the key steps
CRS, and the client accesses the cluster just like accessing a server.2. CRS consists of two Cluster suites: Voting disk and Oracle Cluster Registry. Voting disk is the voting disk. each node in the cluster regularly evaluates its health status and puts its status information on the voting disk. In addition, the nodes view the running status of each other and pass the information to other nodes to write them to the voting disk. When a cluster node fa
The most outstanding performance of Oracle RAC clusters is high availability, which mainly includes load balance and failover. These technologies enable single point of failure (spof) to prevent normal access to the database by client applications, and load balancing between nodes by creating a service. This article describes the Oracle failover test in the
Routine basic maintenance commands for Oracle RAC
Status of all instances and services
$ Srvctl status database-d orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2
Status of a single instance
$ Srvctl status instance-d orcl-I orcl2Instance orcl2 is running on node linux2
The status of the global Naming Service in the database
$ Srvctl status service-d orcl-s orcltestServi
provides a wide range of management functions. To manage ASM instances, you must have SYSDBA permissions, you can use a new role (SYSASM) in Oracle 11g to manage the ASM instance only.1. Create an ASM instanceThere are two methods to create an ASM instance. The first method is to create an ASM instance using dbca. You only need to run Database Configuration Assi
Tags: Name service access RAC Cluster DBA span color Ted ResourceScan conceptLet's start with what is called Scan,scan (single client Access name), which was launched by Oracle from 11g R2, and the client can load-balance connections to the RAC database via the SCAN feature. Scan provides a domain name to access the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.