No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 7600
3 B. Vroman 4800
4 P. Wisse 4000
5 J. Schnackenberg 3200
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48536
Total active users1398
Act. users last 24h2
Act. users last hour1
Registered user hits last week128
Registered user hits last month434
Go up

oracle 11.2.0.4 on linux 8
Next thread: Connection Management Call Elapsed Time in AWR Report quite high
Prev thread: RMAN ckpn SCN and cumulative differential backup

Message Score Author Date
Hi, I have an old hardware, linux 6, oracle 11.2....... Alain Bourgeois Aug 11, 2020, 15:48
Instead of restoring the (rman?) backup, create ...... Michel Cadot Aug 11, 2020, 17:15
Not possible: the db is several Tb big and downtim...... Alain Bourgeois Aug 11, 2020, 17:22
You have few choices. You can't do as you want ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Michel Cadot Aug 11, 2020, 17:42
Hi Alain, why do you want to mess with 11g inst...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Ales Kavsek Aug 12, 2020, 22:10
"open database with upgrade option" Do you mean t...... Alain Bourgeois Aug 13, 2020, 09:09
Hi Alain, it's explained in this thread: htt...... Ales Kavsek Aug 14, 2020, 08:43
The example in this thread is talking about a "col...... Alain Bourgeois Aug 14, 2020, 09:38
Hi, ok, perhaps I was not clear enough in my po...... Ales Kavsek Aug 14, 2020, 12:03
Nope, it is not the same db nor the same hardware....... Alain Bourgeois Aug 14, 2020, 12:34
Hi, yes, this is the path that I would consider...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Aug 14, 2020, 13:13

Follow up by mail Click here


Subject: oracle 11.2.0.4 on linux 8
Author: Alain Bourgeois, Belgium
Date: Aug 11, 2020, 15:48, 45 days ago
Os info: OEL 8
Oracle info: 11.2.0.4 SE
Message: Hi,
I have an old hardware, linux 6, oracle 11.2.0.4 SE.
New hardware is ready to install and apps are 12.2 compatible, so the plan would be to install new hardware with:
* Linux 8
* grid 19.8
* oracle db 11.2.0.4
* oracle db 19.8
then restore 11 backup, dbua 19.8, remove 11g.

Problem: according to https://www.guj.com.br/t/erro-na-instalacao-do-oracle-11g-no-oracle-linux-8-instalei-o-java-13-na-maquina/399769, oracle 11 will refuse to install on linux 8.

Does someone have a hint to make it run, just the time needed to do restore, recover, open resetlogs (db is several Tb so restore and recover will take several days)?
(I would like to avoid linux 7 upgrade to 8, and want to leave old system intact until end of upgrade process).

Thanks.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Michel Cadot, France
Date: Aug 11, 2020, 17:15, 45 days ago
Message:
Instead of restoring the (rman?) backup, create a Data Pump dump and import it in a newly created 19c db.

Regards
Michel


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Alain Bourgeois, Belgium
Date: Aug 11, 2020, 17:22, 45 days ago
Message: Not possible: the db is several Tb big and downtime is limited to a few hours.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Michel Cadot, France
Date: Aug 11, 2020, 17:42, 45 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message:
You have few choices.
You can't do as you want then you have to do it as you don't want.

You can also do it in several steps using several servers (or VM) with OS compatible with subsequent db upgrades 11g->12c->...->19c, which means several downtimes.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Ales Kavsek, Slovenia
Date: Aug 12, 2020, 22:10, 44 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Alain,

why do you want to mess with 11g installation on OEL8 in the first place if you really want an immediate upgrade from 11g to 12c on this new server?

You were already told that you can restore/recover 11g RMAN backupset with higher release, such as 19.8.

Simply put 11g RMAN backupset on OEL 8 filesystem and then restore RMAN backupset with db 19.8. Of course, you'll have to open database with upgrade option and execute manual upgrade (you can't use DBUA).

Regards,
Ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Alain Bourgeois, Belgium
Date: Aug 13, 2020, 09:09, 43 days ago
Message: "open database with upgrade option"
Do you mean that after recover, I can type "startup upgrade"? I thought that an "open resetlogs" from 11g was needed before?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Ales Kavsek, Slovenia
Date: Aug 14, 2020, 08:43, 42 days ago
Message: Hi Alain,

it's explained in this thread:

https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=95068

If you open the link that I provided at the end, you'll find a "demo" of restoring RMAN 9i backup with RMAN 10g.

Regards,
Aleš

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Alain Bourgeois, Belgium
Date: Aug 14, 2020, 09:38, 42 days ago
Message: The example in this thread is talking about a "cold" backup and has no recover. For this case, I have to recover . I think I will have to copy the online redo logs, recreate controlfile then use recover database from sqlplus.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Ales Kavsek, Slovenia
Date: Aug 14, 2020, 12:03, 42 days ago
Message: Hi,

ok, perhaps I was not clear enough in my post. RMAN of higher version can restore and recover backup set made with RMAN of lower version. So, you can have as an input cold or hot RMAN backup, the point is that restore and recovery is done by RMAN.

When you're at the point that you need to open the database exit RMAN, launch SQL*Plus:

sql> alter database open resetlogs upgrade;
sql> <--- run all the scripts that you need for an upgrade --->

I suggest that you setup some dummy/test environment to run
and test all the upgrade steps.

I guess this 11g database is around ~25TB, the DB that you rescued!?
One strategy that you can use is to restore DB, then apply with recovery as many daily diffs/(or redo logs) as you want, keeping DB up to date as much as possible, to minimize downtime needed for recovery on D-Day. The size of the database has little impact on time needed for upgrade.
Be careful however about no-logging operations (direct-path loads etc.!

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Alain Bourgeois, Belgium
Date: Aug 14, 2020, 12:34, 42 days ago
Message: Nope, it is not the same db nor the same hardware. In this case, source is fine, is still alive (r/w), 5.5Tb.

Strategy is as you suggested: stop primary when there is nearly nothing to recover.

upgrade db to 19.8 on new hardware, and change connectionstrings meanwhile.

Then reset all passwords (case-sensitivity) and upgrade timezone.
Then setup SE HA.

downtime expected to 3 hours.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 11.2.0.4 on linux 8
Author: Ales Kavsek, Slovenia
Date: Aug 14, 2020, 13:13, 42 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi,

yes, this is the path that I would consider first. Since you have a new server, you can practice this scenario a couple of times with real database on real HW. The downtime of 3h is achievable, but only if you prepare and practice all the steps, catching any surprises beforehand. For major upgrades of production systems I usually start preparing at least two months before D-day, don't hurry (Mike Dietrich site is always my first stop).

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here