26 April 2011

How to Change the NLS_CHARACTERSET

The syntax of the ALTER DATABASE CHARACTER SET statement is as follows:
ALTER DATABASE [db_name] CHARACTER SET new_character_set;


db_name is optional. The character set name should be specified without quotes. For example:
ALTER DATABASE CHARACTER SET AL32UTF8;


To change the database character set, perform the following steps:

  1. Shut down the database, using either a SHUTDOWN IMMEDIATE or a SHUTDOWN NORMAL statement.
  2. Do a full backup of the database because the ALTER DATABASE CHARACTER SET statement cannot be rolled back.
  3. Complete the following statements:
    STARTUP MOUNT;
    ALTER SYSTEM ENABLE RESTRICTED SESSION;
    ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
    ALTER SYSTEM SET AQ_TM_PROCESSES=0;
    ALTER DATABASE OPEN;
    ALTER DATABASE CHARACTER SET new_character_set;
    SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
    STARTUP;

How to Check tablespace size and freespace

SELECT d.status,
         db.name dbname,
         d.tablespace_name tsname,
         d.extent_management,
         d.allocation_type,
         TO_CHAR (NVL (d.min_extlen / 1024, 0),
                  '99G999G990D90',
                  'NLS_NUMERIC_CHARACTERS = '',.'' ')
            "SIZE In MB",
         d.contents "Type",
         CASE
            WHEN (d.contents = 'TEMP')
            THEN
               TO_CHAR (NVL (a.bytes / 1024 / 1024, 0),
                        '99G999G990D90',
                        'NLS_NUMERIC_CHARACTERS = '',.'' ')
            ELSE
               TO_CHAR (NVL (t.bytes / 1024 / 1024, 0),
                        '99G999G990D90',
                        'NLS_NUMERIC_CHARACTERS = '',.'' ')
         END
            AS "Size In MB",
         TO_CHAR (NVL ( (a.bytes - NVL (f.bytes, 0)) / 1024 / 1024, 0),
                  '99G999G990D90',
                  'NLS_NUMERIC_CHARACTERS = '',.'' ')
            "Used MB",
         TO_CHAR (NVL ( (a.bytes - NVL (f.bytes, 0)) / a.bytes * 100, 0),
                  '990D90',
                  'NLS_NUMERIC_CHARACTERS = '',.'' ')
            "Used Size"
    FROM sys.dba_tablespaces d,
         (  SELECT tablespace_name, SUM (bytes) bytes
              FROM dba_data_files
          GROUP BY tablespace_name) a,
         (  SELECT tablespace_name, SUM (bytes) bytes
              FROM dba_temp_files
          GROUP BY tablespace_name) t,
         (  SELECT tablespace_name, SUM (bytes) bytes
              FROM dba_free_space
          GROUP BY tablespace_name) f,
         v$database db
   WHERE     d.tablespace_name = a.tablespace_name(+)
         AND d.tablespace_name = f.tablespace_name(+)
         AND d.tablespace_name = t.tablespace_name(+)
ORDER BY 10 DESC;

Query :-2
select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name ;

Query :-3
select b.tablespace_name, tbs_size Total_Size, a.free_space Free
from  (select tablespace_name, round(sum(bytes)/1024/1024 ,2) as free_space
       from dba_free_space
       group by tablespace_name) a,
      (select tablespace_name, sum(bytes)/1024/1024 as tbs_size
       from dba_data_files
       group by tablespace_name) b
where a.tablespace_name(+)=b.tablespace_name order by Total_SIZE desc;

15 April 2011

RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error

RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error

Applies to:

Oracle Inventory Management - Version: 11.0.3 to 12.1.3 - Release: 11.0 to 12.1
Information in this document applies to any platform.


How does one relink and bounce the receiving executables?

Solution

   1. Relink receiving executables.
      cd $PO_TOP/bin
      $ adrelink.sh force=y ranlib=y "PO RCVOLTM"
      $ adrelink.sh force=y ranlib=y "PO RVCTP"

      Prior to r11i/r12, the command is adrelink

   2. Bounce the Receiving Transaction Manager.
      a. $ps -ef | grep RCVOLTM (to see how many processes are running)
      b. Deactivate Receiving Transaction Manager
      (System Administrator > Concurrent > Manager > Administer)
      c. $ps -ef | grep RCVOLTM (repeat until no processes are running)
      d. Restart Receiving Transaction Manager

Then retry your issue

For your reference  Receiving Transactions Fail with RVTII-060 or RVTTH-445 or RVTTH-448 or RVTII-030 or RVTII-080 [ID 731070.1]

14 April 2011

mount remote ftp directory host locally into linux filesystem

Mount remote ftp directory host locally into linux filesystem
Install below two rpms package

fuse-curlftpfs-0.9.1-1.el5.rf.x86_64.rpm
fuse-libs-2.7.4-8.el5.x86_64.rpm

# mkdir /mnt/Ariba

Examble
    * username: ftp-user
    * password: ftp-pass
    * host/IP: my-ftp-location.local

# curlftpfs ftp-user:ftp-pass@my-ftp-location.local /mnt/Ariba/

Examble :-

curlftpfs username:password@10.2.0.144 /mnt/Ariba/

#df -h
/dev/mapper/VolGroup00-LogVol00_root
                      146G  103G   36G  75% /
/dev/mapper/VolGroup00-LogVol00_rman_bkup
                      133G  188M  126G   1% /rman_bkup
/dev/mapper/VolGroup00-LogVol00_backup
                       97G  189M   92G   1% /backup
/dev/sda1              99M   13M   81M  14% /boot
tmpfs                  24G  8.9M   24G   1% /dev/shm
/dev/mapper/VG_Storage-r01
                       50G   31G   17G  65% /r01
/dev/mapper/VG_Storage-r02
                       50G   19G   28G  41% /r02
/dev/mapper/VG_Storage-r03
                       50G   35G   12G  75% /r03
/dev/mapper/VG_Storage-r04
                       50G   21G   27G  45% /r04
/dev/mapper/VG_Storage-oracle
                       20G   15G  4.4G  77% /oracle
/dev/mapper/VG_Storage-Archive
                       74G  3.3G   67G   5% /Archive
fuse                  7.5T     0  7.5T   0% /mnt/Ariba

Finaly my ftp server is mounted .

08 April 2011

ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")

Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_j000_19837.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:10 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_cjq0_9471.trc:

Fri Apr 08 10:21:16 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q002_19865.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:16 2011
Process q002 died, see its trace file
Fri Apr 08 10:21:21 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_m000_19928.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:21 2011
Process m000 died, see its trace file
Fri Apr 08 10:21:32 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q000_20027.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:32 2011
Process q000 died, see its trace file
Fri Apr 08 10:21:49 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q002_20140.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kgsp-heap","kglss")
Fri Apr 08 10:21:49 2011
Process q002 died, see its trace file
Fri Apr 08 10:22:05 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q000_20356.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:22:05 2011
Process q000 died, see its trace file
Fri Apr 08 10:22:22 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_m000_20453.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:22:22 2011
Process m000 died, see its trace file
Fri Apr 08 10:23:34 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_m000_21062.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:23:34 2011

More shared memory is needed than was allocated in the shared pool



Solution :-
I have increased the SQA_TARGET,pga_aggregate_target and sga_max_size on init$ORACLE_SID.ora file .

Example: -
Old SGA and PGA Size
sga_max_size    6    1094967296
sga_target    6    1094967296
pga_aggregate_target    1094967296

New SGA and PGA Size :-
pga_aggregate_target      2147483648    2G
sga_max_size        4294967296
sga_target        4294967296

02 April 2011

Step by Step Process for Rapid clone

