About Me.

My self Adinarayana working as Implementation Application DBA with advanced technologies like RAC/PCP,OID/SSO,DMZ,Exadata and Fusion Middleware i.e Demantra,Application Server,SOA,FMW,BPEL and UPK. Created this blog to share the useful information related to DBA and Application DBA Your comments and suggestions are most welcome. Disclaimer: Please note all the views and opinions expressed in this site are my own. It's not recommend to use the fixes/suggestions provided in this site directly in production instance, please test them before implementing.

Monday, July 24, 2023

Weblogic user new password update process for versions earlier than TKX DELTA 7

 1) Log in to the Oracle WebLogic Server Administration console at http://<server>.<domain>:<wls_admin_port>/console <http://<server>.<domain>:<wls_admin_port>/console> <http://<server>.<domain>:<wls_admin_port>/console> with the current username and password.

2) Choose the Lock and Edit button.

3) Click on 'EBS_domain_<SID>' under the Domain Structure section.

4) Select the Security tab.

5) Select Advanced.

6) Enter the new Node Manager password.

7) Choose the Save button and then the Activate Changes button.

8) Choose the 'Security Realms' link on the Oracle E-Business Suite 12.2 domain configuration, and then select the 'myrealm' link.

9) Select the Users and Groups tab and choose the 'weblogic' link.

10) Select the Passwords tab and enter the same password you entered in Step 6.

11) Choose the Save button

12) Back up the following files:

$FMW_HOME/user_projects/domains/EBS_domain_<SID>/servers/AdminServer/security/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_<SID>/servers/forms-c4ws_server1/data/nodemanager/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_<SID>/servers/forms_server1/data/nodemanager/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_<SID>/servers/oacore_server1/data/nodemanager/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_<ID>/servers/oafm_server1/data/nodemanager/boot.properties

13) Use a text editor to edit each of the above files and change the password to the new password.

Note:After the services are restarted in the next step, the password you entered will be obfuscated (not human readable)

14) Stop and restart all application tier services using the adstpall.sh and adstrtall.sh scripts

15) Ensure all services start successfully, and then test the Oracle WebLogic Server console login and Oracle E-Business Suite login

 iii. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services.

 Change the "apps" password in WLS Datasource as follows:

===========================================================

i. Log in to WLS Administration Console.

ii. Click Lock & Edit in Change Center.

iii. In the Domain Structure tree, expand Services, then select Data Sources.

iV. On the "Summary of JDBC Data Sources" page, select EBSDataSource.

V. On the "Settings for EBSDataSource" page, select the Connection Pool tab.

Vi. Enter the new password in the "Password" field.

Vii. Enter the new password in the "Confirm Password" field.

VIII. Click Save.

ix. Click Activate Changes in Change Center.

Step 16: Start MT Services

Step 17: Post Health Checks

Step 18: Run fs clone


EBS 12.2 adop -examples

 adop -examples

Applications DBA Online Patching Tool (adop)

See Oracle E-Business Suite Maintenance Guide for a full description of

adop features, operation, and usage.

Standard Online Patching Cycle:

    In Oracle E-Business Suite Release 12.2, patches are normally applied

    using an online patching cycle.  The online patching cycle consists of

    five phases which are executed in order.

    Example - Typical online patching cycle:

        source <ebs_root>/EBSapps.env run

        adop phase=prepare

        adop phase=apply patches=123456

        adop phase=finalize

        adop phase=cutover

        source <ebs_root>/EBSapps.env run

        adop phase=cleanup

    Note that after cutover the command line environment should be re-loaded

    as the run edition file system has changed.

    In a multi-node deployment, adop commands are only executed from the

    primary node.  The primary adop session uses remote execution to

    automatically perform required actions on any secondary node.

    Multiple phases can be executed in a single adop command.

    Example - combined finalize/cutover/cleanup:

        adop phase=finalize,cutover,cleanup

    Prior to cutover, it is possible to execute additional

    "apply" and "finalize" phases as needed.

    Example - applying multiple patches using separate apply commands:

        source <ebs_root>/EBSapps.env run

        adop phase=prepare

        adop phase=apply patches=123456

        adop phase=apply patches=223456

        adop phase=finalize

        adop phase=apply patches=323456

        adop phase=finalize

        adop phase=cutover

        source <ebs_root>/EBSapps.env run

        adop phase=cleanup

    Note that it is possible to apply additional patches after running the

    finalize phase, but if you do so then you will need to run the finalize

    phase again.  Finalize must always be run immediately prior to cutover.

General parameters applicable to all phases:

    workers=<number>  [default: computed]

        Number of parallel workers used to execute tasks.  Default value is

        computed principally according to number of available CPU cores.

        Example:

            adop phase=prepare workers=8

        The example command executes the prepare phase with 8 parallel workers.

        Not all processing can be executed with parallel workers, and in such

        cases the workers parameter is ignored.  In multi-node systems the

        workers parameter indicates workers per node.

    input_file=<file_name>

        As well as being entered directly on the command line, adop parameters

        can be specified in a text file, with one

            <parameter>=<value>

        on each line of the file.  Command line parameters override input file

        parameters.

        Example - Input File text "empty_cycle.txt" for empty patching cycle:

            phase=prepare,finalize,cutover,cleanup

            workers=4

            loglevel=statement

        Example - Use input file to execute empty patching cycle:

            adop input_file=empty_cycle.txt workers=1

        The example command will execute an empty patching cycle with a

        single worker and maximum log detail.

    loglevel=(statement|procedure|event|warning|error|unexpected)

        [default: event]

        Controls the level of diagnostic log detail displayed on the

        console output.  Each log message is tagged with a level:

            1) statement  - internal debugging messages

            2) procedure  - internal procedure begin/end messages

            3) event      - significant processing action

            4) warning    - important user message or possible problem

            5) error      - a patching action has failed, processing continues

            6) unexpected - a critical action has failed, processing halted

        Setting loglevel will display messages at that level and higher.

        Example - Display full log details:

            adop phase=prepare loglevel=statement

        Example - Display only warnings and errors:

            adop phase=prepare loglevel=warning

    prompt=(yes|no)  [default: yes]

        Specifies whether adop should prompt for user input on warnings.

        By default adop will ask user whether to continue or exit on

        some warning messages.  If this parameter is set to "no" adop

        will remain fully non-interactive, and will continue past any

        warning messages without user confirmation.

        Example - Disable user prompt for warnings:

            adop phase=cutover prompt=no

