No question at this time
DBA Top 10
1 M. Cadot 15900
2 A. Kavsek 11800
3 B. Vroman 10800
4 M. Hidayathullah ... 7600
5 T. Boles 4800
6 P. Wisse 4000
7 J. Schnackenberg 3000
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 700
9 T. P 700
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48114
Total active users1700
Act. users last 24h12
Act. users last hour1
Registered user hits last week507
Registered user hits last month1127
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, 21 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, 21 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, 21 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