[oracle@our12-dev 11.1.0]$ . /oraapps/apps/apps_st/appl/APPSPATCH_our12-dev.env
[oracle@our12-dev scripts]$ admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /oraapps/inst/apps/PATCH_our12-dev/admin/log/MakeAppsUtil_03171648.log
output located at /oraapps/inst/apps/PATCH_our12-dev/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
You have new mail in /var/spool/mail/oracle
[oracle@our12-dev scripts]$cd /oradata/PATCH/db/tech_st/11.1.0
[oracle@our12-dev 11.1.0]$ mv /oraapps/inst/apps/PATCH_our12-dev/admin/out/appsutil.zip .
[oracle@our12-dev 11.1.0]$unzip -o appsutil.zip
inflating: appsutil/bin/adtmplreport.cmd
  inflating: appsutil/bin/txkInventory.pl
  inflating: appsutil/bin/addlnctl.pl
  inflating: appsutil/bin/adcustomizer.sh
  inflating: appsutil/bin/adclonectx.pl
  inflating: appsutil/bin/txkrun.pl
  inflating: appsutil/bin/adcvm.cmd
  inflating: appsutil/template/txkcreateACL.sql
  inflating: appsutil/template/adsvdb.sh
  inflating: appsutil/template/ons_config_db.tmp
  inflating: appsutil/template/adora9i_conf.inf
  inflating: appsutil/template/adregdb.drv
  inflating: appsutil/template/config_aix.s
  inflating: appsutil/template/adstopdb.sql
  inflating: appsutil/template/adora8i_stub.inf
  inflating: appsutil/template/adcmclean.sql
  inflating: appsutil/template/adpreclone.pl
  inflating: appsutil/template/txkcreateACL.sh
  inflating: appsutil/template/addbactmpl.drv
  inflating: appsutil/template/adcrdb.sh
  inflating: appsutil/template/adchknls.pl
  inflating: appsutil/template/addlnctl.sh
  inflating: appsutil/template/config_sol.s
  inflating: appsutil/template/adsvdlsn.sh
  inflating: appsutil/template/addbprf.sql
  inflating: appsutil/template/afinit_db101RAC.ora
  inflating: appsutil/template/adoradbcinf.cmd
  inflating: appsutil/template/adlnkoh.sh
  inflating: appsutil/template/afinit_db102RAC.ora
  inflating: appsutil/template/adora10g_stub.inf
  inflating: appsutil/template/adautocfg_nt.cmd
  inflating: appsutil/template/addbprf.sh
  inflating: appsutil/template/ad8itns.ora
  inflating: appsutil/template/adcrobj.sql
  inflating: appsutil/template/adcrdb.cmd
  inflating: appsutil/template/adcldbclean.sql
  inflating: appsutil/template/config_sol_64.s
  inflating: appsutil/template/adsvdcnv.cmd
  inflating: appsutil/template/txkcreateACL.cmd
  inflating: appsutil/template/adclobconv.sql
  inflating: appsutil/template/adora8iinf.cmd
  inflating: appsutil/template/afifilecbo.ora
  inflating: appsutil/template/adregtools.drv
  inflating: appsutil/template/afdbprf.cmd
  inflating: appsutil/template/afinit_db111.ora
  inflating: appsutil/template/txkConfigDbOcm.pl
  inflating: appsutil/template/adcrobj.cmd
  inflating: appsutil/template/adupdlib_nt.sql
  inflating: appsutil/template/adautocfg_ux.sh
  inflating: appsutil/template/adcldbgenrest.sql
  inflating: appsutil/template/afmkinit_inst.cmd
  inflating: appsutil/template/addbprf.cmd
  inflating: appsutil/template/adxdbctx.tmp
  inflating: appsutil/template/adcvmdb.xml
  inflating: appsutil/template/adclobtmp.sql
  inflating: appsutil/template/adsvdb.cmd
  inflating: appsutil/template/afmkinit.cmd
  inflating: appsutil/template/adpredb.drv
  inflating: appsutil/template/config_aix_64.s
  inflating: appsutil/template/adsvdlsn.cmd
  inflating: appsutil/template/afinit_db102.ora
  inflating: appsutil/template/adclobcln.sql
  inflating: appsutil/template/addbccnv.sql
  inflating: appsutil/template/adcrdbrdlg.cmd
  inflating: appsutil/template/afinit_db111RAC.ora
  inflating: appsutil/template/ad8idbnt.env
  inflating: appsutil/template/adlsnodes_ux.sh
  inflating: appsutil/template/adcrdbrdlg.sh
  inflating: appsutil/template/adstrtdb.sql
  inflating: appsutil/template/adregweboh.drv
  inflating: appsutil/template/adlicnse.sql
  inflating: appsutil/template/ad8ilsnr.ora
  inflating: appsutil/template/afdbprf.sql
  inflating: appsutil/template/ad8isqlnet.ora
  inflating: appsutil/template/adcrsvc.cmd
  inflating: appsutil/template/adcldbstage.sql
  inflating: appsutil/template/addbctl.cmd
  inflating: appsutil/template/addlnctl.cmd
  inflating: appsutil/template/adexecsql.pl
  inflating: appsutil/template/afinit_NT_ALL.ora
  inflating: appsutil/template/afmkinit.sh
  inflating: appsutil/template/config_ux.tmp
  inflating: appsutil/template/adora8i_conf.inf
  inflating: appsutil/template/adcrobj.sh
  inflating: appsutil/template/adxdbinf.tmp
  inflating: appsutil/template/addbctl.sh
  inflating: appsutil/template/adcfgclone.pl
  inflating: appsutil/template/adouitools.pl
  inflating: appsutil/template/addbcltmpl.drv
  inflating: appsutil/template/ad8idbux.env
  inflating: appsutil/template/adlsnr10RAC.ora
  inflating: appsutil/template/adcldbapply.sql
  inflating: appsutil/template/afinit_db101.ora
  inflating: appsutil/template/addbsynhnm.cmd
  inflating: appsutil/template/adlsnodes_nt.cmd
  inflating: appsutil/template/adupdlib_ux.sql
  inflating: appsutil/template/addbtmpl.drv
  inflating: appsutil/template/adsvdcnv.sh
  inflating: appsutil/template/adpreweboh.drv
  inflating: appsutil/template/adouiweboh.pl
  inflating: appsutil/template/adouidb.pl
  inflating: appsutil/template/adpretools.drv
  inflating: appsutil/template/adcctclean.sql
  inflating: appsutil/template/afdbprf.sh
  inflating: appsutil/template/adora9i_stub.inf
  inflating: appsutil/template/addbupdgsm.sql
  inflating: appsutil/media/FNDSSCORP.gif
  inflating: appsutil/media/eyeglasses_transparent.gif
  inflating: appsutil/media/chsd.gif
  inflating: appsutil/media/chsu.gif
  inflating: appsutil/perl/TXK/Error.pm
  inflating: appsutil/perl/TXK/XML.pm
  inflating: appsutil/perl/TXK/RunScript.pm
  inflating: appsutil/perl/TXK/SQLPLUS.pm
  inflating: appsutil/perl/TXK/Techstack.pm
  inflating: appsutil/perl/TXK/Validate.pm
  inflating: appsutil/perl/TXK/Script.pm
  inflating: appsutil/perl/TXK/ARGS.pm
  inflating: appsutil/perl/TXK/Log.pm
  inflating: appsutil/perl/TXK/Process.pm
  inflating: appsutil/perl/TXK/Inventory.pm
  inflating: appsutil/perl/TXK/AutoConfig.pm
  inflating: appsutil/perl/TXK/OSD.pm
  inflating: appsutil/perl/TXK/Runtime.pm
  inflating: appsutil/perl/TXK/AutoBuild.pm
  inflating: appsutil/perl/TXK/Common.pm
  inflating: appsutil/perl/TXK/Restart.pm
  inflating: appsutil/perl/TXK/Util.pm
  inflating: appsutil/perl/TXK/TechstackDB.pm
  inflating: appsutil/perl/TXK/IO.pm
  inflating: appsutil/perl/TXK/Reports.pm
  inflating: appsutil/perl/TXK/FileSys.pm
  inflating: appsutil/perl/ADX/util/Sysutil.pm
  inflating: appsutil/perl/ADX/util/Java.pm
  inflating: appsutil/sql/adgrants.sql
  inflating: appsutil/html/txkCtxInfReport.xsl
  inflating: appsutil/html/txkInventory.xml
  inflating: appsutil/html/txkDiagnostics.xml
  inflating: appsutil/html/txkMessages.xml
  inflating: appsutil/html/txkValObjMap.xml
  inflating: appsutil/html/cabo/images/swan/topTabADjoint.gif
  inflating: appsutil/html/cabo/images/swan/topDimTabL.gif
 extracting: appsutil/html/cabo/images/swan/topTabR.gif
  inflating: appsutil/html/cabo/images/swan/footerBg.gif
  inflating: appsutil/html/cabo/images/swan/topTabBg.gif
  inflating: appsutil/html/cabo/images/swan/topTabDDjoint.gif
  inflating: appsutil/html/cabo/images/swan/headerBg.jpg
  inflating: appsutil/html/cabo/images/swan/topTabDAjoint.gif
  inflating: appsutil/html/cabo/images/swan/navBarUnderTopTabsBg.gif
  inflating: appsutil/html/cabo/images/swan/topDimTabR.gif
  inflating: appsutil/html/cabo/images/swan/t.gif
  inflating: appsutil/html/cabo/images/swan/topTabL.gif
  inflating: appsutil/html/cabo/images/swan/topDimTabBg.gif
  inflating: appsutil/html/txkCtxInfTextReport.xsl
  inflating: appsutil/html/autoconfig_profile.xsl
  inflating: appsutil/html/ProcessCloneDef.xsl
  inflating: appsutil/html/txkValidate.xsl
