10g fet

Oracle 10g is not difficult to install on win, but it is not very easy on other platforms. Our company uses RHAs 4 as the server and I work on databases. It is relatively simple to uninstall on other platforms. It is okay to delete files and environment variables. However, it is not so easy to delete files and environment variables on win. Now I will write down how Oracle uninstalls it on Oracle. Software environment: 1. Windows XP + Oracle

READY, has 1 handler(s) for this service...Service "racdb_XPT" has 2 instance(s). Instance "racdb1", status READY, has 2 handler(s) for this service... Instance "racdb2", status READY, has 1 handler(s) for this service...Service "service1" has 1 instance(s). Instance "racdb1", status READY, has 2 handler(s) for this service...The command completed successfully[[emailprotected] ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Aug 5 21:46:23 2014Copyright (c) 1982, 2010,

Since Oracle 10g Release 2 was released earlier than rhel5.4, the official Oracle documentation does not provide the 10gr2 installation manual on rhel5.4. I will write a separate article on installing 10gr2 on rhel5.4, this document describes how to delete database software. In fact, the idea is simple: Delete the relevant files. There are two methods: manual deletion on the Character interface and deletion on the GUI through oui. This article only de

ORACLE 10 Gb installation in LINUX: First, two images are shown: DBA is the direction of hard work. ORACLE DBAs are all-embracing. Even LINUX/UNIX cannot be used. It also makes p oracle. Two parts: 1. red hat enterprise linux 5 Installation Difficulties (For Me Now): 1.1YUM local source configuration; network related information, not to mention. because it is used on the local machine, after referring to the FTP source, I used the FILE source; 1.2 four files related to bash startup file (

21,200 9 2:26:15 AM 3. view the dbconsole status and access address [Oracle @ devrfel501 ~] $ Emctl status dbconsole TZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.4.0Copyright (c) 1996,200 7 Oracle Corporation. All rights reserved.Https: // devrfel501: 5502/EM/console/aboutapplication # access addressOracle Enterprise Manager 10g is running.------------------------------------

the solution, it only informs that the 10g dynamic library connection will be applicable to all lower versions, and the release is very simple. However, the detailed configuration is also specific to Alibaba Cloud. Now, let's talk about the release method in detail.1. files to be released:1. dll file;(1) OCI. dll(2) oraociei10.dllThe above two DLL files are obtained directly in the installation directory after the Oracle client instantclient is insta

Subject: how to clean up after a failed Oracle clusterware (CRS) Installation Doc ID: 239998.1 type: Bulletin Modified Date: 18-Mar-2009 status: published Purpose------- The purpose of this document is to help DBA's and support analysts understand howTo clean up a failed CRS (cluster ready services) install for 10g RAC. Scope Application------------------- DBA's and support analysts 10g RAC: ho

I am usually busy with my work, and I still have the burden of study and support. not much time. This post is a simple document mainly intended for Oracle-based technical personnel. if I have time, I will post a more detailed document. thank you for your support from the OTN forum. Environment:Macmini 1.25 1 gmem (the one with the original overclock to 1.5 had to be downgraded back later) ORACLE: Oracle 10g 10.1 for Mac OSX ServerOSX server: 10.4.5GC

from the master database to the Standby DB:SQL> alter system set log_archive_dest_state_2 = defer;Re-enable log transmission after flashing back:SQL> alter system set log_archive_dest_state_2 = enable; Oracle 11g environment:The steps are simpler. The new features of Snapshot Standby Database are added to the 11g, which is actually a package of the above 10g functions, the only difference is that archive logs from the master database can be accepted

To modify the port number of an oracle 10g rac listener to 1523, rac1523To modify the port number of an oracle 10g rac listener to 1523I,Modify listener. ora and change 1521 to 1523. Back up the file in advance for quick recoveryII,Modify tnsnames. ora, change the value of remote_listener in tnsnames. ora to 1523, and back up the file in advance to facilitate quick recovery.III,Modify local_listener databas

whole database backup available to you. which two statements are true in this scenario? (Choose two .) A) The instance aborts. B) The database cannot be recovered. C) The database can be recovered by restoring the control files from the backup. D) The database remains opened and you have to shut it down with the ABORT option. E) The database can be restored till the point of the last closed whole database backup. Answer: AE 127. While running the Oracle Universal Installer on a Unix platform t

