Login Hang [message #378551] |
Tue, 30 December 2008 23:12 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
AOA
I want to ask that after some days my database server refuse to login and clients are in hanging position. On inspection I saw that in enterprise manager it indicating for waiting for log switch.
I restart my server then it is ok. I also saw that there are every thing is file.
But what is the problem.(I am using in archivelog mode)
Pls help.
|
|
|
|
|
Re: Login Hang [message #379104 is a reply to message #378598] |
Sun, 04 January 2009 22:05 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
---------- Alert log file looks like------------
Date
Oracle Instance abc Cannot allocate log,archival required
Date
ARCH: Connecting to console port.....
Thread 1 cannot allocate new log,sequence 1785.
All online log needed archiving.
Current log#2 seq#1784 mem#0 : /data/redo/redo02.log.
|
|
|
|
|
|
|
Re: Login Hang [message #400009 is a reply to message #399682] |
Sat, 25 April 2009 00:27 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
Dear
Database is in archive log mode. Because when restart it database is open normally and work properly and can be list archive log list.
|
|
|
|
|
Re: Login Hang [message #400304 is a reply to message #400009] |
Mon, 27 April 2009 08:18 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
smunir362 wrote on Sat, 25 April 2009 01:27 | ...when restart it database is open normally and work properly and can be list archive log list.
|
What does that mean?
Looks like you are just ignoring questions. Once again I will ask, then move on. Do an archive log list
|
|
|
|
Re: Login Hang [message #400551 is a reply to message #400541] |
Tue, 28 April 2009 12:59 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
No, do it NOW! Jesus Christ, we ask for you do do a simple thing which may give us insight into your problem, but no, you make it difficult. Have fun solving your problem.
|
|
|
|
|
|
|
|