[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

5010.0. "Attaches hang after convert to 6.1" by ukvms3.uk.oracle.com::PJACKSON (Oracle UK Rdb Support) Fri Feb 07 1997 06:16

    A customer has just installed V6.1. He converted a database (from V6.0)
    and after saying that the convert had been committed it hung. Ctrl-Y
    etc did not work. He had to stop the process. Attaching to the
    database afterwards also hung.
    
    Any ideas?
    
    Sorry for the lack of information - I called the customer about the
    problem had had installing 6.1 on a system with no DECwindows
    installed, and he mentioned this, but was too busy to talk about it for
    long.
    
    Peter
T.RTitleUserPersonal
Name		DateLines
5010.1ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportThu Feb 13 1997 06:239
    The customer was doing an RMU/RESTORE of a backup made using 6.0A.
    He gets the message about the convert being committed. Then it becomes
    totally cpu bound. I asked him to try to force a bugcheck using
    RMU/BUGCHECK, but he got an RMU NOPRIV error despite having a fully
    privileged account. He can create a database, and attach to it, so his
    installation seems OK. He is going to try an export/import. It is a
    single file database.
    
    Peter
5010.2ACLs causing looping?ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportThu Feb 13 1997 07:5511
    IMPORT with NOACL creates a usable database.
    
    IMPORT with the original ACLs creates a database that causes ATTACH to
    hang.
    
    The old ACL is missing the following type of access - references,
    security, distribtran, but seems to have everything else.
    
    The database was created using Rdb V3, but has been converted to V6.0.
    
    Peter
5010.3NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 13 1997 10:0311
~    IMPORT with NOACL creates a usable database.
~    
~    IMPORT with the original ACLs creates a database that causes ATTACH to
~    hang.

This surprises me.  Can you perform a SHOW PROT and SHOW PRIV for the database
(before the EXPORT)?  Please post the output here.

thanks,

Ian
5010.4ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportThu Feb 13 1997 10:5217
    I have received a fax with the ACLs after each import.
    
    With NOACL it looks normal.
    
    With ACLs there is a entry for [*,*] giving full access followed by
    many entries like this
    
    (UNKNOWN=%X00,SIZE=%DO,FLAGS=%X0000,ACCESS=%X00000000,DATA)
    
    The customer says that there are thousands of these.
    
    This the same as on the pre-export database. He can attach to it using
    Rdb 6.0-0.
    
    The database was converted from 3.something straight to version 6.
    
    Peter
5010.5NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 13 1997 11:404
Looks like the ACL blob has been trashed.  Without the database it is a bit
hard to diagnose further.

ian
5010.6ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportThu Feb 13 1997 11:484
    I have asked for a copy of the export file. They have the problem on
    more than one database.
    
    Peter
5010.7BugNo:457362ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportTue Feb 25 1997 12:033
    Low priority bug entered
    
    Peter