No question at this time
DBA Top 10
1 M. Cadot 15900
2 B. Vroman 15500
3 A. Kavsek 10000
4 T. Boles 6800
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3900
7 P. Wisse 1800
8 T. P 700
9 B. Derous 500
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48209
Total active users1645
Act. users last 24h6
Act. users last hour0
Registered user hits last week186
Registered user hits last month812
Go up

transportable database - windows to linux
Next thread: Tuning
Prev thread: EXP-00003: no storage definition found fo

Message Score Author Date
I am following several notes on migrating a databa...... Jeffrey Beckstrom Dec 27, 2017, 15:19
Crossref http://www.orafaq.com/forum/mv/msg/2...... Michel Cadot Dec 27, 2017, 15:52
Hi, one thing for sure is that you have a synta...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Ales Kavsek Dec 27, 2017, 16:24

Follow up by mail Click here


Subject: transportable database - windows to linux
Author: Jeffrey Beckstrom, United States
Date: Dec 27, 2017, 15:19, 176 days ago
Message: I am following several notes on migrating a database from Windows to Linux. One of the notes is 1401921.1. Database is 11.2.0.4 so using transportable database option.

I have copied all of the database files from Windows to the Linux server using OS commands.The System and rollback datafiles were placed in a separate directory awaiting conversion.

I nomounted the database and started rman on the Linux server.

Now trying to convert the system and rollback datafiles only since they need conversion per the MOS notes.

I am attempting to run the following command from a file:

CONVERT datafile
'/oracle/orat/convert/system.dbf',
'/oracle/orat/convert/system_2.dbf',
'/oracle/orat/convert/system_3.dbf',
'/oracle/orat/convert/system_4.dbf',
'/oracle/orat/convert/system_5.dbf',
'/oracle/orat/convert/rollback.dbs'
DB_FILE_NAME_CONVERT
'/oracle/orat/convert','/oracle/orat'
FROM PLATFORM 'Microsoft Windows x86 64-bit
parallelism 6;

When I run this command, I get:

RMAN> @rman_convert_datafile.sql

RMAN> CONVERT datafile
2> '/oracle/orat/convert/system.dbf',
3> '/oracle/orat/convert/system_2.dbf',
4> '/oracle/orat/convert/system_3.dbf',
5> '/oracle/orat/convert/system_4.dbf',
6> '/oracle/orat/convert/system_5.dbf',
7> '/oracle/orat/convert/rollback.dbs'
8> DB_FILE_NAME_CONVERT
9> '/oracle/orat/convert','/oracle/orat'
10> FROM PLATFORM 'Microsoft Windows x86 64-bit
11> parallelism 6;
12>
13>
14> **end-of-file**
15>

RMAN is listing the file instead of executing the commands. What am I doing wrong?
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: transportable database - windows to linux
Author: Michel Cadot, France
Date: Dec 27, 2017, 15:52, 176 days ago
Message:
Crossref

http://www.orafaq.com/forum/mv/msg/204243/667423/#msg_667423

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

Subject: Re: transportable database - windows to linux
Author: Ales Kavsek, Slovenia
Date: Dec 27, 2017, 16:24, 176 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi,

one thing for sure is that you have a syntax error at line 10, missing a single quote at the end of platform name...

FROM PLATFORM 'Microsoft Windows x86 64-bit

should be:

FROM PLATFORM 'Microsoft Windows x86 64-bit'

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