Diagnostic Parameters, normally not used unless directed by Support:

    allowcoredump=(yes|no)  [default: no]

        Specifies whether adop should create a core dump if it crashes.  This

        option should only be used if directed by support.

        Example - Enable writing of core dump files:

            adop phase=cutover allowcoredump=yes

    analytics=(yes|no)  [default: no]

        Controls whether adop writes additional reports with information

        that might be helpful in some diagnostic situations.  This option

        should not be used unless directed by Support.

        Example - Enable additional analytic reports

            adop phase=finalize analytics=yes

    defaultsfile=<file_name>  [default: adalldefaults.txt]

        Name of the response file providing default parameter values for

        non-interactive execution of adadmin and adop.  The file must be in

        the $APPL_TOP/admin/$TWO_TASK directory in both run edition and patch

        edition file systems.  The default file "adalldefaults.txt" is

        maintained by AutoConfig and normally you should not need to change

        any values.

        Example - Using a custom AD Defaults file:

            adop phase=apply defaultsfile=adcustomdefaults.txt

Prepare Parameters:

    skipsyncerror=(yes|no)  [default: no]

        Specifies whether to ignore errors that may occur during incremental

        file system synchronization.  This might happen if you applied

        a patch in the previous patching cycle that had errors but decided

        to continue with the cutover.  When the patch is synchronized on

        the next patching cycle, the apply errors may occur again, but

        can be ignored.

    sync_mode=(delta|patch) [default: patch]

        Specifies the method used to synchronize the patch file system

        with the run file system.

        'delta' mode uses the file system synchronization command

        specified in $AD_TOP/patch/115/etc/delta_sync_drv.txt.

        'patch' mode reapplies the patches that were applied on

        the run file system.

        Example:

            adop phase=prepare skipsyncerror=yes sync_mode=delta

        Note: sync_mode has been deprecated and replaced with prepare_sync_mode

        (for prepare phase) and fs_clone_sync_mode (for prepare and fs_clone

        phases).

    prepare_sync_mode=(patch|delta) [default:patch]

        Specifies the method used to synchronize the patch file system

        with the run file system.

        This parameter replaces sync_mode, which has been deprecated.

        'delta' mode uses the file system synchronization command

        specified in $APPL_TOP_NE/ad/admin/delta_sync_drv.txt.

        'patch' mode reapplies the patches that were applied on

        the run file system.

        Example:

            adop phase=prepare prepare_sync_mode=patch

            adop phase=prepare prepare_sync_mode=patch fs_clone_sync_mode=cp

    fs_clone_sync_mode=(cp|delta) [default:cp]

        Specifies the method used to synchronize the patch file system

        with the run file system.

        This parameter replaces sync_mode, which has been deprecated.

        'delta' mode uses the file system synchronization command

        specified in $APPL_TOP_NE/ad/admin/delta_sync_drv.txt.

        'cp' mode creates the complete patch file system from run file system.

        Example:

            adop phase=prepare fs_clone_sync_mode=cp

            adop phase=prepare prepare_sync_mode=patch fs_clone_sync_mode=cp

