toad for oracle 10g

solve the problem is very complicated, and sometimes solve a problem after the emergence of new problems. such as: Ora-12154:tns: Unable to resolve the specified connection identifier, Ora-12514,listener does not currently kown of service requested in Connect descriptor and so on.This process will automatically generate Oracle's service, and you can connect it directly with Plsql.In fact, for those who just use and don't delve into Oracle, it may be

/oracleasm Createdisk D2/DEV/SDC1/etc/init.d/oracleasm Createdisk D3/DEV/SDD1/etc/init.d/oracleasm Createdisk D4/dev/sde15. Create an ASM instance using DBCADepending on the DBCA prompt, you need to execute under the root user/u01/app/oracle/product/10.2.0/db_1/bin/localconfig addIf the boot is not normal, or if the disk is not recognized, you will need/u01/app/oracle/product/10.2.0/db_1/bin/localconfig Res

Standard one, standard, and enterprise are commonly used in Oracle 10 Gb operations. Do you want to know the specific differences between these three versions, the following article introduces the three frequently used versions of Oracle 10g .. Reference Oracle10g is divided into four versions: 1. Oracle Database Stand

Today, friends on the AIX 5.3 system installed Oracle 10g build database is used bare device, DBCA to 2% error exit, observe alert log discovery is the temp table space caused by insufficient space. View the tablespace data file with a bare device capacity of 512M, the data file size given when the database was built is also 512M. Perhaps because the AIX system is calculated in 1000, and the

Win7 Installing the Oracle 10g (Vista) methodFirst download, 10203_vista_w2k8_x86_production_db (note to the next, otherwise there is no Refhost.xml file)Http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.htmlThen unzip, found in the directory Refhost.xml (there are two, my one is in the Stage\prereq\db directory, one is in the Stage\prereq\db_prereqs\db directory) to ad

Oracle "Recycle Bin" in Oracle 10G by fenng Http://www.DBAnotes.net In Oracle 10G, the concept of a Recycle Bin (recycle Bin) is introduced. The Recycle Bin, in principle, is a data dictionary table, where the user drops the database object information. The object that th

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,

Installation Background: due to the need of Graduation Project, Oracle 10g is installed on CentOS6.2 platform, mainly referring to the documents I think are more reliable on the Internet. It turns out that this is also true, here are my installation steps for your reference! (Because some documents with previous errors are lost, Google is recommended if you have any problems !) Installation preparation: 1/1

The Oracle 10g Clusterware processes on UNIX-based systems are:Oracle ClusterwareOracle-provided clusterware that manages clusterdatabase processing including node membership, group services, global resourcemanagement, and high availability functions.CRSD-OracleClusterware DaemonThe primary Oracle Clusterware processCrsd: Performs highavailability recovery and ma

Install Oracle 10g in Windows 7. The orcale version used is 10 Gb. Step 1: Download from the orcale official website, for: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip You can directly copy it to thunder to download it. The size is 778 MB. Step 2: Click setup.exe to install it. After pre-judgment, if the following error message is displayed: 1 error, 1 warning, 2

Issue: When you create a instance and a database after your install Oracle 10g. You may come into SS following exception in D:/Oracle/product/10.2.0/db_2/bin/sqlnet. Log **************************************** *******************************Fatal Ni connect error 12638, connecting:(Description = (address = (Protocol = beq) (program =

Install Oracle 10g in Windows 7. The orcale version used is 10 Gb. Step 1: Download from the orcale official website, for: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip You can directly copy it to thunder to download it. The size is 778 MB. Step 2: Click setup.exe to install it. After pre-judgment, if the following error message is displayed: 1 error, 1 warning, 2

First, add the ORACLE 10g installation CD to the optical drive. If it runs automatically, the installation interface 1 appears:Figure 1Click "Start installation" to install ORACLE 10 Gb. Generally, check whether the system configuration meets the requirements. Then, the "Oracle DataBase 10 Gb installation" dialog box a

#! /Bin/sh# The scripts is for RHEL5U1# Author is kevin# Date 2011-06-06 For I in libXp-1.0.0-8 openmotif-2.3.0-0.3.el5 compat-db-4.2.52-5.1 compat-gcc-34-3.4.6-4 compat-libf2c-34-3.4.6-4 compat-gcc-34-g77-3.4.6-4 compat-gcc-34-c ++-3.4.6-4 compat-libstdc ++-296-2.96-138 compat-libstdc ++-33-3.2.3-61DoYum install-y $ IDone Oracle_PASSWD = oracle# Oracle user passwordSETUP_FILE_PATH =/u01/

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

Solution for Abnormal Termination of Oracle 10g installation in win7 an error occurs when Oracle 10g is installed in win7, prompting "Abnormal Termination of the program, an unknown error. Solution: First modify the refhost. xml file under \ orcale \ database \ stage \ prereq \ db and add the following content after

Oracle 10g installation in win7, select advanced options, prompt program abnormal termination, an unknown error occurs Modify Oracle 10G \ database \ stage \ prereq \ db \ refhost. xml In the Go to the install directory and find the oraparam. ini file. # Windows = 4.0, 5.0, 5.1, 5.2 Modify # Windows =

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

Oracle 10g one master multiple slave construction skills In the Oracle database environment, one-master-one-slave mode is a traditional method of use. In case of a disaster, you can flexibly switch the master-slave role to maintain service accessibility. However, some core systems still have more filters, and one master and one slave seem to be unsecure. If there

to modify the Oracle 10g RAC Listener Port number 1523OneModify the Listener.ora to change the 1521 to 1523. Make a backup of the file in advance for quick recoveryTwoModify the Tnsnames.ora, change the remote_listener corresponding value in the Tnsnames.ora parameter to 1523, make a backup of the file in advance for quick recoveryThreemodifying Local_listener database initialization parameters alter system