What is the procedure to be followed to migrate a database from a Solaris machine to Red Hat Linux 9? (The size of the database is 20 GB.)
You have two options, Oracle's export/import utilities and Transportable Tablespaces (TTS). For TTS, you must be running Oracle 10g on both servers since you are going from one OS to another OS. TTS does not support cross-OS transfers prior to 10g. But I would probably use export/import since the database is not that big. On the Solaris server, perform a full export. Then create your database on the Red Hat platform. FTP the dump file to the new server (in BINARY mode). Finally, perform a full import into your new database.
Dig Deeper on Oracle database administration
Readers ask SearchOracle.com expert Brian Peasland where they can find learning materials for becoming a better Oracle database administrator.
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database.
One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes.