Problems during upgrade.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Problems during upgrade.

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Unhappy

    Hi all,

    I am upgrading from 81715 to 81730 on NT 4.

    First, during 81730 installation, I got the foll. error.

    “Error writing to file E:\OA\Oracle817\bin\ociw32.dll". I read in the metalink that it is because MS DTC (Microsoft Distributed Transaction Coordinator) service is running and it locks ociw32.dll.

    But, there is no such service in the NT on our server.

    Where should I find it.

    As, I could not find it, I used the workaround and renamed ociw32.dll and clicked on Retry and completed the installation.

    My question is that is it OK if I rename the file? Should I use 'Rename' when I do upgrade finally on Production database?

    OK, after that I followed the 81730 readme and was running step no. 7 i.e running catalog and catproc.sql.

    While running catproc.sql, I got foll. errors.
    SQL> create public synonym utl_http for sys.utl_http;
    create public synonym utl_http for sys.utl_http
    *
    ERROR at line 1:
    ORA-00955: name is already used by an existing object
    drop type aq$_jms_text_message
    *
    ERROR at line 1:
    ORA-04043: object AQ$_JMS_TEXT_MESSAGE does not exist
    CREATE ROLE aq_administrator_role
    *
    ERROR at line 1:
    ORA-01921: role name 'AQ_ADMINISTRATOR_ROLE' conflicts with another user or
    role name
    DROP TYPE ODCIIndexCtx
    *
    ERROR at line 1:
    ORA-34369: Message 34369 not found; product=RDBMS; facility=ORA
    DROP TYPE ODCIRidList
    *
    ERROR at line 1:
    ORA-02303: cannot drop or replace a type with type or table dependents

    I connected as internal when running catproc.sql.

    Can someone help me pl?

    Thanks in Adv.




    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    As a guess, ociw32.dll could be in \MSSQL\BINN if SQL Server was every installed on the machine. If you haven't rebooted your machine, it could be still 'in core' from when you did your cleanup before the install.

    As to the second, it sounds like you are doing a second install, ie you either aborted an earlier install or installed the default database already. In either case, I would ignore the errors and check the stuff at the end. You may be okay. The other possibility is that you are not using the same account as installed Oracle, or at least have not yet set the environmental variables so that the message files can be automatically located.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    JRPM,

    We have never had SQL server in our Oracle Server. There is no such directory also in the server.

    catalog and catproc must have run at then time, when I first upgraded my database from 805 to 81715. I ran u0800050.sql as internal user only.

    Should I go ahead now?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width