- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle database mounted but Frozen
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2007 10:47 AM
тАО03-20-2007 10:47 AM
Oracle database mounted but Frozen
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2007 11:22 AM
тАО03-20-2007 11:22 AM
Re: Oracle database mounted but Frozen
Rajos
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2007 12:16 AM
тАО03-21-2007 12:16 AM
Re: Oracle database mounted but Frozen
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2007 02:36 AM
тАО03-21-2007 02:36 AM
Re: Oracle database mounted but Frozen
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2007 04:24 AM
тАО04-27-2007 04:24 AM
Re: Oracle database mounted but Frozen
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2007 04:29 AM
тАО04-27-2007 04:29 AM
Re: Oracle database mounted but Frozen
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2007 09:12 PM
тАО04-29-2007 09:12 PM
Re: Oracle database mounted but Frozen
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2007 12:07 AM
тАО04-30-2007 12:07 AM
Re: Oracle database mounted but Frozen
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2007 12:08 AM
тАО04-30-2007 12:08 AM
Re: Oracle database mounted but Frozen
ipcrm -s <#>
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2007 01:51 AM
тАО04-30-2007 01:51 AM
Re: Oracle database mounted but Frozen
Best Regards
Camacho