12 Replies Latest reply: Jun 7, 2012 10:01 AM by 941917 RSS

    Computer crash

    941917
      Hello everybody,
      I'm using Oracle 9.2 on an old computer that suddenly broke down. We managed to recover the data from the hard disk, and I want to recreate the databases on a new machine. I tried to create a new DB and substitute the *.DBF files, but the database ID is different and it doesn't work.
      Can you help me or tell me where can I find some useful information?

      Thank you
      Davide
        • 1. Re: Computer crash
          Uwehesse-Oracle
          You need to install the same 9i sources you had on your old server onto the new server.
          Then you just copy the database files that you apparently saved from the crashed into the same directory structure on the new server.
          No need to create a new database then. Just startup the old there.

          Kind regards
          Uwe Hesse

          "Don't believe it, test it!"
          http://uhesse.com
          • 2. Re: Computer crash
            941917
            What sources I need to copy exactly? Or where can I find info on the procedure to do that?

            Thanks
            Davide
            • 3. Re: Computer crash
              Uwehesse-Oracle
              If you have the installation media for your 9i DB software not available, you need to request them from Oracle - I suppose you have a license.
              They cannot be downloaded anymore from the Oracle OTN wbesite.

              I recommend that you open a Service Request here for that https://support.oracle.com/

              Kind regards
              Uwe Hesse

              "Don't believe it, test it!"
              http://uhesse.com
              • 4. Re: Computer crash
                941917
                Thanks for the reply Uwe,
                I installed the same Ora version, copied the old DB folder in the new datafiles folder, rebooted and I now see the DB in the console list.
                However when I try to connect I get:
                "ORA-12154: TNS: could not resolve service name."
                I realized there is no Oracle Service running and that the tnsnames.ora is not updated with the new database
                How to make it run?
                • 5. Re: Computer crash
                  Uwehesse-Oracle
                  Easy if that is your only problem :)

                  Try first to set ORACLE_SID to the name of your DB like
                  $ export ORACLE_SID=orcl
                  if orcl is the name of your DB. Then type in
                  $ id
                  Confirm your OS user is in the group dba. Then
                  sqlplus
                  SQL> connect / as sysdba
                  SQL> startup
                  If that works, you won. Sort out the TNS thing later on.

                  Kind regards
                  Uwe Hesse

                  "Don't believe it, test it!"
                  http://uhesse.com

                  Edited by: Uwe Hesse on 06.06.2012 14:46 changed the sys connect because that was different in 9i
                  • 6. Re: Computer crash
                    941917
                    Sorry but I'm not a DB administrator so I need more explanations..
                    Unfortunately I've a Windows machine and the command

                    $ export ORACLE_SID=orcl

                    doesn't work, however I think I set the SID though the Console.
                    After that I've (manually) created a service for the database and updated the file tnsnames.ora.
                    Now when I try to connect I get

                    ORA-12514: TNS:listener does not currently know SERVICE_NAME requested in connect descriptor

                    So do you think I did what you asked right?
                    And how do you suggest to solve the TNS?

                    Thanks for the patience!
                    Davide
                    • 7. Re: Computer crash
                      sb92075
                      938914 wrote:
                      Sorry but I'm not a DB administrator so I need more explanations..
                      Unfortunately I've a Windows machine and the command

                      $ export ORACLE_SID=orcl

                      doesn't work, however I think I set the SID though the Console.
                      After that I've (manually) created a service for the database and updated the file tnsnames.ora.
                      Now when I try to connect I get

                      ORA-12514: TNS:listener does not currently know SERVICE_NAME requested in connect descriptor

                      So do you think I did what you asked right?
                      And how do you suggest to solve the TNS?

                      Thanks for the patience!
                      Davide
                      I suspect that the DB has not yet been started

                      open Command Window & type exactly (line for line) as below

                      sqlplus
                      / as sysdba
                      startup

                      COPY commands & results then PASTE all back here.
                      • 8. Re: Computer crash
                        904735
                        Hi,

                        Did you start the listener?

                        Check the

                        1.listener status and listener log file.
                        2.Check the TNS ping status.

                        And could you please paste you are exact out puts so that we can give better output..

                        Thanks,
                        Srini...
                        • 9. Re: Computer crash
                          sb92075
                          Srini wrote:
                          Hi,

                          Did you start the listener?

                          Check the

                          1.listener status and listener log file.
                          2.Check the TNS ping status.

                          And could you please paste you are exact out puts so that we can give better output..

                          Thanks,
                          Srini...
                          only could get error below when listener is already running

                          ORA-12514: TNS:listener does not currently know SERVICE_NAME requested in connect descriptor
                          • 10. Re: Computer crash
                            904735
                            Oh...ok..Thanks for correcting me.. :)
                            • 11. Re: Computer crash
                              941917
                              I suspect that the DB has not yet been started
                              open Command Window & type exactly (line for line) as below

                              sqlplus
                              / as sysdba
                              startup

                              COPY commands & results then PASTE all back here.>

                              Thanks for your help,
                              Doing that first I get:
                              bq. Connected to:
                              bq. Oracle 9i Enterprise Edition Release ...

                              and then with the startup:
                              bq. ORA-01081: cannot start already-running ORACLE - shut it down first

                              And about the other question:
                              2.Check the TNS ping status.
                              I get OK

                              So basically I have copied my old database folder in the new folder, created a service but the listener doesn't know the service name yet..
                              Any idea? Does anyone know any other thread where I can find info on how to recover a database from the folder files?
                              • 12. Re: Computer crash
                                941917
                                I better do a short summary of what I did and what is the problem:

                                PROBLEM:
                                1. My computer crashed, the only things left are the files from the oradata folder (.DBF, .CTL, log)
                                2. I want to restore the old databases on a new machine (or at least read the data)

                                SOME INFO
                                I'm using Oracle 9.2 on Window XP both in the old and new machine.

                                WHAT I DID:
                                As suggested previously I copied the old DB files in the new oradata folder and now the Oracle console does see the DB.
                                What else should I do?

                                Thank you
                                Davide