-
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
-
I do believe the correct technical term for your current situation is "FAWKED!".
Got Backup?
MH
I remember when this place was cool.
-
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.
-
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
-
...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help
-
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.
-
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.
-
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"
-
Originally posted by stecal
Look up orapwd.
Should I use my power of invisibility for good or evil?
-
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 01: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|