Install oracle 10g configuration file change reference on win7 install Oracle in win7 system, there are the following points to note: Java code 1. You need to install it under the administrator user. 2. Because oracle 10g is not compatible with win7 for the moment, we can modify some files in the installation software to achieve the installation goal. A) Open the "\ Oracle
Search for Median in a 10G integer File
Http://hxraid.iteye.com/blog/649831
Question: 10 Gb in a fileIntegers in disorder. The median must be located. The memory limit is 2 GB. Just write out the idea (the memory limit is 2 GB, that is, 2 GB space can be used to run the program, regardless of the memory occupied by other software on this machine ).
Analysis: to find the median, it is easy to think about sorting. Byte-based bucket sorting is a feasible
Oracle Enterprise Manager 10 Gb Database Control is designed to manage a single Database, regardless of whether the Database is a single instance or a cluster Database. This Enterprise Manager 10g Database Control release contains the following advanced features available only after obtaining the Oracle license: Database diagnostic package
Automatic workload data archives
ADDM (automatic database diagnostic monitor)
Performance monitoring (data
Some changes need to be made when Oracle Client 10g is installed on Windows 7, oracle10g
The new notebook, Windows 7 Pro, needs to install the Oracle Client, the colleague gave a 10G version. Prompt during installation:
"Checking operating system requirements... Expected results: 5.0, 5.1, 5.2, 6.0 actual results: 6.1 check completed.
The overall result of this check is: Failed
There are many posts o
1. Architecture
In Oracle 10g, the process for transmitting logs to the standby node database is ARCH and LGWR. (In 11g, LGWR is replaced by LNS, but I'm not sure if it is LGWR in 10g !)
The slave node receives logs by using the log_archive_config, fal_client, and fal_server parameters, and communicates with the master node to identify whether the log is applied.
Data Guard adopts the maximum available mode
In Linux, the total number of Oracle clients is less than 40 MB, which is very convenient and quick to install.
1. First, check the directory structure after downloading:
Copy it to linux.
2. Use the root user in the command line window to operate in the rpm directory:
Rpm-ivh... rpm
Rpm-ivh... rpm
Rpm-ivh... rpm
Rpm-ivh... rpm
(Install the four RPMs separately. Install the basic one first, and install the other three in any order)
3. Modify the tansnames. ora File
# Tnsnames. ora Network Confi
Grantconnect, resource, dba to Facial;
Place aa. dmp and aa. log in the E: \ oracle \ product \ 10.2.0 \ admin \ orcl \ dpdump directory
10g Import Statement: impdp userid ='Facial/Facial@OrclAs sysdba 'schemas =FacialDirectory = DATA_PUMP_DIR dumpfile = aa. dmp logfile = aa. logversion = 10.2.0.1.0
The red part is rewritten as needed. For example, my usersFacialThe password isFacial, Database sid isOrcl, The user name to import schemas isFacialTo
Understanding of DRM in oracle 10g RAC, racdrmSummary of DRM1. What is DRM?Dynamic Resource Management (DRM) is a new feature of oracle 10 Gb. in oracle rac environment, ORACLE uses GRD (Global Resource Service) to record Resource information of each node, it is managed through the GCS (Global Cache Service) and GES (Global Enqueue Service) services. Each node in RAC has its own SGA and buffer cache. To ensure the consistency and high performance of c
oltp_servicesrvctl stop service-D orcl -s batch_service
Iii. jobs and services
-- Oracle 10g sched allows links between jobs and job classes so that services-related jobs run on specified nodes in the RAC environment by job class. -- To meet the preceding requirements, you can create the following two job classes. -- Create OLTP and batch job classes. begin classes (job_class_name => 'oltp _ job_class ', service => 'oltp _ Service'); dbms_scheduler.c
RedHat Linux Fedora Core 5 successfully installed Oracle 10g
Host Configuration:Intel P4 CPU 3.0 GHz512 MB memory80 GB hard drive
1. Prepare the host and operating system:
1. Physical memory: 512 MB2. 2 GB swap spaceNote: During the installation of CMDL, the installation process will prompt that the teaching space should be at least 3068 MB, which is different from the 2G mentioned here. It does not matter. Direct installation will not be a problem,
This article makes it possible to discover some of the problems of backup during the recovery process by using a complete backup of Oracle 10g RAC Rman for a different machine recovery process. such as the redundancy of the Regulation log, control the use of automatic backup of files and parameter files, and so on, this example takes an Rman backup set for backup, so there was a problem during the last startup of the database, prompting for problems s
This document is only the process of deploying Dataguard, does not involve the interpretation and description of concepts, there is no dataguard theory of introduction, in this regard, please check the official Oracle documentation.
Operating system: RedHat 4.2
[ORACLE@DG1 ~]$ Uname-a
Linux dg1 2.6.9-22.el #1 Mon Sep 18:20:28 EDT i686 i686 i386
Oracle Software: Oracle 10g release 10.2.0.1.0
Host information:
Machine Name: DG1 IP Address: 192.168
Oracle
No setting required to immediately recognize all changes to a row
In the Oracle9i Database, we saw that it introduced a "time Machine" in the form of a flashback query. This feature allows the DBA to see the column value at a specific time, provided that the previously mirrored copy of the data block is available in the restore segment. However, a flash-back query provides only a fixed snapshot of the data at a given moment, rather than a running state of the data changed between the two
In development we often use Oracle databases. Oracle now has different versions, and different projects use different versions of Oracle due to different development times. Because of the different versions of the database functionality, it is generally difficult to upgrade the database version once it has been developed. But the operating system we use is constantly being updated. Many people are willing to try a new operating system. The installation of Oracle
Tags: Oracle 10g RAC Rebuilding CRS1.crs file is corrupt, remove CRS informationRAC10G1 node:[Email protected] install]# ./rootdelete.shShutting down Oracle Cluster ready Services (CRS):Stopping resources.Error while stopping resources. Possible CAUSE:CRSD is down.Stopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.Shutdown has begun. The daemons should exit soon.Checking to see if Oracle CRS stack are down ...Oracle CRS Stack
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/11g data source, click Connect will error [connection failed], such as:
R
cenOS5.5 installation oracle10g (Fool article) http://www.cnblogs.com/fnng/archive/2012/06/19/2554159.html (Turn)Installing Oracle 10G on cenOS5.5 It's not that fresh stuff, but it took a week to build it around. I think everyone will encounter some different problems when installing. Since it is a fool's article, it must be very stupid. Ha ha!!================== Required Equipment =============================Virtual Machine VirtualBoxHttps://www.vir
Oracle 10g version is 10201_database_win32, installation Prompt "program terminated abnormally, an unknown error occurred."1. Modify Oracle 10g\database\stage\prereq\db\refhost.xmlIn 2. Locate the Oraparam.ini file in the install directory and#Windows =4.0,5.0,5.1,5.2Modified into#Windows =4.0,5.0,5.1,5.2,6.1and add the following[Windows-6.1-required]#Minimum display colours for OUI to runmin_display_colors
In order to do the virtual machine, you need to the server 11g of the user's complete data out. The oracle10g on the virtual machine, directly exported, cannot be imported to the virtual machine.
So, try to export the data using a 10g client,
With command: Exp exoa/***** @exoa1 file=20100526.dmp grants=y full=y
After execution, the system prompts:
EXP-00008: Oracle Error 1406 encountered
ORA-01406: The extracted column value was truncated
EXP-00
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.