Home » RDBMS Server » Server Administration » Migration of Oracle from AIX to Solaris (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit, AIX 5.3, Solaris 10)
Migration of Oracle from AIX to Solaris [message #573912] Fri, 04 January 2013 04:18 Go to next message
raj9999
Messages: 49
Registered: June 2011
Member
We have to migrate our database from current OS (AIX 5.3) to Solaris 10. We'll do it through expdp/impdp. Is there any other way to do it as well?

Also, we have dataguard configured at current setup. So is there any way we can take backup of existing database at DR & restore it at new server (Solaris) or we'll have to take a fresh backup from DC (after migration) & ship it to DR & create a new standby?

Any other thing need to be tested while migrating across platform?
Re: Migration of Oracle from AIX to Solaris [message #573917 is a reply to message #573912] Fri, 04 January 2013 04:35 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
The transportable database facility might be the way to go, http://docs.oracle.com/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDCFFDI
Re: Migration of Oracle from AIX to Solaris [message #573924 is a reply to message #573912] Fri, 04 January 2013 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See and follow the current following topic about the same question:
http://www.orafaq.com/forum/t/185588/102589/

Regards
Michel
Re: Migration of Oracle from AIX to Solaris [message #577642 is a reply to message #573924] Tue, 19 February 2013 05:54 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
We have migrated our production database from AIX 5.3 to Solaris 5.10. It is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit.

For migration purpose, exp-imp was used. pfile, spfile, tnsnames.ora, listener.ora, sqlnet.ora are taken from old server only. Everything is same except the ip address & hostname of the new server. We have modified tnsnames.ora & listener.ora accordingly. We are able to make sqlplus connections from Primary to standby & vice versa. Also, tnsping is also working fine both ways.

The problem is now that standby database is not applying the archives on its own. We have to manually register the logfiles or do the manual recovery to keep the database in sync.

We are receiving below error in standby alert logfile

RFS[301]: Possible network disconnect with primary database
Aborting archivelog file creation: /arch/DB_ARCHIVE/1_2814_805723031.arch
If this a network disconnect, then this archivelog will be fetched again by GAP resolution mechanism.

Error Codes
---------------------------------------------------
ORA-16055, ORA-03135


Kindly help.
Re: Migration of Oracle from AIX to Solaris [message #577650 is a reply to message #577642] Tue, 19 February 2013 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-16055: FAL request rejected
 *Cause:  Fetch archive log (FAL) server rejected a redo gap fetch request
          from the client. This may have various causes.
 *Action: Check the alert log on the primary database. Take the appropriate
          action to solve the problem.
Re: Migration of Oracle from AIX to Solaris [message #577654 is a reply to message #577650] Tue, 19 February 2013 07:06 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
Thanks for the reply Michel. But i want to know the reason of this error that why the archive is getting rejected at standby site.
because i am facing this error that some archives are getting shipped & applied at standby database but it gets stuck to an archive & it doesn't go further till the time that archieve is manually copied & registered at standby. & i get the below mentioned error again & again.

RFS[301]: Possible network disconnect with primary database
Aborting archivelog file creation: /arch/DB_ARCHIVE/1_2814_805723031.arch
If this a network disconnect, then this archivelog will be fetched again by GAP resolution mechanism.

[Updated on: Tue, 19 February 2013 07:07]

Report message to a moderator

Re: Migration of Oracle from AIX to Solaris [message #577660 is a reply to message #577654] Tue, 19 February 2013 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you know the reason but WE don't know all the messages by heart.
You should post what I posted each time you have an error to avoid we waste our time to search for meaning of an error code.

Now, you know what is the reason "Possible network disconnect with primary database".
We can't know the reason as we have not your environment.

Regards
Michel
Re: Migration of Oracle from AIX to Solaris [message #577662 is a reply to message #577660] Tue, 19 February 2013 07:48 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
Michel,

I have given the exact problem & the error codes clearly in first post. What you have given is a description of the error code. But if just having the description of error code is going to solve the issue then we don't need to come to this forum. If you want any further details then you can write that.

I was trying to elaborate the whole scenario but i think i am going to get replies like this only from your side instead of anything related to the resolution of the issue.

Anyway, thanks for your time.
Re: Migration of Oracle from AIX to Solaris [message #577665 is a reply to message #577662] Tue, 19 February 2013 08:00 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You MUST give the what I posted for each error number. The longer I wasted my time to search for what you should post the less time I have to help
2/ You tell us what you think you do, if you do everything properly then everything works fine, otherwise you are wrong on some points, we have nothing to determine if what you told us is correct or not.
3/ How can we help you with ONLY what you post and nothing more?

Regards
Michel
Previous Topic: error in re-creation of a datafile
Next Topic: Tablespace Read Stats
Goto Forum:
  


Current Time: Thu Mar 28 16:41:14 CDT 2024