control file. D. The trace file contains the instructions to manually re-create the control file. E. The trace file is an image copy of the control file created during the backup of the control file. Answer: B Online Documentation: An alternative to the create controlfile statement is alter database backup controlfile to trace, which generates a SQL script in the trace file to re-create the controlfile Http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5003.htm 5. While r

Since Oracle version 10g, data Pump is provided as a new data mobile technology. The technical tools are expdp and impdp respectively. We often use them in actual projects, such as migrating data from the production database to the test database. I will introduce the usage, usage, and differences between these two tools and the imp/exp of 9i. Expdp and impdp have three main purposes: 1. implement logical backup and recovery of databases; 2. Move datab

Recently, many employees who have installed Oracle 10g RAC on the RHEL 5.X platform do not have much difficulty, but repetitive manual work is still relatively high. Therefore, a semi-automatic installation script is compiled by the way. Install operating system patches, create database users, and modify user configuration files. Issues to be resolved:1. The host name is automatically configured, which requires a separate configuration file. In additi

Install Oracle 10g RAC with 64-bit redhat4.8_64 under VMware-simple script I. Preparations 1. System Information [Root @ r4r4o10n1 ~] # Uname- Linux r4r4o10n1 2.6.9-89.EL #1 Mon Apr 2010:edt 2009 x86_64 x86_64 x86_64 GNU/Linux VM: vmware workstation9 OS: redhat4.8 DATABASE: ORACLE10201 2. Configure the network [Root @ r4o10n1 ~] # System-config-network [Root @ r4o10n1 ~] # More/etc/hosts # Do not remove the following line, orvarious programs # That re

Today, we will introduce the entire process of installing Oracle 10 Gb in Red Hat Enterprise Linux AS 5.4. 1. Download Oracle 10g First, describe in detail my environment, system: Virtual Machine Red Hat Enterprise Linux AS 5.4, Database: Oracle Database 10g Release 2 (10.2.0.1 ). Go to the official website to download Oracle. The downloaded file is 10201_database_linux32.zip. Ii. configuration before 10 Gb

Environment Settings...First, check your physical memory size. We recommend that you increase the memory size by 1 GB.# Grep MemTotal/proc/meminfo Check whether your swap partition size meets the requirements. Generally, it is twice the physical memory size ..# Grep SwapTotal/proc/meminfo Check whether the size of the partition mounted to/tmp is sufficient. If the size is smaller than 400 MB, delete other junk files and increase the space.# Df-k/tmp View the cpu type.# Grep "model name"/proc/cpu

1)Role of Wallet Starting from Oracle 10g R2, any user can log on to the database without a password by using Oracle Wallet (non-operating system authentication ), this is very useful for scripts that use user passwords to log on to the database for operations in shell, and does not expose the user password. for example, on the Oracle clientMkstore command settingsThe Wallet authentication information can be directly connected to the database through

= 262144 Kernel. shmall = 2097152Kernel. shmmax = 2147483648 # modify according to the actual situation, usually twice the memoryKernel. shmmni = 4096# Semaphores: semmsl, semmns, semopm, semmniKernel. sem = 250 32000 100 128Fs. file-max = 6815744Fs. aio-max-nr = 1048576Net. ipv4.ip _ local_port_range = 9000 65500Net. core. rmem_default = 4194304Net. core. rmem_max = 4194304Net. core. wmem_default = 262144Net. core. wmem_max = 10448756 2.Vi/etc/security/limits. confOracle soft nproc 2047Hard

42424 4096 Oct 23 2005 database-Rw-r -- 1 root 801603584 Oct 14 2009 10201_database_linux_x86_64.cpio2. Create a software installation environment2.1 create an Oracle account and directory:Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/--> [root @ Fantasy ~] # Groupadd oinstall[Root @ Fantasy ~] # Groupadd dba[Root @ Fantasy ~] # Useradd-g oinstall-G dba oracle[Root @ Fantasy ~] # Passwd oracleChanging password for user oracle.New UNIX password:B