Oracle 12CR2 version has been released for some time, and has been trying to test the installation of RAC, from last weekend to today for two weekends and today's time to finally put the RAC installed successfully. This records the configuration of the operating system during installation and some of the pits encountered during installation.
1, the first is the operating system selection problem,
Oracle 12C has been released... Next I will learn about silent installation and configuration of Oracle 12C and the example users.
Installing Oracle 12C in Linux-6-64
New Features of Oracle 12C: Paging Query
12 new features of Oracle
Oracle 11g Dataguard Duplicate physical standby configuration (i) Create configuration for physical repositories
# ver:1.5 Fifth time modified
# modify:2013.8.16
# Author:koumm
Description
The installation of this article is configured with Oracle 11g Dataguard to create a physical repository in duplicate mode.
T
compatibility, you can also use the Alterdatabase command to modify:CONN [email protected]ALTER DATABASE DEFAULT tablespace users;ALTER DATABASE DEFAULT Temporary tablespacetemp;Attention:Regardless of which method you use, it is important to ensure that container is correct before you modify it.--------------------------------------------------------------------------------------------All rights reserved, the article prohibits reprint, otherwise investigates the legal liability!Aboutdave:-----
I. Main Content
There are many factors that affect the performance of ArcSDE, but in the final analysis, there are two aspects: the configuration of Oracle and ArcSDE in the background. Oracle not only includes database component size definition, storage parameters, but also the initialization parameters of Oracle inst
1. After ODP. NET 10.2 is installed, its Net Manager and Net Configuration Assistant cannot be opened. After clicking the Start menu, there is no response.
My solution: uninstall ODP. NET 10.2 and reinstall ODP. NET. Pay attention to the following two points during installation: a) the installation directory should not contain null characters, such as Program Files. B) Select
10G RAC installation encountered the failed to upgrade Oracle Cluster Registry configuration, caused by the use of the DMM multipath software Device-mapper-multipath to trigger this bug.About the DMM multi-path software Device-mapper-multipath installation RAC, reference document Configuring RAW Devices (Multipath) for Oracle clusterware 10g Release 2 (10.2.0) on
The following articles mainly introduce Oracle installation, configuration, and SQL * Plus operation steps. I saw Oracle installation, configuration, and SQL * Plus operation steps on the relevant website two days ago, I think it's good. I just want to share it with you. I hope this will help you in your future studies
Tags: des style color os strong file IO problemThe last two days have been in for the installation of Oracle configuration monitoring can not be saved and then find a variety of solutions, and finally I actually configured it.Because of the lack of listening files, copy others into their own directory C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN Listener.ora,
In this paper, the configuration scheme of Oracle database is described in detail in several aspects.
All users connected to Oracle must execute two code modules:
Application or Oracle Tools: A database user executes a database application or an Oracle tool that emits SQL
In some cases, for example, you need to configure static registration for the listener. ora of the standby database when performing the upload uard operation.
In some cases, for example, the listener. ora of the standby database needs to be configured for static registration when data guard is used.
In some cases, for example, the listener. ora of the standby database needs to be configured for static registration when data guard is used.
1. listener. ora:
[
Label:1. What is TNS? TNS is part of Oracle NET, a tool dedicated to managing and configuring Oracle Database and client connections, and in most cases the client and database must be configured for TNS, but in rare cases, you can connect to an Oracle database without having to configure TNS. For example, through JDBC. If you connect to
One, Oracle NETconfiguration fileOracle NET is a software layer that supports conversions between different network protocols. Different physical machines can use this software layer to communicate with each other, specifically to enable remote access to Oracle.The Oracle NET configuration files include Listener.ora,tnsnames.ora,sqlnet.ora and Ldap.ora, and the
Tags: port control file family file from log file should oracle11g RTLOracle Windows Environment Requirementsoracle10g memory should be at least 512M, preferably 1GB or above;oracle11g memory preferably 2GB or aboveoracle10g and oracle11g must use an Internet browser to log in to ORACLE Database Enterprise Manager, and the best way to get HTTPS ports is to $oracle_home\install. The author of the computer is
Introduction to the three configuration files of ORACLE
Overview
In the oracle installation directory $ HOME/network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many people.
Sqlnet. ora is used on the oracle
Label:I. DB instanceFirst, you have to have a db instance that you can create without using the following tools:The database instance created is as follows:Two. Server-side listener configurationThe following database configuration listener is configured to listen for connection requests made by the client to the database server side:Open the server-side net Manager, listener
The following is a test on how to configure the db console in Oracle 10 Gb. EM is usually used too much and is not familiar with it.
Test environment: OS: SOLARIS 10, DB: 10.2.0.1
1. EMCA Creation
$ Emca-config dbcontrol db-repos create
Started emca atDec 22,201 2 12:30:09
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003,200 5, Oracle
network.
Prerequisites for direct connection:
If it is Oracle and the client directly connects to the server database, the Oracle client program must be installed and configured. Install the oracle client and configure the connection under Net Manager.
Directly Connected parameter
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.