//
archives

Archive for

JDBC Code with Oracle – Transaction

JDBC Code with Oracle – Delete

Oracle 11g R2 RAC on Oracle Enterprise Linux 5.11 with Virtual Box – Section 1 The Database Environment

Oracle RAC Nodes Node Name Instance Name Database Name Processor RAM Operation System orcl11gnode1 TESTDB1 TESTDB.newzonetech.com 2 Virtual CPU 3GB Oracel Enterprise Linux 5 upgrade 11 orcl11gnode2 TESTDB2 2 Virtual CPU 3GB Oracel Enterprise Linux 5 upgrade 11   Network Configuration Node Name Public IP Private IP Virtual IP SCAN Name SCAN IP orcl11gnode1 192.168.56.40 … Continue reading

Set Oracle User password never expired

Sometime the Oracle User account password need to set to never expire 1、First, to check the user belong to which profile,normal the user belong to ‘default’ group: 2、Check the password policy for the profile( for example ‘default’): 3、Change the password expire period from 180 days to unlimited: 4、After the password expire period change, reset the … Continue reading

JDBC Code with Oracle – update

JDBC Code with Oracle – Insert

 

JDBC Code with Oracle – select

1) Install Oracle Database Client 2) set classpath 3) Java code for SelectTest03.java