 My Oracle's Database suspend [message #126150] |
Fri, 01 July 2005 05:17  |
nhom9a
Messages: 51
Registered: July 2005
Location: VN
|
Member |
|
|
Please help me.
My Oracle Database sometime suspends. If I restart my server it will Start and do well but sometime it suspends. I don't know reason. Can you help me ?
|
|
|
|
|
|
|
|
|
|
| Re: My Oracle's Database suspend [message #126337 is a reply to message #126150] |
Sun, 03 July 2005 20:30  |
nhom9a
Messages: 51
Registered: July 2005
Location: VN
|
Member |
|
|
Thanks.
I found it and read it. It happens some mistake but I don't know what reason. Can you explan for me.
Fri Jul 01 19:40:29 2005
Errors in file e:\oracle\admin\div_12\udump\odiv12_j001_2632.trc:
ORA-12012: error on auto execute of job 225
ORA-04052: error occurred when looking up remote object KT07.SYS@OBR07_XDHCM.US.ORACLE.COM
ORA-00604: error occurred at recursive SQL level 3
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
I have a Database link, it receipt data from a branch
|
|
|
|
| Re: My Oracle's Database suspend [message #126341 is a reply to message #126150] |
Sun, 03 July 2005 23:01 |
nhom9a
Messages: 51
Registered: July 2005
Location: VN
|
Member |
|
|
My database has just suspended and I found in Aleart.log file have a mistake. Can anyone help me ?
Mistake:
Fri Jul 01 19:44:14 2005
Thread 1 cannot allocate new log, sequence 70
All online logs needed archiving
Current log# 2 seq# 69 mem# 0: E:\ORACLE\ORADATA\DIV_12\REDO02.LOG
|
|
|
|
| Re: My Oracle's Database suspend [message #126343 is a reply to message #126341] |
Sun, 03 July 2005 23:30 |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
First:
Look for your logs wait events,If high so increase the Log buffer.
Second:
make sure that your online and archive log destination has sufficient disk space.
Third:
Check your network system,Is there any other high loading application on your network?Maybe something like timeout errors occure!?
|
|
|
|
|
|
|
|
| Re: My Oracle's Database suspend [message #126366 is a reply to message #126150] |
Mon, 04 July 2005 01:45 |
nhom9a
Messages: 51
Registered: July 2005
Location: VN
|
Member |
|
|
Can anyone help me ?. My database is hanging and it's log file have some note:
Mon Jul 04 12:58:45 2005
Thread 1 cannot allocate new log, sequence 72
All online logs needed archiving
Current log# 1 seq# 71 mem# 0: E:\ORACLE\ORADATA\DIV_12\REDO01.LOG
|
|
|
|
| Re: My Oracle's Database suspend [message #126378 is a reply to message #126150] |
Mon, 04 July 2005 02:36 |
shettyshetty
Messages: 18
Registered: June 2005
Location: Malaysia
|
Junior Member |
|
|
Hi,
You have set init.ora parameter "log_archive_start" to FALSE for an ARCHIVELOG mode database.
Manually enable automatic archiving by issuing
ALTER SYSTEM ARCHIVE LOG START;
When you restart the instance next time, do remember to include log_archive_start=TRUE in your init.ora file. If you are using Oracle 9i, it's highly recommended that you use spfile.
Regards,
Sunil
|
|
|
|
| Re: My Oracle's Database suspend [message #126380 is a reply to message #126150] |
Mon, 04 July 2005 02:47 |
nhom9a
Messages: 51
Registered: July 2005
Location: VN
|
Member |
|
|
Thanks for your help. Shetyshety
But I'm a new Oracle so I'm not understand how to do. Can you show me clearly.
Now.I saw in Initialization Parameter
log_archive_start is FALSE
|
|
|
|
| Re: My Oracle's Database suspend [message #126381 is a reply to message #126366] |
Mon, 04 July 2005 02:51 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi ,
See ur database is hanging after ur redo logfile gets full.
Everytime the message is thr ,logfile needs archiving.
Is ur database is running in archivelog or noarchivelog mode? There is some problem with ur archivelog mode.
u can check it with command :
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination D:\oracle\ora92\RDBMS
Oldest online log sequence 23
Current log sequence 25
SQL>
U asked about log wait events , u can check it as follows .
SQL> select * from v$sysstat where name like '%redo log%';
SQL> select * from v$system_event where event like '%log%';
From these views u can check the waits .
Regards,
Tarun
|
|
|
|
| Re: My Oracle's Database suspend [message #126383 is a reply to message #126380] |
Mon, 04 July 2005 02:57 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hi,
do
log_archive_Start=true
the save it.
And restart the database with this pfile.
sQl> startup pfile='path\init.ora'
Then again check
SQL> Archive log list
It should display that automatic archiving enabled
|
|
|
|
| Re: My Oracle's Database suspend [message #126386 is a reply to message #126150] |
Mon, 04 July 2005 03:06 |
nhom9a
Messages: 51
Registered: July 2005
Location: VN
|
Member |
|
|
Thanks.
I tried it follow your suggetion and now my database have status:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\oracle\oradata\Div_12\archive
Oldest online log sequence 70
Next log sequence to archive 72
Current log sequence 72
I will check it. I hope it will not suspend
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