Apply Parameters:

    apply=(yes|no)  [default: yes]

        Controls whether adop actually applies the patch.  You can specify

        "apply=no" to run adop in test mode, where the patch will not actually

        be applied, and adop will record what it would have done in the log.

        Example - Execute adop apply in test mode:

            adop phase=apply apply=no patches=1234

    patches=<patch#>[,<patch#>...]

    patches=<patch_directory>:<driver>[,<patch_directory>:<driver>...]

        This parameter specifies a comma-separated list of patches to be

        applied.  Patches can be specified either as the patch number or

        by the patch directory and driver file.  All patches are expected

        to be in the $PATCH_TOP directory on all tiers.  Patches are applied

        serially unless the merge=yes parameter is specified.

        Example - Apply two patches in series:

            adop phase=apply patches=1234,5678

        Example - Apply patch and its translation:

            adop phase=apply patches=1012464,10124646_AR:u10124646.drv

    patchtop=<directory_name>  [default: $PATCH_TOP]

        Path to a user-specified directory where patches are unzipped.

        The default and recommend location is the $PATCH_TOP directory

        automatically created by the install.  When using an alternate

        patchtop you must ensure that the location is not within the

        editioned file systems (fs1, fs2) and is accessible by the same

        path for all nodes of a multi-node deployment.

        Example - Apply patch from alternate patchtop directory:

            adop phase=apply patches=123456 patchtop=/install/patches

    apply_mode=(online|downtime|hotpatch)  [default: online]

        Use online mode to apply a patch to the patch edition during an

        online patching cycle; downtime mode to apply a patch to the

        run edition when application services are down; and hotpatch

        mode to apply a patch to the run edition when application

        services are up. Only use hotpatch mode when explicitly

        directed by documentation.

        Example - apply a patch in downtime mode:

            adop phase=apply patches=123456 apply_mode=downtime

        In downtime mode, adop will validate that application services

        are shutdown before apply the patch.  The patch will be applied

        to the run edition of the system.  Downtime mode cannot be used

        if there is an online patching cycle in progress.

        Example - apply a patch in hotpatch mode:

            adop phase=apply patches=123456 apply_mode=hotpatch

        In hotpatch mode, adop will apply the patch to the run edition

        of the system while application services are still running.  Patches

        that can be safely applied in hotpatch mode (such as NLS and Online

        Help patches) will document this in the patch readme.  Hotpatch mode

        cannot be used if there is an online patching cycle in progress.

    merge=(yes|no)  [default: no]

        Indicates whether adop should merge a list of patches before applying.

        By default, adop will apply a list of patches serially in the order

        specified.  You can also use AD Merge Patch to merge multiple patches

        ahead of the apply command.

        Example - Merge multiple patches before applying

            adop phase=apply patches=1234,5678 merge=yes

        In some cases it may be necessary to merge patches, such as when

        an additional patch corrects an installation issue in the main patch.

        If the merge parameter is required, this will be documented in the

        patch readme.

    restart=(yes|no)  [default: no]

        Use restart=yes to resume the previous failed apply command

        from where processing terminated.  If an apply command fails,

        check the log files for further information.  If the problem

        can be corrected, you can then restart the apply command where

        it left off using the restart parameter.

        Example - Restart a apply command

            adop phase=apply patches=123456 restart=yes

        When restarting a failed apply it is important to use the

        same parameters as the failed command, with only the addition

        of the restart=yes parameter.

    abandon=(yes|no)  [default: no]

        Use abandon=yes to abandon the previous failed apply command

        and start a new apply command.  Note that any changes made

        to the system by the failed command will remain in effect.

        The abandon flag is most useful when applying a replacement

        patch for the failing patch.

        Example - Abandon previous apply command and apply replacement

            adop phase=apply patches=223456 abandon=yes

        If a patch fails to apply and there is no replacement patch,

        you may also abort the online patching cycle.  See abort phase

        later in this text.

    options=<patch_option>[,<patch_option>...]

        Options can be specified in a comma-separated list to control

        advanced features when a patch is applied.  These options are normally

        not needed unless specified by documentation or support.  Note

        that these options can be prefixed with "no", e.g. "nocheckfile",

        to disable the behavior, and for some options "no" is the default.

            checkfile       - Skip running exec, SQL, and exectier

                              commands if they are recorded as already run.

                              [default: checkfile]

            compiledb       - Compile invalid objects in the database

                              after running actions in the database driver.

                              [default: compiledb]

            compilejsp      - Compile out-of-date JSP files, if the patch

                              has copy actions for at least one JSP file.

                              [default: compilejsp]

            copyportion     - Run commands found in a copy driver.

                              [default: copyportion]

            databaseportion - Run commands found in a database driver.

                              [default: databaseportion]

            generateportion - Run commands found in a generate driver.

                             [default: generateportion]

            integrity       - Perform patch integrity checking

                              [default: nointegrity]

            autoconfig      - Run AutoConfig.

                              [default: autoconfig]

            actiondetails   - Turn off display of action details.

                              [default: actiondetails]

            parallel        - Run actions that update the database or

                              actions that generate files in parallel.

                              [default: parallel]

            prereq          - Perform prerequisite patch checking prior to

                              running patch driver files.

                              [default: noprereq]

            validate        - Connect to all registered Oracle E-Business

                              Suite schemas at the start of patch application.

                              [default: novalidate]

            phtofile        - Save patch history to file

                              [default: nophtofile]

            forceapply      - Reapply a patch that has already been applied.

                              Useful in combination with "nocheckfile" option

                              to rerun files that have already been executed.

                              [default: noforceapply]

        Example - Apply patch again, force re-execution of driver commands:

            adop phase=apply patches=123456 options=forceapply,nocheckfile

        This command will apply the patch again, and will execute SQL, exec

        and exectier actions even if they have already been executed.

    flags=<patch_flag>[,<patch_flag>...]

        Flags can be specified in a comma-separated list to control advanced

        features when applying a patch.  Note that these flags can be prefixed

        with "no", e.g.  "nologging", to disable the behavior and for some

        flags "no" is the default.

            hidepw          - Omit the "HIDEPW:" comments in the log file.

                              [default: hidepw]

            trace           - Log all database operations to a trace file.

                              [default: notrace]

            logging         - Create indexes in LOGGING or NOLOGGING mode.

                              [default: nologging]

            autoskip        - To proceed with adpatch execution even if some

                              driver actions failed.  Failed actions are

                              recorded in a log file.

                              [default: noautoskip]

        Example - Skip apply failures:

            adop phase=apply patches=123456 flags=autoskip

    preinstall=(yes|no)  [default: no]

        Allows a patch to be applied to the file system without connecting

        to the database.  Do not use this parameter unless directed by Oracle.

    wait_on_failed_job=(yes|no)  [default: no]

        Controls whether adop apply command exits when all workers have

        failed.  Instead of exiting, you can force adop to wait, and use

        the "adctrl" to retry failed jobs.

    printdebug=(yes|no)  [default: no]

        Controls whether to display additional debugging information.

    uploadph=(yes|no)  [default: yes]

        Controls whether to upload patch history information to database after

        applying the patch.

Finalize Parameters:

    finalize_mode=(full|quick)  [default: quick]

        Quick mode will provide the shortest execution time, by

        skipping non-essential actions.

        Full mode performs additional actions such as gathering

        statistics that may improve performance after cutover.

        Example - Perform additional optimizations during Finalize:

            adop phase=finalize finalize_mode=full

        Using full mode after applying a major patch can help maintain

        optimal system performance.

Cutover Parameters:

    mtrestart=(yes|no)  [default: yes]

        Specifies whether to restart application tier servers after cutover.

        Leave at default unless you need to perform any manual steps during

        downtime.

        Example - Perform downtime actions after cutover:

            adop phase=cutover mtrestart=no

            <Perform downtime steps>

            adstrtal.sh

    cm_wait=<minutes>  [default: forever]

        Specifies the number of minutes to wait for Concurrent Manager

        shutdown.  Adop cutover starts by requesting a concurrent manager

        shutdown and then waits for in-progress requests to complete.

        If Concurrent Manager does not shutdown within the specified

        time limit, remaining concurrent requests will be killed and

        cutover will proceed.

        Example - cutover with maximum wait of 15 minutes:

            adop phase=cutover cm_wait=15

        Note that any concurrent requests killed during forced shutdown

        may need to be manually re-submitted after cutover.  To avoid

        killing concurrent requests, schedule cutover at a time of

        minimal user activity or manually shutdown Concurrent Manager

        in advance of cutover.

Cleanup Parameters:

    cleanup_mode=(full|standard|quick)  [default: standard]

        Quick mode provides the shortest execution time, by

        skipping non-essential actions.

        Standard mode performs additional processing to drop

        obsolete code objects from old editions.

        Full mode performs additional processing to drop empty

        database editions and unused table columns.

        Example - Run quick cleanup for minimum delay to next prepare:

            adop phase=cleanup cleanup_mode=quick

        Example - Run full cleanup for maximum space recovery:

            adop phase=cleanup cleanup_mode=full

Special Operations:

    Cloning the Patch Edition File System:

        The patch edition file system is normally synchronized with the

        run edition file system during the prepare phase.  There are some

        cases where it is helpful or required to manually re-clone the patch

        edition file system from the run edition.

            1) After aborting an online patching cycle.

            2) After manually changing the run edition file system.

            3) After patching middle-tier technology components.

            4) After applying an EBS RUP.

        By re-cloning the patch edition file system, you can be certain that

        it is correctly synchronized, and also minimize any synchronization

        delay that would normally occur on the next prepare command.

        Example - Re-clone the patch edition file system:

            adop phase=fs_clone

        If there is any error you must examine log files and correct the

        problem, then restart the fs_clone by running the command again.

        If fs_clone does not restart correctly you can force the process

        to restart from the beginning.

        Example - Restart failed fs_clone from the beginning:

            adop phase=fs_clone force=yes

        You can specify the method used to synchronize the patch file system

        with the run file system by setting the fs_clone_sync_mode parameter:

        fs_clone_sync_mode=(cp|delta) [default:cp]

        This parameter replaces sync_mode, which has been deprecated.

        'delta' mode uses the file system synchronization command

        specified in $APPL_TOP_NE/ad/admin/delta_sync_drv.txt.

        'cp' mode creates the complete patch file system from run file system.

        Example - fs_clone with new parameter fs_clone_sync_mode

            adop phase=fs_clone fs_clone_sync_mode=cp

    Aborting an online patching cycle:

        If an online patching cycle encounters problems that cannot be

        fixed immediately you can abort the patching cycle and return

        to normal runtime operation.

        Example - Aborting a failed online patching cycle:

            adop phase=prepare

            adop phase=apply patches=123456

            ### serious unfixable error reported

            adop phase=abort

            adop phase=cleanup cleanup_mode=full

            adop phase=fs_clone

        The abort command drops the database patch edition and

        returns the system to normal runtime state.  Immediately

        following abort, you must also run a full cleanup and

        fs_clone operation to fully remove effects of the failed

        online patching cycle.

    Dropping old database editions:

        As online patching cycles are completed, the system will build

        up a number of old database editions.  When the number of old

        database editions reaches about 25, you should consider running

        a special maintenance operation to drop old database editions.

        Example - Actualize_All and Full Cleanup:

            adop phase=prepare

            adop phase=actualize_all

            adop phase=finalize

            adop phase=cutover

            adop phase=cleanup cleanup_mode=full

        Warning: This maintenance operation will take much longer than a

        typical online patching cycle, and should only be performed when

        there is no immediate need to start a new online patching cycle.

        The actualize all and full cleanup can be done separately as shown

        above, or can be executed in conjunction with an online patching

        cycle.

        Example - Actualize_All and Full Cleanup combined with patching:

            adop phase=prepare

            adop phase=apply patches=123456

            adop phase=actualize_all

            adop phase=finalize

            adop phase=cutover

            adop phase=cleanup cleanup_mode=full

adop exiting with status = 0 (Success)


Wednesday, March 8, 2017

EBSO Cache Clear

12.1 Cache Clear:

