Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Single instance to RAC

Raghav_DBANov 6 2016

I am converting single instance database to RAC manually.

While creating log file for node 2 getting error

SQL> alter database add logfile thread 2 group 4 ('+DATA’,'+FRA’) size 50m;

alter database add logfile thread 2 group 4 ('+DATA’,'+FRA’) size 50m

                                                        *

ERROR at line 1:

ORA-00907: missing right parenthesis

Comments

thatJeffSmith-Oracle

migrations are setup in 2 primary steps, schema capture and data capture - what you want is pretty simple - just skip the data capture

it has a wizard, you can walk it

it's documented in the help, i've written 2 white papers as well

Mike Kutz

Jammin wrote:

Hi All,

I' d like to use the existing migration features in SQL Developer to migrate

a MSSQL Server db structure (tables, views, procedures, etc...) into a Oracle

db but I'm not interested to migrate the data.

I need to recreate an exact copy of empty db in Oracle with the same structure

with same table, views, procedures....

I am newbie so exists a step-by-step tutorial to do this ?

Thanks a lot to all....

G.M.

"Database Agnostic Code" is a myth.

Oracle has a completely different transaction model than SQL Server.

Those procedures will need to be reviewed to ensure that they "do things the Oracle way".

Refactoring them into Packages almost guarantees a complete re-write of your application.

My $0.02

MK

1 - 2

Post Details

Added on Nov 6 2016
0 comments
494 views