Oracle start up problem

Printable View

10-02-2003, 04:34 PM
sfdba

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
10-02-2003, 04:41 PM
Mr.Hanky

I do believe the correct technical term for your current situation is "FAWKED!".

Got Backup?

MH
10-02-2003, 04:58 PM
stecal

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.
10-02-2003, 06:39 PM
OracleDoc

Quote:

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.
10-02-2003, 07:14 PM
sfdba

...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help
10-02-2003, 07:34 PM
stecal

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.
10-02-2003, 07:37 PM
stecal

Quote:

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.
10-02-2003, 11:26 PM
SANJAY_G

Quote:

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
10-03-2003, 12:11 AM
stecal

Quote:

Originally posted by stecal
Look up orapwd.

Should I use my power of invisibility for good or evil?
10-03-2003, 12:48 AM
sfdba

I don't have a metalink ID, can anyone email me the article as advised by SANJAY_G
email id is : [email protected]
10-03-2003, 01:01 AM
sfdba

sorry my email id. is :

[email protected]