Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

User_KWXZ9Jun 20 2013 — edited Jun 20 2013

Hi All ,

I am using oracle 11.2.0.3 with 3 node rac with ODI .

I have the below table which i am not able to drop  and giving the error .

SQL> drop table I$_CDS_FAULT_DEV1;

drop table I$_CDS_FAULT_DEV1

           *

ERROR at line 1:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

SQL> show parameter ddl_lock

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

ddl_lock_timeout                     integer     300

i changed to 100 but still the same error also i have checked and there are no locks . Can you please provide me a way to resolve this issue .

Regards ,

DBApps
This post has been answered by unknown-698157 on Jun 20 2013
Jump to Answer

Comments

unknown-7404
You should not do this.

Environment variables such as PATH can only give preference to one item of any given name. With DLLs for example the first DLL of any given name that is found will be the one loaded by Windows. It would be up to the software doing the loading to determine if that is the correct version and most software just looks by name.

That is what is known as 'dll hell'; the wrong version of a dll is being used.

You don't need both clients installed so why do you want to do that?
Pl identify which version of Win 7 - you will need Professional or higher. Pl also identify which exact version of Oracle client.

I have no personal experience with this myself, but the 11gR2 docs say you can install both the 32-bit and 64-bit clients as long as you use different ORACLE_BASE directories.

http://docs.oracle.com/cd/E11882_01/relnotes.112/e23557/toc.htm#CJADGJDB

HTH
Srini
1 person found this helpful
Helios-GunesEROL
Hi;

By using different path yes you can install.

Please review:
Master Note For Oracle Database Client Installation [ID 1157463.1]
Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]


Regard
Helios
1 person found this helpful
941843
Windows 7 Enterprise

Oracle Client 11g (11.2.0.1.0)
941843
Doesn't this write both ORACLE_HOME paths to the PATH environment variable, and then cause, as mentioned above, DLL hell? With WOW64, it is unclear to me how Microsoft separates 32-bit paths from 64-bit paths.

Unfortunately, my company is running 32-bit Microsoft Office 2007 and other 32-bit programs that use the Oracle thick client install, and my company also uses 64-bit programs that require the Oracle thick client install too.

The solution thus far has been to uninstall one of the programs, and thus clean-up the %PATH% environment variable; or rearrange the order of the Oracle client homes in %PATH% to make the broken one work.
941843
After researching the links, this was still unclear if the 2 clients would conflict with each other.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 18 2013
Added on Jun 20 2013
#general-database-discussions
4 comments
79,887 views