Results 1 to 8 of 8
  1. #1
    Join Date
    May 2006
    Posts
    13

    Unanswered: oracle status after reinstallation of windows XP

    can i get back my oracle9i data . i did the reinstallation of my windows XP keeping the data in that partition intact . I dont have import of data .is any way to read my procedure , triggers script ?Even if i reinstall the oracle can i attatch my datafile. plz help

  2. #2
    Join Date
    May 2006
    Posts
    132
    Are you saying you have ALL the datafiles saved in a partition that wasn't rebuilt or formatted? Do you have all the controlfiles, pfile/spfile and redo logs too?

  3. #3
    Join Date
    May 2006
    Posts
    13
    yes i am having all my files ie . pfiles, spfiles, datafiles,ctl files , redolog files

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >yes i am having all my files ie . pfiles, spfiles, datafiles,ctl files , redolog files
    So, invoke sqlplus
    startup
    exit
    & you should have a online DB again.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    May 2006
    Posts
    132
    In addition to what anacedent indicated, you will also need to create a new Windows service for the database with oradim. Enter oradim and then hit Return at a command prompt for complete syntax and options.

  6. #6
    Join Date
    May 2006
    Posts
    13

    errors in invoking

    C:\oracle\ora92\bin>sqlplus
    Error 6 initializing SQL*Plus
    Message file sp1<lang>.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory



    C:\oracle\ora92\bin>oradim
    Message 1 not found; No message file for product=RDBMS, facility=ORADIM
    Message 22 not found; No message file for product=RDBMS, facility=ORADIM
    Message 23 not found; No message file for product=RDBMS, facility=ORADIM
    Message 24 not found; No message file for product=RDBMS, facility=ORADIM
    Message 25 not found; No message file for product=RDBMS, facility=ORADIM
    Message 26 not found; No message file for product=RDBMS, facility=ORADIM
    Message 27 not found; No message file for product=RDBMS, facility=ORADIM
    Message 28 not found; No message file for product=RDBMS, facility=ORADIM
    Message 29 not found; No message file for product=RDBMS, facility=ORADIM
    Message 30 not found; No message file for product=RDBMS, facility=ORADIM
    Message 31 not found; No message file for product=RDBMS, facility=ORADIM
    Message 32 not found; No message file for product=RDBMS, facility=ORADIM
    Message 33 not found; No message file for product=RDBMS, facility=ORADIM
    Message 34 not found; No message file for product=RDBMS, facility=ORADIM
    ===============
    These are the errors i am getting .
    In oracle registry entry i can only see NLS_LANG;
    i do not find other parameters like
    ORACLE_HOME, ORACLE_SID, and LD_LIBRARY_PATH.

    In environmental variable i have added SQLPLUS : C:\oracle\ora92\sqlplus\mesg;

    now the error has changed to

    C:\oracle\ora92\bin>sqlplus
    SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0
    Unable to proceed
    ========
    can i add these registry entry on my own ;

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >can i add these registry entry on my own ;
    We give up. Can you? Should you?

    >In environmental variable i have added SQLPLUS : C:\oracle\ora92\sqlplus\mesg;
    WHY? Do you know what an evironmental variable is & how it is used?


    >SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
    You need to correct this before getting to the next error.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    May 2006
    Posts
    132
    Quote Originally Posted by anacedent
    >We give up. Can you? Should you?
    LOL...that is classic !!

    @OP...It may help to read over Oracle9i Database Administrator's Guide Release 2 (9.2) for Windows.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •