Delphix Products

  • 1.  Error LRM-00109 in creating VDB

    Posted 09-03-2015 05:27:00 AM
    When creating VDB, received the following error.

    Failed to mount database instance. See command output for more information.

    Make sure that the parameters in init<sid>.ora file are valid. Review the Oracle alert log for more details if applicable.

    rm -f $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora

    DELPHIX>$DLPX_SHELL $DB_SCRIPT_DIR/mount-vdb-instance.sh "restrict pfile='/bck/target/ZCOM/datafile/init.ora.rename'"

    #####DELPHIX_START_ERROR#####

    ERROR :

    ERROR : SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 2 14:20:48 2015

    ERROR :

    ERROR : Copyright (c) 1982, 2013, Oracle. All rights reserved.

    ERROR :

    ERROR : Connected to an idle instance..

    ERROR :

    ERROR : ZCOM1:SYS> LRM-00109: could not open parameter file '/bck/target/ZCOM/datafile/init.ora.rename'

    ERROR : ORA-01078: failure in processing system parameters

    ERROR : ZCOM1:SYS> Disconnected

    #####DELPHIX_END_ERROR#####

    MOUNT_DATABASE_ERROR

    <rpcinfo output>

    NEW_tcomdb1:/bck/target>rpcinfo -p 172.20.0.189

       program vers proto   port  service
        100000    4   tcp    111  portmapper
        100000    3   tcp    111  portmapper
        100000    2   tcp    111  portmapper
        100000    4   udp    111  portmapper
        100000    3   udp    111  portmapper
        100000    2   udp    111  portmapper
        100155    1   tcp  44485
        100024    1   udp  49301  status
        100024    1   tcp  43740  status
        100133    1   udp  49301
        100133    1   tcp  43740
        100021    1   tcp   4045  nlockmgr
        100021    2   tcp   4045  nlockmgr
        100021    3   tcp   4045  nlockmgr
        100021    4   tcp   4045  nlockmgr
        100021    1   udp   4045  nlockmgr
        100021    2   udp   4045  nlockmgr
        100021    3   udp   4045  nlockmgr
        100021    4   udp   4045  nlockmgr
        100005    1   udp  40795  mountd
        100005    1   tcp  39752  mountd
        100005    2   udp  40795  mountd
        100005    2   tcp  39752  mountd
        100005    3   udp  40795  mountd
        100005    3   tcp  39752  mountd
        100003    2   udp   2049  nfs
        100003    3   udp   2049  nfs
        100227    2   udp   2049
        100227    3   udp   2049
        100003    2   tcp   2049  nfs
        100003    3   tcp   2049  nfs
        100003    4   tcp   2049  nfs
        100227    2   tcp   2049
        100227    3   tcp   2049

    < sudo outpuut>
    NEW_tcomdb1:/bck/target>sudo -l
    User oracle may run the following commands on this host:
        (root) NOPASSWD: /usr/sbin/mount
        (root) NOPASSWD: /usr/sbin/umount
        (root) NOPASSWD: /usr/bin/mkdir
        (root) NOPASSWD: /usr/bin/rmdir
        (root) NOPASSWD: /usr/sbin/nfso
        (root) NOPASSWD: /usr/bin/ps

    <mount, umount>
    NEW_tcomdb1:/bck/target>sudo mount 172.20.0.189:/public /bck/target

    Taget is AIX 7.1 and delphix engine is 4.2.1.0.

    What should be checked to resolve this problem ?

    Thanks,


  • 2.  RE: Error LRM-00109 in creating VDB

    Posted 09-03-2015 06:13:00 AM
    Also, How can I check the status of NFS processor in Delphix engine?


  • 3.  RE: Error LRM-00109 in creating VDB

    Posted 09-03-2015 10:33:00 AM
    <df output after mount  /bck/target>
    NEW_tcomdb1:/bck/target>df  Filesystem    512-blocks      Free %Used    Iused %Iused Mounted on
    /dev/hd4        20971520  20246656    4%    12710     1% /
    /dev/hd2        20971520   9650544   54%    81342     8% /usr
    /dev/hd9var     20971520  19724672    6%    27366     2% /var
    /dev/hd3        41943040  39353856    7%      470     1% /tmp
    /dev/hd1        41943040  18515280   56%      795     1% /home
    /dev/hd11admin    2097152   2068224    2%       17     1% /admin
    /proc                  -         -    -         -     -  /proc
    /dev/hd10opt    20971520  20623568    2%     8655     1% /opt
    /dev/livedump    1048576   1047760    1%        4     1% /var/adm/ras/livedump
    /dev/swlv       41943040  38785816    8%    13460     1% /sw
    /dev/apploglv   20971520  20558376    2%     1235     1% /applog
    /dev/oraclelv  167772160  98338336   42%    56921     1% /oracle
    /dev/dblv      104857600  31683944   70%    12632     1% /db
    /dev/arch1lv   125829120  49848072   61%       51     1% /arch1
    /dev/bcklv     293601280 105131024   65%      619     1% /bck
    172.20.0.189:/public  222953872 222953832    1%        7     1% /bck/target
    NEW_tcomdb1:/db/diag/rdbms/tcom/TCOM1/trace>sudo umount -f /bck/target