[oracle@our12-dev 11.1.0]$ cd appsutil/scripts/
DEV_our12-dev/   PATCH_our12-dev/
[oracle@our12-dev 11.1.0]$ cd appsutil/scripts/PATCH_our12-dev/
[oracle@our12-dev PATCH_our12-dev]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oradata/PATCH/db/tech_st/11.1.0/ap                                                                                        psutil/log/PATCH_our12-dev/03171649/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /oradata/PATCH/db/tech_st/11.1.0
        Classpath                   : :/oradata/PATCH/db/tech_st/11.1.0/jdbc/lib                                                                                        /ojdbc6.jar:/oradata/PATCH/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/orad                                                                                        ata/PATCH/db/tech_st/11.1.0/appsutil/java:/oradata/PATCH/db/tech_st/11.1.0/jlib/                                                                                        netcfg.jar:/oradata/PATCH/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

        Using Context file          : /oradata/PATCH/db/tech_st/11.1.0/appsutil/                                                                                        PATCH_our12-dev.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oracle@our12-dev PATCH_our12-dev]$ perl adpreclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.2

Enter the APPS User Password:
Running:
perl /oradata/PATCH/db/tech_st/11.1.0/appsutil/bin/adclone.pl java=/oradata/PATC                                                                                        H/db/tech_st/11.1.0/appsutil/jre mode=stage stage=/oradata/PATCH/db/tech_st/11.1                                                                                        .0/appsutil/clone component=dbTier method=CUSTOM dbctx=/oradata/PATCH/db/tech_st                                                                                        /11.1.0/appsutil/PATCH_our12-dev.xml showProgress
APPS Password :

Beginning database tier Stage - Thu Mar 17 16:51:01 2011

/oradata/PATCH/db/tech_st/11.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDA                                                                                        TED=false  -Doracle.installer.oui_loc=/oradata/PATCH/db/tech_st/11.1.0/oui -clas                                                                                        spath /oradata/PATCH/db/tech_st/11.1.0/lib/xmlparserv2.jar:/oradata/PATCH/db/tec                                                                                        h_st/11.1.0/jdbc/lib/ojdbc6.jar:/oradata/PATCH/db/tech_st/11.1.0/appsutil/java:/                                                                                        oradata/PATCH/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/oradata/PATCH/db/tech                                                                                        _st/11.1.0/oui/jlib/ewt3.jar:/oradata/PATCH/db/tech_st/11.1.0/oui/jlib/share.jar                                                                                        :/oradata/PATCH/db/tech_st/11.1.0/oui/jlib/srvm.jar:/oradata/PATCH/db/tech_st/11                                                                                        .1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /oradata/PATCH/db/tec                                                                                        h_st/11.1.0/appsutil/PATCH_our12-dev.xml -stage /oradata/PATCH/db/tech_st/11.1.0                                                                                        /appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password :
Log file located at /oradata/PATCH/db/tech_st/11.1.0/appsutil/log/PATCH_our12-de                                                                                        v/StageDBTier_03171651.log

  /     50% completed

Completed Stage...
Thu Mar 17 16:51:16 2011
[oracle@our12-dev PATCH_our12-dev]$cd /oraapps/inst/apps/PATCH_our12-dev/admin/scripts
[oracle@our12-dev scripts]$perl adpreclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.2

Running:
perl /oraapps/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl java=/oraapps/apps/tech_st/10.1.3/appsutil/jdk mode=stage stage=/oraapps/apps/apps_st/comn/clone component=appsTier method= appctx=/oraapps/inst/apps/PATCH_our12-dev/appl/admin/PATCH_our12-dev.xml showProgress
APPS Password :
method defaulted to CUSTOM


Beginning application tier Stage - Thu Mar 17 16:59:03 2011

/oraapps/apps/tech_st/10.1.3/appsutil/jdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/oui -classpath /oraapps/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/oraapps/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/oraapps/apps/apps_st/comn/java/classes:/oraapps/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/oraapps/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/oraapps/apps/tech_st/10.1.3/oui/jlib/share.jar:/oraapps/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/oraapps/apps/tech_st/10.1.3/jlib/ojmisc.jar  oracle.apps.ad.clone.StageAppsTier -e /oraapps/inst/apps/PATCH_our12-dev/appl/admin/PATCH_our12-dev.xml -stage /oraapps/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM   -showProgress

Log file located at /oraapps/inst/apps/PATCH_our12-dev/admin/log/StageAppsTier_03171659.log

  /     80% completed

Completed Stage...
Thu Mar 17 16:59:20 2011
[oracle@our12-dev scripts]$cd /oradata/PATCH/db/tech_st/11.1.0
[oracle@our12-dev 11.1.0]$. PATCH_our12-dev.env
[oracle@our12-dev 11.1.0]$sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 17 16:59:49 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
You have new mail in /var/spool/mail/oracle
[oracle@our12-dev PATCH_our12-dev]$ lsnrctl stop PATCH

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 17-MAR-2011 17:00:19

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=our12-dev.bilt.com)(PORT=1544)))
The command completed successfully
[oracle@our12-dev 11.1.0]$

Copy source to target .

[oracle@our12-dev bin]$ perl adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Running:
/backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/java:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_32115.lst -stage /backup/PROD/db/tech_st/11.1.0/appsutil/clone  2> /tmp/adcfgclone_32115.err; echo $? > /tmp/adcfgclone_32115.res

Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0402075626.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [our12-dev] :

Target Instance is RAC (y/n) [n] :

Target System Database SID : PROD

Target System Base Directory : /backup/PROD

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [4] :

Target System DATA_TOP Directory 1 [/r03/oradata] : /oradata/PROD/r03/oradata

Target System DATA_TOP Directory 2 [/r02/oradata] : /backup/PROD/oradata

Target System DATA_TOP Directory 3 [/r04/oradata] : /oradata/PROD/r04/oradata

Target System DATA_TOP Directory 4 [/r01/oradata] : /oradata/PROD/r01/oradata

Target System RDBMS ORACLE_HOME Directory [/backup/PROD/db/tech_st/11.1.0] :

Do you want to preserve the Display [y] (y/n) ? : n

Target System Display [our12-dev:0.0] : y

Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 75

Checking the port pool 75
done: Port Pool 75 is free
Report file located at /backup/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /backup/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
  /backup/PROD/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
  /backup/PROD/db/tech_st/11.1.0/appsutil/PROD_our12-dev.xml

Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneConte
Check Clone Context logfile /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/Cl

Running Rapid Clone with command:
perl /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/backup/P                                                                                        /11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/backup/PROD/db/te
Running:
perl /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/backup/P                                                                                        /11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/backup/PROD/db/te
APPS Password :

Beginning database tier Apply - Sat Apr  2 07:58:20 2011

/backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCON                                                                                        spath /backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/backup                                                                                        psutil/clone/jlib/java:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/Or                                                                                        ROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/backup/PROD/db/tech_st/                                                                                        ib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /backup/PROD/db/tech_st/11.1                                                                                        howProgress
APPS Password : Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/log/
  -     15% completed
Completed Apply...
Sat Apr  2 08:03:06 2011

Starting database listener for PROD:
Running:
/backup/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_our12-dev/addlnctl.sh start PROD

You are running addlnctl.sh version 120.1.12010000.2

Logfile: /backup/PROD/db/tech_st/11.1.0/appsutil/log/PROD_our12-dev/addlnctl.txt

Starting listener process PROD ...


Listener PROD has already been started.


