ORACLE common dummies: Question 1000 (one)
Author: CCBZZP
When you use ORACLE, you may encounter many seemingly unexpected problems. specifically for new users, today I will simply sum up it, I hope it will help you! Explore with everyone and make progress together!
For ORACLE experts, it is not worth looking.
1. What
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 from scratch-20141208, 11g-20141208
Section 1.3.6
It is used to store all the data of an object with an independent storage structure defined in a tablespace. It consists of one or more zones.
1. Data Segment
Used to store all data in a table.
2. Index segment
Used to store all the data of an index.
3. Temporary Section
Used to store temporary
Windows 10 x64 installation and configuration of Oracle 11g process records (Graphic tutorial), Windows 10 11g
Note: I want to install an oracle exercise on my computer, but I am afraid of problems during the installation process, and oracle uninstallation is notoriously tro
)
RAC special problems and combat experience (V)
ORACLE one-to-G Version 2 RAC ready for use with NFS on Linux (vi)
ORACLE ENTERPRISE LINUX 5.7 under Database 11G RAC cluster installation (vii)
ORACLE ENTERPRISE LINUX 5.7 Databases 11G RAC database installati
1 start-> All Programs->oracle products->warehouse builder->administration->repository Assistant
2 in the Pop-up Repository assistant-welcome window click Next, and enter the following image page:
3 fill in the host name, Port number, and Oracle Services name (database service names), which we take ORCL for example, and click Next to go to the page shown below:
4 because we are using OWB
Label:Oracle 11G RAC cluster installation (vii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review
export or after the import recompile. The stored procedure did not import successfully, so I finally took advantage of Navicat to import the stored procedure successfully.Note: (1) To ensure that two databases have the same character set, if the difference will be an error. I checked the next two database character sets are the same, so I'm not sure what is wrong with the specific report. To view the database character set:SELECT * from V$nls_parameters WHERE PARAMETER in (' Nls_characterset ',
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R
Write in front: In the work, the general installation of Oracle oneG client, configure Net Manager (installed client or server), remote connection to the Oracle database to meet the needs of connecting the database. If you want the machine to operate Oracle, you need to install Oracle one-to-oneG server.
ASM file allocation in a disk group
Oracle ASM striping
Oracle ASM strip has the following two purposes:
Distribute the Server Load balancer across all disks in the disk group.
Reduces I/O latency
ASM strip is divided into coarse-grained strip and fine-grained strip. Coarse-grained strip is used as a disk group to provide load balancing, while fine-grained strip can reduce the I/O latency of a specif
Navicat for Oracle connection to Oracle 11G operation process, navicat11g
Procedure for connecting Navicat for Oracle to Oracle at 11 GB
1. Change the Oracle configuration file
After installing
Fusion Technology (IV)
RAC special problems and combat experience (V)
ORACLE one-to-G Version 2 RAC ready for use with NFS on Linux (vi)
ORACLE ENTERPRISE LINUX 5.7 under Database 11G RAC cluster installation (vii)
ORACLE ENTERPRISE LINUX 5.7 Databases 11G R
Lab environment: 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. Then, partition the disk on the first node. [root @ Rac1 ~] # Fdisk-ldisk/dev/SDE: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersunits = cylinders of 16065*512 = 8225280 bytes
Device boot start end blocks
unknown keyNote: The value of kernel. shmmax's is half of the physical memory. My memory is 2 GB, so it is 1073741824Step 2: VI/etc/security/limits. conf, add:Oracle soft nproc 2047Hard nproc 16384Oracle soft nofile 1024Oracle hard nofile 65536Step 3: VI/etc/PAM. d/login. Add the following parameters:Session required pam_limits.so step4: VI/etc/profile:If [$ user = "oracle"]; thenIf [$ shell = "/bin/KSh"]; thenUlimit-P 16384Ulimit-N 65536ElseUlimit-u
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.