Re: Oracle migration.

Hi

Yes, You must install a 7.3.4 and 7.0.16 in a separate home. To upgrade the Db use the standard migration method from install utility. (install 7.3.4, start DB with 7.3.4 then migrate that) Modify TNSNAMES.ORA on the server and set TWO_TASK parameter, so your forms will connect via SqlNet to the DB. (it is a surely things if you recompile all forms, menu, pro*c ...) I hope this will help

feherl

Vikas S wrote:

> Hello,
> I'm transferring an Oracle database 7.0.16 on Solaris 2.4 to
> 7.3.4.0.1 on a new Sun E450 (2cpu 1GB RAM 120 MB SGA) running Solaris 2.6.
> The old database contains Forms 3.0, Menu 5.0, pl/sql & Pro*C
> applications. I want to transfer all these to the new database. After
> installing 7.3.4 on new machine and doing a full import of a full export
> of old database, I'm getting following errors.
>
> 1)
> IMP-00041: Warning: object created with compilation warnings
> "CREATE PROCEDURE "BILL"."EMAILPURGE"
> TIMES"
> "TAMP '1999-02-18:16:02:37' "
> IMP-00008: unrecognized statement in the export file:
> \375\377\207
> IMP-00008: unrecognized statement in the export file:
> ^F
> IMP-00008: unrecognized statement in the export file:
>
> 2)
> IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SYSTEM"."MENU_V_PARAM"
> ("SUBSTI"
>
> "TUTION_STRING","APPLICATION_NAME","PAR_SIZE","PAR_DEF","ECHO","MUST_FILL",""
> "RESPONSE_REQUIRED","UPPER_CASE","OBJECT_TEXT_ID","PROMPT") AS "
> "SELECT
> "SUBSTITUTION_STRING","APPLICATION_NAME","PAR_SIZE","PAR_DEF","ECHO""
> ","MUST_FILL","RESPONSE_REQUIRED","UPPER_CASE","OBJECT_TEXT_ID","PROMPT"
> FRO"
> "M MENU_B_PARAM "
>
> IMP-00017: following statement failed with ORACLE error 4063:
> "GRANT SELECT ON "MENU_V_PARAM" TO "BILL" WITH GRANT OPTION"
> IMP-00003: ORACLE error 4063 encountered
>
> etc....
>
> From whatever I've read, I understand pl/sql procedures do not
> need recompilation. When I'm manually compiling pl/sql applications, it is
> working fine.
> I've installed Forms 3.0 & Menu 5.0 in a separate ORACLE_HOME.
> Are the type 2) errors coming because of the absence of both in 7.3.4.
> How do I import old Forms applications & run in new system.
> Also, since Solaris 2.6 ensures binarty compatibility, should I
> recompile Pro*C applications.
> Finally, I've ensured all date fields in forms 3.0 applications
> to be in 'DD-MON-YYYY' form. Will this not ensure Y2K compliance.
>
> Thanks & regards,
> Vikas
Received on Fri Oct 01 1999 - 21:06:43 CEST