addlnctl.sh: exiting with status 0
[oracle@our12-dev bin]$cd /oraapps/PROD/apps/apps_st/comn/
[oracle@our12-dev bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Running:
/oraapps/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /oraapps/PROD/apps/apps_st/comn/clone/jlib/java:/oraapps/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /oraapps/PROD/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5889.lst -stage /oraapps/PROD/apps/apps_st/comn/clone  2> /tmp/adcfgclone_5889.err; echo $? > /tmp/adcfgclone_5889.res

Log file located at /oraapps/PROD/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [our12-dev] :

Target System Database SID : PROD

Target System Database Server Node [our12-dev] :

Target System Base Directory : /oraapps/PROD

Target System Tools ORACLE_HOME Directory [/oraapps/PROD/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/oraapps/PROD/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/oraapps/PROD/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/oraapps/PROD/apps/apps_st/comn] :

Target System Instance Home Directory [/oraapps/PROD/inst] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [enabled] :

Do you want to preserve the Display [y] (y/n) ? : n

Target System Display [our12-dev:0.0] : y

Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 75

Checking the port pool 75
done: Port Pool 75 is free
Report file located at /oraapps/PROD/inst/apps/PROD_our12-dev/admin/out/portpool.lst
Complete port information available at /oraapps/PROD/inst/apps/PROD_our12-dev/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /backup/PROD/db/tech_st/11.1.0/appsutil/outbound/PROD_our12-dev
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :

Creating the new APPL_TOP Context file from :
  /oraapps/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /oraapps/PROD/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml

Log file located at /oraapps/PROD/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log
Check Clone Context logfile /oraapps/PROD/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log for details.

Running Rapid Clone with command:
perl /oraapps/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/oraapps/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/oraapps/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/oraapps/PROD/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml showProgress contextValidated=true
Running:
perl /oraapps/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/oraapps/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/oraapps/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/oraapps/PROD/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml showProgress contextValidated=true
APPS Password :

Beginning application tier Apply - Sat Apr  2 08:13:37 2011

/oraapps/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /oraapps/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/java:/oraapps/PROD/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/oui/share.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/oraapps/PROD/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /oraapps/PROD/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml -stage /oraapps/PROD/apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /oraapps/PROD/inst/apps/PROD_our12-dev/admin/log/ApplyAppsTier_04020813.log
  \     89% completed

Completed Apply...
Sat Apr  2 08:20:10 2011

Starting application Services for PROD:
Running:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adstrtal.sh -nopromptmsg

You are running adstrtal.sh version 120.15

The logfile for this session is located at /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adstrtal.log
Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.6

Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_PROD.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adapcctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.13

Starting OPMN managed OACORE OC4J instance  ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adoacorectl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh  version 120.16

Starting OPMN managed FORMS OC4J instance  ...

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adformsctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adoafmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for PROD ...
Starting PROD_0402@PROD Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adcmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/ieo/ieoicsm.sh start
script returned:
****************************************************

You are running ieoicsm.sh version 120.6

Starting Oracle ICSM server ...

ieoicsm.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/oraapps/PROD/inst/apps/PROD_our12-dev/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /oraapps/PROD/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9375 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /oraapps/PROD/inst/apps/PROD_our12-dev/logs/appl/admin/log/adstrtal.log for more information ...

[oracle@our12-dev bin]$

01 April 2011

How to install or Register ttf font in Linux

[root@our12-test ~]# mkdir /usr/share/fonts/ttf/     copy your font file
[root@our12-test ~]# cd /usr/share/fonts/ttf/
[root@our12-test ~]# mkdir /usr/local/fonts/ttf/      copy your font file
[root@our12-test ~]# cd /usr/local/fonts/ttf/
[root@our12-test ttf]# ttmkfdir > fonts.scale
[root@our12-test ttf]# mkfontdir
[root@our12-test ttf]# chkfontpath -a /usr/share/fonts/ttf
[root@our12-test ttf]# vi /etc/X11/xfs/config    or   /etc/X11/fs/config
[root@our12-test ttf]# vi /etc/X11/fs/config
#
# Default font server configuration file for Red Hat Linux
#

# allow a max of 10 clients to connect to this font server
client-limit = 10

# when a font server reaches its limit, start up a new one
clone-self = on

# alternate font servers for clients to use
#alternate-servers = foo:7101,bar:7102

# where to look for fonts
#
catalogue = /usr/X11R6/lib/X11/fonts/misc:unscaled,
/usr/X11R6/lib/X11/fonts/75dpi:unscaled,
/usr/X11R6/lib/X11/fonts/100dpi:unscaled,
/usr/X11R6/lib/X11/fonts/Type1,
/usr/X11R6/lib/X11/fonts/Speedo,
/usr/share/fonts/default/Type1,
/usr/share/fonts/ttf,

# in 12 points, decipoints
default-point-size = 120

# 100 x 100 and 75 x 75
default-resolutions = 75,75,100,100

# use lazy loading on 16 bit (usually Asian) fonts
deferglyphs = 16

# how to log errors
use-syslog = on

# don't listen to TCP ports by default for security reasons
no-listen = tcp

[root@our12-test ttf]# chkfontpath -a /usr/share/fonts/ttf
chkfontpath: /usr/share/fonts/ttf already in list
[root@our12-test ttf]#