OraFAQ Forum: Server Administration » very urgent please help me error (merged)

Home » RDBMS Server » Server Administration » very urgent please help me error (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

very urgent please help me error (merged) [message #266586]

Tue, 11 September 2007 03:24

aboodlardy
Messages: 80
Registered: November 2006
Location: India

Member

kwqiclode: Error 376 happened during loading of queue

in alert log what this means.

Report message to a moderator

Re: very urgent please help me error [message #266596 is a reply to message #266586]

Tue, 11 September 2007 03:36

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: please help me error [message #266600 is a reply to message #266596]

Tue, 11 September 2007 03:46

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

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.

Report message to a moderator

please help me with this error..... [message #266605 is a reply to message #266586]

Tue, 11 September 2007 03:58

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

Report message to a moderator

Re: very urgent please help me error [message #266606 is a reply to message #266604]

Tue, 11 September 2007 04:01

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

Report message to a moderator

Re: please help me with this error..... [message #266607 is a reply to message #266605]

Tue, 11 September 2007 04:02

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.

Report message to a moderator

Re: very urgent please help me error [message #266611 is a reply to message #266586]

Tue, 11 September 2007 04:05

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

Bounce again and again. Problem will be go away. Laughing

Report message to a moderator

Re: very urgent please help me error [message #266614 is a reply to message #266611]

Tue, 11 September 2007 04:10

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

Report message to a moderator

Re: very urgent please help me error [message #266619 is a reply to message #266614]

Tue, 11 September 2007 04:15

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: very urgent please help me error [message #266624 is a reply to message #266619]

Tue, 11 September 2007 04:27

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

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

Report message to a moderator

Re: very urgent please help me error (merged) [message #266628 is a reply to message #266586]

Tue, 11 September 2007 04:38

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');

Report message to a moderator

Re: very urgent please help me error (merged) [message #266640 is a reply to message #266628]

Tue, 11 September 2007 04:56

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>

Report message to a moderator

Re: very urgent please help me error (merged) [message #266641 is a reply to message #266640]

Tue, 11 September 2007 05:00

Michel Cadot
Messages: 68686
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

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.

Report message to a moderator

Re: very urgent please help me error (merged) [message #266643 is a reply to message #266586]

Tue, 11 September 2007 05:06

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:48:59 CDT 2024