Solved

Oracle 8i DB hung up in middle of shutdown immediate...30 minutes now

Posted on 2016-10-04
13
36 Views
Last Modified: 2016-10-06
I entered the command shutdown immediate; in SQLPlus (logged in as INTERNAL) and haven't gotten a response. Trying anyother command in a new instance of SQL*Plus just gives me the response:

ORA-01089: immediate shutdown in progress - no operations are permitted

HELP! what do I do? Can I restart the server (windows) without screwing things up? I don't want to have to go through a recovery.
0
Comment
Question by:uomobello
  • 6
  • 5
  • 2
13 Comments
 
LVL 34

Expert Comment

by:johnsone
ID: 41828819
What was the database doing when you issued the statement?  It is most likely cleaning up temporary space.  It has been a long time, but I believe that was an issue with 8i.  If your temp space is large and was mostly in use at shut down it can take a long time.

Also, all in flight transactions would have to be rolled back.

If you restart the server you will have to go through recovery, but you should only have to go through instance recovery.  Essentially everything it is trying to do now, it will have to do on the way back up.  You can try to cancel the shutdown immediate, then issue a shutdown abort.  But again, everything it is doing now, it will have to do on the way back up.  Sometimes it is faster on the way back up, but not always.
0
 

Author Comment

by:uomobello
ID: 41828835
johnsone,

There were a few online users doing some transactions probably. I've only had to do a recovery once before but as long as Oracle tells me which archive log file to use for recovery I should be okay....but I'd rather not have to do that. How would I cancel the shutdown immediate? it's not letting me even login.

It's been over an hour now since issuing the shutdown command. Do you still think there's a chance the DB will work this finish the shutdown without my intervention?
0
 
LVL 34

Expert Comment

by:johnsone
ID: 41828846
Instance recovery wouldn't need archive logs.

You should be able to ctrl-C the shutdown.  That usually works.

Eventually it should finish.  There may be old cases where it doesn't.  Like I said, I haven't seen 8i in at long time (at least 10 years).
0
 

Author Comment

by:uomobello
ID: 41828864
I'm a one man band here and really a programmer, not a DBA, so my knowledge of this stuff is limited.

if I do reboot the server, what would be the recovery command?
0
 

Author Comment

by:uomobello
ID: 41828867
...also, I tried ctrl-C while in SQL*Plus with no change.
0
 
LVL 34

Accepted Solution

by:
johnsone earned 500 total points
ID: 41828904
You shouldn't have to issue any recover command.  Instance recovery is automatic.
1
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:uomobello
ID: 41829804
The server hung on the restart so it had to be rebooted. After that the DB came back up without issues. Thanks for your help.
0
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 41830685
"The server ... had to be rebooted.  After that the DB came back up without issues."  That's been my experience with every Oracle database that I've worked on (dating back to Oracle5) on a variety of O/Ses: VAXVMS, Netware, HPUX, Solaris, Windows and Linux.

And yes, the instance recovery is usually automatic with no manual or DBA input required, other that re-starting the instance if that is not automated on your server following a reboot.  With Oracle8i on Windows, that can be automated.
0
 

Author Comment

by:uomobello
ID: 41832617
markgeer...yes, I already wrote a script that automates the DB startup when the server reboots. I was hesitant about shutting down the server because the only other time the DB hung during a shutdown and I issued a shutdown abort followed by "startup", I got an error:....file 1 needs media recovery.

After a number of missteps and some help from the old forum Lazy DBA, I was finally able to complete the recovery. However, I think that incident was so troublesome because the DB hung while I was using Oracle DBA Studio which I have since heard has always been glitchy.
0
 
LVL 34

Expert Comment

by:johnsone
ID: 41832625
You shouldn't have to write any script to start the database when the server starts.  Oracle supplies scripts for UNIX type operating systems and I believe all you have to do is auto start the service on Windows (sorry, I don't use Windows very much).

A shutdown abort shouldn't normally cause a need for media recovery.  The difference between shutdown immediate and shutdown abort is that everything that shutdown immediate does on the way down, startup has to do on the way up with a shutdown abort.  There really isn't a whole lot of difference.  I got that from some internal Oracle people.

As I recall, what you are seeing is more or less normal behavior on 8i.  It is more or less the major reason that temporary tablespaces were created.  The tablespace gets extremely fragmented and the housekeeping is a big issue on a permanent tablespace.
1
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 41832636
I agree that you don't need a script to autostart an Oracle8i database on Windows when the server restarts.  You just configure the two main Oracle services (one for the database and one for the listener) so that they start automatically when the server reboots.

I did that for Oracle8i which we ran on Windows some years ago.  We moved to Linux and Oracle9i over 10 years ago, in late 2005.  I liked the combination of Oracle8i and Windows then, but the combination of Oracle9, 10 or 11 and Linux is *MUCH* more stable than Oracle8i was on Windows.  When we ran that combination here (Oracle8i and Windows) we did a scheduled, automated shutdown and reboot of the database and server every weekend (using the Windows job scheduler) and we still averaged a crash per week of either the DB or the O/S.  On Linux, we average less than a crash per year (and we had no previous Linux experience).
0
 

Author Comment

by:uomobello
ID: 41832662
if my memory serves, a number of years ago the main DB service wasn't starting properly on a server restart. It's status was reading as "starting." Writing a script in Windows that issued a 'startup' command whenever the server was started seemed to solve the issue.

Also, now that I think about it, I was probably altering the DB in some way when DBA Studio simply hung. Not knowing what else to do I think I simply forced the process to stop and that's when my problems started and DB recovery was needed.

We're thinking about virtualizing this server so maybe I'll consider going over to Linux. I have zero experience with Linux but you have me considering it.
0
 
LVL 34

Expert Comment

by:johnsone
ID: 41832717
Unless you already have a copy of it, you won't be able to move to a Linux server and still run 8i.  Ideally you should be running 12.  You could probably still get a copy of 11, but I wouldn't try to go back any further than that.

Also before moving to a virtual server, be sure that you are aware of Oracle's support rules on virtual servers.  You probably want to contact them, but the general rule is usually that if you have a problem you need to duplicate the problem in a non-virtual server before they will look at it.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now