rm -rf $LOG_HOME/ora/10.1.3/Apache/*
rm -rf $LOG_HOME/ora/10.1.3/j2ee/*
rm -rf $LOG_HOME/ora/10.1.3/javacache/DiskCache/*
rm -rf $LOG_HOME/ora/10.1.3/opmn/*
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence $ORA_CONFIG_HOME/10.1.3/j2ee/forms/tldcache
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/tldcache
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/tldcache
rm -rf $COMMON_TOP/_Tldcache
rm -rf $COMMON_TOP/$CONTEXT_NAME/_Tldcache

 mv  $ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence $ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence_old
 mkdir  $ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence

 mv $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence_old
 mkdir $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence

 mv $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence  $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence_old
 mkdir $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence

=====================================================================================
rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*;rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*;rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

=====================================================================================

How To Clear The Cache Using Functional Administrator in R12 E-Business Suite 11i & R12:
========================================================================================
In R12 we use the following steps to clear the cache and also when we do this activity make sure that the  users shouldn’t connect the applications.
Step1: Log in and choose the Functional Administrator responsibility – then choose Home.
Step2:Choose the Core Services Tab – then the Caching Framework Sub-Menu .
Step3:Click Global Configuration’ from the left hand side menu that appears  and  – In the far right choose ‘Clear all Cache’ button
Step4: A screen prompts and confirms that the action will clear all cache on the middle tier server – choose Yes.
Step5: A confirmation message is displayed, confirming that all cache has been cleared across middle tiers.

12.2 Cache Clear:

$DOMAIN_HOME/servers/<server name>/tmp/*.lok?
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/*.lok?
$DOMAIN_HOME/servers/<server name>/data/store/default/*.DAT?
$DOMAIN_HOME/servers/<server name>/data/store/diagnostics/*.DAT

Tuesday, February 28, 2017

Translation Synchronization patches or Addition of Patches

Reference Note id's:
********************
R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)
Oracle Applications NLS Release Notes, Release 12.1 (Doc ID 788053.1)
How To Apply An NLS Patch Again When The Maintain MultiLingual Step Is Missed (Doc ID 1623652.1)

1.Shutdown required MT and DB services
2.Take  required backup
3.Start the DB and MT services.
4.Install the required Language (French) from OAM.

Enabling the Arabic from OAM, folllow the below steps
Login to OAM as a sysadmin -> sitemap -> License Manager -> License -> Languages And license the following language

Enable the below languages

a. Spanish
b. Korean
c. Simplified Chinese
d. Traditional Chinese 

Note:Make sure you should not change the base language, it should be english.

5.Validate the language activated

Login to application with apps user and execute the below command.

Select NLS_LANGUAGE from FND_LANGUAGES where INSTALLED_FLAG in ('B','I');

Make sure you get below result.

a. Spanish
b. Korean
c. Simplified Chinese
d. Traditional Chinese 

Here base lang is American

5. Stop MT services
6.Run Maintain Multi-lingual Tables

      4.Maintain Applications Database Entities
              
         3. Maintain multi-lingual tables

AD Administration Main Menu > Maintain Applications Database Entities Menu using adadmin.

7.Run Update current view snapshot from adadmin

adadmin -> Maintain Applications Files -> Maintain snapshot information -> Update current view snapshot)

             2.    Maintain Applications Files menu

                4.    Maintain snapshot information

                   2.    Update current view snapshot

                      1.    Update Complete APPL_TOP

8.Run the Translation Synchronization Patch utility (adgennls.pl)

Login to applmgr user in application tier, make sure enviorment is sourced properly and execute the following command

perl $AD_TOP/bin/adgennls.pl

Above command will genertate the manifest file which you need to upload to support. Menifist file will be on following location:

$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt

9.Upload the manifest file to oracle support, use the below steps.

Upload the adgennls.txt file to https://updates.oracle.com/TransSync.
Once you upload the file, select the option Get Latest Translstions and click on next it will provide you the patch number which support is going to generate for NLS syncronization.

Note:If you do not receive any email regarding your request within 48 hours, you may contact Oracle Support for assistance.
this patch will generate NLS media patck, it will take some time to generate

15.Bring up the instance and release instance to customer
16.Once we have TSP patches then apply the Translation Synchronization patches with options=nocheckfile. 

adpatch  driver=u_merged.drv -options=nocheckfile

10.Bring down DB and MT services and take one cold backup
11.Start DB and listener.
12.Follow the instructions in the README file to apply the patch.

note: Before Applying patch make sure enough space in appl top directory, patch initially copy all required files to appl top create new lang patch Choose a directory that contains enough space for the NLS updates (about 10 GB for each language Minimum).

unzip patches in source folder
mkdir /home/applmgr/patch/dest
chmod -Rf 777 /home/applmgr/patch/dest
admrgpch -s /home/applmgr/patch/source -d /home/applmgr/patch/dest -merge_name u_mergeded
cd /home/applmgr/patch/dest
adpatch driver=u_mergeded.drv options=nocheckfile

13.AD Administration utility to generate message files from the Generate Applications Files menu.
14.Compile the invalid objects using utlrp.
15.Complie Forms and Reports
16.Complile Apps schema and validate apps schema
17.Check below queries it has to show other languages also:
SQL> select RESPONSIBILITY_ID,RESPONSIBILITY_Name,LANGUAGE,SOURCE_LANG from fnd_responsibility_tl where RESPONSIBILITY_ID in ('20419','20420');

RESPONSIBILITY_ID RESPONSIBILITY_NAME            LANG  SOUR
----------------- ------------------------------                      ----    ------
            20419 Application Developer                        US       US
            20420 System Administrator                        US       US
            20419 Desarrollador de Aplicaciones           ESA     ESA
            20420 Administrador de Sistema                 ESA     ESA
            
18.Bring up the applications services

Thursday, February 9, 2017

Golden Gate ggsci commands

GGSCI command Summary
ggsci> help

Object:          Command:
SUBDIRS          CREATE
ER               INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG,
                 SEND, START, STATS, STATUS, STOP
EXTTRAIL         ADD, ALTER, DELETE, INFO
GGSEVT           VIEW
MANAGER          INFO, REFRESH, SEND, START, STOP, STATUS
MARKER           INFO
PARAMS           EDIT, VIEW
REPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG,
                 SEND, START, STATS, STATUS, STOP
REPORT           VIEW
RMTTRAIL         ADD, ALTER, DELETE, INFO
TRACETABLE       ADD, DELETE, INFO
TRANDATA         ADD, DELETE, INFO
CHECKPOINTTABLE  ADD, DELETE, CLEANUP, INFO

Commands without an object:

(Database)       DBLOGIN, LIST TABLES, ENCRYPT PASSWORD
(DDL)            DUMPDDL
(Miscellaneous)  FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, 
                 SHELL, SHOW, VERSIONS, !

For help on a specific command, type HELP [command] [object]

Example: HELP ADD REPLICAT

Note: You must use the keyword COMMAND to display the “!” help topic. 

ggsci> help ! command

ggsci> help add rmttrail

To create default directories within Oracle GoldenGate home directory

ggsci> CREATE SUBDIRS    

To display the status of all Manager, Extract, and Replicat processes
ggsci> INFO ALL [TASKS | ALLPROCESSES]  
ggsci> info all

Program     Status      Group       Lag       Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EXTR      00:00:00      00:00:01
REPLICAT    ABENDED     REP       00:00:00      00:25:08

ggsci> info all tasks
ggsci> info all allprocesses

To determine whether or not the Manager process is running

ggsci> INFO MANAGER
ggsci> INFO MGR

To review recently processed markers from a NonStop system

ggsci> INFO MARKER [COUNT number_of_items]
ggsci> info marker

To display Status of Extract, Approximate Extract lag, Checkpoint information, Process run history

ggsci> INFO EXTRACT group_name [, SHOWCH [n]] [, DETAIL] [, TASKS | ALLPROCESSES]
ggsci> info extract emp_ext
ggsci> info extract cust_ext, detail
ggsci> info extract ext*, showch
ggsci> info extract *, detail
ggsci> info extract hr, tasks

To display status of Replicat, Approximate replication lag, the trail from which Replicat is reading, Replicat run history, including checkpoints in the trail, Information about the Replicat environment.

ggsci> INFO REPLICAT group_name [, SHOWCH [n]] [, DETAIL] [, TASKS | ALLPROCESSES]
ggsci> info replicat emp_rep
ggsci> info replicat emp_rep, detail
ggsci> info replicat prd*, detail, allprocesses
ggsci> info replicat *, tasks
ggsci> info replicat fin, showch

To retrieve configuration information for a local trail

ggsci> INFO EXTTRAIL trail_name 
ggsci> info exttrail *
ggsci> info exttrail e:\ogg\dirdat\ex

To retrieve configuration information for a remote trail

ggsci> INFO RMTTRAIL trail_name 
ggsci> info rmttrail *
ggsci> info rmttrail d:\ogg\dirdat\ex

To determine whether logging/replication enabled or not

ggsci> INFO TRANDATA user_name.table_names [, OLDFORMAT] [, USETRIGGER] 
ggsci> info trandata hr.*
ggsci> info trandata fin.acct

To confirm the existence of a checkpoint table and view the date and time that it was created

ggsci> INFO CHECKPOINTTABLE [user_name.table_name] 
ggsci> info checkpointtable gg_owner.chkpt_table

To verify the existence of the specified trace table

ggsci> INFO TRACETABLE [owner.table]    
ggsci> info tracetable ora_trace

To get information on multiple Extract and Replicat groups as a unit
ggsci> INFO ER group_wildcard_specification  
ggsci> info ER *ext*

To display the Oracle GoldenGate environment

ggsci> SHOW
ggsci> SHOW ALL

To establish a database connection

ggsci> DBLOGIN {SOURCEDB|TARGETDB dsn | USERID user_name[, PASSWORD password] [SYSDBA] | 
SOURCEDB|TARGETDB dsn, USERID user_name[, PASSWORD password] [SYSDBA] [SQLID sqlid]  
ggsci> dblogin sourcedb testdb
ggsci> dblogin targetdb repldb
ggsci> dblogin userid gg
ggsci> dblogin userid gg, password oracle
ggsci> dblogin userid system@localhost:1521/prod, password 12345678
ggsci> dblogin sourcedb ctdb@host1, userid gg_owner, password ggs sysdba

To encrypt a database login password

ggsci> ENCRYPT PASSWORD password [ENCRYPTKEY keyname]  
ggsci> encrypt password oracle143 encryptkey spiderman

To list all tables in the database that match the specification

ggsci> LIST TABLES table_name  
ggsci> list tables cust*

To create or change a parameter file

ggsci> EDIT PARAMS {MGR | ./GLOBALS | group_name | file_name} 
ggsci> edit params mgr
ggsci> edit params ./GLOBALS
ggsci> edit params myload
ggsci> edit params rep_emp
ggsci> edit params e:\gg\dirprm\replp.prm

To view the contents of a parameter file

ggsci> VIEW PARAMS {MGR | group_name | file_name}   ggsci> view params mgr
ggsci> view params s_extr
ggsci> view params e:\prm\replp.prm

To view GoldenGate error log (ggserr.log file)

ggsci> VIEW GGSEVT               

To view the process report that is generated by Extract or Replicat

ggsci> VIEW REPORT {group_name[n] | file_name}  
ggsci> view report ext6
ggsci> view report rep
ggsci> view report c:\ogg\dirrpt\orders.rpt

To create an Extract group
ggsci> ADD EXTRACT group_name
{, SOURCEISTABLE |, TRANLOG [bsds_name] |, VAM |, EXTFILESOURCE file_name |, EXTTRAILSOURCE trail_name |, VAMTRAILSOURCE VAM_trail_name} {, BEGIN {NOW | yyyy-mm-dd hh:mi:[ss[.cccccc]]]} |, EXTSEQNO seqno, EXTRBA relative_byte_address |, LOGNUM log_number, LOGPOS byte_offset |, EOF |, LSN value |, EXTRBA relative_byte_address |, PAGE data_page, ROW row | } [, THREADS n] [, PASSIVE] [, PARAMS parameter_file] [, REPORT report_file] [, DESC "description"]

Syntax for an alias Extract:

ADD EXTRACT group_name, RMTHOST {host_name | IP_address}, {MGRPORT port} | {PORT port} [, RMTNAME name] [, DESC "description"]

ggsci> add extract s_extr, tranlog, begin now
ggsci> add extract finext, tranlog, begin now, threads 4
ggsci> add extract fin, tranlog, begin now, passive
ggsci> add extract ext_ms, extseqno 111, begin now
ggsci> add extract hr_ext, extrba 567890, begin 2012-02-02 12:00:00
ggsci> add extract initload, sourceistable
ggsci> add extract pump, exttrailsource /oracle/gg11/dirdat/hr
ggsci> add extract fin, vam       -- VAM - Vendor Access Module
ggsci> add extract fin, vamtrailsource /ogg/dirdat/vt
ggsci> add extract finA, rmthost host123, mgrport 7810, rmtname fin

To create a Replicat group

ggsci> ADD REPLICAT group_name
{, SPECIALRUN |, EXTFILE full_path_name |, EXTTRAIL full_path_name}
[, BEGIN {NOW | YYYY-MM-DD HH:MM[:SS[.CCCCCC]]} |, EXTSEQNO seqno, EXTRBA rba] [, CHECKPOINTTABLE owner.table | NODBCHECKPOINT]
[, PARAMS parameter_file] [, REPORT report_file] [, DESC "description"]  
ggsci> add replicat repl, exttrail C:\OGG10G\dirdat\lt
ggsci> add replicat t_rep, exttrail /oracle/gg11/dirdat/lt, checkpointtable gg_owner.checkpoint
ggsci> add replicat initload, specialrun
ggsci> add replicat sales, exttrail /oracle/gg11/dirdat/lt, nodbcheckpoint

To create a trail for online processing on local system 

ggsci> ADD EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]  
ggsci> add exttrail /oracle/gg11/dirdat/lt, extract s_extr
ggsci> add exttrail C:\OGG10G\dirdat\et, extract emp_ext
ggsci> add exttrail c:\ogg\dirdat\fi, extract fin, megabytes 30

To create a trail for online processing on remote system

ggsci> ADD RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]  
ggsci> add rmttrail C:\OGG10G\dirdat\hr, extract extr
ggsci> add rmttrail /u01/app/oracle/ogg/dirdat/ms, extract msextr
ggsci> add rmttrail /u01/app/oracle/ogg/dirdat/my, extract mysql, megabytes 50

To enable Oracle GoldenGate to acquire the transaction information it needs from the transaction records

ggsci> ADD TRANDATA user_name.table_names [, COLS (column_list)] [, INCLUDELONG | EXCLUDELONG]
 [, LOBSNEVER | LOBSALWAYS | LOBSIFCHANGED | LOBSALWAYSNOINDEX] [, NOKEY] [, OLDFORMAT] [, USETRIGGER]     
ggsci> add trandata hr.*
ggsci> add trandata emp.employees
ggsci> add trandata fin.acct, cols (name, address)
ggsci> add trandata fin.acct, nokey, cols (name, pid)
ggsci> add trandata fin.acct, lobsalwaysnoindex
To create a checkpoint table in the target database

ggsci> ADD CHECKPOINTTABLE [user_name.table_name]  
ggsci> add checkpointtable
ggsci> add checkpointtable gg_owner.checkpoint

To create a trace table in the Oracle database

ggsci> ADD TRACETABLE [owner.table]  
ggsci> add tracetable
ggsci> add tracetable ora_trace

ggsci> REGISTER EXTRACT extract_group_name LOGRETENTION
ggsci> register extract extr logretention

To start Manager process

ggsci> START MANAGER   
ggsci> START MGR
ggsci> START *

To start Extract process

ggsci> START EXTRACT extract_name    
ggsci> start extract extr

To start Replicat process

ggsci> START REPLICAT group_name [SKIPTRANSACTION | ATCSN csn | AFTERCSN csn]  
ggsci> start replicat rep
ggsci> start replicat fin, atcsn 5238306       -- commit sequence number (CSN)
ggsci> start replicat fin, aftercsn 0X000006B1:0002334D:0004

To start multiple Extract and Replicat groups as a unit

ggsci> START ER group_wildcard_specification   
ggsci> start er *rep*

To stop Manager process

ggsci> STOP MANAGER [!]   
ggsci> stop manager
ggsci> stop manager !              -- will not ask for confirmation

ggsci> STOP EXTRACT extract_name   -- To stop Extract gracefully
ggsci> stop extract extr
To stop Replicat gracefully

ggsci> STOP REPLICAT replicat_name [!]  
ggsci> stop replicat rep

To stop multiple Extract and Replicat groups as a unit

ggsci> STOP ER group_wildcard_specification  
ggsci> stop er *ext*

To determine whether or not the Manager process is running

ggsci> STATUS MANAGER 

To determine whether or not Extract is running

ggsci> STATUS EXTRACT group_name [, TASKS | ALLPROCESSES]  
ggsci> status extract extr_hr
ggsci> status extract ext*, tasks
ggsci> status extract *ext*, allprocesses

To determine whether or not Replicat is running

ggsci> STATUS REPLICAT group_name [, TASKS | ALLPROCESSES] 
ggsci> status replicat emp_rep
ggsci> status replicat cust_rep, allprocesses

To check the status of multiple Extract and Replicat groups as a unit

ggsci> STATUS ER group_wildcard_specification    
ggsci> status er *EX*

To display statistics for one or more Extract group

ggsci> STATS EXTRACT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTFETCH | NOREPORTFETCH] [, REPORTRATE HR|MIN|SEC] [, ... ] 
ggsci> stats ext_hr
ggsci> stats extract ext
ggsci> stats extract ext2 reportrate sec
ggsci> stats extract fin, total, daily
ggsci> stats extract fin, total, hourly, table acct, reportrate min, reset, reportfetch

To display statistics for one or more Replicat groups

ggsci> STATS REPLICAT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTDETAIL | NOREPORTDETAIL] [, REPORTRATE HR|MIN|SEC] [, ... ]  
ggsci> stats rep_hr
ggsci> stats replicat fin, total, table acct, reportrate hr, reset, noreportdetail

To get statistics on multiple Extract and Replicat groups as a unit

ggsci> STATS ER group_wildcard_specification  
ggsci> stats er ext*

ggsci> REFRESH MANAGER  -- not available in Oracle 11g

To retrieve the status of the active Manager process or to retrieve dynamic port information as configured in the Manager parameter file

ggsci> SEND MANAGER [CHILDSTATUS [DEBUG]] [GETPORTINFO [DETAIL]] [GETPURGEOLDEXTRACTS]  
ggsci> send manager childstatus
ggsci> send manager childstatus debug
ggsci> send manager getportinfo
ggsci> send manager getportinfo detail
ggsci> send manager getpurgeoldextracts

To communicate with a running Extract process

ggsci> SEND EXTRACT group_name, 
{ CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} | FORCESTOP | FORCETRANS id [THREAD n] [FORCE] | GETLAG | GETTCPSTATS | LOGEND | REPORT | ROLLOVER | SHOWTRANS [id] [THREAD n] [COUNT n] [DURATION duration_unit] [TABULAR] [FILE file_name [DETAIL]] | SKIPTRANS id [THREAD n] [FORCE] | STATUS | STOP | TLTRACE {DEBUG | OFF | level} [SIZELIMIT size] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] {tracefile | OFF} | TRACEINIT | TRANLOGOPTIONS {PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} | TRANLOGOPTIONS TRANSCLEANUPFREQUENCY minutes | VAMMESSAGE "Teradata_command" | VAMMESSAGE {ARSTATS | INCLUDELIST [filter] | EXCLUDELIST [filter]} | VAMMESSAGE OPENTRANS
}    
Teradata_command = {"control:terminate" | "control:suspend" | "control:resume" | "control:copy database.table"
ggsci> send extract exthr status
ggsci> send extract extr, getlag
ggsci> send extract group_name tltrace file file_name ddlinclude
ggsci> send extract fin, rollover
ggsci> send extract fin  stop
ggsci> send extract fin, vammessage control:suspend
ggsci> send extract fin, tranlogoptions transcleanupfrequency 15
ggsci> send extract fin, showtrans count 10
ggsci> send extract fin, skiptrans 5.17.27634 thread 2

To communicate with a starting or running Replicat process

ggsci> SEND REPLICAT group_name,
{ FORCESTOP | GETLAG | HANDLECOLLISIONS [table_specification] | NOHANDLECOLLISIONS [table_specification] | REPORT [HANDLECOLLISIONS [table_specification]] | STATUS | STOP | TRACE[2] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] OFF | TRACEINIT
}   
ggsci> send replicat fin, handlecollisions
ggsci> send replicat fin, report handlecollisions fin_*
ggsci> send replicat fin, getlag

To send instructions to multiple Extract and Replicat groups as a unit

ggsci> SEND ER group_wildcard_specification  
ggsci> send er *ext

To change the attributes of an Extract group, To increment a trail to the next file in the sequence

ggsci> ALTER EXTRACT group_name [, ADD_EXTRACT_attribute] [, THREAD number] [, ETROLLOVER] 
ggsci> alter extract fin, begin 2012-02-16
ggsci> alter extract fin, etrollover
ggsci> alter extract fin, extseqno 26, extrba 338
ggsci> alter extract accounts, thread 4, begin 2012-03-09
ggsci> alter extract sales, lsn 1234:123:1

To change the attributes of a Replicat group

ggsci> ALTER REPLICAT group_name , 
[, BEGIN {NOW | YYYY-MM-DD HH:MM[:SS[.CCCCCC]]} |, EXTSEQNO seqno, EXTRBA rba] [, PARAMS parameter_file] [, REPORT report_file] [, DESC "description"]  
ggsci> alter replicat fin, begin 2011-09-28 08:08:08
ggsci> alter replicat fin, extseqno 53
ggsci> alter replicat fin, extrba 666

To change the attributes of a trail (on the local system)

ggsci> ALTER EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]  
ggsci> alter exttrail c:\ogg\dirdat\aa, extract fin, megabytes 30

To change the attributes of a trail (on a remote system)

ggsci> ALTER RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]  
ggsci> alter rmttrail c:\ogg\dirdat\et, extract fin, megabytes 25

To delete run history for specified Extract group

ggsci> CLEANUP EXTRACT group_name [, SAVE count]   
ggsci> cleanup extract fin
ggsci> cleanup extract e*, save 6

To delete run history for specified Replicat group

ggsci> CLEANUP REPLICAT group_name [, SAVE count]  
ggsci> cleanup replicat fin
ggsci> cleanup replicat *, save 10

To remove checkpoint records from the checkpoint table

ggsci> CLEANUP CHECKPOINTTABLE [user_name.table_name] 
ggsci> cleanup checkpointtable ggs.fin_check

To delete an Extract group

ggsci> DELETE EXTRACT group_name [!]  
ggsci> delete extract emp_ext
ggsci> delete extract emp_ext !              -- will not ask for confirmation

To delete a Replicat group

ggsci> DELETE REPLICAT group_name [!]  
ggsci> delete replicat emp_ext
ggsci> delete replicat emp_ext !             -- will not ask for confirmation

To delete the record of checkpoints associated with a trail on a local system

ggsci> DELETE EXTTRAIL trail_name   
ggsci> delete exttrail /home/ogg/dirdat/et

To delete the record of checkpoints associated with a trail on a remote system

ggsci> DELETE RMTTRAIL trail_name     
ggsci> delete rmttrail /home/ogg/dirdat/et

To delete logging/replication data

ggsci> DELETE TRANDATA user_name.table_names [, OLDFORMAT] [, USETRIGGER] 
ggsci> delete trandata fin.acct
ggsci> delete trandata fin.cust*
ggsci> delete trandata emp.hr, usetrigger

To drop checkpoint table from database

ggsci> DELETE CHECKPOINTTABLE [user_name.table_name] [!]    
ggsci> delete checkpointtable ggs.fin_check

To delete a trace table

ggsci> DELETE TRACETABLE [owner.table]  
ggsci> delete tracetable ora_trace

To kill an Extract process running in regular or PASSIVE mode

ggsci> KILL EXTRACT group_name   
ggsci> kill extract fin

To kill a Replicat process

ggsci> KILL REPLICAT group_name  
ggsci> kill replicat fin

To forcefully terminate multiple Extract and Replicat groups as a unit

ggsci> KILL ER group_wildcard_specification  
ggsci> kill er *x*

To determine a true lag time between Extract and the datasource

ggsci> LAG EXTRACT group_name   
ggsci> lag extract ext*
ggsci> lag extract *

To determine a true lag time between Replicat and the trail

ggsci> LAG REPLICAT group_name    
ggsci> lag replicat myrepl
ggsci> lag replicat *

To get lag information on multiple Extract and Replicat groups as a unit

ggsci> LAG ER group_wildcard_specification  
ggsci> lag er *ext*

To view the data in the Oracle GoldenGate DDL history table

ggsci> DUMPDDL [SHOW]  
ggsci> dumpddl

To view the most recently issued GGSCI commands since the session started

ggsci> HISTORY [n]  
ggsci> history       -- by default, shows last 10 commands
ggsci> history 30

To change the default text editor for the current session of GGSCI, default editors are Notepad for Windows and vi for UNIX

ggsci> SET EDITOR program_name     
ggsci> set editor wordpad

To display operating system and database version information

ggsci> VERSIONS
To display edit a previously issued GGSCI command and then execute it again
ggsci> FC [n | -n | string]  
ggsci> fc
ggsci> fc 9
ggsci> fc -3
ggsci> fc sta

FC editor commands

i text  -- Inserts text
r text  -- Replaces text
d       -- Deletes a character
replacement_text  -- Replaces the displayed command with the text that we enter on a one-for-one basis.

To execute shell commands from within GGSCI interface

ggsci> SHELL shell_command  
ggsci> shell ls -l /u01/app/oracle/gg/dirdat
ggsci> shell dir dirprm\*
ggsci> shell rm ./dat*

To execute previous GGSCI command

ggsci> ! [n | -n | string]     
ggsci> !
ggsci> ! 6    -- To run the command 6 listed in the history
ggsci> ! -3
ggsci> ! sta
ggsci> help ! command

To process a file that contains a list of GoldenGate commands.

ggsci> OBEY ggsci_script     
ggsci> shell more /u01/app/oracle/gg/startup.txt
START MANAGER
START EXTRACT EXT3
START EXTRACT DPUMP
INFO ALL
ggsci> OBEY /u01/app/oracle/gg/startup.txt
ggsci> OBEY ./mycommands.txt

ggsci> EXIT