Operating System - HP-UX
1748359 Members
5085 Online
108763 Solutions
New Discussion юеВ

Re: Startup Oracle DB with different version of excutable..!?

 
Warren_9
Honored Contributor

Startup Oracle DB with different version of excutable..!?

Hiya,

I've an Oracle DB in version 7.2.0 but lost the oracle executables.....

is it possible to use other verison of oracle executable to open and mount the DB?

The oldest oracle i can found is 7.2.3!
if not, any suggestion to startup the DB??

THX,
Warren
14 REPLIES 14
Luk Vandenbussche
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

Hi Warren,

I it will work if you have the init.ora file.
But I would take a backup of all datafiles before trying this action
Warren_9
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

hi,

actually, the $ORACLE_HOME was lost and also the init.ora and the listener configure.

Can i use the default parameters to startup the DB? of course i need to point to the correct control files in the init.ora

THX,
Warren
Luk Vandenbussche
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

Hi Warren,

I should work with the default parameters in init.ora
Yogeeraj_1
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

hi,

before you try anything, please do a full backup.

if you have a copy of the database controlfile, maybe you can get back to operations quite easily...

is your database still up?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Frank de Vries
Respected Contributor

Re: Startup Oracle DB with different version of excutable..!?

Technically you can do it,
your version is not to far off.

first you can go to nomount state to debug
your new init.ora file.
Once you have achieved that you can
check the control file(s) by going
to mount state.
You may need to run the catproc again !!
(it doesn't do any harm anyway if you do)
from there you can open with a
open resetlogs.

Good luck


Look before you leap
Indira Aramandla
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

Hi Warren,

Yes it should work with the default parameters in init.ora. As you mentioned change the parameter file to point to the correct location of the control files, and also check the number and the names of the rollback segments defined are the same as defined in the database.

And as Yogeeraj mentioned, it is good to take a full backup of the DB.


IA

Never give up, Keep Trying
Warren_9
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

Hi all,

Thanks for the reply!

The DB is restored from tape but ppl didn't perform any backup on the oracle executables..!!

I also post the question in a oracle forum and 1 reply said that it need to start the DB in upgrade/migrate mode, any idea?

I need to make sure the procedure and it will work

MANY THX!!
Warren.
Warren_9
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

....

If I don't know the name of the RBS, could I startup the DB in nomount and re-create a new group of RBS?

THX.
Warren
Indira Aramandla
Honored Contributor

Re: Startup Oracle DB with different version of excutable..!?

Hi Warren,

If you do not know the rollback segment names and the number of them, then you can comment this line in the init.ora file before starting the database.



IA
Never give up, Keep Trying