The problem occurred when installing Oracle10G. Later, I asked my roommates to re-send an Oralce10g Client installation package and install it. It was possible to use PLSQL at the beginning. Later, due to work needs, an Oracle database backup was sent from an import colleague at a time, and an error 6550 occurred when importing data using the IMP statement under the command line, online query
The problem oc
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
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
)----Multiple instances to open a database• Stream----Multiple Oracle servers propagate transactions to one another• Data protection----The primary database to update the standby database Determine if it is a single instance Select parallel from V$instance; --NO Single InstanceSelect Protection_level from V$
. Table Directory: if the data stored in the block is table data, the table directory stores information about the table.
3. Row directory
4. Free Space:
5. Row Space: the storage space used in the block. Table or index data is stored in the row space.
1.4 New Features of oracle 11g
1.4.1 Database Management
1. Plan Management
Allows you to fix the query p
The database was uninstalled in the previous article, and the database software was deleted.
As has been mentioned at the beginning of the article, improper unloading of the RAC environment can cause problems. Normally, you should uninstall the modifications made by cluster first, and then uninstall Clusterware.
It s
. Typical Installation6, the related configuration path, here need to pay attention to carefully check, management password is password, need at least one uppercase, a lowercase, a number, at least 8 bits7, the Inventory directory needs to be specified in the following Oracle, easy to find8, the detection through, the package is there, you can find, the upper right corner ignore can, and then click Finish9, long-time installation~]#/opt/
remove the path information for OracleEcho.EchoStart removing the Oracle directory from the Start menuPauseRd/s/q "%allusersprofile%\" start "menu \ Program \oracle Database 11g Express Edition"REMRestart your computerEcho @echo off> "%userprofile%\" start "menu \ Program \ Start \1.bat"Echo Echo.>> "%userprofile%\" s
Tags: system sys AST download data BSP Enterprise Database large Web siteOracle Database 11g Release 2 standard Edition and Enterprise Edition software DownloadsOracle Database 11g 2nd Edition Standard Edition,Software download for Enterprise EditionMicrosoft Windows (32-bit
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
About Oracle ASM instances
About Oracle ASM disk groups
About grouping and failure groups
About Oracle ASM Disks
About Oracle ASM files
About Oracle ASM instances
The Oracle ASM instance is built based on the same technology a
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
Manually uninstall Oracle in Windows and oracle in windows
There is a problem with uninstalling the Oracle Al Installer that comes with Oracle: it is not clean, not complete, and there are some residual registries, which will affect subsequent installation. Therefore, we rec
Test whether 11G Oracle Restart can automatically start the killed component. The main story is oralce 11g restartOracle Restartis another component of Oracle Grid Infrastructure for a Standalone Server that will be used in this guide. starting with Oracle
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
-Firewall-1-INPUT -m state –state NEW -m udp -p udp –dport 177 -j ACCEPT
:wq! #Save exit
Service iptables restart #restart
Gdm-restart #restart
Shutdown -r now #restart the system
Second, install Xmanager on the Windows client system
1. Download and install Xmanager Enterprise 3
Http://www.onlinedown.net/soft/32684.htm #英语原版
Http://www.downxia.com/downinfo/19164.html #汉化包
2. After downloading the installation software, open Xmanager Enterprise
3, then open Xbrowser, as shown below:
I
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
Oracle 11g on July 11, 2007 11 O'Clock (Beijing time 11th 22 o'clock) officially released, 11g is Oracle 30 years to release the most important version of the database, according to the needs of users to achieve information lifecycle management (information Lifecycle Managem
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.