Message-Id: <10725.125477@fatcity.com> From: Philippe Siquin Date: Fri, 29 Dec 2000 11:56:05 -1000 Subject: my ORA-1079 gift for christmas and happy new year; thanx --=====================_15402173==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed subject: my ORA-1079 gift for christmas and happy new year; thanx Oracle! :-) hello, while trying to 'startup' my database, i have the following message: ORA-01079: ORACLE database was not properly created, operation aborted SVRMGR> I tried to recreate a controlfile as said in the doc : SVRMGR> create controlfile reuse 2> database FISCD 3> logfile 4> '/ora01/oraredo/FISCD/redoFISCD11.log' size 1M, 5> '/ora01/oraredo/FISCD/redoFISCD21.log' size 1M, 6> '/ora01/oraredo/FISCD/redoFISCD31.log' size 1M 7> noresetlogs 8> datafile 9> '/ora01/oradata/FISCD/sys01.dbf' size 50M 10> maxinstances 8 11> maxlogfiles 32 12> / Statement processed. alter database open * ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/ora01/oradata/FISCD/sys01.dbf' aaaaaaaaaaahhhh!!!!!!!!! ok, I recover datafile : PROD_sfx [SOFIX]:/home/oracle> oerr ora 1113 01113, 00000, "file %s needs media recovery" // *Cause: An attempt was made to online or open a database with a file that // is in need of media recovery. // *Action: First apply media recovery to the file. SVRMGR> select * from v$recover_file ; FILE# ONLINE ERROR CHANGE# TIME ---------- ------- ------------------ ---------- --------- 1 ONLINE 149111 28/12/00 1 row selected. SVRMGR> recover datafile '/ora01/oradata/FISCD/sys01.dbf' Media recovery complete. Super! it works :-)))))) SVRMGR> alter database open ; alter database open * ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], [], [], [] :-((((( F*ck ! oerr ora 600 00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" // *Cause: This is the generic internal error number for Oracle program // exceptions. This indicates that a process has encountered an // exceptional condition. // *Action: Report as a bug - the first argument is the internal error number any ideas ? PS: i'm not an Oracle-guru (as you can see...:-) PS2: Happy new year from Tahiti (French Polynesia)! * | | * | * \ | / \ . / \ a / \ .@. / @@@ * - - - - - `@@@@@@@@@@@@@' - - - - - * `@@@@@@@' / @@@@ @@@@ \ / @@@ @@@ \ / @@ + @@ \ ' "X" ` "XXX" "XXXXX" "GOD JUL" "BUON ANNO" "FELIZ NATAL" "JOYEUX NOEL" "VESELE VANOCE" "MELE KALIKIMAKA" "NODLAG SONA DHUIT" "BLWYDDYN NEWYDD DDA" """""""BOAS FESTAS""""""" "FELIZ NAVIDAD" "MERRY CHRISTMAS" "KALA CHRISTOUGENA" "VROLIJK KERSTFEEST" "FROHLICHE WEIHNACHTEN" "BUON NATALE-GODT NYTAR" "HUAN YING SHENG TAN CHIEH" "WESOLYCH SWIAT-SRETAN BOZIC" "MOADIM LESIMHA-LINKSMU KALEDU" "HAUSKAA JOULUA-AID SAID MOUBARK" """""""'N PRETTIG KERSTMIS""""""" "ONNZLLISTA UUTTA VUOTTA" "Z ROZHDESTYOM KHRYSTOVYM" "NADOLIG LLAWEN-GOTT NYTTSAR" "FELIC NADAL-GOJAN KRISTNASKON" "S NOVYM GODOM-FELIZ ANO NUEVO" "GLEDILEG JOL-NOELINIZ KUTLU OLSUM" "EEN GELUKKIG NIEUWJAAR-SRETAN BOSIC" "KRIHSTLINDJA GEZUAR-KALA CHRISTOUGENA" "SELAMAT HARI NATAL - LAHNINGU NAJU METU" """""""SARBATORI FERICITE-BUON ANNO""""""" "ZORIONEKO GABON-HRISTOS SE RODI" "BOLDOG KARACSONNY-VESELE VIANOCE " "MERRY CHRISTMAS AND HAPPY NEW YEAR" "ROOMSAID JOULU PUHI -KUNG HO SHENG TEN" "FELICES PASUAS - EIN GLUCKICHES NEUJAHR" "PRIECIGUS ZIEMAN SVETKUS SARBATORI VESLLE" "BONNE ANNEBLWYDDYN NEWYDD DDADRFELIZ NATAL" """"""""""""""""""""""""""""""""""""""""""""""""" XXXXX XXXXX XXXXX XXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX --=====================_15402173==_.ALT Content-Type: text/html; charset="us-ascii" subject: my ORA-1079 gift for christmas and happy new year; thanx Oracle! :-)

hello,

while trying to 'startup' my database, i have the following message:

ORA-01079: ORACLE database was not properly created, operation aborted
SVRMGR>

I tried to recreate a controlfile as said in the doc :

SVRMGR> create controlfile reuse
     2> database FISCD
     3> logfile
     4>         '/ora01/oraredo/FISCD/redoFISCD11.log'  size 1M,
     5>         '/ora01/oraredo/FISCD/redoFISCD21.log'  size 1M,
     6>         '/ora01/oraredo/FISCD/redoFISCD31.log'  size 1M
     7> noresetlogs
     8> datafile
     9> '/ora01/oradata/FISCD/sys01.dbf'        size   50M
    10> maxinstances 8
    11> maxlogfiles  32
    12> /
Statement processed.

alter database open
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/ora01/oradata/FISCD/sys01.dbf'


aaaaaaaaaaahhhh!!!!!!!!!
ok, I recover datafile :


PROD_sfx [SOFIX]:/home/oracle> oerr ora 1113
01113, 00000, "file %s needs media recovery"
// *Cause:  An attempt was made to online or open a database with a file that
//         is in need of media recovery.
// *Action: First apply media recovery to the file.


SVRMGR> select * from v$recover_file ;
FILE#      ONLINE  ERROR              CHANGE#    TIME    
---------- ------- ------------------ ---------- ---------
         1 ONLINE                         149111 28/12/00
1 row selected.


SVRMGR> recover datafile '/ora01/oradata/FISCD/sys01.dbf'
Media recovery complete.


Super! it works :-))))))



SVRMGR> alter database open ;
alter database open
*
ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], [], [], []


:-((((( F*ck !

oerr ora 600
00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause:  This is the generic internal error number for Oracle program
//         exceptions.  This indicates that a process has encountered an
//         exceptional condition.
// *Action: Report as a bug - the first argument is the internal error number

any ideas ?
PS: i'm not an Oracle-guru (as you can see...:-)
PS2: Happy new year from Tahiti (French Polynesia)!

                                     *
                                     |
                                     |
                         *           |           *
                           \         |         /
                             \       .       /
                               \     a     /
                                 \  .@.  /
                                    @@@
                 * - - - - -  `@@@@@@@@@@@@@'  - - - - - *
                                 `@@@@@@@'
                             /   @@@@ @@@@    \
                           /    @@@     @@@     \
                         /     @@    +    @@      \
                             '      "X"      `
                                   "XXX"
                                  "XXXXX"
                                 "GOD JUL"
                                "BUON ANNO"
                               "FELIZ NATAL"
                              "JOYEUX   NOEL"
                             "VESELE   VANOCE"
                            "MELE   KALIKIMAKA"
                           "NODLAG  SONA  DHUIT"
                          "BLWYDDYN  NEWYDD  DDA"
                         """""""BOAS FESTAS"""""""
                              "FELIZ NAVIDAD"
                             "MERRY CHRISTMAS"
                            "KALA CHRISTOUGENA"
                           "VROLIJK  KERSTFEEST"
                          "FROHLICHE WEIHNACHTEN"
                         "BUON  NATALE-GODT NYTAR"
                        "HUAN YING SHENG TAN CHIEH"
                       "WESOLYCH SWIAT-SRETAN BOZIC"
                      "MOADIM LESIMHA-LINKSMU KALEDU"
                     "HAUSKAA JOULUA-AID SAID MOUBARK"
                    """""""'N  PRETTIG  KERSTMIS"""""""
                         "ONNZLLISTA UUTTA VUOTTA"
                        "Z ROZHDESTYOM  KHRYSTOVYM"
                       "NADOLIG LLAWEN-GOTT NYTTSAR"
                      "FELIC NADAL-GOJAN KRISTNASKON"
                     "S  NOVYM  GODOM-FELIZ ANO NUEVO"
                    "GLEDILEG JOL-NOELINIZ KUTLU OLSUM"
                   "EEN GELUKKIG NIEUWJAAR-SRETAN BOSIC"
                  "KRIHSTLINDJA GEZUAR-KALA CHRISTOUGENA"
                 "SELAMAT HARI NATAL - LAHNINGU NAJU METU"
                """""""SARBATORI FERICITE-BUON  ANNO"""""""
                     "ZORIONEKO GABON-HRISTOS SE RODI"
                    "BOLDOG KARACSONNY-VESELE  VIANOCE "
                   "MERRY CHRISTMAS  AND  HAPPY NEW YEAR"
                  "ROOMSAID JOULU PUHI -KUNG HO SHENG TEN"
                 "FELICES PASUAS -  EIN GLUCKICHES NEUJAHR"
                "PRIECIGUS ZIEMAN SVETKUS  SARBATORI VESLLE"
               "BONNE  ANNEBLWYDDYN  NEWYDD DDADRFELIZ  NATAL"
              """""""""""""""""""""""""""""""""""""""""""""""""
                                   XXXXX
                                   XXXXX