Skip to Main Content

Oracle Database Discussions

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!

Moving a Oracle 10g Database from AIX 5L to Linux 4L

user291565Jul 8 2010 — edited Jul 8 2010
Hi
I planning to move a 10g database from AIX to Iinux .... What would be the best approach??

This is what I've tried.... I've created the directory structure on the Linux box.. Move a new hot backup across including the control files, redo logs, init.ora and password file....

I then created a spfile from the pfile.

I get the following error message when I try to startup the database...

SQL> startup
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size 2075912 bytes
Variable Size 620757752 bytes
Database Buffers 2449473536 bytes
Redo Buffers 81809408 bytes
ORA-00205: error in identifying control file, check alert log for more info

I've checked the pfile to make sure that the name and location is correct of the control file... all is good...

Alert_log

System parameters with non-default values:
processes = 600
sga_target = 3154116608
control_files = /oracle/database/ifcp03/control1.ctl, /oracle/database/ifcp03/control2.ctl
db_block_size = 8192
compatible = 10.2.0
log_archive_dest_1 = LOCATION=/oracle/database/logs/ifcp03 MANDATORY REOPEN=30
log_archive_dest_2 = LOCATION=/oracle/database/logs2/ifcp03 OPTIONAL REOPEN=120
log_archive_format = ifcp03_arch_%s­_%t_%r.dbf
log_buffer = 79330304
db_files = 100
db_file_multiblock_read_count= 32
fast_start_mttr_target = 60
dml_locks = 400
undo_management = AUTO
undo_tablespace = undotbs1
undo_retention = 1800
recyclebin = off
remote_login_passwordfile= NONE
db_domain =
global_names = TRUE
instance_name = ifcp03
service_names = ifcp03
session_cached_cursors = 800
utl_file_dir = /oracle/database/output/c
job_queue_processes = 64
background_dump_dest = /apps/oracle/admin/ifcp03/bdump
user_dump_dest = /apps/oracle/admin/ifcp03/udump
max_dump_file_size = 10240
core_dump_dest = /apps/oracle/admin/ifcp03/cdump
db_name = ifcp03
open_cursors = 1000
os_authent_prefix = ops$
optimizercost_based_transformation= off
pga_aggregate_target = 503316480
statistics_level = all
PMON started with pid=2, OS id=2522
PSP0 started with pid=3, OS id=2524
MMAN started with pid=4, OS id=2526
DBW0 started with pid=5, OS id=2528
LGWR started with pid=6, OS id=2530
CKPT started with pid=7, OS id=2532
SMON started with pid=8, OS id=2534
RECO started with pid=9, OS id=2536
CJQ0 started with pid=10, OS id=2538
MMON started with pid=11, OS id=2540
MMNL started with pid=12, OS id=2542
Thu Jul 8 09:49:11 2010
ALTER DATABASE MOUNT
Thu Jul 8 09:49:11 2010
**ORA-00202: control file: '/oracle/database/ifcp03/control1.ctl'**
**ORA-27047: unable to read the header block of file**
Additional information: 2
Thu Jul 8 09:49:11 2010
ORA-205 signalled during: ALTER DATABASE MOUNT...

Please can someone help.... What am I missing???

Thank you....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2010
Added on Jul 8 2010
9 comments
1,139 views