DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT HELP: error closing password file & unable to flush file data in UNIX

  1. #1
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93

    URGENT HELP: error closing password file & unable to flush file data in UNIX

    Hi friends, I'm really scared because I received this error on AIX:
    error closing password file & unable to flush file data

    This is the screeen of the error when I tried to shutdown the database in my coldbackup cron:

    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    SVRMGR> connect internal
    Password:
    Connected.
    SVRMGR> shutdown immediate;
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SVRMGR> startup;
    ORACLE instance started.
    Total System Global Area 87207652 bytes
    Fixed Size 69348 bytes
    Variable Size 53411840 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 172032 bytes
    ORA-01992: error closing password file '/oracle/dbs/orapwmy_db'
    ORA-27052: unable to flush file data
    IBM AIX RISC System/6000 Error: 5: I/O error
    Additional information: 1
    SVRMGR>

    I have noticed that before the error had produced in the server, I received these mails of the cron. These were produced during an export and the coldbackup automated via cron:

    -- mail 1 --


    Message 1:
    From daemon Thu Dec 12 22:01:03 2002
    Date: Thu, 12 Dec 2002 22:01:03 -0500
    From: daemon
    To: ora816

    rm: 0653-609 Cannot remove /oracle/export/exp_my_db.dmp.Z.
    There is an input or output error.

    Export: Release 8.1.6.0.0 - Production on Thu Dec 12 22:00:02 2002

    (c) Copyright 1999 Oracle Corporation. All rights reserved.


    EXP-00028: failed to open log_export.log for write
    EXP-00000: Export terminated unsuccessfully
    exp_my_db.dmp.Z: A file or directory in the path name does not exist.
    netout: write returned 0?


    *****************************************************************
    cron: The previous message is the standard output
    and standard error of one of the cron commands.

    ?

    -- mail 2 --
    ? 1
    Message 1:
    From daemon Fri Dec 13 00:34:07 2002
    Date: Fri, 13 Dec 2002 00:34:07 -0500
    From: daemon
    To: ora816

    There is an input or output error.
    /oracle/coldbackup/cold.sh[67]: ./logcold.txt: 0403-005 Cannot
    create the specified file.
    There is an input or output error.
    There is an input or output error.
    netout: write returned 0?
    netout: write returned 0?

    *****************************************************************
    cron: The previous message is the standard output
    and standard error of one of the cron commands.


    ----------------------------------------
    WHAT CAN I DO ?

    I think the first error was produced during the export activity because the process still alive in the next morning, and it seems to be a write-read error of unix. I can startup and shutdown the database, but it always send me the error error closing password file & unable to flush file data. I used the fsck utility and I discover some filesystems have corruptions.
    I already check the process, semaphores, dbs/.sga files and mem segments and all related to oracle and there is nothing with that account running.
    What can I do ? I think I'm in a big problem, please help me!

    Thank you in advance

  2. #2
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    It looks like due to OS problem. After their side is clear, try
    1). shutdown instance(if nomount or mount), backup old passwd file and recreate new passwd file by
    $ orapwd file=$ORACLE_HOME/dbs/orapwSID password=xxx entries=...
    2) try to start instance again
    3) If failed again, try set init.ora file
    remote_login_passwordfile=NONE
    and restart instance.

    Good luck!

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Have you checked to make sure that all of your volumes are mounted?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width