Why cannot I enable ADG for Oracle 11g slave database?
Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby database was in the mount stage. This was a 11gR2
Tags: size reliable moderator large online benefits audit security soft
High reliability. The ability to place server failures, site failures, and human errors wherever possible.
High security information. Data security and compliance can be ensured with a comprehensive meeting of row-level security, fine-grained auditing, transparent data encryption, and data.
Better data management. Easily manage the entire lifecycle of information for the largest
Installing Oracle 11g R2 in LinuxI. installation environment
Linux Server: CentOS 6.4 64-bit
Oracle Server: Oracle 11gR2 64-bitIi. System Requirements
Requirements for installing Oracle in L
the Oracle user on the graphical interface. First copy the downloaded Oracle installation package to Linux, and we recommend copying it with Xmanager or other FTP tools.Open a terminal and run the unzip command to extract the Oracle installation files, such as:
Enter the command:Unzip Linux.x64_11gR2_d
name.
Simple command description about vi: After you enter vim/home/oracle/. bash_profile to create a configuration file, you must press I (enter insert mode) to add and modify the file.
After modification, Press ESC and press shift +: And enter wq to save and exit.
In addition, if you directly copy the preceding variables from a windows system file to a linux configuration file, run the vi command to ope
security of the database, once lost, it is difficult to find back. Therefore, it is hoped that through the establishment of database clusters, the redundancy of the data set, the backup data to ensure security. Classification of database clusters
Database cluster technology is a technology that combines multiple serve
This article mainly describes the installation of Oracle 11gR2 (11.2.0.3) under Oracle Linux 6.3. Starting with Oracle 11g, the Oracle website no longer provides download links to its patches and requires a Meatlink account to dow
In the use of Oracle databases, Backup recovery is the most critical. When the database fails, it can be restored in a timely manner to reduce unnecessary losses. Next I will briefly introduce the import and export of databases, solutions, tables, and the role of things in the Process of use.1. Export data tables[Oracle @ CentOS ~] $ Exp scott/system tables = t f
My linux version is centos5.5 and the kernel version is 2.6.18-194. el5. in linux, it is best to install the oracle System with 1 GB memory and 2 GB swap space. The hard disk requires at least 4 GB space.1. Download oracleGo to the oracle official website to download the corresponding version of
variable settings ld_library_path and Tns_admin point to the extracted directory, you can use Sqlplus.I downloaded the instant client version number 10.2.0.2.0 and tested the connection to Oracle 9.2.0.4 and Oracle 10.2.0.1.Instant client does not include tnsping, Exp/imp, Rman, NETCA and other tools. If you need these tools, you need to install Oracle clientAss
Install Oracle 11g in RedHat Linux 6.0
Steps for installing Oracle in Linux
Preparations before installation
Transmit oracle to the root directory through ssh (this installation is under VMware)
Installation Package for
Install Oracle 11G Release 2 (11.2) on Centos Linux 7This article presents what to install the Oracle 11G on Centos Linux 7.read following article How to install CentOS Linux 7:install
use RedHat Enterprise Edition as the Oracle operating system. The latest version isRedHat6.1. You can choose 32-bit or 64-bit Linux based on the CPU architecture. Generally, the 64-bit version can manage larger memory and hard disk space, which should be the first choice for enterprise applications.Oracle 11g R2 database
, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The databas
Tags: Linux oracle System install Oracle 11g required installation package and related dependency package no softwareCat >>/tmp/rpm.txt Consolekit.x86_64Consolekit-libs.x86_64Consolekit-x11.x86_64Gconf2.x86_64Orbit2.x86_64Atk.x86_64audit-libs.i686Avahi-glib.x86_64Avahi-libs.x86_64Bc.x86_64Bind-libs.x86_64Bind-utils.x86
With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer:
Oracle RMAN compatibility and FAQs between different versions and different platforms
This article demonstrates an example of restoring 10 Gb to 11 GB in linux.
Target end:
The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered th
As we all know, it is not easy to migrate a database from a higher version of Oracle to a lower version of oracle. If you directly use the SQL developer tool, you may not be able to complete the migration successfully (errors may occur more or less in the middle ).
Exp and IMP are applicable to Oracle data copy and bac
Delete Oracle 11g R2 in Linux 6.4
Close DatabaseSQL> shutdown [immediate]
Stop Listener[Oracle @ ora920 oracle] $ lsnrctl stop
If an application service exists, stop the application service first.[Oracle @ ora920
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.