• Find us:
    +1 415 655 1723   |   +91-844-844-8901
  • Free Newsletter

     
     

  • Archive

  • Categories


  • RCU-6083:Failed – The schema owner ODS is connected to the database. Please disconnect and try again

    Posted by "" in "oid" on 2014-08-22

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    Last week  I was trying to drop the ODS schema using Repository Creation Utility (RCU) but was getting an ERROR

    The schema owner ODS is connected to the database. please disconnect and try again. The whole error is listed in the image below.

    error in rcu drop

     

    Solution:-

    a)  Run the following command to obtain the values of the schema owner to be killed

    select sid,serial# from v$session where username=’ODS’;

    b) Kill the session inorder to disconnect the user

      alter system kill session ‘sid,serial#’;

    Note:- If you shutdown and start the database again then still the error will not be able to resolve as the user gets connected to database again on restart 

    c) REVOKE CONNECT statement removes a user from the database

       REVOKE  CONNECT  FROM  ODS;

    CONNECT will drops a user name from the database

    Then, I was able to proceed with the RCU Drop operation

     

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    Leave a Reply

    Your email address will not be published. Required fields are marked *



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    128 Uxbridge Road, Hatchend,,
    London, HA5 4DS

    US: +1 415 655 1723
    India: +91-844-844-8901

  • Copyright 2019, K21 Technologies. All rights reserved
  • TOP
    TOP