Label:As for some errors that occur during the installation process, I summarize that the path does not have permissions, not the user group below theTo create Oracle users and user groups and directories, and to assign permissions to the directory, refer to the following example:This place can be successfully installed if you simply follow the procedure below, but if you want to install Oracle in a different directory,Need to be modified, this is simply to build Oracle in the root directory, an
open resetlogs;is stillOra-03113:end-of-file on communication fileAnd the instance died immediately.Repeated attempts failed.At this time try to use ALTER DATABASE clear log Group 4, the result fails.and the current log group cannot drop.Finally try using recover database using Backup controlfile until cancel;Then an archive log under ASM is specified, although the error says that it does not contain the desired SCN value, but the recover is completed normally, try againALTER DATABASE open rese
A. Oracle 10g1.1DescriptionUnder Oracle 10g, by default, passwords are case-insensitive. This is due to the default parameters for the password file.C:\users\administrator.daviddai>orapwdUsage:orapwd file=whereFile-name of password file (required),Password-password for SYS would is prompted if not specified at CommandLine,Entries-maximum number of distinct DBA (optional),Force-whether to overwrite existing file (optional),Ignorecase-passwords is case-
Oracle 10G New Features-- RMAN
Author: Fuyuncat
Source: WWW.HelloDBA.COM
The Rman incremental backup scheme, offline recovery of incremental backups, recovery previews, recovery from Resetlogs, file compression, and so on, become more powerful.Most people agree that Rman is the de facto database backup tool for Oracle. Although earlier versions of Rman are already strong, there is still much to expect from them. Many DBAs fret about fea
First install the Oracle 10g CD-ROM into the CD-ROM drive, and if it runs automatically, it will typically appear as shown in Figure 1 installation Interface:
Figure 1
By clicking Start installation, you can install Oracle 10g, typically checking the system configuration for compliance, and then the Oracle DataBase 10g Installation dialog box appears, as shown
Label:First, hardware requirements1. Memory SwapMinimum:1 GB of RAMRecommended:2 GB of RAM or moreCheck memory condition # grep memtotal/proc/meminfo# grep swaptotal/proc/meminfo2. HDDSince the CentOS installation is almost 4~5g, plus Oracle and so on, please prepare at least 10G of hard disk space.Check disk condition # Df-hSecond, the softwareSystem Platform: CentOS 6.3 (x32)Centos-6.3-i386-bin-dvd1.isoOracle Version: Oracle
Oracle
Oracle 10G Data Pump (part I)
Author: fenng
Source: Http://www.DBAnotes.net
Oracle 10G Data Pump technology enables high-speed movement of databases and metadata among different databases. This technique is based on two data movement.
Tools: Data Pump Export and data Pump Import.
Oracle's data Pump is implemented through a Pl/sql package: Dbms_datapump (also known as the Data Pump API). Data Pump
----query for OCR status:
#/oracle/product/10g/crs/bin/ocrcheck
Prot-601:failed to initialize Ocrcheck
---------Replace the original OCR disk with an error:
#/oracle/product/10g/crs/bin/ocrconfig-replace OCR '/DEV/RDSK/C5T600A0B80005AD8BC0000020000000000D0S7 '
/oracle/product/10g/crs/bin/ocrconfig-replace ocrmirror '/dev/rdsk/c5t600a0b80005ad8bc0000020000000
DirectoryFirst, hardware requirementsSecond, the softwareThird, System installation noteIv. System Readiness prior to Oracle installationV. Install Oracle and set up the settingsSix, upgrade Oracle to Patchset 10.2.0.4Vii. using Rlwrap to invoke the Sqlplus history commandFirst, hardware requirements1. Memory SwapMinimum:1 GB of RAMRecommended:2 GB of RAM or moreCheck memory condition# grep memtotal/proc/meminfo# grep swaptotal/proc/meminfo2. HDDSince the CentOS installation is almost 4~5g, plu
Earlier Ethernet switches used the architecture of Gigabit Ethernet switches, but added the 10GE module to support 10 Gbit/s Ethernet. We once made a 10G Ethernet topic named "10g power" in a newspaper in October 13. Many manufacturers mentioned that the early 10G Ethernet products only reached half of the throughput specified in the standard, and some of them pr
Tencent Micro Cloud Ordinary users more than 10G how to do?
Tencent Micro Cloud
Tencent Micro Cloud Ordinary users more than 10G how to do?
Tencent Micro Cloud yesterday night issued a notice that from January 16 next year, the average user's free storage capacity reduced to 10G, member storage capacity unchanged, the original storage files have more than
Installing Oracle under Linux is a daunting thing, much more complicated than installing the Linux operating system itself. If you are able to successfully install Oracle, you can also learn some Linux technologies. This article describes the method for installing Oracle 10g under Redhat Linux. Here is a description, Oracle 10g G is the abbreviation of grid, meaning for the grid, the current more cutting-ed
Title: There are 10G integers in a file, ordered in order to find the median. The memory limit is 2G. Writing only ideas (memory limit of 2G means that you can use 2G of space to run the program, regardless of the other software on this machine memory consumption).
About Median: The number of positions in the middle after the data is sorted. The data is divided into two parts, one part greater than the number, and one part is less than the number. Pos
Oracle|window
Download today to Oracle 10g for Windows 32bit, install screenshots, give you a reference.
This step takes a long time.
It is illustrated above. Overall, 10g is more convenient to install, there will be no 9i when some problems. But some things are not tested, we still have to pay attention to: installation path or try not to conta
Oracle
Week Three: Table space management
What does the name contain? : Improved table space management
Table space management has been significantly improved, which can be attributed to a sparser SYSTEM, support for user-defined default tablespace, new Sysaux, and even renaming
How many times have you been hurt by the user's creation of a non-SYS and system segment in the system table space?
Before Oracle9i Database, if you do not specify a default tablespace when you create a user, it de
The Oracle 10g version is designed to redesign the operational functions of data entry and output to increase the ability to disconnect and connect in the input or output work. Minor changes to these features can facilitate the operation of the DBA table space.
Output table space as a whole unit
There are 3 modes of output and input in the past: dependent on object output, such as a single table of indexes, output of all objects of a user, and outpu
Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison.
This article compares the differences between IMP and IMPDP import.
The comparison of exp and data pump export, you can see that the data pump export speed and direct path, compared to the speed is not the essence of improvement, the following look at the data pump Import mode and imp difference.
The imported DMP file is the result of the above
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.