Oracle Hangs !!!!!

[st2000]

Hi : I have a system setup running perfectly..(fresh one)
No Archive log mode.. Locally managed TS..
Enough disk space.. < 2 users anytime (testing system)
At a ceratin point when i try to insert, oracle simply hangs and does nothing.. auto extend is on and when i check for the dba_free_space the TS is not listed(should I worry)..
Even otherwise I try to create a datafile, it doesnt repsond..
Simply hangs at that point..
Any clues any direction??
Thx..

[Halo]

A locally managed ts is never listed in the data dictionary. Check on Metalink for this problem and ensure that there are no bugs involved. Try to bounce the db and/or the server.

[st2000]

Did a reboot on the server as well Halo..
Did bounce the db a few times..
Thanks for the tip on locally managed TS.. I thought so, since it is managed locally it would not show as a dictionary item, but how is it that many of my other TS show up..
Anyway now the problem on hand is different..
Please refer any other clues and probable causes for that..
Thx

[Halo]

What is the Oracle version and OS type?? Do you have access to Metalink??

[Edited by Halo on 01-10-2001 at 11:54 AM]

[sreddy]

Have a read on this column on 'locally managed tablespaces' something might strike you to resolve the problem.

[url]http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html[/url]

[st2000]

version is 8.1.6
os type : SunOS sun4u

Actually in alert_nbs.log the following appears::
Errors in file /u01/app/oracle/admin/nbs/bdump/nbs_snp0_1813.trc:
ORA-12012: error on auto execute of job 4
ORA-04054: database link AMILINK does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 604
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 661
ORA-06512: at "SYS.DBMS_IREFRESH", line 577
ORA-06512: at "SYS.DBMS_REFRESH", line 211
ORA-06512: at line 1
Wed Jan 10 16:53:13 2001..

Basically the links are created and i have dropped the links to see if the problem improves.. it still complains it is looking for links.. links are public and we have created 2 liniks..

any more clues.. Thx