oracle database 11.2.0.3 release patch set 2

Patch 10404530: 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER

11.2.0.3 Patch Set - List of Bug Fixes by Problem Type [ID 1348303.1]

ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [ID 880782.1]

Installation Types and Associated Zip Files
Installation Type Zip File

Oracle Database (includes Oracle Database and Oracle RAC) p10404530_112030_platform_1of7.zip

Note: you must download both zip files to install Oracle Database. p10404530_112030_platform_2of7.zip


Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart) p10404530_112030_platform_3of7.zip

Oracle Database Client p10404530_112030_platform_4of7.zip

Oracle Gateways p10404530_112030_platform_5of7.zip

Oracle Examples p10404530_112030_platform_6of7.zip

Deinstall p10404530_112030_platform_7of7.zip

ASM

v$asm_diskgroup
v$asm_disk


create tablespace tbsname datafile size 10m autoextend on maxsize 10g;

alter tablespace tbsname add datafile size 10m autoectend on maxsize 10g;

View Description

V$ASM_ALIAS


In an ASM instance, contains one row for every alias present in every disk group mounted by the ASM instance.

In a DB instance, contains no rows.

V$ASM_ATTRIBUTE


Displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, the view may show other attributes that are created automatically. Note that attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher.

V$ASM_CLIENT


In an ASM instance, identifies databases using disk groups managed by the ASM instance.

In a DB instance, contains information about the ASM instance if the database has any open ASM files.

V$ASM_DISK


In an ASM instance, contains one row for every disk discovered by the ASM instance, including disks that are not part of any disk group.

In a DB instance, contains rows only for disks in the disk groups in use by that DB instance.

This view performs disk discovery every time it is queried.

V$ASM_DISK_IOSTAT


Displays information about disk I/O statistics for each ASM client.

In a DB instance, only the rows for that instance are shown.

V$ASM_DISK_STAT


In an ASM instance, contains the same columns as V$ASM_DISK, but to reduce overhead, does not perform a discovery when it is queried. It does not return information about any disks that are new to the storage system. For the most accurate data, use V$ASM_DISK instead.

V$ASM_DISKGROUP


In an ASM instance, describes a disk group (number, name, size related info, state, and redundancy type).

In a DB instance, contains one row for every ASM disk group mounted by the local ASM instance.

This view performs disk discovery every time it is queried.

V$ASM_DISKGROUP_STAT


In an ASM instance, contains the same columns as V$ASM_DISKGROUP, but to reduce overhead, does not perform a discovery when it is queried. It does not return information about any disks that are new to the storage system. For the most accurate data, use V$ASM_DISKGROUP instead.

V$ASM_FILE


In an ASM instance, contains one row for every ASM file in every disk group mounted by the ASM instance.

In a DB instance, contains no rows.

V$ASM_OPERATION


In an ASM instance, contains one row for every active ASM long running operation executing in the ASM instance.

In a DB instance, contains no rows.

V$ASM_TEMPLATE


In an ASM or DB instance, contains one row for every template present in every disk group mounted by the ASM instance.

send email automatically in linux

1. mail
mail -s "test" test@test.com < messge.txt mail -s "test" test@test.com <test
>test
>test
>EOF

2. mutt
mutt -s "test" -a test.log test@test.com < message.txt mutt -s "test" -a test.log test@test.com <test
>test
>test
>EOF

ATTN: uuencode can be used with mail to attach file, but it was not installed by default. To install uuencode, install package: sharutils

reference:
http://www.cyberciti.biz/tips/sending-mail-with-attachment.html
http://www.thegeekstuff.com/2009/12/how-to-send-an-email-with-attachment-and-body-from-linux/

escape in sqlplus

set colsep ',' #used to generate csv file

set escape \ #used to escape substitution charactor in sql, not for sql processing.

for example select '\&1' from dual;

if you want to escape character in like clause

use .... like '\_sss' escape '\'

reference:
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:12520384680605

date format in oracle loader

start_date TIMESTAMP "Mon dd yyyy hh:mi:ss:ff3AM",

select to_char(systimestamp,'Mon-dd-yyyy hh:mi:ss:ff3AM') from dual;

reference:
http://www.dbforums.com/oracle/1118058-sql-loader-date-format-unrecognized.html

date in unix

date +%Y_%m_%d

%% a literal %

%a localeâs abbreviated weekday name (e.g., Sun)

%A localeâs full weekday name (e.g., Sunday)

%b localeâs abbreviated month name (e.g., Jan)

%B localeâs full month name (e.g., January)

%c localeâs date and time (e.g., Thu Mar 3 23:05:25 2005)

%C century; like %Y, except omit last two digits (e.g., 21)

%d day of month (e.g, 01)

%D date; same as %m/%d/%y

%e day of month, space padded; same as %_d

%F full date; same as %Y-%m-%d

%g last two digits of year of ISO week number (see %G)

%G year of ISO week number (see %V); normally useful only with %V

%h same as %b

%H hour (00..23)

%I hour (01..12)

%j day of year (001..366)

%k hour ( 0..23)

%l hour ( 1..12)

%m month (01..12)

%M minute (00..59)

%n a newline

%N nanoseconds (000000000..999999999)

%p localeâs equivalent of either AM or PM; blank if not known

%P like %p, but lower case

%r localeâs 12-hour clock time (e.g., 11:11:04 PM)

%R 24-hour hour and minute; same as %H:%M

%s seconds since 1970-01-01 00:00:00 UTC

%S second (00..60)

%t a tab

%T time; same as %H:%M:%S

%u day of week (1..7); 1 is Monday

%U week number of year, with Sunday as first day of week (00..53)

%V ISO week number, with Monday as first day of week (01..53)

%w day of week (0..6); 0 is Sunday

%W week number of year, with Monday as first day of week (00..53)

%x localeâs date representation (e.g., 12/31/99)

%X localeâs time representation (e.g., 23:13:48)

%y last two digits of year (00..99)

%Y year

%z +hhmm numeric timezone (e.g., -0400)

%:z +hh:mm numeric timezone (e.g., -04:00)

%::z +hh:mm:ss numeric time zone (e.g., -04:00:00)

%:::z numeric time zone with : to necessary precision (e.g., -04,
+05:30)

%Z alphabetic time zone abbreviation (e.g., EDT)

Informatica

1. startup
$INFA_HOME/tomcat/bin/infaservice.sh startup

2. shutdown
$INFA_HOME/tomcat/bin/infaservice.sh shutdwon

log file: $INFA_HOME/tomcat/logs/catalina.out


3. change database connection info

$INFA_HOME/server/infasetup.sh updateGatewayNode -da database_hostname:database_port -ds database_name

4. change database password
$INFA_HOME/server/infasetup.sh UpdateGatewayNode -databasepassword

./infasetup.sh UpdateGatewayNode -da [new database host]:[new database port] -du [new database user] -dp [new database password -dt [database type i.e. db2] -ds [new database name]


reference:
https://forums.oracle.com/forums/thread.jspa?threadID=2240006
https://community.informatica.com/thread/27876
http://www.tek-tips.com/viewthread.cfm?qid=1561513