10g gbic

InWindows 7LowerInstall Oracle database lite 10 GBThe following error occurs after setup.exe is run. The error message is as follows: Checkinginstallerrequirements... Checkingoperatingsystemversion:mustbe5.0,5.1,5.2or6.0.Actual6.1 Failed ExitingOracleUniversalInstaller,logforthissessioncanbefoundatC:\ProgramFiles\Oracle\Inventory\logs\installActions2011-08-01_09-40-07AM.log PleasepressEntertoexit... Open the log file in the error message and check the first line in

. #SQLNET.ORANetworkConfigurationFile:D:oracleora92networkadminsqlnet.ora #GeneratedbyOracleconfigurationtools. SQLNET.AUTHENTICATION_SERVICES=(NTS) NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME) Name of sqlnet. ora in a three-tier structure #NAMES.PREFERRED_SERVERS= #(ADDRESS_LIST= #(ADDRESS=(PROTOCOL=TCP)(HOST=MICROSOF-3D9384)(PORT=1575)) #) 4. Oracle http server cannot be started Stop the site that uses port 80 in IIS, or change the port number of the Oracle H

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 appears, as shown in Figure 2:Figure 2You can select "Basic installation" or "Advanced installation" when installing Oracle DataBase at

Adding a shared disk to a VM supports ORACLE 10g rac. Because the original ASM shared disk capacity is small, it is impossible to mount the archive log and backup files. so I decided to add a disk. 1. Add a virtual disk to node 1 and place it in the original shared directory named ASM4. Select SCSI. Note that the disk is placed behind another disk on SCSI bus 1, otherwise, it is easy to change the drive letter mode = independent-> Persistent www.2cto.

A function wmsys in oracle 10g and 11g. wmsys. the function of wm_concat is to merge multiple rows into one row. For example, if A person buys three stocks A, B, and C, we will record three data records normally, now we want to display the stock of this person with a piece of data. This is wmsys. the wm_concat method is useful. however, in 10 Gb, the return value of this method can be directly converted to String for use, but it is Clob type in 11g, y

Oracle 10g rac listener name: CRS-0210: cocould not find resource problem want to restart the listener, The results found that the [oracle @ node1 ~] $ Srvctl stop listener-n node1CRS-0210: cocould not find resource ora. node1.LISTENER _ NODE1.lsnr. View listener www.2cto.com [oracle @ node1 ~] $ Srvctl config nodeapps-n node1-l the listener does not exist. Check whether a specific node exists. [oracle @ node1 ~] $ Srvctl config listener-n node1node1

Oracle 10g OEM regular error solving ------- Unknown host specified Oracle Enterprise Manager provides a web-based interface-based tool for managing a single oracle database. Since OEMs use web-based applications, therefore, http is used. When you log on to www.2cto.com: database error I/O exception: Unknown host specified if this problem occurs, you can manually register the time zone parameter configured next to it and use the following command: set

Oracle RAC migration OCR (10g) Oracle RAC addition and deletion OCR reference: http://www.bkjia.com/database/201303/197136.html Oracle RAC backup and recovery OCR reference: http://www.bkjia.com/database/201303/196370.html If you want to change an existing ocr location or a faulty ocr location, you can use the following procedure to migrate the ocr. 1. view the current ocr [plain] [oracle @ node1 crs_1] $ ocrcheck Status of Oracle Cluster Registry is

After logging on to oracle 10g EM, the system prompts "the database status is currently unavailable, probably because the database status is loaded or not loaded ".After the password such as sys and system is changed during database creation, EM can log on normally, but the system prompts "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 t

that if the bhints CARDINALITY and SELECTIVITY of Oracle 10 Gb are defined in the same batch of tables, both of them will be ignored. no_use_nl Hint no_use_nl enables CBO to execute loop nesting. By using the specified table as an internal table, each specified table is connected to another original row. With this hint, only hash join and sort-merge joins are considered for the specified table. Example: SELECT/*+NO_USE_NL(employees)*/... no_use_merge This hint allows CBO to

