Server Administration :: ORA-00054 / Resource Busy And Acquire With NOWAIT Specified Or Timed Expired
Jan 31, 2012
i want to drop a table by applying fol
SQL> drop table table1 purge;
and i get ORA-00054 resource busy and acquire with NOWAIT specified or timed expired
This table is of 600 Gb in size and no more used and not involved in any logical and physical backup and do not referenced by application but still i am getting this error.i search for this error and found which is to "Wait and retry" but i waited and then apply but still no progress.
View 12 Replies
ADVERTISEMENT
Sep 1, 2010
i have one procedure that run at same time for two different partition.In the begin of the processes i do the truncate partition and after that the insert of data in the partition.Since i have two processes running at the same time, i will fill up data in two different partition.
But it occurred one error :
"ORA-00054: resource busy and acquire with NOWAIT specified"
The problem is caused by the truncate partition. I'm doing two simultaneous execution of the same process, but when one process is doing the truncate other is insert data.How can i do the truncate of this two partition, or insert in to, without get any error. I think the two simultaneous insert is not a problem.
So how can i lock the table in the first truncate and after that release the table for the next truncate?
View 5 Replies
View Related
Apr 6, 2012
i am working in scott's schema and i want to create foreign key on new table that is "test" table ,structure is----
create table test(id number, name varchar2(20),dno number,pno number);
and now create a foreign key on id column of "test" table reffering the empno of "emp" table which has pk already. but it shows an error-------"ora-ORA-00054-resource busy and acquire with NOWAIT specified or timeout expired"
while i have create the "test" table just 1 min ago.
View 3 Replies
View Related
Jul 21, 2010
A batch job was running for a long time which executes a stored procedure that was doing physical deletes on an oracle table. This job ran for about 3 hrs and is still executing. Meanwhile another job(which was making indexes unusable in another table) has cancelled saying "resource busy and acquire with NOWAIT specified", i think it was ORA-0054! So i killed the first job and reran the second thinking the first one was taking up resources which resulted in the cancel of the second job. Now the second job ran successfully. Both these tables are not related to each other whatsoever...but why was there a cancel?
View 6 Replies
View Related
Jan 17, 2013
SQL> drop MATERIALIZED view log on afccv.tbl_voicechat;
drop MATERIALIZED view log on afccv.tbl_voicechat
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
i dont want to kill the sessions or anything is there any way to set prority to do this task?
View 2 Replies
View Related
Aug 29, 2010
I found in alert log that PMON "failed to acquire latch" during shutdown.What it means and how to rectify the same.
View 2 Replies
View Related
Sep 21, 2011
I have a question:
With this plan active
PLAN GROUP_OR_SUBPLAN TYPE CPU_P1 CPU_P2 CPU_P3
x_PLAN x_APP_GROUP CONSUMER_GROUP 75 0 0
x_PLAN x_BO_HIGH_GROUP CONSUMER_GROUP 10 0 0
x_PLAN x_BO_LOW_GROUP CONSUMER_GROUP 5 0 0
x_PLAN OTHER_GROUPS CONSUMER_GROUP 10 0 0
if there is only an user of X_APP_GROUP that is working in a specified moment, he will use the 100% of CPU or il will be limited at 75% as specified in the plan?
View 1 Replies
View Related
Aug 5, 2010
I get the Error like this frequently
ERROR at line 1:
ORA-20001: ORA-04022: nowait requested, but had to wait to lock dictionary
object
ORA-06512: at "MDWDBA.MDW_PKG", line 917
ORA-04022: nowait requested, but had to wait to lock dictionary object
ORA-06512: at line 1
why this occurs? and how to Resolve it?
View 2 Replies
View Related
Aug 29, 2013
May any one confirm that the below issue is not only to RAC but also on normal database enterprize edition 11.2.0.3 ? Bug 12865902 - NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") in RAC (Doc ID 12865902.8)
currently i am using for update nowait concurrently for 50 processes on similar table with similar query and getting performance issue.
SELECT txn_ID,status_FLAG
INTO txn_id,status_flag
FROM cp_txn_detail WHERE txn_ID = pi_txn_ID FOR UPDATE NOWAIT;
View 2 Replies
View Related
Jul 31, 2010
I am getting the Oracle Database error "ORA-00069 cannot acquire lock -- table locks disabled for string" in a stored proc. According to some sites I looked at, it says the Cause is "A command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are: LOCK TABLE, ALTER TABLE ... ADD (...), and so on.". And the Action they suggest is "Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command".
I am not doing either a lock table or alter table command in my procedure, so what else could be causing this?
View 3 Replies
View Related
Nov 7, 2012
I would like to resolve my problem about truncating table in oracle 10g, i have a table with more than 2 millions of data and i tr to delete data using delete statement but it take many time and i tried with truncate it's ok but when i want to insert data into the table it give me this error ORA-00054 ORA-00054: ressource occupée et acquisition avec NOWAIT
View 30 Replies
View Related
Nov 15, 2012
oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
I have a procedure that is run weekly to load the data, for which it calls another procedure. This weekly procedure, disables the index, load the data, and rebuilds the index. During rebuilding of index, its giving ORA-00054: resource busy and acquire with NOWAIT error. I dont have privileges to look for session id, and kill the session. How to avoid this error.
create or replace
PROCEDURE "WCL_WEEKLY_UPLOAD" (
p_event_id IN NUMBER
)
[code]....
As you can see, after the procedure wc_upload, COMMIT is issued, and then the rebuilding of the index is starting. So dont know what is causing the table to lock.
View 6 Replies
View Related
Apr 26, 2013
Frequently getting below error in alert log file. to sort out this issue.
Database: Active standby database
OS: Windows Server
Db Version: 11.2.0.2
Error:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
[code]...
View 1 Replies
View Related
Dec 20, 2011
I noticed oracle background process ora_fbda_padwsdpr is suffering from buffer busy wait. When i further finding the object, it was on SYS_FBA_FA tables.
what is this is causing BUFFER BUSY WAIT. Also to add we have disabled flashback database.
View 4 Replies
View Related
Nov 11, 2011
i am using a oracle server. And all my users password has been expired, is there any way to recover those users without failing my data.
View 19 Replies
View Related
Aug 31, 2010
In my awr reports I have CPU time(in seconds) as one of top 5 timed events.Does that mean oracle is waiting for my cpu to execute the statements.But my cpu usage is 0-10% always
View 4 Replies
View Related
Aug 22, 2013
Created user xyz on July 20,2013 with defualt profile (oracle version 11.2.0) and PASSWORD_LIFE_TIME is 180 for default profile. Immediate my friend have assigned new profile APSC to user xyz where profile APSC has PASSWORD_LIFE_TIME = UNLIMITED.
we surprised, user account has expired within a month. How user xyz account can expired within a month????
Note: User account status was open when account created and assigned to profile APSC.
View 4 Replies
View Related
May 20, 2013
One fo my Db having reliable message as top first timed events.
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
reliable message 685,139 24,625 36 29.58 Other
View 1 Replies
View Related
Jun 19, 2012
When i am trying to shutdown the database its getting HANG, and alert log showing
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Which force me to use Shutdown Abort.
DB version in 10.2.0.1.0
OS Linux 5.5
View 5 Replies
View Related
Oct 2, 2013
I've have a system where the most buffer waits are spent on system tables like
SYS.DBMS_ALERT_INFO
and SYS.DBMS_LOCK_ALLOCATED
Would it convert the system tablespace from dictionary managed to locally managed?
View 7 Replies
View Related
Aug 14, 2013
Account XYZ has expired and we don't know the password of account xyz and don't want reset the password also. How can open account XYZ without change the password?
View 1 Replies
View Related
Jan 29, 2012
I am getting error in alert log file something like this:
WARNING: inbound connection timed out(ora-3136)
while on checking SQLNET.LOG file it is showing :
Tns error struct:
ns main err 12541
TNS:12541: TNS:no listener
ns secondary error 12560
nt main error 511
TNS:00511 : No listener
nt secondary error 146
nt OS err 0
View 3 Replies
View Related
Jan 13, 2013
I have two related questions:
Scenario 1:
1. I have two remote Windows machines with database on each. One is Win 2003 Server (machine A) and another one is Win XP (machine B)
2. I can ping from A to B.
3. I can ping from B to A.
4. I can tnsping from A to B.
5. I CAN'T tnsping from B to A.
6. Windows Firewall on both machines are off.
What could be possible reason for point# 5?
Scenario 2:Now, the second part:
1. I had an unwanted entry in tnsnames.ora on B which I removed.
2. Then I restarted the listener on B. Actually, I wanted to restart the one on A to check if that resolves issue mentioned in point# 5 above.
3. I tried tnsping from A to B but suprisingly it is also giving "operation timed out" error now. So now tnsping not working from either sides.
I didn't make any changes in listener.ora on B, just stopped it and started again. Only change made was removing unwanted entry in tnsnames.ora on B.
Why does that affected database connectivity from A to B which was working fine previously?
NOTE: The two machines are connected through VPN using LogMeIn Hamachi. Hamachi assigns it's own IP address to each machine. Machine A is Windows Server 2003 and B is Windows XP.
View 3 Replies
View Related
Jul 26, 2005
I have a windows XP server with Oracle 9i on it, when i tried to connect this server from another win XP machine after creating a service. I m getting an error
TNS-12535 TNS:operation timed out
But as i know this error is related to CONNECT_TIMEOUT and it is now obsolete in 9i( am i correct ). I tried it doing from 2 machines but got the same error from everywhere so it means that the problem is with the server.my files are :
Listener.ora
# LISTENER.ORA Network Configuration File: D:oracleora92NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Tarun)(PORT = 1521))
)
[code]....
View 9 Replies
View Related
Jul 20, 2010
we are working to increase the security of our oracle application by adding profil and expiration to all our database username.
Expiration is actually set to 60 days.So if i understand it correctly, 60 days is counting from when i change my password. So if I change it at 10:30am it will expire at 10:30am in 60 days.
Our forms application is calling all forms using the command open_form with SESSION parameter to open all forms in new session.
My problem is when the user connect in the system let say at 9:00am. At 10h30am the password will expire and when the user will click to open a new form from the application he will get the message ORA-28001:the password has expired.The new module will open even if password is expired and will raise the error FRM-41352: Failed to create session. So the module will stay in the same session than the caller.
Is there a way to catch the ORA-28001 and force a new logon.Probably with some code in the ON-ERROR of the called module but this mean that i will have to change +400 forms.
View 1 Replies
View Related
Jan 2, 2013
I am trying to connect to a server from a client on another network. I am able to connect just fine if I am on that server, but when I try to connect from a client in my office to the amazon server, I get a timeout message as follows.
ora-12535: TNS:operation timed out.
here is my entry in my local tnsnames.ora file. I believe that the network is wide open between my two computers. o firewalls on the computers and the settings on my cisco allow this to go through. I see the client connect in log files on the server, but it always gets a timeout after 20 seconds.
I have tried to add these parameters to the sqlnet.ora file.
SQLNET.SEND_TIMEOUT= 120
SQLNET.RECV_TIMEOUT= 120
SQLNET.EXPIRE_TIME = 120
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
RDCTEST2.rdcamazon.com =
[code].....
How would I go about debugging this? I replaced the ip with x's since this is a public post.
client = windows xp
server = windows 2003 server
I am able to connect to a local database server from my client without a problem.
View 8 Replies
View Related
Jun 26, 2012
One of our production database we are getting error "TNS:operation timed out" from unknown port in alert logfile. Need to check why TNS error is occurring to these unknown port as our listener is running on default 1521 port. Also to inform that host=192.191.118.24 itself is the same database hosting server IP.
TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
ns secondary err 12606
ns secondary err 12606
nt main err 0
[code]......
View 3 Replies
View Related
Oct 3, 2010
Is there any relationship b/w tuning BUFFER CACHE and BUFFER BUSY WAITS?
1) Buffer Busy Waits are happening as the User process found the same Datablock is being used by another user in the BUFFER CACHE.
2) And also happens, when the server process found the same Datablock are being used in the Datafile.
View 5 Replies
View Related
Mar 31, 2011
I have one form in which I need to change cursor style to busy while doing some process and after completing that process cursor should get to default.I have done changing cursor style but during its busy state it is allowing me to change values or click buttons.It should not allow user to change anything or click any button.
View 1 Replies
View Related
Jan 2, 2013
I'm trying to write short program to reset password on databases. I'm trying to use OCINewPassword property with following
public void ResetPassword(String sOldPass, String sNewPass) {
this.sCurrent = sOldPass;
this.sNewPassword = sNewPass;
Properties props;
Connection conn = null;
[code]....
View 4 Replies
View Related