9i to 10g data migration using Export/import

Dear Friends,           Back to work after long time, was busy in trekking. Today we did database migration from 9i to 10g using Export / Import. To upgrade a database using the Export/Import utilities kindly follow below mention steps.  Keep database in restricted mode - Export data from the current database exp  FILE=exp_20092011.dmp FULL=y GRANTS=y BUFFER=4096  [...]

Read Full Post »

TNS-12555 / TNS-12560 / TNS-00525 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

Dear Friends,           Today we face new issue relate to listener, so wanted to share with you same. We imported the dump into fresh blank copy of tha database and just chages IP of th server so that application configaration will not impacted. But when we swap the IP of both server we get the [...]

Read Full Post »