Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle database mounted but Frozen

Oracle database mounted but Frozen

Last friday I started receiving errors regarding a disk disconnect, and now in the morning I cannot start my oracle DB. I issue the startup command but I have this screen (see below) and then it frozes.

Total system global area NNNN
Fixed size NNNN
Variable size NNNN
Database buffers NNNN
Redo buffers NNNN
Database mounted.

and then the messages stays there until I kill the session.

I have already issued and ioscan -fnC disk and I can see all disks.

I have:
OS HP-UX 11.0
Oracle 8.1.4

Can anybody help me to resolve this?
Thanks in advance...
Camacho
9 REPLIES
Ra Jose
Regular Advisor

Re: Oracle database mounted but Frozen

You should see in syslog whether you are getting errors for disks. If so, run diagnostics on the disk. It may be possible that certain areas on disk are corrupted. Looks for oracle logs and see any error messages.
Rajos
Eric Antunes
Honored Contributor

Re: Oracle database mounted but Frozen

Hi Camacho,

Try this:

sqlplus '/ as sysdba'
SQL>shutdown abort;
SQL>startup;

If it doesn't work then post the output of:

ipcs -mb

Best Regards,

Eric Antunes
Each and every day is a good day to learn.

Re: Oracle database mounted but Frozen

Thank you very much for your response.
My server is about to be sent to a museum :), is very old . I turn it off during the night and in the morning I turn it on and the database worked perfectly...

Regards.

Camacho

Re: Oracle database mounted but Frozen

Hello everyone,

I am having the problem (Cannot open my database). I am posting the result of ipcs -mb.

$ ipcs -mb
IPC status from /dev/kmem as of Fri Apr 27 11:20:53 2007
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x412017ee --rw-rw-rw- root root 348
m 1 0x4e0c0002 --rw-rw-rw- root root 31040
m 2 0x41147763 --rw-rw-rw- root root 8192
m 203 0x43200560 --rw-rw-rw- daemon root 5767168
m 4 0x00000000 D-rw-r----- oracle oinstall 110395392
m 5 0x00000000 D-rw-r----- oracle oinstall 110395392

I have done this before:

startup nomount (Ok)
alter database mount; (Ok)
alter database open; (freeze)

Re: Oracle database mounted but Frozen

Hello everyone,

I am having the problem (Cannot open my database). I am posting the result of ipcs -mb.

$ ipcs -mb
IPC status from /dev/kmem as of Fri Apr 27 11:20:53 2007
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x412017ee --rw-rw-rw- root root 348
m 1 0x4e0c0002 --rw-rw-rw- root root 31040
m 2 0x41147763 --rw-rw-rw- root root 8192
m 203 0x43200560 --rw-rw-rw- daemon root 5767168
m 4 0x00000000 D-rw-r----- oracle oinstall 110395392
m 5 0x00000000 D-rw-r----- oracle oinstall 110395392

I have done this before:

startup nomount (Ok)
alter database mount; (Ok)
alter database open; (freeze)

Erick Antunes suggested me to post ipcs -mb, Can you please help me?

Regards
Camacho
Eric Antunes
Honored Contributor

Re: Oracle database mounted but Frozen

Hi Camacho,


The D mode means:

"The associated shared memory segment has been removed. It will disappear when the last process attached to the segment detaches it."

Try as oracle:

$sqlplus '/ as sysdba'
SQL>shutdown abort;
SQL>exit

$ps -fu oracle

See if there are any processes and kill them:

$kill -9

Then try to start the database:

$sqlplus '/ as sysdba'
SQL>startup;

If you aren't able to start the database then you will need to restart the server...

Best Regards,

Eric
Each and every day is a good day to learn.
Rita C Workman
Honored Contributor

Re: Oracle database mounted but Frozen

Your ipcs output shows that Oracle is in fact still holding onto memory (m) segments.
I prefer the command ipcs -a to question everything.

Shared Memory:
m 0 0x412017ee --rw-rw-rw- root root 348
m 1 0x4e0c0002 --rw-rw-rw- root root 31040
m 2 0x41147763 --rw-rw-rw- root root 8192
m 203 0x43200560 --rw-rw-rw- daemon root 5767168
m 4 0x00000000 D-rw-r----- oracle oinstall 110395392
m 5 0x00000000 D-rw-r----- oracle oinstall 110395392

If, as you mention, the database is not starting then you need to clean up everything that is left hanging out there.
Two ways to do this. One reboot your box -or- clear up those hung resources using ipcrm
ipcrm -m <#> to clear memory segments
ipcrm -q <#> to clear query segements
ipcrm -q <#> to clear semaphores

The <#> is that first column after the corresponding letter.
Once you have everything cleared up..do a ps-ef | grep ora and clean up anything there. Then try to restart your Oracle manually.

Rgrds,
Rita
Rita C Workman
Honored Contributor

Re: Oracle database mounted but Frozen

..sorry mistype on semaphores...

ipcrm -s <#>

Rita

Re: Oracle database mounted but Frozen

As previously happen I restarted the server and the problem was resolved. The solution will then be to purchase a new hard disk, It seems to be damaged. However your responses were usefeul to argue my boss to buy a new server...

Best Regards

Camacho