Oracle DB fails to shutdown.

[John Flanagan]

DB version 8.1.7 32 bit
OS HP-UX 11i

The database is shutdown every night for backup. On 2 out of the last 4 nights I get the following error

SHUTDOWN: waiting for logins to complete.

To get the database to shutdown I have to use shutdown abort. When I try to start up the db I get an end of file on communication channel error.

On the other 2 nights there was no problem and the database allways stops and starts without a problem when I do it manually.

How can I check what process or application is trying to connect to the database? and why to I get the end of file on communication channel error on startup?

Regards,

John.

[Eric Antunes]

Hi John,

You must use the instruction "immediate" with the shutdown command:

SQL>shutdown immediate;

Regards,

Eric Antunes

[Sivakumar TS]

Hi John,

Check if any running oracle process are available,

#ps -ef | grep oracle

and try
shutdown immediate once

and try to startup and shutdown normallly.

WIth Regards,

Siva.

[John Flanagan]

All shutdowns are done with shutdown immediate. I should have stated that in the question.

[Sanjay Kumar Suri]

Check these links:

http://www.praetoriate.com/oracle_tips_process_detail.htm

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=997654

sks

[Eric Antunes]

Hi John,

Can you attach the last trace files of those 2 nights (usually in $ORACLE_HOME/admin//bdump)?

Regards,

Eric Antunes

[Eric Antunes]

One more question:

Is there a database link?

[John Flanagan]

There are no DB links.

I should have said that the backup uses the oracle provided script

/usr/bin/su oracle -c /home/oracle/8.1.7/bin/dbshut

I have just noticed that the backup logfile shows an end of file on communication channel error.

SVRMGR> Connected.
SVRMGR> ORA-03113: end-of-file on communication channel
SVRMGR>
Server Manager complete.
Database "paulive" shut down.


The errors from the udump file

*** SESSION ID:(46.1349) 2006-02-01 23:35:16.420
SHUTDOWN: waiting for logins to complete.
*** 2006-02-01 23:40:27.510
SHUTDOWN: waiting for logins to complete.
*** 2006-02-01 23:45:38.570
SHUTDOWN: waiting for logins to complete.
*** 2006-02-01 23:50:49.650
...........
.........

I am going to check the HP-UX patchs.

[John Flanagan]

All documentation I found relates to HP-UX 11.00 and not to 11.11.

Is there documentation relating to patch requirements on 11.11 for Oracle 8.1.7.

[Yogeeraj_1]

hi John,

Cold backups always presents these types of problems. cold backup typically implies unattended shutdown/startup.

A hot backup removes that worry. True, you could use a shutdown abort, startup/shutdown cycle to remove many of the issues with unattended shutdowns but not all (database won't restart without someone kicking something for example)...

I think a hot backup, especially with rman (don't even have to put it into backup mode) is easier than a cold for this reason.

I cannot see any disadvantages of doing so.

kind regards
yogeeraj