I have a test database 8.1.7 on one server and I have 9.2.0 installed on another server. I want to copy the 8.1.7 database to the 9.2.0 server and try to migrate it to 9.2.0. The problem is that when I move it I have tio recreat the control files before I mount it to start the migration because the filesystem is layed out differently.

Can this be done? I copied all the files except control files to new server. Created an init.ora. Then I logged in as sysdba and ran my create control file script pointing everything to the new directories and I get the following error

ORA-04031: unable to allocate 11164520 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","FileOpenBlock")
CREATE CONTROLFILE SET DATABASE "DBTEST" RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01034: ORACLE not available


ALTER DATABASE MOUNT
*
ERROR at line 1:
ORA-01034: ORACLE not available