Oracle start up problem
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Oracle start up problem

  1. #1
    Join Date
    Jan 2002
    Posts
    40

    Oracle start up problem

    Hi to all ,
    I have a oracle server with an index2ordb.ora file of 803MB configured on a second harddisk, due unavoidable circumstances I had to format my second harddisk. When I restarted my server oracle database is not mounting and the trace file clearly indicates that the problem is due to the missing index2ordb.ora file....I don't have the password of Internal user to start the database using nomount command and recover the file....
    Will the following soln. work :
    (1) Copy the index1ordb.ora form disk1\orant\database to the second harddisk and then rename it to index2ordb.ora and restarting the server
    (2) somehow creating a file of 803 mb file and naming it as index2ordb.ora
    (3) or is there any way to connect as internal without knowing the password


    please help

    Regards
    Sfdba

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    I do believe the correct technical term for your current situation is "FAWKED!".

    Got Backup?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Why don't you have internal password? Can you login as a member of the dba_group, do sqlplus /nolog, conn / as sysdba?

    If you could log on, you could try dropping the tablespace including contents, assuming this was just an index tablespace. Then recreate it.

    The only "switch and bait" file manipulation you can perform is for identical files - internally indentical files, that is, as far as Oracle is concerned, like redo log and control files. Datafiles, unless multiplexed (obviously, yours was not), no can do.

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by Mr.Hanky
    I do believe the correct technical term for your current situation is "FAWKED!".
    Just like a football bat Or soup sandwich in your case. Either way tis` not good.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Jan 2002
    Posts
    40

    Unhappy

    ...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    Code:
    SQL> startup mount
    SQL> alter database datafile 
      2 'D:\ORACLE\ORADATA\DB00\INDX01.DBF' 
      3  offline drop;
    
    Database altered.
    
    SQL> alter database open;
    
    Database altered.
    
    SQL> drop tablespace indx including contents;
    
    Tablespace dropped.
    Wait!! Son-of-a-biscuit-eater! That was my index tablespace I just trashed.

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by sfdba
    ...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help
    Look up orapwd.

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by sfdba
    ...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help
    You can recreate the passwordfile using orapwd utility.
    For more information on similar issues go throught this.
    http://metalink.oracle.com/metalink/...&p_id=185703.1
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by stecal
    Look up orapwd.
    Should I use my power of invisibility for good or evil?

  10. #10
    Join Date
    Jan 2002
    Posts
    40

    Unhappy

    I don't have a metalink ID, can anyone email me the article as advised by SANJAY_G
    email id is : adamsb@indiatimes.com
    Last edited by sfdba; 10-03-2003 at 02:29 AM.

Posting Permissions

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


Click Here to Expand Forum to Full Width