• We are, to both our benefit and disadvantage, creatures of habit. We tend to get stuck in our ways quite easily, and it takes a lot of work to change them. And we often don’t realize that these behaviors are getting in our own way when it comes to things like achieving our biggest goals.

    Success is quite a unanimously shared goal because we all want to be happy, secure, proud, and respected. But the path there is often loaded with hurdles. There are surely more than enough obstacles posed by the outside world, and you aren’t doing yourself any favors by getting in your own way, so click through to see all the things you should leave behind to propel yourself forward.

    A singular idea of success

    If you let other people define what success is, you’ll only be chasing after what they have. Instead, consider that some artists define success as completing and releasing their work, as opposed to it selling well. Some define success as being able to do what they love, and others want to hit a certain salary or see an idea through. Define what success means to you first and foremost.

    An unhealthy lifestyle

    Almost everything you want to achieve in life will depend on your health. Eat well and exercise, and you’ll have the right foundation to chase your dreams.

    Downplaying yourself

    Being humble is a wonderful quality that we should all maintain, but downplaying yourself so that others will feel better about themselves or because you’re afraid of seeming arrogant is definitely something you want to leave behind.

    Mindless scrolling

    This is a difficult one because social media apps are literally designed to keep you on them, mindlessly scrolling through an infinite feed, but they’re a huge time suck and they are completely demotivating, as so much of it relies on people showing off and comparing themselves to others.

    Short-term thinking

    Success involves having a vision and setting long-term goals. Short-term thinking can help start to establish successful habits, but, for example, if you only work out for the summer, it’s not sustainable in comparison to if you were working out because that’s part of who you are.

    Excuses

    There will always be a reason getting in the way of your success, but in order to achieve success it’s essential to take responsibility for all of your actions, despite the hand that life deals you.

    Excuses

    There will always be a reason getting in the way of your success, but in order to achieve success it’s essential to take responsibility for all of your actions, despite the hand that life deals you.

    A fixed mindset

    If the path you’re on isn’t leading you where you want to go, you have to be able to reroute. That could involve learning new skills or trying new methods.

    The need for control

    It’s important to make plans for the future, but it’s equally as important to allow room for life to happen—and to be prepared so that you’re ready to change your plans. Focusing on what you can actually control will save you a lot of energy.

    The dream of overnight success

    Even the people who seem to have overnight success were likely working towards their goals out of the spotlight for ages before making it. Just focus on the work you need to do, and a much more sturdy success will come when it’s time.

    Waiting for success to feel happy

    Success is a moving target, and so if you believe your happiness will only arrive when you achieve success, you’ll be unhappy for a long time. Focus on enjoying the journey and you won’t be so let down when the happiness you get from success inevitably fades or underwhelms you.

    Perfectionism

    The thing with perfectionism is that it isn’t attainable, so while sometimes it feels like you’re chasing success, you’re actually just running in the same spot. Don’t let perfectionism hold you back from getting yourself and your work out into the world.

    Fear of failure or rejection

    No one wants to fail, but it’s an inevitable part of everyone’s journey. It’s how you learn, and it’s why you must be resilient. We love to hear a good underdog story, but we’ll have to learn to live it!

    Multitasking

    This might sound like the opposite of what one might expect, but while multitasking can get a lot done, it also dilutes your efforts. Most successful people know the value in sticking to an idea, project, or task, and being fully present and committed to it.

    Other people’s expectations

    When we try to meet other people’s expectations, we set ourselves further back on our own unique paths to our own unique ideas of success. Seek to exceed others’ expectations by defying them completely.

    The need to be liked

    Wouldn’t it be nice if everyone adored you and believed in you? Unfortunately we don’t quite live in such utopia, and everyone has their own acquired taste. That’s totally natural and should actually encourage you to be as authentic as possible because you don’t need to appeal to the masses.

    The have-do-be paradigm

    Most people think they must have something (i.e. success) before they do something (write a book, start a business, etc.), which will allow them to be something (i.e. happy). But it should be reversed: first be something (happy), then do something from that healthy state, and then you’ll have the things you want (success).

    Toxic people

    Not only do they totally sap your energy, but they’ll want to hold you back from achieving your goals, sometimes because that’s easier than going after their own. You should surround yourself with people who are more successful than you.

    Saying “yes” to everything

    You have to be very selective with what you put on your plate if you truly want to achieve your goals. Most successful people say “no” to many tasks and activities from colleagues and even friends and family if they don’t align with their goals.

    Competition with peers

    We often strive for our goals under the myth that there is a limited amount of success available and we must compete with everyone else on the path, but that’s not actually true. This harmful capitalist-fed competition becomes a battle of who can slightly outdo the other for cheaper and cheaper until neither party is winning.

    Copying others

    The way to get ahead is really to be authentic, unique, and niche, to provide something novel that you can be an expert in and that shifts the focus away from competition and towards genuine quality work.

    Fear of criticism

    The sooner you embrace criticism, the sooner you’ll get to where you want to be. Praise, while it feels good, isn’t very constructive, whereas criticism is like free advice. Plus, when it’s not constructive, you’ll know that you’ve achieved enough success to have haters, which means you’re intimidating enough to evoke a response.

    Bingeing shows every weekend

    When you work hard all week, it can be easy to convince yourself that you “deserve” a weekend of escape into your favorite series. While it’s, of course, essential to take breaks, think of it this way: you deserve to have healthy restful habits that also contribute to your success.

    Not valuing what you have now

    Of course success depends upon wanting more, but knowing that what you have right now is enough will ensure that you’re acting out of a stable sense of self, and that when you do acquire more you won’t succumb to the endless suffering of always wanting more.

    Compartmentalizing your life

    Though our lives can feel more and more robotic these days, humans are intrinsically holistic beings that need all parts of life to be aligned so as to really succeed. Don’t neglect one part, like relationships for example, in favor of a career, because you’ll inevitably find that it will seep into your work and throw the balance off.

    Self-doubt

    Believing that something is too hard for you to achieve is putting a huge hurdle in front of yourself for no reason, giving you a disadvantage just for lack of an optimistic imagination. Plus, if you don’t believe in yourself, how will you get others to?

    Seeking permission

    You can’t wait for someone to give you permission to chase your dreams, because it won’t ever come. You have to give yourself permission to go against the grain and change your circumstances, no matter what people say.

    Reluctance to ask for help

    No good business is run by just one person. Instead, a good business person knows how to ask for help and when to delegate. Your personal success might seem like an individual task, but success almost necessarily depends on other people.

    Waiting

    Timing is important, and when it comes to things like selling your project, for example, it’s best not to be too early. But when it comes to starting, the answer is always now. You’re not behind, and it’s never too late.

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • If weblogic seems to load slow, or connecting to the nodemanager takes 4-5 mins, the issue may be with /dev/urandom

    Change $JAVA_HOME/jre/lib/security/java.security

    Replace
    securerandom.source=file:/dev/urandom
    with
    securerandom.source=file:/dev/./urandom

    Note that the /./ is needed.

    I know this seems odd, but it fixed the 5 min startup issue that we saw.

    I hope this helps.

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • (Original questions and answers are copy from narayanasetti’s blog)

    Q1) What is Weblogic server?
    A weblogic server is a instance of java process executing in a JVM.
    Weblogic server is a software application that runs as a middle tire between back-end database and related applications and browser based thin clients.
    Two Type of servers: 
    1. Administration server:
    2. Managed server:
    Every domain have one and only one admin server.
    It is the central point of control for the webLogic domain.
    It runs Weblogic admin console.

    Q3) What is a Managed server?

    A domain can have zero or more managed servers.
    All the applications are hosted in managed servers only.
    Admin server stores the master copy of the domain config. Each Managed server stores local copy of domain config.
    Managed server contacts the admin server while starting. So, to do any changes, we need to contact Admin server. Admin server will push those changes to Managed servers. We can start the managed server if admin server failed. But we cant do any changes in managed server if admin is failed(Stopped).

    Q4) What is a Domain?

    Logically related group of WebLogic server resources that are managed as a single unit.
    It is administrative boundary for all servers, admin server, managed Servers, clusters, applications, services etc.
    – Each domain must have its one Admin server.
    – Any given admin or managed server or cluster can belong to only one Domain.
    – Managed servers in a domain must run same WL server version and Admin server must have same or higher WL server version.

    Q5) What is a Cluster?

    A cluster is a logical group of WebLogic Servers Instances, acting together for high availability and load Balancing.
    All the servers in a cluster must be in same domain. All servers in a cluster must be same version level, though they can run on different machines.

    Q6) What is a Machine in Weblogic server?

    A computer that hosts the WL server instances.
    Used by node manager to restart a failed managed server.

    Q7) What is a Node Manager?

    -Node manager is a utility or process running on a physical server that enables starting, stopping,suspending or restarting admin and managed server remotely.
    -It is not associated with a domain, though can start any server that reside on same physical server.
    -it is required if we use Admin console to start servers.
    There is two  types of NM,
    1. java-based
    2. Script based.
    Q8)What are the Default port number for admin, node manager and ssl ?
    Default multicast address? Multicast range?
    Default port no for admin :7001
    ssl: 7002
    node manager: 5556
    Default multicast address :239.192.0.0
    range 224.0.0.0 to 239.255.255.255

    What is the Domain in Weblogic server?

    An Oracle WebLogic Server administration,
    Domain is a logically related group of Oracle WebLogic Server resources.
    Domains include a special Oracle WebLogic Server instance called the Administration Server, which is the central point from which you configure and manage all resources in the domain.
    Usually,you configure a domain to include additional Oracle WebLogic Server instances called managed Servers.

    Note:
    Domain is a logically related group of Oracle WebLogic Server resources that are managed as a single unit.

    Back up of existing domain

    Abhishek Porwal Simple way is to make tar File.

    Atchut Ram Gundu Use domain-builder.sh file under wlsserver directory which will create a template..

    Kumara Guruparan R You can take a template of the existing domain… Also config. XML can be backed up… Moreover the data on the server is backed up by tsm servers

    Gaguturi Kamalbee pack means copy the pack the domain and unpack means paste the domain to multiple server

    Mohammad Faisal Zakarneh pack used to ‘pack’ a domain or managed servers only of domain in a template file .. unpack then used to ‘unpack’ the package packed by pack  


    PACK Process 
    export PATH=/export/home/wlsuser/bea/weblogic92/common/bin:$PATH
    Syntax:
    pack -domain=domain -template=template -template_name=“template_name”
    [-template_author=“author”][-template_desc=“description”]
    [-managed={true|false}][-log=log_file] [-log_priority=log_priority]

    if it is in the pack command in the path you can give pack.sh from any directory otherwise you need to goto that path.
    Example

    bash-3.00$ pack.sh -domain=”/export/home/wlsuser/domains/wlscldom”
    -template=”/export/home/wlsuser/templates/wlscltemp.jar” -template_name=”WLS
    CLUSTER DOMAIN” -log=/export/home/wlsuser/logs/wlscldompack.log -log_priority=INFO

    UNPACK Process


    To run this we must already run the pack command on a domain which is already existing. The domain template jar must be copied to the destination machine.

    Syntax:
    unpack -template=template -domain=domain [-user_name=username]
    [-password=password] [-app_dir=application_directory]
    [-java_home=java_home_directory] [-server_start_mode={dev|prod}]
    [-log=log_file] [-log_priority=log_priority]

    Example

    bash-3.00$ unpack.sh -template=wlscltemp.jar -domain=domains/wlscldom
    -log=wlscldomunpack.log -log_priority=INFO

    ———————————————————————————————————————-
    To unpack managed server also it will work in the similar manner. But need to put the
    “-managed=true”

    Example:

    pack.sh -managed=true -domain="/home/wluser/domains/WLclsnm/" -template="/home/wluser/templates/WLclsnm.jar" -template_name="WLS CLUSTER DOMAIN" -log=/home/wluser/logs/wlscldompack.log -log_priority=INFO
    
    
    unpack.sh -template=WLclsnm.jar -domain=domains/WLclsnm -log=WLclsnmpack.log -log_priority=INFO

    8.      If two managed servers is there Same Domain is configured in both servers, but one server is crashed then how can you create a domain with the same configuration?

    Pack one domain and unpack it to the new server for the same domain.

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • No need to explain, everything are in those scripts:

    .bash_profile
    
    MW_HOME=/u00/app/orafmw2/Oracle/Middleware; export MW_HOME
    ORACLE_HOME=$MW_HOME/as_1; export ORACLE_HOME
    ORACLE_INSTANCE=$MW_HOME/asinst_1; export ORACLE_INSTANCE
    #
    FORMS_DOMAIN=$MW_HOME/user_projects/domains/forms_domain; export FORMS_DOMAIN
    FMW_DOMAIN=$MW_HOME/user_projects/domains/fmw_domain; export FMW_DOMAIN
    
    
    
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat runNodeManager.sh
    nohup /u01/app/as5d/Oracle/Middleware/wlserver_10.3/server/bin/startNodeManager.sh >> ./nodeManager_log.out 2>&1 &
    
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat runFMWAdmin.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/startWebLogic.sh -Dweblogic.system.StoreBootIdentity=true >> ./as5d_adminserver_log.out 2>&1 &
    ================
    [oraas5d@cal7-as5 ~]$ cat runFMWservers.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/startManagedWebLogic.sh soa_server1 >> ./soaserver1.log 2>&1 &
    sleep 30
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/startManagedWebLogic.sh bam_server1 >> ./bamserver1.log 2>&1 &
    sleep 30
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/startManagedWebLogic.sh osb_server1 >> ./osbserver1.log 2>&1 &
    
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat runFormsAdmin.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/forms_domain/bin/startWebLogic.sh -Dweblogic.system.StoreBootIdentity=true >> ./forms_adminserver_log.out 2>&1 &
    ================
    [oraas5d@cal7-as5 ~]$ cat runForms.sh
    USER_MEM_ARGS="-Xms1024m -Xmx1024m"
    export USER_MEM_ARGSnohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/forms_domain/bin/startManagedWebLogic.sh WLS_FORMS >> ./wls_forms.log 2>&1 &
    sleep 10
    /u01/app/as5d/Oracle/Middleware/asinst_1/bin/opmnctl startall
    sleep 10
    /u01/app/as5d/Oracle/Middleware/asinst_1/bin/opmnctl status
    
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat runBIAdmin.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/bip_domain/bin/startWebLogic.sh -Dweblogic.system.StoreBootIdentity=true >> ./bip_adminserver_log.out 2>&1 &
    ================
    [oraas5d@cal7-as5 ~]$ cat runBIservers.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/bip_domain/bin/startManagedWebLogic.sh bi_server1 >> ./bipserver1.log 2>&1 &
    
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat runOSRAdmin.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/svcreg_dev_domain/bin/startWebLogic.sh -Dweblogic.system.StoreBootIdentity=true >> ./osr_adminserver_log.out 2>&1 &
    =================
    [oraas5d@cal7-as5 ~]$ cat runOSR.sh
    nohup /u01/app/as5d/Oracle/Middleware/user_projects/domains/svcreg_dev_domain/bin/startManagedWebLogic.sh osr_server1 >> ./osrserver1.log 2>&1 &
    ====================================================================================
    ====================================================================================
    ====================================================================================
    ====================================================================================
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat stopFMWservers.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/stopManagedWebLogic.sh soa_server1 t3://cal7-as5.global.amec.com:6101
    sleep 30
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/stopManagedWebLogic.sh bam_server1 t3://cal7-as5.global.amec.com:6101
    sleep 30
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/stopManagedWebLogic.sh osb_server1 t3://cal7-as5.global.amec.com:6101
    ==================
    [oraas5d@cal7-as5 ~]$ cat stopFMWAdmin.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/as5d_domain/bin/stopWebLogic.sh weblogic redfox5D t3://cal7-as5.global.amec.com:6101 -force=ture
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat stopForms.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/forms_domain/bin/stopManagedWebLogic.sh WLS_FORMS t3://cal7-as5.global.amec.com:6901
    ==================
    [oraas5d@cal7-as5 ~]$ cat stopFormsAdmin.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/forms_domain/bin/stopWebLogic.sh weblogic redfox5D t3://cal7-as5.global.amec.com:6901 -force=ture
    ================
    [oraas5d@cal7-as5 ~]$ cat stopOHS.sh
    /u01/app/as5d/Oracle/Middleware/asinst_1/bin/opmnctl stopall
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat stopBIservers.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/bip_domain/bin/stopManagedWebLogic.sh bi_server1 t3://cal7-as5.global.amec.com:6901
    ==================
    [oraas5d@cal7-as5 ~]$ cat stopBIAdmin.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/bip_domain/bin/stopWebLogic.sh weblogic redfox5D t3://cal7-as5.global.amec.com:6901 -force=ture
    ====================================================================================
    [oraas5d@cal7-as5 ~]$ cat stopOSRAdmin.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/svcreg_dev_domain/bin/stopWebLogic.sh weblogic redfox5D t3://cal7-as5.global.amec.com:6601 -force=ture
    ===================
    [oraas5d@cal7-as5 ~]$ cat stopOSR.sh
    /u01/app/as5d/Oracle/Middleware/user_projects/domains/svcreg_dev_domain/bin/stopManagedWebLogic.sh osr_server1 t3://cal7-as5.global.amec.com:6601
    =====================================================================================
    [oraas5d@cal7-as5 ~]$ cat runNodeManager.sh
    nohup /u01/app/as5d/Oracle/Middleware/wlserver_10.3/server/bin/startNodeManager.sh >> ./nodeManager_log.out 2>&1 &
    
    
    [oraas5d@cal7-as5 ~]$ cat stopNodeManager.sh
    export x=`ps -ef|grep -i jrockit|grep  NodeManager|grep -v AdminServer|awk '{print $2}'`
    kill -9 $x
    echo $x ' - NodeManager is killed'
    ==================
    ==================
    ==================
    vi $ORACLE_INSTANCE/config/WebCache/webcache1/webcache.xml
          
    
          <EVENTLOGDIR 
    	  
    

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • After you installed the Oracle 11gR2 on Linux 7 machine, you start the EM console, and can open it from local server web browser (Firefox). But you don’t like it because that’s firefox plus you have to login to server. You believe DB console is an web service, it should be able to be accessed from any device on same network.

    But the truth is NO by default. The port number 1158 which used by EM console are blocked by firewall on this Linux 7 box. You have to do following steps to open the port 1158 in order to access EM console from remote machine:

     

    Edit /etc/sysconfig/iptables, add one new line to active port 1158:

    [root@ol7 sysconfig]# vi iptables
    
    ... ... ...
    -A INPUT -i lo -j ACCEPT
    -A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
    -A INPUT -p tcp -m state --state NEW -m tcp --dport 1158 -j ACCEPT
    -A INPUT -j REJECT --reject-with icmp-host-prohibited
    -A FORWARD -j REJECT --reject-with icmp-host-prohibited
    

    Restart iptables service:

    [root@ol7 sysconfig]# service iptables restart
    

    Now you can use following link to remotely access EM Console from you be loved browser.

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • following output is based on the RMAN sctipt used by my following post:

    Setup Standby Instance on same host – Oracle 11gR2 / OEL7_64bit

    [oraadmin@ol7 work]$ rman target sys/oraadmin@ora11g auxiliary sys/oraadmin@ora11gsd
    
    Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 15 15:33:57 2015
    
    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
    
    connected to target database: ORA11G (DBID=4278207140)
    connected to auxiliary database: ORA11GSD (not mounted)
    
    RMAN> @dup.sql
    
    RMAN> run {
    2> allocate channel prmy1 type disk;
    3> allocate channel prmy2 type disk;
    4> allocate channel prmy3 type disk;
    5> allocate channel prmy4 type disk;
    6> allocate auxiliary channel stby type disk;
    7> duplicate target database for standby from active database spfile parameter_value_convert 'ORA11G','ORA11GSD'
    8> set db_unique_name='ORA11GSD'
    9> set db_file_name_convert='/u01/app/oracle/oradata/ORA11G/','/u01/app/oracle/oradata/ORA11GSD/'
    10> set log_file_name_convert='/ORA11G/','/ORA11GSD/'
    11> set control_files='/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl','/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl','/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'
    12> set log_archive_max_processes='5'
    13> set fal_client='ORA11GSD'
    14> set fal_server='ORA11G'
    15> set standby_file_management='AUTO'
    16> set log_archive_config='dg_config=(ORA11G,ORA11GSD)'
    17> set log_archive_dest_1='service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD';
    18>
    19> }
    using target database control file instead of recovery catalog
    allocated channel: prmy1
    channel prmy1: SID=17 device type=DISK
    
    allocated channel: prmy2
    channel prmy2: SID=142 device type=DISK
    
    allocated channel: prmy3
    channel prmy3: SID=16 device type=DISK
    
    allocated channel: prmy4
    channel prmy4: SID=146 device type=DISK
    
    allocated channel: stby
    channel stby: SID=134 device type=DISK
    
    Starting Duplicate Db at 15-JUN-15
    
    contents of Memory Script:
    {
    backup as copy reuse
    targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11G' auxiliary format
    '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11GSD' targetfile
    '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11G.ora' auxiliary format
    '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11GSD.ora' ;
    sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11GSD.ora''";
    }
    executing Memory Script
    
    Starting backup at 15-JUN-15
    Finished backup at 15-JUN-15
    
    sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11GSD.ora''
    
    contents of Memory Script:
    {
    sql clone "alter system set audit_file_dest =
    ''/u01/app/oracle/admin/ORA11GSD/adump'' comment=
    '''' scope=spfile";
    sql clone "alter system set dispatchers =
    ''(PROTOCOL=TCP) (SERVICE=ORA11GSDXDB)'' comment=
    '''' scope=spfile";
    sql clone "alter system set db_unique_name =
    ''ORA11GSD'' comment=
    '''' scope=spfile";
    sql clone "alter system set db_file_name_convert =
    ''/u01/app/oracle/oradata/ORA11G/'', ''/u01/app/oracle/oradata/ORA11GSD/'' comment=
    '''' scope=spfile";
    sql clone "alter system set log_file_name_convert =
    ''/ORA11G/'', ''/ORA11GSD/'' comment=
    '''' scope=spfile";
    sql clone "alter system set control_files =
    ''/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl'', ''/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl'', ''/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'' comment=
    '''' scope=spfile";
    sql clone "alter system set log_archive_max_processes =
    5 comment=
    '''' scope=spfile";
    sql clone "alter system set fal_client =
    ''ORA11GSD'' comment=
    '''' scope=spfile";
    sql clone "alter system set fal_server =
    ''ORA11G'' comment=
    '''' scope=spfile";
    sql clone "alter system set standby_file_management =
    ''AUTO'' comment=
    '''' scope=spfile";
    sql clone "alter system set log_archive_config =
    ''dg_config=(ORA11G,ORA11GSD)'' comment=
    '''' scope=spfile";
    sql clone "alter system set log_archive_dest_1 =
    ''service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD'' comment=
    '''' scope=spfile";
    shutdown clone immediate;
    startup clone nomount;
    }
    executing Memory Script
    
    sql statement: alter system set audit_file_dest = ''/u01/app/oracle/admin/ORA11GSD/adump'' comment= '''' scope=spfile
    
    sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=ORA11GSDXDB)'' comment= '''' scope=spfile
    
    sql statement: alter system set db_unique_name = ''ORA11GSD'' comment= '''' scope=spfile
    
    sql statement: alter system set db_file_name_convert = ''/u01/app/oracle/oradata/ORA11G/'', ''/u01/app/oracle/oradata/ORA11GSD/'' comment= '''' scope=spfile
    
    sql statement: alter system set log_file_name_convert = ''/ORA11G/'', ''/ORA11GSD/'' comment= '''' scope=spfile
    
    sql statement: alter system set control_files = ''/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl'', ''/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl'', ''/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'' comment= '''' scope=spfile
    
    sql statement: alter system set log_archive_max_processes = 5 comment= '''' scope=spfile
    
    sql statement: alter system set fal_client = ''ORA11GSD'' comment= '''' scope=spfile
    
    sql statement: alter system set fal_server = ''ORA11G'' comment= '''' scope=spfile
    
    sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile
    
    sql statement: alter system set log_archive_config = ''dg_config=(ORA11G,ORA11GSD)'' comment= '''' scope=spfile
    
    sql statement: alter system set log_archive_dest_1 = ''service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD'' comment= '''' scope=spfile
    
    Oracle instance shut down
    
    connected to auxiliary database (not started)
    Oracle instance started
    
    Total System Global Area 1453092864 bytes
    
    Fixed Size 2253304 bytes
    Variable Size 905973256 bytes
    Database Buffers 536870912 bytes
    Redo Buffers 7995392 bytes
    allocated channel: stby
    channel stby: SID=133 device type=DISK
    
    contents of Memory Script:
    {
    backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl';
    restore clone controlfile to '/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl' from
    '/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl';
    restore clone controlfile to '/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl' from
    '/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl';
    }
    executing Memory Script
    
    Starting backup at 15-JUN-15
    channel prmy1: starting datafile copy
    copying standby control file
    output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_ORA11G.f tag=TAG20150615T153429 RECID=3 STAMP=882459270
    channel prmy1: datafile copy complete, elapsed time: 00:00:03
    Finished backup at 15-JUN-15
    
    Starting restore at 15-JUN-15
    
    channel stby: copied control file copy
    Finished restore at 15-JUN-15
    
    Starting restore at 15-JUN-15
    
    channel stby: copied control file copy
    Finished restore at 15-JUN-15
    
    contents of Memory Script:
    {
    sql clone 'alter database mount standby database';
    }
    executing Memory Script
    
    sql statement: alter database mount standby database
    
    contents of Memory Script:
    {
    set newname for tempfile 1 to
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_temp_bqjqmo79_.tmp";
    switch clone tempfile all;
    set newname for datafile 1 to
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf";
    set newname for datafile 2 to
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf";
    set newname for datafile 3 to
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf";
    set newname for datafile 4 to
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf";
    set newname for datafile 5 to
    "/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf";
    backup as copy reuse
    datafile 1 auxiliary format
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf" datafile
    2 auxiliary format
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf" datafile
    3 auxiliary format
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf" datafile
    4 auxiliary format
    "/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf" datafile
    5 auxiliary format
    "/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf" ;
    sql 'alter system archive log current';
    }
    executing Memory Script
    
    executing command: SET NEWNAME
    
    renamed tempfile 1 to /u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_temp_bqjqmo79_.tmp in control file
    
    executing command: SET NEWNAME
    
    executing command: SET NEWNAME
    
    executing command: SET NEWNAME
    
    executing command: SET NEWNAME
    
    executing command: SET NEWNAME
    
    Starting backup at 15-JUN-15
    channel prmy1: starting datafile copy
    input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_system_bqjqlhlm_.dbf
    channel prmy2: starting datafile copy
    input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_sysaux_bqjqlzq8_.dbf
    channel prmy3: starting datafile copy
    input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf
    channel prmy4: starting datafile copy
    input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11G/datafile/example_01.dbf
    output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf tag=TAG20150615T153445
    channel prmy1: datafile copy complete, elapsed time: 00:00:35
    channel prmy1: starting datafile copy
    input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_users_bqjqnhqv_.dbf
    output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf tag=TAG20150615T153445
    channel prmy4: datafile copy complete, elapsed time: 00:00:51
    output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf tag=TAG20150615T153445
    channel prmy1: datafile copy complete, elapsed time: 00:00:26
    output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf tag=TAG20150615T153445
    channel prmy2: datafile copy complete, elapsed time: 00:01:17
    output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf tag=TAG20150615T153445
    channel prmy3: datafile copy complete, elapsed time: 00:01:17
    Finished backup at 15-JUN-15
    
    sql statement: alter system archive log current
    
    contents of Memory Script:
    {
    switch clone datafile all;
    }
    executing Memory Script
    
    datafile 1 switched to datafile copy
    input datafile copy RECID=3 STAMP=882459366 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf
    datafile 2 switched to datafile copy
    input datafile copy RECID=4 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf
    datafile 3 switched to datafile copy
    input datafile copy RECID=5 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf
    datafile 4 switched to datafile copy
    input datafile copy RECID=6 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf
    datafile 5 switched to datafile copy
    input datafile copy RECID=7 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf
    Finished Duplicate Db at 15-JUN-15
    released channel: prmy1
    released channel: prmy2
    released channel: prmy3
    released channel: prmy4
    released channel: stby
    
    RMAN> **end-of-file**
    
    RMAN>
    

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • Please see following article:

    How to create Physical Standby on the same host for testing purposes (Linux + ORACLE 11.2)

    Following is my steps:

    Standby Database can be reside on same host (with same Oracle software installation) with primary database. For this configuration, you have to give standby database a different DB_NAME and DB_UNIQUE_NAME.

    Assumption:

    One Oracle Database Software 11.2.0.4 Linux 64bit installation on host ol7.localdomain
    Primary instance created and DB_NAME=ORA11G, DB_UNIQUE_NAME=ORA11G

    [oraadmin@ol7 oracle]$ hostname
    ol7.localdomain
    [oraadmin@ol7 oracle]$ env|grep ORACLE
    ORACLE_UNQNAME=ORA11G
    ORACLE_SID=ORA11G
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOSTNAME=ol7.localdomain
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
    

    Switch force_logging to YES if not enabled yet:

    SQL> select force_logging from v$database;
    FOR
    ---
    NO
    SQL> alter database force logging;
    Database altered.
    SQL> select force_logging from v$database;
    FOR
    ---
    YES
    

    Configure the standby redo logs on the primary database with the same size

    SQL> select GROUP#, trunc(bytes/1024/1024,3) Mbytes from v$log;
    
    GROUP# MBYTES
    ---------- ----------
    1 50
    2 50
    3 50
    
    SQL> alter database add standby logfile
    2 ('/u01/app/oracle/HA/redolog1/ORA11G/onlinelog/sdyredo1a.log',
    3 '/u01/app/oracle/HA/redolog2/ORA11G/onlinelog/sdyredo2a.log',
    4 '/u01/app/oracle/HA/redolog3/ORA11G/onlinelog/sdyredo3a.log') size 50M;
    
    Database altered.
    
    SQL> alter database add standby logfile
    2 ('/u01/app/oracle/HA/redolog1/ORA11G/onlinelog/sdyredo1b.log',
    3 '/u01/app/oracle/HA/redolog2/ORA11G/onlinelog/sdyredo2b.log',
    4 '/u01/app/oracle/HA/redolog3/ORA11G/onlinelog/sdyredo3b.log') size 50M;
    
    Database altered.
    
    SQL> alter database add standby logfile
    2 ('/u01/app/oracle/HA/redolog1/ORA11G/onlinelog/sdyredo1c.log',
    3 '/u01/app/oracle/HA/redolog2/ORA11G/onlinelog/sdyredo2c.log',
    4 '/u01/app/oracle/HA/redolog3/ORA11G/onlinelog/sdyredo3c.log') size 50M;
    
    Database altered.
    

    Set LOG_ARCHIVE_CONFIG and LOG_ARCHIVE_FILE_DEST parameters on the primary database:

    SQL> select * from v$dataguard_config;
    
    DB_UNIQUE_NAME
    ------------------------------
    ORA11G
    
    SQL> alter system set log_archive_config='dg_config=(ORA11G,ORA11GSDY)';
    
    System altered.
    
    SQL> select * from v$dataguard_config;
    
    DB_UNIQUE_NAME
    ------------------------------
    ORA11G
    ORA11GSD
    
    SQL> alter system set log_archive_dest_1='SERVICE=ORA11GSDY
    2 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
    3 DB_UNIQUE_NAME=ORA11GSDY';
    
    System altered.
    
    SQL> show parameter log_archive_dest_1
    
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_1 string SERVICE=ORA11GSD
    VALID_FOR=(ONLINE_LOGFILES,PRI
    MARY_ROLE)
    DB_UNIQUE_NAME=ORA11GSD
    

    revert DB_RECOVERY_FILE_DEST as archive log destination:

    SQL> alter system set log_archive_dest_10=
    2 'LOCATION=USE_DB_RECOVERY_FILE_DEST';
    
    System altered.
    
    SQL> sho parameter log_archive_dest_10
    
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_10 string LOCATION=USE_DB_RECOVERY_FILE_
    DEST
    

    Configure ARCHIVELOG for primary database and enable automatic archiving:

    SQL> select log_mode from v$database;
    
    LOG_MODE
    ------------
    NOARCHIVELOG
    
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup mount;
    ORACLE instance started.
    
    Total System Global Area 1453092864 bytes
    Fixed Size 2253304 bytes
    Variable Size 872418824 bytes
    Database Buffers 570425344 bytes
    Redo Buffers 7995392 bytes
    Database mounted.
    SQL> alter database archivelog;
    
    Database altered.
    
    SQL> alter database open;
    
    Database altered.
    
    SQL> select log_mode from v$database;
    
    LOG_MODE
    ------------
    ARCHIVELOG
    

    Perform a whole database backup including archived redo log files using RMAN:

    [oraadmin@ol7 schema]$ rman target /
    
    Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 12 13:47:39 2015
    
    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
    
    connected to target database: ORA11G (DBID=4278207140)
    
    RMAN> backup database plus archivelog delete all input;
    ... ... ...
    Finished backup at 12-JUN-15
    RMAN>
    

    Prepare listener.ora and tnsname.ora for standby database:

    $ORACLE_HOME/network/admin/tnsnames.ora
    ORA11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol7.localdomain)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORA11G.localdomain) ) ) LISTENER_ORA11G = (ADDRESS = (PROTOCOL = TCP)(HOST = ol7.localdomain)(PORT = 1525)) ORA11GSDY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol7.localdomain)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORA11GSDY.localdomain) ) )
    
    $ORACLE_HOME/network/admin/listener.ora
    # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. ADR_BASE_LISTENER_ORA11G = /u01/app/oracle SID_LIST_LISTENER_ORA11G = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (PROGRAM = extproc) ) (SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = ORA11G) ) (SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = ORA11GSDY) ) ) LISTENER_ORA11G = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol7.localdomain)(PORT = 1525)) ) )
    

    Create new password file for the Standby database (or copy it from Primary)

    [oraadmin@ol7 admin]$ cd $ORACLE_HOME/dbs
    [oraadmin@ol7 dbs]$ ls
    hc_ORA11G.dat init.ora lkORA11G orapwORA11G snapcf_ORA11G.f spfileORA11G.ora
    [oraadmin@ol7 dbs]$ cp orapwORA11G orapwORA11GSDY
    
    Create some directories for Standby DB:
    
    [oraadmin@ol7 admin]$ cd $ORACLE_BASE/admin
    [oraadmin@ol7 admin]$ ls
    ORA11G
    [oraadmin@ol7 admin]$ mkdir -p ORA11GSDY/adump
    [oraadmin@ol7 admin]$ cd $ORACLE_BASE/oradata
    [oraadmin@ol7 oradata]$ ls
    ORA11G
    [oraadmin@ol7 oradata]$ mkdir ORA11GSDY
    [oraadmin@ol7 oradata]$ ls
    ORA11G ORA11GSDY
    

    From sqlplus on the Primary database perform next statement for initfile creation:

    [oraadmin@ol7 dbs]$ cd $ORACLE_HOME/dbs
    [oraadmin@ol7 dbs]$ ls
    hc_ORA11G.dat init.ora lkORA11G orapwORA11G orapwORA11GSDY snapcf_ORA11G.f spfileORA11G.ora
    [oraadmin@ol7 dbs]$ sqlplus / as sysdba
    
    SQL> create pfile from spfile;
    
    File created.
    
    SQL> exit
    [oraadmin@ol7 dbs]$ ls
    hc_ORA11G.dat initORA11G.ora orapwORA11G snapcf_ORA11G.f
    init.ora lkORA11G orapwORA11GSD spfileORA11G.ora
    
    [oraadmin@ol7 dbs]$ cp initORA11G.ora initORA11GSD.ora
    

    And configure initORA11GSD.ora like below:

    ORA11G.__db_cache_size=503316480
    ORA11G.__java_pool_size=16777216
    ORA11G.__large_pool_size=33554432
    ORA11G.__oracle_base='/u01/app/oracle'
    ORA11G.__pga_aggregate_target=520093696
    ORA11G.__sga_target=939524096
    ORA11G.__shared_io_pool_size=117440512
    ORA11G.__shared_pool_size=234881024
    ORA11G.__streams_pool_size=16777216
    *.audit_file_dest='/u01/app/oracle/admin/ORA11GSD/adump'
    *.audit_trail='db'
    *.compatible='11.2.0.4.0'
    *.control_files='/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/o1_mf_bqjql4mj_.ctl','/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/o1_mf_bqjql4ts_.ctl','/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/o1_mf_bqjql52b_.ctl'
    *.db_block_size=8192
    *.db_create_file_dest='/u01/app/oracle/oradata'
    *.db_create_online_log_dest_1='/u01/app/oracle/HA/redolog1'
    *.db_create_online_log_dest_2='/u01/app/oracle/HA/redolog2'
    *.db_create_online_log_dest_3='/u01/app/oracle/HA/redolog3'
    *.db_domain='localdomain'
    *.db_name='ORA11GSD'
    *.db_recovery_file_dest='/u01/app/oracle/HA/fast_recovery_area'
    *.db_recovery_file_dest_size=5218762752
    *.diagnostic_dest='/u01/app/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA11GXDB)'
    *.local_listener='LISTENER'
    *.log_archive_config='dg_config=(ORA11G,ORA11GSD)'
    # *.log_archive_dest_1='SERVICE=ORA11G ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=ORA11GSD'
    *.log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST'
    *.memory_target=1443889152
    *.open_cursors=300
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.undo_tablespace='UNDOTBS1'
    

    Start Standby database using new pfile:

    If you get error “ORA-00845: MEMORY_TARGET not supported on this system“, then refer to following this article.

    Start Standby database. Please note, you have to start standby database by using pfile, not spfile which hasn’t been created yet:

    [oraadmin@ol7 dbs]$ sqlplus sys/oraadmin@ora11gsd as sysdba;
    
    SQL> startup nomount pfile='initORA11GSD.ora'
    

    Invoke RMAN to connect target database (Primary DB) and auxiliary database (standby DB):

    [oraadmin@ol7 dbs]$ rman target sys/oraadmin@ora11g ausiliary sys/oraadmin@ora11gsd
    

    and run following script dup.sql

    run {
    allocate channel prmy1 type disk;
    allocate channel prmy2 type disk;
    allocate channel prmy3 type disk;
    allocate channel prmy4 type disk;
    allocate auxiliary channel stby type disk;
    duplicate target database for standby from active database spfile parameter_value_convert 'ORA11G','ORA11GSD'
    set db_unique_name='ORA11GSD'
    set db_file_name_convert='/u01/app/oracle/oradata/ORA11G/','/u01/app/oracle/oradata/ORA11GSD/'
    set log_file_name_convert='/ORA11G/','/ORA11GSD/'
    set control_files='/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl','/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl','/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'
    set log_archive_max_processes='5'
    set fal_client='ORA11GSD'
    set fal_server='ORA11G'
    set standby_file_management='AUTO'
    set log_archive_config='dg_config=(ORA11G,ORA11GSD)'
    set log_archive_dest_1='service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD';
    
    }
    

    If you see following ORA-17628 error:

    executing Memory Script
    
    sql statement: alter system set control_files = ''/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/o1_mf_bqjql4mj_.ctl'', ''/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/o1_mf_bqjql4ts_.ctl'', ''/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/o1_mf_bqjql52b_.ctl'' comment= ''Set by RMAN'' scope=spfile
    
    Starting backup at 15-JUN-15
    channel prmy1: starting datafile copy
    copying standby control file
    released channel: prmy1
    released channel: prmy2
    released channel: prmy3
    released channel: prmy4
    released channel: stby
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of Duplicate Db command at 06/15/2015 15:28:16
    RMAN-05501: aborting duplication of target database
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-03009: failure of backup command on prmy1 channel at 06/15/2015 15:28:16
    ORA-17628: Oracle error 19505 returned by remote Oracle server
    
    RMAN> **end-of-file**
    

    This may because you didn’t create directory “/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile” (and also redolog2,redolog3 directories) to host control files yet. Create directory, rerun the scripts, error should be gone. Please also note, when you try to re-run this RMAN script to duplicate database, you may need to remove spfile, restart standby database using pfile again,  if the spfile already been created and used by standby database by this RMAN script.

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

  • Tip 1:

    What to do if you missed 32bit package only on 64bit OS?

    [root@ol7 ~]# rpm -qa|grep -i libstdc++
    libstdc++-devel-4.8.3-9.el7.x86_64
    libstdc++-4.8.3-9.el7.i686
    compat-libstdc++-33-3.2.3-72.el7.x86_64
    libstdc++-4.8.3-9.el7.x86_64
    compat-libstdc++-33-3.2.3-72.el7.i686

    You can see you missed libstdc++-devel-4.8.3-9.el7.i686./n
    Here is simply way to do it:

    [root@ol7 ~]# yum install libstdc++-devel

    double hit “tab” button, you will see an “.i686” automatically appended. See? you don’t need to enter full package name and you can get it installed.

    Enjoy!

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶

    ¶¶¶¶¶