Oracle hangs

[Former Member]

Hi All,

My SAP system is hanging . at Oracle level also it hangs .

SAP 4.0 B , Oracle :- 8.1.7 , OS :- AIX 5.2

Shutdown immidiate hangs and "alter system switch logfile;" also does not happen .

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-

---

-

---

-

---

-

---

-

---

--- -

---

FIRST_CHANGE# FIRST_TIM

-

---

-

---

1 1 119977 20971520 2 NO ACTIVE

301029632 14-JAN-10

2 1 119973 20971520 2 NO INACTIVE

301014870 12-JAN-10

3 1 119975 20971520 2 NO INACTIVE

301022200 13-JAN-10

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-

---

-

---

-

---

-

---

-

---

--- -

---

FIRST_CHANGE# FIRST_TIM

-

---

-

---

4 1 119978 20971520 3 NO CURRENT

301035466 14-JAN-10

5 1 119976 20971520 2 NO INACTIVE

301027566 14-JAN-10

6 1 119974 20971520 2 NO INACTIVE

301017630 13-JAN-10

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination /oracle/PRD/saparch/PRDarch

Oldest online log sequence 119973

Current log sequence 119978

SQL>

Read statements are successful But any alter operation just hangs .

Any input ?Pls advice

Thanks,

Suman

[Former Member]

Had to patch oracle 8 with terminal patches for solving this.

[saif_sabri]

Hi

You are not mentioned your Operationg System (OS).

Regards from Pakistan

[Former Member]

hi,

can you connect with sys user and write:

select open_mode from v$database;

thanks

ferhan

[former_member524429]

Hi,

Please refer [SAP Note 521264 - Hang situations|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=521264]

Have you applied latest Oracle PatchSet/Patches corresponding to you OS Platform ? If not, then apply it with the help of the following reference notes.

[SAP Note 362060 - Current patch set for Oracle 8.1.7|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=362060]

[ SAP Note 509314 - Downloading Oracle patches from SAP Service Marketplace|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=509314]

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Jan 22, 2010 12:16 PM

[Former Member]

Database log mode No Archive Mode

Looking very strange that your DB is in No archive mode...then file system(arch) issue should not be there

Put your DB in archive mode and let us know the status.

Regards,

Nick Loy

[Former Member]

Hi All,

There no alert in the alert log .

Also no file system is full .

Thanks

Suman

[Former Member]

Put in a df -g and check the sapdata and oraarch filesystems whethere they are filled up completly.

Also check whether you see anything in alertlog file.

[Former Member]

First thing to check:

oraarch directory full?

Next thing to check:

What does your alert<SID>.log file say?