Install Oracle 11g R2 and oracle11g in Redhat Linux
Official documents: http://docs.oracle.com/cd/E11882_01/nav/portal_11.htm
1: Basic Environment
Redhat Enterprise Linux 6.132bit
Memory: 1 GB
Disk Space: 30 GB
2: Check the packages required for Oracle 11G. If the packages are not found on the Redhat Enterprise Linux 6
Oracle 11g ASM: how to create an Oracle ACFS file system experiment environment in ASMCMD command line tool: Oracle 11g R2 RAC (11.2.0.3.5) oracle Enterprise Linux 5.6x86 1. Create an ASM disk group and mount the disk on two nodes
I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and delete the old user! Next we will introduce this new feature in the 11g rac environment!
1. Create a test user xxx and
Fault symptom Oracle Database 11g Database common user login prompt ORA-28002: the password will expire within 7 days[11: 01: 00oracle @ dvd db_1] $ sqlplus wang/oracleSQL * Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012Copyright (c) 1982,200 9, Oracle. All rights reserved.ERROR:ORA-28002: the password will expire within 7 daysConnected:Oracle Da
Oracle-validated RPM for oracle Linux
(Skip this part for your reference)
Because the Database requires some software packages, software package versions, and Kernel Parameter fine-tuning, You need to configure the operating environment in advance before installing Oracle Database 10g or 11g on the system. (Be sure to
Oracle 11G R2 replicuard construction in CentOS 5.11
Datagard is a disaster tolerance solution for Oracle Enterprise Edition. It is widely used in enterprises and I will record the setup process for backup.Host Name database version Instance name IPDb1 Oracle 11G R2 member 1
1. OverviewThe Oracle EM11g database needs to be migrated. The main steps are as follows:
1. Disable OMS
2. Back up the current database and restore it to the new server.
3. Update OracleEM OMS database connection Configuration
4. Start OMS
This operation method is also valid in Oracle EM 12c.
2. ProcedureStep 1: Disable OMS
Find the emctl tool in the bin where OMS is located and disable the OMS service.
/U
Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the handling process records.First, extract the installation package and generate a client directory. When runInstaller is run, an error is reported. The error is as
Database partitioning is one of the key functions required by each database. Almost all Oracle databases use the Partition Function to improve query performance. The Oracle 11g Partition Function simplifies the daily management and maintenance of the database, greatly reducing the DBA (Database Design and Management Engineers).
The new features provided in
Startup Mount Tip: Oracle routines are startedTotal System Global area 118255568 bytesFixed Size 282576 bytesVariable Size 82886080 bytesDatabase buffers 33554432 bytesRedo buffers 532480 bytesDatabase loading complete ALTER DATABASE open;Tips:An error occurred on line 1th:ORA-01157: Unable to identify/lock data file 19-see DBWR trace fileORA-01110: Data file: "' F:/llh/bookspace. DBF ";This hint file section is somewhat different depending on the c
Tags: 3.1 environ rpm package conf linu for file upload bit enter Ability to download: http://download.csdn.net/detail/ykh554541184/8086647 Documents for easy access Official Document: Http://docs.oracle.com/cd/E11882_01/nav/portal_11.htm 1: Basic Environment Redhat Enterprise Linux 6.132bit Memory: 128GB Disk space: 600GB 2: Check the required packages for Oracle 11g, assuming they are not found on the Red
Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: oraclememorytarget
Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux:
[oracle@hosta ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.1.
Label:Under the Linux operating system, the increase in Oracle DB 11g Memory_max_target and Memory_target should be noted: [[emailprotected] ~]$ sqlplus/as sysdba sql*plus:release 11.1.0.7.0-production on Tue Jul 01:12:24 Co Pyright (c) 1982, D, Oracle.
All rights reserved. Connected to:oracle Database 11g Enterpris
Oracle's latest database products began to enter beta status at the end of last year, with Oracle releasing hundreds of feature improvements in the initial beta release. As one of the world's largest market share database products suppliers, Oracle's new version of the product can be described with great attention, currently can be determined that the name of this product will be Oracle
Tags: rhel, rhel 5.8, Oracle, Oracle 11gFirst, prefaceRecently to prepare for the exam, ready to review the knowledge of Oracle database, then the premise of learning Oracle is definitely deployed, the current mainstream Oracle version is
Recently, the company has changed the computer, and the 10 Gb memory is still quite powerful. First, the Oralce runtime environment is installed on the local machine. I thought it would be very smooth, but there were still some minor problems, record it and help you sort it out. It is also the beginning of the blog. I remember the first time I installed Oracle on Linux, I did not know how many days I had to spend, the installation package was incorrec
Before Oracle 11g, we can create pfile from spfile or use pfile to create spfile. In Oracle 11g, spfile management is enhanced. You can use memory to create pfile and spfile.
Syntax:
Create pfile [= 'pfile _ name']
From {spfile [= 'spfile _ name']} | memory };
Create spfile [= 'spfile _ name']
From {pfile [= 'pfile _
Before Oracle 11g, we can create pfile from spfile or use pfile to create spfile. In Oracle 11g, spfile management is enhanced. You can use memory to create pfile and spfile.
Syntax:
Create pfile [= 'pfile _ name']
FROM {SPFILE [= 'spfile _ name']} | MEMORY };
Create spfile [= 'spfile _ name']
FROM {PFILE [= 'pfile _
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.