10g gbic

, including:Slave (database package) RAC1 VotingdiskOCRdiskVmware sharedisk ASMdisk1 (two ASM, one for user data and one for flash data)ASMdisk2RAC21) install vmware-1.0.9 Virtual MachineRpm-ivh VMware-server-1.0.9-156507.i386.rpmRAC1 (New-> select bridge-> LSI Logic-> SCSI-> RAC1.vmdk (10G)-> Votingdisk. vmdk (0.1G) (scsi1: 1) (Independent)-> OCRdisk. vmdk (0.1G) (scsi1: 2) (Independent)-> ASMdisk1 (2G) (scsi1: 3) (Independent)-> ASMdisk2 (1G) (scsi1

In Oracle 10 Gb database applications, the UNDO tablespace is too large, leading to insufficient disk space and crash. After analyzing the problem, the main reasons for the problem are summarized as follows: 1. There is a large volume of transactions that allow Oracle Undo to automatically expand, resulting in excessive disk space occupation; 2. There are large transactions that have not been contracted or are not committed by the system; Note: this problem is normal in Oracle system management.

to/u01/app/oracle/product/10.2.0/db_1/network/log/listener. logListening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.6) (PORT = 1521 ))) Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.6) (PORT = 1521 )))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.4.0-ProductionStart Date 13-FEB-2014 22:58:13Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener

source code Installing Oracle 11g R2 using RHEL6 ASM Oracle 10g manual creation of the ASM Database 2. Advantages of ASM Disk increase: it is very easy to add disks. No downtime is required and the file area is automatically reassigned. I/O allocation: I/O is automatically distributed across all available Disks without manual intervention. This reduces the possibility of hot spots. Band Width: segments in the redo log file can be subdivided (K for fa

/crsctl.2928. Nov 2 09:54:10 node2 logger: Cluster Ready Services completed waiting on dependencies. Nov 2 09:54:10 node2 last message repeated 2 times Nov 2 09:55:10 node2 logger: Running CRSD with TZ = Nov 2 09:56:01 node2 logger: Oracle CSSD graceful shutdown Nov 2 09:56:32 node2 logger: Cluster Ready Services completed waiting on dependencies. [Root @ node2 ~] # Crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy [Root @ node2 ~] # Crs_stat-t Name Type Target State

1. the Oracle 10g Stream table-level replication configuration () was previously implemented. If a replication environment already exists, you need to clear the existing replication environment before configuring other types of replication, otherwise, the replication will fail.Use the stream administrator to perform the following operations on the source database:SQL> conn streamadmin/oracle @ primaryConnected.SQL> begin2 for cur_pro in (select propag

Clean up junk tables for oracle 10G and oracle10 G An Oracle O M experience that I learned and worked on is a pitfall step by step. Cause: a set of systems that have been running for five years have been slow to be reflected by customers in the near future. I learned about the runtime environment: windows2003 (16G + 4 Core) + jdk (32) + tomcat and window2003 (4G + dual-core) + oracle10G On-site phenomenon: when the customer operates the warehouse rec

Project error due to Oracle 10g empty table export failure -- the table or view does not exist, oracle10 g View This afternoon, the data in the remote database is exported and imported to the local database. After the deployed project connects to the local database, jboss starts compiling and reports the following error: Severe: Exception sending context initialized event to listener instance of class com. dicpsi. mis. contextListener. ContextListene

1. When installing cluster in Oracle 10g, the following error is prompted during the period from 61%: WARNING: Error while copying directory/home/oracle/app/oracle/10R2/crs with exclude file list 'null' to nodes 'rac2 '.[PRKC-1002: All the submitted commands did not execute successfully] (similar) Solution: This error can be ignored. Cause: during the installation of the Oracle cluster, database, and accompanying CD, Oracle Universal Installer (OUI) w

The sys password of the Oracle 10g ASM instance sometimes needs to be modified. The modification method is to directly modify the password file of the ASM instance, which is different from that of the user in the database instance. We cannot use the alter user command to modify the sys user password of the ASM database. The sys password of ASM can only be provided by the password file, and the value of REMOTE_LOGIN_PASSWORDFILE of the ASM instance is

graphical tool dbca. 6. Brief Introduction to data guard Oracle 10g data guard uses arch or lgwr to continuously transmit the logs generated in the master database to the slave database, and then the slave database system continuously transmits the logs that are passed in by applications, this allows near real-time data synchronization between the two databases.When a physical fault occurs in the master database, such as an operating system down or d

#! /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/oracle#10g installer directoryINSTALL_TO_PATH =/u01# Installatio

I have just joined a new project recently. The requirements have been completed and will enter the detailed design stage. The project framework should use a multi-project system framework that is being developed by other project teams and use this main framework to develop modules of our own system. I have learned about the composition of this framework over the past few days, mainly uses the WCF Service, entityframework 4.1 Framework, and ext. NET component development, by the way, I learned EF

The following problems are frequently encountered during data migration: 1. If the exported file is not valid, the header verification fails; 2. EXP-00056: Oracle error 6550ORA-06550: Line 1, column 41:PLS-00302: component 'set _ no_outlines 'must be declaredORA-06550: Line 1, column 15:PL/SQL: Statement ignoredEXP-00000: Export termination failed About import and export: 1. The exp command on the client must be consistent with the Oracle version on the server when the export is executed; 2

During the National Day, I upgraded my Oracle 8i database to 10g 64. After the upgrade, I found that the datafile of sysaux tablespace was not. it turns out that the datafile list I used when I upgraded to the control file is the one I used before the upgrade, the datafile of the new tablespace sysaux generated during the upgrade is not added to the List. I did not add this file in my previous tests, but the system has not reported any errors, so it h

Oracle 10g listener ProgramCannot start normally? Error message: Start tnslsnr: Please wait...TnslsnrFor32-bit windows: Version 10.2.0.3.0-ProductionThe system parameter file is D: \ app \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ listener. ora.Write the log information of D: \ app \ oracle \ product \ 10.2.0 \ db_1 \ Network \ log \ listener. LogListener: (description = (address = (Protocol = IPC) (pipename = \. \ PIPE \ extproc1ipc )

About Oracle 10 Gb performance, the most talked about is the new automatic workload repository (AWR) features and proactive performance monitoring through automatic database Diagnostic Monitoring (ADDM. They are widely reported as an alternative to STATPACK. Indeed, according to Mr. Niemiec, they can do more to represent the future of Oracle performance analysis.However, he also said not to ignore STATSPACK, not only because it still exists in Oracle 10 Gb as a heritage, but also has made many u

Oracle 10g rac ip/VIP address modification exampleI. Preparations 1. Database Information Operating system version: OEL5.4 x64Database Version: Oracle 10.2.0.5 x64 RAC2. IP address information Note: The server host name cannot be changed. If you want to change the name, you need to reinstall CRS to solve the problem. It is better to reinstall it.The environment in this article is 10 Gb rac + ocfs + asm, And the heartbeat address remains unchanged. The

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 li

Oracle 10g Lsnrctl does not reflect database connection failure Symptom Description: The Oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If lsnrctl stop is entered, no response is returned. Applications connected to the database run normally, but new applications cannot connect to the database. SQL plus is normal on the Oracle database server, but PL/SQL and Navicat on th