crs2

); Crs.execute () while (Crs.nextpage ()) while (Crs.next ()) System.out.println ( "id" + "\t\t" +crs.getstring ("name"); we set the number of rows per page before Crs.execute (), so reader reads the data with only the specified number of rows. This avoids having to read all the data at once and then paging. Is it simple? Joinrowset interface: This interface allows us to join the result set directly in a connectionless state. The following code provides the implementation of the Joinrowset: Cac

Continue ..... Joinrowset Interface: This interface allows us to join the result set directly in a connectionless state. The following code provides the implementation of the Joinrowset: CachedRowSet crs1=new Caehedrowsetimpl (); Crs1.seturl ("Jdbc:mydql://localhost:3306/test"); Crs1.setusername ("root"); Crs1.setpassword (""); Crs1.setcommand ("SELECT * from table1"); Crs1.execute (); CachedRowSet crs2=new Caehedrowsetimpl ();

: --------------------------------------------------------------------------- Device Boot Start End Blocks Id System /Dev/sdb1 1 132 1060258 + 83 Linux // CRS1 900 M /Dev/sdb2 133 264 1060290 83 Linux // CRS2 900 M /Dev/sdb3 265 396 1060290 83 Linux // CRS3 900 M /Dev/sdb4 397 13054 101675385 5 Extended /Dev/sdb5 397 3008 20980858 + 83 Linux // DATA1 30 GB /Dev/sdb6 3009 5620 20980858 + 83 Linux // DATA2 30 GB /Dev/sdb7 5621 8232 20980858 + 83 Linux

encoding units will increase the number of symbols to be encoded and better reflect the advantages of the paradigm Huffman. Current Program /Files/rocketfan/glzip.rar Def usage (): "" glzip 1.txt # will compress 1.txt to 1.txt. CRS using Huffman method glzip-D 1.txt. CRS # will decompress 1.txt. CRS to 1.txt.crs.de glzip-C 1.txt # Will cocompress 1.txt to 1.txt. crs2 using canonical Huffman method glzip-D-C 1.txt.

variables (grid and oracle user_all nodes) Grid User: [Grid @ rac01 ~] # Vi. bash_profile Export ORACLE_SID = + ASM1/+ ASM2 Export ORACLE_BASE =/u01/app/oracle Export ORACLE_HOME =/u01/app/grid/11.2 Export PATH = $ PATH: $ ORACLE_HOME/bin Oracle users: [Oracle @ rac01 ~] # Vi. bash_profile Export ORACLE_SID = racdb1/racdb2 Export ORACLE_UNQNAME = $ ORACLE_SID Export ORACLE_BASE =/u01/app/oracle Export ORACLE_HOME = $ ORACLE_BASE/11.2/db_1 Export PATH = $ PATH: $ ORACLE_HOME/bin 4.9. ASM disk

User _ all nodes) Grid users: [Grid@rac01 ~]# Vi. Bash_profile Export ORACLE_SID=+ASM1/+ASM2 Export Oracle_base=/u01/app/oracle Export oracle_home=/u01/app/grid/11.2 Export path= $PATH: $ORACLE _home/bin Oracle Users: [Oracle@rac01 ~]# Vi. Bash_profile Export ORACLE_SID=RACDB1/RACDB2 Export Oracle_unqname= $ORACLE _sid Export Oracle_base=/u01/app/oracle Export Oracle_home= $ORACLE _base/11.2/db_1 Export path= $PATH: $ORACLE _home/bin 4.9. ASM Disk Group Planning Partitioning 4.9.1 uses FDI

followed by the SQL statement that uses the CTE. Otherwise, the CTE will become invalid. With CRSAs (select number from employer where employee like 'd % ')-- Select * From person-CTE must follow the CTE statement directly. Otherwise, an error is returned.Select * From depart where employee ID in (select * from CRS) (2) The CTE can be followed by multiple CTE, but only one with can be used. Multiple CTE are separated by commas. For example, find the Department and salary of employees whose name

, Oracle suggests using CLUVFY comp ocr-n All commands to do a full check. This command is in the Clusterware installation software.1 first turn off CRS for all nodes[Root@rac1 bin]#./crsctl Stop CRS2 Export OCR content with root user [Root@rac1 bin]#./ocrconfig-export/u01/ocr.exp 3) Restart CRS[Root@rac1 bin]#./crsctl start CRS 4) Check CRS status[Root@rac1 bin]#./crsctl Check CRSCSS appears healthyCRS appears healthyEVM appears healthy 5) Destroy OC

environment can be reproduced. Check whether you need to adjust this parameter www.2cto.com to adjust O2CB_HEARTBEAT_THRESHOLD STEP 0. stop all services connected to the database. stop the crs2.stop ocfs2 service on all nodes. 3. modify all node parameters O2CB_HEARTBEAT_THRESHOLD4. restart the o2bc service on all nodes, start ocfs2, and start the crs service. test whether the application is normal or not. 1. It affects the external service time of t

