Migration from 8.1.7 to 9.2.0

[lesstjm]

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

[waitecj]

Did you STARTUP NOMOUNT before CREATE CONTROLFILE to get the instance started?

[lesstjm]

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DBTEST" RESETLOGS NOARCHIVELOG

[waitecj]

'course you have otherwise it wouldn't be trying to allocate memory from your shared_pool... Have you tried increasing the size of your shared pool so that Oracle can find a sufficient chuck of memory to allocate to your request?

[waitecj]

Have a look at this:

http://metalink.oracle.com/metalink/...&p_id=146599.1