topic Re: Urgent Please ! in Operating System - HP-UX

Urgent Please !

Massimo_37 — Thu, 10 Jun 2004 04:36:57 GMT

One more quick question, If I install 7.2.3 and upgrade to 7.3.4 on a new server before I create any databse at all on 7.2.3, should I run the CAT7301.sql,CAT7302.sql..CAT7304.sql scripts ? I am planning to create the database after the upgrade to 7.3.4 and import data from a database created with 7.3.4 . Many thanks in advance

Re: Urgent Please !

Sanjay Kumar Suri — Thu, 10 Jun 2004 04:44:07 GMT

Need to run CAT7304.sql script.

sks

Re: Urgent Please !

Massimo_37 — Thu, 10 Jun 2004 05:07:51 GMT

Suri,
Could you please tell me the reason for doing so, as my database will be created in 7.3.4 and imported data will also be 7.3.4. The notes in cat7304.sql tells me that i need to do this when a 7.3.3 database is started using 7.3.4 for first time.
Many Thanks

Re: Urgent Please !

Fred Ruffet — Thu, 10 Jun 2004 05:12:22 GMT

I believe that what Sanjay mean was that you must create the 734 catalog. You are not running any "migration" in the Oracle sens. You will create Ã 7.3.4 DB, and import a schema in it. No matter were the import come, the imp command will issue "create table" commands on a 7.3.4.

As long as we don't have 7.3.4 DB anymore, we cant tell you the name for the catalog script, but the only one you must run is the one for 7.3.4.

reagrds,

Fre

Re: Urgent Please !

Sanjay Kumar Suri — Thu, 10 Jun 2004 05:20:20 GMT

Check this tip:

http://www.bijoos.com/oratom/ot_200101.htm

sks

Re: Urgent Please !

Ravi_8 — Thu, 10 Jun 2004 05:22:35 GMT

Hi

As oracle suggest you need to run CAT7304.sql script to upgrade from 7.2.3 to 7.3.4

Re: Urgent Please !

Fred Ruffet — Thu, 10 Jun 2004 05:26:56 GMT

Sanjay, Ravi,

It seems to me that there is no migration in the air. Oracle kernel is migrated, but DB is created after migration. So, no 7.2 DB has to be migrated to 7.3.4.

Could you confirm George ?

Fred

Re: Urgent Please !

Massimo_37 — Thu, 10 Jun 2004 05:32:06 GMT

You are right Fred- I am not migrating a database from 7.2 to 7.3.4. All i am doing is installing 7.2.3 and upgrading to 7.3.4. I am installing 7.2.3 only to get the Forms3 and sqlmenu 5 from the 7.2.3 release. But there is no db creation or import while the 7.2.3 is on server. Infact I will upgrading to 7.3.4 soon after the 7.2.3 install . And then I will be creating database in 7.3.4 and importing data into 7.3.4. I think the catalog script that Fred mentioned is the catalog.sql for 7.3.4.
While I am here, one more question, do I have to do "upgrade database objects" section in the 7.3.4 upgrade, as I won't have any database on the server at the time of upgrade ?
Many thanks

Re: Urgent Please !

Fred Ruffet — Thu, 10 Jun 2004 05:48:43 GMT

No. As long as you will create your DB in 7.3.4, dictionnary will be 7.3.4. Your import will not damage this dictionnary, so you'll have a good old 7.3.4 database.

reagrds,

Fred