still five minutes of problems. In 9i, flashback query based on time is very easy to have a large error, but fortunately, 10g has improved this. in fact, the main reason is that it takes 5 minutes for the 9i scn to synchronize with the time. That is to say, if the newly inserted data is less than 5 minutes, flashback query will be made based on the time. No data can be found.
1. Find the relationship between SCN and Time: SELECT to_char (sysdate, 'yy
Environment: RedHat Enterprise 4 and enterprise 5 have passed the test (if Enterprise 5 is used, modify the system parameters)
10201_database_linux32
Part 1 configure the system environment before installation
Configure Linux for OracleCreate a Linux Group and user account for installing and maintaining the Oracle database version 10g 2nd software. User accounts are called oracle, while groups are called oinstall and dba. Run the following command as
This article describes how to use vmware server in Red Hat 5.5 to install Oracle 10g RAC (OCFS + ASM). This article assumes that your RHEL5 has been installed, the specific configuration and installation process of Linux are listed below.
I. installation environment
1. host operating system environment overview:
Host Name
Operating System
Processor
Memory
Disk
Nic
Robinson
Windows XP Professional Service Pack 3
1. 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 path "\ ORACLE10G_client \ stage \ prereq \ client \", find the refhost. xml file, open it, add the following code to it, and save it.
Copy codeThe Code is as follows: B) Open the "\ ORACLE10G_client \ install" path, find the oraparam. ini file, open it, add the following code to it, and
Regional Metro wide area three-way Attack
The 10-Gigabit Ethernet technology breaks the limits of Traditional Ethernet short-range transmission. In addition to lan and campus networks, it can also be easily applied in the city or even wide area to build a high-performance network core.
Broadband IP MAN
The 10-Gigabit Ethernet device can provide high-density 10-Gigabit Ethernet interfaces to provide service providers and enterprise users with man and WAN connections.
. Previously, this will happen in the future. Therefore, the cabling industry will be relocated to a higher target.
According to the results of various information, the current six types of systems have limited support for new applications. Basically, the standard six types of systems can meet the needs of all applications with over five types of systems, the support for new applications requires 6 or 7 new systems.
In fact, if you have an understanding of the work of the 10GBase-T Standard Work
Use rman to migrate 10 Gb servers across databases and servers: 192.168.182.133Oracle10.2.0.1.0RHEL432bit11g server: Server 192.168
Use rman to migrate 10 Gb servers across databases and servers: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g server: Server 192.168
Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit
11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oe
After Oracle 10g R2 is installed, the following errors are prompted when you log on to the Web console:
Io exception: Unknown host specified;
Java. Lang. Exception: exception in sending request: NULL;
"Agent process exited abnormally during initialization" in System Event Log;
Cause: this problem is caused by the time zone error automatically configured by the Database Control Service. Generally,/config/EMD is in the file. properties, no ag
Problem:
Imp-00019: Row reject due to Oracle error 12899Imp-00003: encountered Oracle error 12899ORA-12899: column "jackeyj". "jk_register". "opname" is too large (actual value: 21, maximum value: 20)
Column 1 523
This error occurs when the IMP to the 10g Database is obtained from the exp data in the 9i environment.
Solution:
Modify the character set of Oracle 10 GBOracleModify the database character set to zhs16gbk.View server Character Set SQ
ArticleDirectory
How can I enter Chinese characters on the cmd.exe interface?
(From: After Oracle 10g installation is complete, you cannot log on to Em)
Status:
OpenHttp: // localhost-: 5500/emThe system displays the following information:
The database status is currently unavailable. It may be because the database is in the load or not loaded state. Click Start to obtain the current status and open the database. If you cannot op
10g RAC has many installation steps and takes a long time. It takes two days to install it.The following are the problems encountered during installation two days ago:1. The installation of ocfs2 is delayed for a long time. After installation, run/usr/sbin/ocfs2console and select [clucster]-[configure nodes]. The following error occurs:"Cocould not start cluster stack. This must be resolved before any ocfs2 ...."
Cause:1. To Ensure Disable SELinux se
Oracle 10g installation in Oracle10g + win 7
After logging on to Em, the system prompts java. Lang. Exception: exception in sending request: null.
(1) Find the EMD. properties file in sysman under the xxx_orcl file in db_1 under the Oracle installation directory, and change agenttzregion = GMT to agenttzregion = Asia/Chungking.
(2) Open the CMD command window and reconfigure em.
Set oracle_sid = orcl.
Run the EM emca config dbcontrol comman
After Oracle 10g R2 is installed, the following errors are prompted when you log on to the Web console:
Io exception: Unknown host specified; the network administrator downloads dl.bitscn.com
Java. Lang. Exception: exception in sending request: NULL;"Agent process exited abnormally during initialization" in System Event Log;
This problem is caused by a time zone error automatically configured by the Database Control Service. Generally,/config/EMD
Oracle Database 10g basic learning (1), oracledatabase
Oracle was overwhelmed from scratch. To master a skill, the best way is to first learn how to use it, and then study it in depth. First, there will be technology.
1. What is a database? Why databases?
A database is essentially a list of information or a list of working items. A database program can be considered as a list manager. Simple information can be recorded in an electronic table, and the
with your work.bat and other manufacturers of the development path, you can understand as, you learn the path. You're using it in this process.content editing skills, copywriting skills, event planning skills, project management skills, community operations skills, data analysis skills, time management skills, team management skills, and more. It can be said that the whole stack operation. That would be a lot of learning skills for people who have not yet entered the profession (including colle
Oracle upgrades from 10g to 11g detailed steps database old version: 10.2.0.4
Database new version: 11.2.0.2
OS Version: Solaris 10
Reference Documentation: Complete checklist for Manual upgrades to 11GR2 [ID 837570.1]
Part I-Installing 11GR2 software
The installation of the software here is not explained in detail, you can refer to the appropriate documentation.
Here is to note: If you want to 11gr2 on the latest PSU or CPU, you can first in th
In Oracle's latest version of 10g R2, the most timely technology should be transparent data encryption technology (transparent data encryption,tde).
TDE is used to encrypt data, usually the application logic executed by SQL does not need to be changed to function properly. In other words, the application can use the same syntax to insert data into the application table, and the Oracle database will automatically encrypt the data before it is written
1. Because Oracle 10g does not have a Win7 compatible version for the time being, we can achieve the installation target by modifying some files in the installation software.
A) Open the "\oracle10g_client \stage\prereq\client\" path, locate the Refhost.xml file, open it, add the following code to it, and save it.
Copy Code code as follows:
B Open the "\oracle10g_client\install" path, locate the Oraparam.ini file, open it, add t
Oracle Full Uninstall under Windows: Use Oui to unload a database, but there will still be some residue in the registry and file system after uninstalling. These residues not only consume disk space, but also affect Oracle's reinstallation and system performance.
To uninstall Oracle 10g under Windows: 1 Remove the Clustered Sync service CSS (Cluster Synchronization Services). If the database is configured with automatic storage management ASM, the CS
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.