CentOS Installation Oracle 11g R2Lab Environment:Linux server operating system: CentOS 5.5 32-bit (note: Please separate partition/data for installation of Oracle database during system installation)Linux Server IP Address: 192.168.32.130Oracle Database version: Linux_11gr2_
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp in the Development Library
Some ASP. NET + Oracle 11g learning and writing essays. This seriesArticleIt can help. net that is unfamiliar with Oracle and is not even used at all.ProgramStaff, can get started and develop applications in the shortest time, to avoid having to spend as much time as I did for the support team to flip books, Query files, create code for implementation and test, a
amp; Itemid = 687411 amp; typ = blogHttp://topic.csdn.net/t/20050428/09/3972494.htmlHttp://topic.csdn.net/t/20040510/17/3050699.htmlHttp://www.blueshop.com.tw/board/show.asp? Subcde = brd20050513132850f5h fumcde = fum20041006161839lrj rplcnt = 16
For example, set the sqlnet. ora file on the host where the Oracle server-side program is located:Sqlnet. authentication_services = (CNT)ChangeSqlnet. authentication_services = (none)
Sqlnet. ora is i
Oracle.sysman.emcp.EMDBPostConfig Invoke Warning: WARNING ************************ The management repository is placed in safe mode, in which Enterprise Manager data is encrypted. The encryption key has been placed in the file d:/app/10188535/product/11.2.0/dbhome/a23181215.z The Te.intra_dw/sysman/config/emkey.ora. Be sure to back up this file, because if this file is lost, the encrypted data will not be available. *********************************************************** Configuration of
One, Oracle 11g installationBefore installing to determine your own computer configuration, Windows as an example, if it is Win7 the following systems such as XP, you can select Oracle 10g. Because the program file of 10g only more than 200 trillion, and 11g and reached 2G, the specific file official download path has
" user./U01/oracle/product/11.2/db_1/root. shTo execute the configuration scripts:1. Open a terminal window2. Log in as "root"3. Run the scripts The cloning of OraDb11g_home1 was successful.Please check '/u01/oracle/oraInventory/logs/cloneActions2013-10-28_02-45-44PM.log' for more details.Run root. sh as the root user.[Root @ rac2 tmp] # sh/u01/oracle/product/11.
following options:
ASM This is the preferred storage option for Oracle and is the only configuration supported in the RAC Standard Edition
OCFS2
Bare devices are not recommended, not only because they are deprecated by the new Linux kernel, but also not supported in Oracle 11.2
Network File System (NFS)
The Red Hat Global file System is only supported in Red Hat and
Dg_broker_start
NAME TYPE VALUE
------------------------------------------ -----------------------------------
Dg_broker_start boolean FALSE
sql> alter system set DG_ Broker_start = true;
System altered.
Sql> Show parameter Dg_broker_start
NAME TYPE VALUE
-------------------------------------- ---------------------------------------
dg_broker_start boolean TRUE
Co
) (PORT = 1521)) (connect_data = nbsp; (SERVER = dedicated) (service_name = oracle.bak) ) oracle Home is the Oracle client path, mine is e:\oracle\instantclient _12_1,oci Library is e:\oracle\instantclient_12_1 \oci.dll. With these two things you should be able to access someone else's
Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary
1. Preparations before installation:
Operating System: RHEL6.5
Storage: Huawei, multi-path configured
Bind the business network card and heartbeat network card and pass the redundancy test.
YUM source configuration
BASH/SSL vulnerability patches
2. Check System Requirements
A. LINUX version
Cat/etc/issue
B. Memory (at least 1 GB)
Grep
Tags: 11g hand-built library Oracle 11gFirst step: Catalog-- Database Files directory$ cd $ORACLE _base/oradata$ ls-- When you see a library that already exists SIDPROD$ pwd-- Take a look at the absolute path/u01/app/oracle/oradata$ mkdir HYL$ ls-l-- production look at the d
wasn't restored from a sufficiently old backupOra-01110:data file 1: '/OPT/ORACLE/ORADATA/TPY100/SYSTEM01.DBF 'Is the standby monitoring is not open, using lsnrctl start, start monitoring, and then open the database will not error.sql> ALTER DATABASE recover managed standby database using current logfile disconnect fr
: IOException in reading Response: Connection reset"
The proxy cannot be canceled on the Interface operation. Therefore, we log on to the grid control database to directly modify the configuration information.
Use the mgmt_admin.cleanup_agent ('host: port') function to clear the agent.
The host and port values are obtained from the emctl status agent output information on the monitoring server.
The details are as follows:
[
This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and
Label:Selection:32-bit memory is a bottleneck, already 64-bit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In virtual machine installation, the network is set up by hostonly modeNote: Network adapter to set up ICS (Internet Connection Sharing) to the VMware network Adapter VMnet1So for virtual machines, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24 segmentHDD 40G, Memory 2G1
following options:
ASM This is the preferred storage option for Oracle and is the only configuration supported in the RAC Standard Edition
OCFS2
Bare devices are not recommended, not only because they are deprecated by the new Linux kernel, but also not supported in Oracle 11.2
Network File System (NFS)
The Red Hat Global file System is only supported in Red Hat and
Have always wanted to learn Oracle, but is the installation of Oracle has not been successful, people are very distressed, especially what listener what, has not understood, got a whole day did not get out, the Internet to find information on most of the information is uneven, not too detailed, and after the attempt has not been successful, Now through my careful modulation, finally installed successfully,
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.