2011-04-29

Downshifting

  • Making a list of weekly purchases and eliminating non-essential items
  • Cutting up a credit card
  • Not buying impulsively for instant gratification
  • Hand-making items
  • Donating, recycling or reusing old items
  • Buying quality secondhand goods
http://en.wikipedia.org/wiki/Downshifting

Document TitleOCR Corruption after Adding/Removing voting disk to a cluster when CRS stack is running

OCR Corruption after Adding/Removing voting disk to a cluster when CRS stack is running (Doc ID 390880.1)

how to ADD/REMOVE/REPLACE/MOVE ocr and voting disks

Document TitleOCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) (Doc ID 428681.1)

REP-0124: Unable to write to the temporary file

UPDATE: this error may also be caused by lack (or low) of disk space on your application server ( check C or D drive in case you have windows )

CSTRSCCRP Ends In Error Rep-0124 Unable To Write To The Temp [ID 751482.1]

2011-04-28

Initial Extent Size of a Partition Changed To 8MB From 64KB

Initial Extent Size of a Partition Changed To 8MB From 64KB [ID 1295484.1]

Trial Recovery

Trial Recovery [ID 283262.1]

ORA-752 or ORA-600 [3020]

Resolving ORA-752 or ORA-600 [3020] During Standby Recovery [ID 1265884.1]

ORA-28604

ORA-28604 Error Occurs When Creating a Bitmap Index on a Table [ID 119674.1]

ASM Instance Showing Down In 11g Grid Control With Error ORA-15000

ASM Instance Showing Down In 11g Grid Control With Error ORA-15000 [ID 1276657.1]

2011-04-27

how to create a awr snapshot

EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;

apex listener

How to Use the Standalone APEX Listener [ID 1190053.1]

How To Downgrade From Database 11.2 To Previous Release

How To Downgrade From Database 11.2 To Previous Release [ID 883335.1]

DELETE_CATALOG_ROLE

This role can be granted to users to allow them to delete records from the system audit table (AUD$).

http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/privs.htm

bso black hack down

A song in Breton :


"I was waiting, waiting for a long time
In the dark shadow of grey towers
In the dark shadow of grey towers
In the dark shadow of rain towers
You will see me waiting forever
You will see me waiting forever
One day it will come back
Over the lands, over the seas
The blue wind will return
And take back with it my wounded heart
I will be pulled away by its breath
Far away in the stream, wherever it wishes
Wherever it wishes, far away from this world
Between the sea and the stars"

2011-04-21

Ofsa is not certified on linux 5

Is OFSA certified with Red Hat Linux 5?

There is no plan to certify OFSA 4.5 with Linux 5 given underlying roguewave libraries are not certified; so the entire library would need to be replaced.

2011-04-19

how to unload a BLOB to a OS file

How to Load File Content to a BLOB Field and Unload BLOB Content to a File on the OS [ID 471715.1]

how to unload a table to a flat text file

HOW TO UNLOAD A TABLE INTO SQL*LOADER FORMAT:

2011-04-15

fericire

"Noua zecimi din fericirea noastra se bazeaza pe sanatate." Schopenhauer.

"Fiecare imbatraneste asa cum a trait!"

datafile number not processed because file is read-only

Solution : http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov002.htm

6.2.1.1 Recovery of Databases with Read-Only Tablespaces

Read-only tablespaces may require special handling in a restore and recover operation. By default, the restore operation will skip read-only tablespaces. If a read-only tablespace is at the SCN where it became read-only after it is restored from backup, no redo will be applied to it when the rest of the database is recovered. You can force RMAN to restore any missing datafiles belonging to read-only tablespaces by using the CHECK READONLY option to the RESTORE command:
RMAN> RESTORE DATABASE CHECK READONLY;
RMAN> RECOVER DATABASE DELETE ARCHIVELOG;

2011-04-14

ORA-32696: HTI: No free slot

Bug 8394351  ORA-32696 from a parallel GROUP BY with no aggregates or COUNT(DISTINCT)

 

sql loader manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/part_ldr.htm  for 10.2

how to use a sequence in sql loader ( sqlldr )

"The SEQUENCE function generates a unique value in the column LOADSEQ. This function finds the current maximum value in column LOADSEQ and adds the increment (1) to it to obtain the value for LOADSEQ for each row inserted."


http://www.pafumi.net/sql_loader.htm#3

example:
  LOAD DATA
   INFILE *
   APPEND
   INTO TABLE emp
   FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
   (empno, ename, job, mgr,
   hiredate DATE(20) "DD-Month-YYYY",
   sal, comm, deptno CHAR TERMINATED BY ':',
   projno,
   loadseq  SEQUENCE(MAX,1))

There is also a second workaround: http://www.orafaq.com/wiki/SQL*Loader_FAQ 
One can also populate columns with static or derived values. However, this only applies for the conventional load path (and not for direct path loads)

LOAD DATA
  INFILE *
  INTO TABLE modified_data
  (  rec_no                      "my_db_sequence.nextval",
     region                      CONSTANT '31',
     time_loaded                 "to_char(SYSDATE, 'HH24:MI')",
     data1        POSITION(1:5)  ":data1/100",
     data2        POSITION(6:15) "upper(:data2)",
     data3        POSITION(16:22)"to_date(:data3, 'YYMMDD')"
)

how to skip the first and the last record, with sqlldr

Example: you have a text file ( fixed delimited ) and you want to load it with sql loader ( sqlldr command ) . The problem is that this file has a header and a footer

To skip the first line from the source text file is simple  ( SKIP=1 ) .. for example you have a header in the file



To skip the last line from the source text file , use the following workaround :
http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/how-to-skip-the-trailor-line-using-sql-loader-635925

Usually, when there is a trailer, there is some sort of record type
indicator. Use this in a condition of loading (I believe it is a WHEN in
SQLLOADER). Suppose your record indicator is in the first position, and is
H[eader], D[etail], T[railer]. You already probably used SKIP to skip the
header, but you can accomplish both by

WHEN (1:1)='D'

There is a pseudocolumn in SQLLOADER that shows the record number; look in
the manual; I believe is it RECORD.

Warning : http://www.orafaq.com/wiki/SQL*Loader_FAQ
SQL*Loader does not allow the use of OR in the WHEN clause. You can only use AND as in the example above! To workaround this problem, code multiple "INTO TABLE ... WHEN" clauses. Here is an example:

LOAD DATA
  INFILE  'mydata.dat' BADFILE  'mydata.bad' DISCARDFILE 'mydata.dis'
  APPEND
  INTO TABLE my_selective_table
  WHEN (01) <> 'H' and (01) <> 'T'
  (
     region              CONSTANT '31',
     service_key         POSITION(01:11)   INTEGER EXTERNAL,
     call_b_no           POSITION(12:29)   CHAR
  )
  INTO TABLE my_selective_table
  WHEN (30:37) = '20031217'
  (
     region              CONSTANT '31',
     service_key         POSITION(01:11)   INTEGER EXTERNAL,
     call_b_no           POSITION(12:29)   CHAR
)

2011-04-11

2011-04-10

ORA-600 [8201]

Rman Backup Failed With Error Rman-00600 [8201] [ID 412786.1]

2011-04-09

11gR2 Grid Infrastructure Redundant Interconnect

11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]