How to install Oracle11gRAC in CentOS5.5 How to install Oracle 11g RAC in CentOS 5.5 Many problems occurred when installing RAC. The summary is as follows: 1. During installation, ohasd cannot be started because root. sh is running at the same time at two nodes and an error occurs. Then delete and reinstall the disk. The previously created CRS disk cannot be selected. You have to return the disk again (select already a disk member) (This information is available only after query. You can ex

Modsecurity is an intrusion detection and blocking engine that is primarily used for Web applications so it can also be called a Web application firewall. It can be run as a module of the Apache Web server or as a separate application. The purpose of modsecurity is to enhance the security of Web applications and protect Web applications from known and unknown attacks. This paper mainly introduces the idea of a penetration testing competition for open source WAF.1. Article backgroundModsecurity S

Tags: OCR damageScenario Description:To do the OCR Backup recovery experiment, OCR has 4 automatic backup. After you replace the OCR disk with +OCR2 (/DEV/RAW/RAW4), use Ocrconfig-manualbackup to manually back up OCR, and then perform a DD operation on the/DEV/RAW/RAW4 after you complete the +data. Shut down the cluster, start the cluster, and discover that the cluster cannot start. Problem analysis (assuming you don't know where the problem is, analyze it first):1, check the Cluster service, fo

ModSecurity is an engine for intrusion detection and prevention. It is mainly used for Web applications and can also be called Web application firewall. it can be run as a module or a separate application of the Apache Web server. ModSecurity aims to enhance the security of Web applications and protect Web applications from known and unknown attacks. This article mainly introduces the idea of an open source WAF penetration testing competition.1. BackgroundModSecurity SQL Injection Challenge (A p

@zracnode1 grid]$./runinstallerThe 1.4 graphical interface is as follows:Here Cluster Name: can pick up, the actual combat named: Rac-clusterSCAN Name:zrac-scanIn combat: The name of public is: ZRACNODE1 VIP name: ZRACNODE1-VIPThe name of public is: Zracnode2 VIP's name is: ZRACNODE2-VIPIn combat: Eth0 's subnet: 10.2.13.0 corresponds to public interfaceThe subnet of eth1 is: 10.2.12.0 corresponds to private interfaceIn combat, the ASM Group was established as CRSThe selected mode is normalThe d

Many problems occurred when installing RAC. The summary is as follows: 1. During installation, ohasd cannot be started because root. sh is running at the same time at two nodes and an error occurs. Then delete and reinstall the disk. The previously created CRS disk cannot be selected. You have to return the disk again (select already a disk member) (This information is available only after query. You can execute ASMCA to manage the ASM disk group before deleting the file) Delete the CRS1,

] $./runInstaller1.4 The graphic interface is as follows:Here, the Cluster Name can be obtained by itself. In practice, it is named rac-cluster.SCAN Name: zrac-scanIn practice: public name: zracnode1 vip name: zracnode1-vipPublic name: zracnode2 vip name: zracnode2-vipIn practice, the Subnet of eth0 is: Public interface corresponding to 10.2.20.Subnet of eth1 is: Private interface corresponding to 10.2.12.0In practice, the created asm group is CRS.The selected mode is Normal.The selected disk is

unzip the package as follows:[Root @ Zracnode1 software] # ls-lTotal 7359056Drwxr-xr-x. 7 root 4096 Aug 27 2013 databaseDrwxr-xr-x. 7 root 4096 Aug 27 2013 grid1.3 install GI[Root @ Zracnode1 software] # xhost +[Root @ Zracnode1 software] # su-grid[Grid @ Zracnode1 ~] $ Cd/u01/software/grid/[Grid @ Zracnode1 grid] $./runInstaller1.4 The graphic interface is as follows:Here, the Cluster Name can be obtained by itself. In practice, it is named rac-cluster.SCAN Name: zrac-scanIn practice: public n

-creators=1 Importing stored procedure methods Delimiter $$ CREATE PROCEDURE ' Pms_authuser ' (in account varchar (255), in Vorgid varchar (255))Not deterministicContains SQLSQL Security DefinerComment 'BeginDeclare CNT integer;DECLARE pmsc varchar (100);Select @pmsc: =orgid from organization where Pmscode=vorgid;Select @cnt: =count (*) from UserInfo as UserInfo where userinfo.username=account and userinfo.orgid = @pmsc;If @cnt >0ThenSelect Userinfo.*,org.orgid as orgdepth from UserInfo as

Environment Introduction:A total of two disk groups: CRS and Data;crs use normal redundancy; Data uses external redundancy.Add a new ASM disk procedure (slightly)1. Pre-migrationSql> Select Group_number, Failgroup, Name,path from V$asm_disk order by 1group_number Failgroup NA ME PATH-------------------------------------------------------------------------------------- --------------------------0/DEV/ASM/CRS02 0/dev/asm/crs01