Home » RDBMS Server » Server Administration » very urgent please help me error (merged)
very urgent please help me error (merged) [message #266586] Tue, 11 September 2007 03:24 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
kwqiclode: Error 376 happened during loading of queue



in alert log what this means.
Re: very urgent please help me error [message #266596 is a reply to message #266586] Tue, 11 September 2007 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
very urgent please help me error

This prevent me for giving any help.

Read and follow OraFAQ Forum Guide.

Regards
Michel
Re: please help me error [message #266600 is a reply to message #266596] Tue, 11 September 2007 03:46 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
i am sorry michael, actuall in so tense , i forgot to mention it properly
can give me solution, out application users are getting logoff frequently without any problem on db due to this error.

Please help.


[mod-edit] illiterate IM speak words removed.

[Updated on: Tue, 11 September 2007 07:57] by Moderator

Report message to a moderator

Re: very urgent please help me error [message #266604 is a reply to message #266586] Tue, 11 September 2007 03:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Do you use other profile rather than default one? Check out limit of connect_time, idle_time etc.
please help me with this error..... [message #266605 is a reply to message #266586] Tue, 11 September 2007 03:58 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
kwqiclode: Error 376 happened during loading of queue



in alert log what this means.

it prevents application users to logon to db, they are getting logoff frequently


please help
Re: very urgent please help me error [message #266606 is a reply to message #266604] Tue, 11 September 2007 04:01 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
no
actually to make the db available again to the users i have to bounce it , so profiles may not be the problem.

still i will check it .


Please help
Re: please help me with this error..... [message #266607 is a reply to message #266605] Tue, 11 September 2007 04:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

No one will help you.

Duplicate entry.
Bad title.
You have not followed sticky.
Re: very urgent please help me error [message #266611 is a reply to message #266586] Tue, 11 September 2007 04:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
actually to make the db available again to the users i have to bounce it so profiles may not be the problem.

Nice Laughing Laughing Laughing
Bounce again and again. Problem will be go away. Laughing Laughing
Re: very urgent please help me error [message #266614 is a reply to message #266611] Tue, 11 September 2007 04:10 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member

Please friends help me..Please i am helpless, i hve done those mistake on this forum unintentionally pls try to understand.



please help
Re: very urgent please help me error [message #266619 is a reply to message #266614] Tue, 11 September 2007 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"pls"? You still didn't read the Guide or don't want to follow it.
How can you expect help?
As you said "pls try to understand".

Regards
Michel
Re: very urgent please help me error [message #266624 is a reply to message #266619] Tue, 11 September 2007 04:27 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member


I apologise u all.

I really very sorry for that , Now i can say i have read fullly the forum guide, and i request respected people to help me to find out the solution for my problem, Please i need kind help.


Thankin YOU all

[mod-edit] IM speak words removed.

[Updated on: Tue, 11 September 2007 07:58] by Moderator

Report message to a moderator

Re: very urgent please help me error (merged) [message #266625 is a reply to message #266586] Tue, 11 September 2007 04:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

After reading forum guide you used "u" instead of you. Nice reading. Laughing
Re: very urgent please help me error (merged) [message #266628 is a reply to message #266586] Tue, 11 September 2007 04:38 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I really want to help you,

What's the result of your query?
select resource_name ,profile,limit from dba_profiles where resource_name in ('IDLE_TIME','CONNECT_TIME');

Re: very urgent please help me error (merged) [message #266640 is a reply to message #266628] Tue, 11 September 2007 04:56 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Thanks for reply.



SQL> select resource_name ,profile,limit from dba_profiles where
n ('IDLE_TIME','CONNECT_TIME');

RESOURCE_NAME PROFILE
-------------------------------- ------------------------------
LIMIT
----------------------------------------
IDLE_TIME DEFAULT
10

CONNECT_TIME DEFAULT
UNLIMITED

IDLE_TIME MONITORING_PROFILE
DEFAULT


RESOURCE_NAME PROFILE
-------------------------------- ------------------------------
LIMIT
----------------------------------------
CONNECT_TIME MONITORING_PROFILE
DEFAULT

IDLE_TIME DBA_PRF
60

CONNECT_TIME DBA_PRF
DEFAULT


RESOURCE_NAME PROFILE
-------------------------------- ------------------------------
LIMIT
----------------------------------------
IDLE_TIME DEV_PRF
60

CONNECT_TIME DEV_PRF
UNLIMITED

IDLE_TIME MCR_LOG_PRF
5


RESOURCE_NAME PROFILE
-------------------------------- ------------------------------
LIMIT
----------------------------------------
CONNECT_TIME MCR_LOG_PRF
UNLIMITED


10 rows selected.

SQL>
Re: very urgent please help me error (merged) [message #266641 is a reply to message #266640] Tue, 11 September 2007 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you still don't follow the guidelines and don't format your post and it is unreadable.

You scorn the rules, you despise the members, you lie with your fake apologies, you just want help from us.
You will not get it from me.

Regards
Michel

[Updated on: Tue, 11 September 2007 05:00]

Report message to a moderator

Re: very urgent please help me error (merged) [message #266642 is a reply to message #266586] Tue, 11 September 2007 05:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Very badly formatted. My question was,
Quote:
Do you use other profile rather than default one?


Your answer was "no"

Without checking you answered wrong.

No help unless you format your post.
Re: very urgent please help me error (merged) [message #266643 is a reply to message #266586] Tue, 11 September 2007 05:06 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yet I don't want to be harsh to you. Change your idle_time resource_name and your problem will go down.
Run these
 alter profile default limit IDLE_TIME unlimited;
 alter profile dba_prf  limit IDLE_TIME unlimited;
 alter profile mcr_log_prf  limit IDLE_TIME unlimited;
 alter profile dev_prf  limit IDLE_TIME unlimited;


Now please read oracle forum Guide and follow it.

[Updated on: Tue, 11 September 2007 05:07]

Report message to a moderator

Previous Topic: ORA-04031 shared memory errors are occuring
Next Topic: Oracle 10g Parameters (Performance related)
Goto Forum:
  


Current Time: Sun Dec 04 12:50:33 CST 2016

Total time taken to generate the page: 0.09058 seconds