Delphix Products

Expand all | Collapse all

i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

prakash v

prakash v05-11-2016 08:30:00 AM

prakash v

prakash v05-11-2016 09:11:00 AM

prakash v

prakash v05-11-2016 09:13:00 AM

prakash v

prakash v05-11-2016 09:17:00 AM

  • 1.  i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 08:30:00 AM
    it ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1413934/RackMultipart20160511-117287-1m3oh6-Untitled_inline.png?1462958966">
    #DemoEnvironment


  • 2.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 08:32:00 AM
    in the terminal it shows failed to mount the database instance.see the command output for more instance


    rm -f $ORACLE_HOME/dbs/spfile${ORACLE_SID}.oraDELPHIX>$DLPX_SHELL $DB_SCRIPT_DIR/mount-vdb-instance.sh "restrict pfile='/mn< IPT_DIR/mount-vdb-instance.sh "restrict pfile='/mnt /provision/qadb/datafile/< .sh "restrict pfile='/mnt/provision/qadb/datafile/i nit.ora.rename'"
    #####DELPHIX_START_ERROR#####
    ERROR :
    ERROR : SQL*Plus: Release 11.2.0.2.0 Production on Wed May 11 05:23:09 2016
    ERROR :
    ERROR : Copyright (c) 1982, 2011, Oracle. All rights reserved.
    ERROR :
    ERROR : Connected to an idle instance.
    ERROR :
    ERROR : SQL> ORA-00845: MEMORY_TARGET not supported on this system
    ERROR : SQL> Disconnected
    #####DELPHIX_END_ERROR#####
    MOUNT_DATABASE_ERROR


  • 3.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 08:52:00 AM
    HI It seems that your target linux  does not have defined  /dev/shm device

    Try this as root:

    mount -t tmpfs shmfs -o size=1500m /dev/shm

    if does not work increase further

    mount -t tmpfs shmfs -o size=4500m /dev/shm

    Make sure that you have sufficient physical memory (RAM) in your linux target box.

    You need to make sure memory_target and memory_max_target is less that the value above.

    Also check value of MEMORY_TARGET or MEMORY_MAX_TARGET in your Oracle instance template.


  • 4.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:00:00 AM
    where will be oracle instance template will be located..?


  • 5.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:02:00 AM
    Oracle instance template settings are in advanced options on first screen after you click PROVISION.
    See for MEMORY_TARGET, and MEMORY_MAX_TARGET in template you will use for provision.
    Then review your TMPFS size.


  • 6.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:06:00 AM
    i didnt found it..could you send me the screen shot where i can found it.?


  • 7.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:11:00 AM



  • 8.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:12:00 AM
    how much i need to make memory target now..?
    presently Memory target=788529152


  • 9.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:13:00 AM
    i have allocated 2GB RAM to linux Target


  • 10.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?
    Best Answer

    Posted 05-11-2016 09:14:00 AM
    Prakash, Oracle XE only allows one instance to run on a server. You cannot provision a second running instance to the same server. Disable your Dev database instance first, then try to reprovision your QA instance.


  • 11.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:14:00 AM
    Yes, as you can see the MEMORY_TARGET has size apx 8g, so your /dev/shm fs need to be larger than 8g. Or simply use different template with smaller MEM size.


  • 12.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:17:00 AM
    how to use different template with smaller memory size..?
    Now i can't reduce the MEMORY_TARGRT..?
    if i reduce the MEMORY_TARGET does it work..?


  • 13.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:17:00 AM
    k Adam.


  • 14.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:20:00 AM
    First Oracle XE has limitation to single instance on box. Second you can select DEV Template during provision, which has smaller memory requirement.


  • 15.  RE: i am unable to create virtual copy in QA folder after creating virtual copy in DEV folder..?

    Posted 05-11-2016 09:28:00 AM
    now its provisioning..thank you Adam and Marcin:)