based on the user's identity, the user's permission level, and the account administrator to which the user reports. Strings created and returned by policy functions may be highly dynamic. To ensure the results, Oracle must re-execute policy functions each time, which wastes resources and reduces performance. In this type of policy, each execution of a predicate may be very different. This policy is called a "dynamic" policy, which has been provided in the Oracle9i database and earlier versions.

In Oracle10g, useOem toolsWhen setting database backup and recovery policies, you must provideHost ID. In fact, the host identity is the OS account of the host where Oracle is located. After entering the account name and password, a verification error is often prompted: **************************************** ************************ Check and correct the following errors, and then try again: ERROR-failed to connect to the host as user administrator: ERROR: Wrong password for user Enter the

SP2-1503: Unable to initialize Oracle call interface (same fashion 10g and 11g) solution 1. The error SP2-1503: Unable to initialize Oracle call interfaceSP2-0152: ORACLE may not be functioning properly 2 is reported when sqlplus/as sysdba is executed in a 11g environment. Analysis (1) After 10 Gb is installed on the same AIX machine, an environment variable of 11 GB is configured as follows (note the red part) export ORACLE_BASE =/opt/oracle export O

With the rapid development of popular technologies such as big data, mobile Internet, and online video, this makes it necessary for network security devices to conduct more in-depth and comprehensive analysis of traffic, to solve the new security challenges brought about by the increase in bandwidth, and the network security has truly entered the 10G era. Web security threats and defense in a 10-Gigabit Network Environment In the network age of 10 Gig

After installing oracle in the notebook, you can use the OEM console normally. However, after logging out, log on again or restart the system, or change the network environment of the notebook, problems may occur. The solutions to these problems have been used, but I have forgotten them for a long time. Today I have recorded these problems and solutions here.1. Failed to start due to network environment changes This problem occurs because the OEM cannot be started. Use the following command line

1. Install Oracle 10g RAC in the Oracle Linux environment on the vmvm This article references: Http://www.oracle.com/technology/global/cn/pub/articles/chan-ubl-vmware.html Http://www.oracle.com/technology/global/cn/pub/articles/smiley_rac10g_install.html Precautions for installing Linux: 1. When installing Linux, install all "development" and "Legacy development" under "development ". 2. Select: System Tools Ocfs-2-2.6.9-42.0.0.0.1EL, Ocfs2-tools Oc

). Specify backup and recovery options: Select whether to enable automatic backup. 14 ). Password of the database solution. Includes passwords for sys, system, sysman, and Dbsnmp. Note that the password starts with a letter. 15 ). Finally, generate the summary file of Oracle universal install. Check the profile carefully to determine your options. If there is no change, click Install to start Oracle 10g installation. The specific installation time va

Symptoms: When Oracle 10g is installed, the network detection fails. If no processing is performed, the installation continues and the IP address is not specified. After iporacledbconsole is modified for the machine, it cannot be started, view the system startup log: Agent process exited abnormally during initialization.One of the solutions to fail to start oracledbconsole　　 Symptom: it turned out to be normal. After a DNS suffix is added to the machi

Zhuan:Http://space.itpub.net/16128/viewspace-426863 Database: Banner----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL release 10.2.0.1.0-ProductionCore 10.2.0.1.0 ProductionTNS for 32-bit windows: Version 10.2.0.1.0-ProductionNlsrtl version 10.2.0.1.0-Production Experiment process: SQL> shutdown abort;The Oracle routine has been disabled. SQL> startup Mount;Th

The problem is, Oracle had to be installed some days ago due to learning needs, However, the downloaded Oracle 9i R1 cannot be installed in my win7 environment, Since I cannot bear win7 (I don't want to switch back to XP), I installed Oracle 10g R2, But when I got the Oracle 10 Gb EM (Enterprise Manager) today, This means that EM cannot be enabled, Http: // Xiaozhen-PC: 1158/em The default em is always inaccessible, and I checked the ser