Tuesday, January 23, 2018

Application Tier code level checker

Source you App environment

checkMTpatch.sh

 +===============================================================+ 
 |    Copyright (c) 2005, 2016 Oracle and/or its affiliates.     | 
 |                     All rights reserved.                      | 
 |             Oracle E-Business Suite Release 12.2              | 
 |        Applicatione Tier Technology Codelevel Checker         | 
 +===============================================================+ 

Using context file from currently set applications environment:
/apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/appl/admin/VIS_suthakar.xml

Starting Application Tier Technology Codelevel Checker 
Version: 120.0.12020000.32.
Tue Jan 23 11:30:13 EST 2018
Log file for this session: /scratch/r12patch/checkMTpatch_12087.log

Bugfix XML file version: 120.0.12020000.33
This file will be used for identifying missing bugfixes. 

Mapping XML file version: 120.0.12020000.18
This file will be used for mapping bugfixes to patches.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user: 
Connecting to database. 
Database connection successful.
The installed AD.C codelevel does not support storing the results in the database.

===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.

Oracle Home = /apps2/oracle/product/fs1/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
  Missing Bugfix: 17353142  ->  Patch 25768948
  Missing Bugfix: 20643256  ->  Patch 25768948
  Missing Bugfix: 16041055  ->  Patch 25768948
  Missing Bugfix: 16910762  ->  Patch 25768948
  Missing Bugfix: 20270659  ->  Patch 25768948
  Missing Bugfix: 17372642  ->  Patch 25768948
  Missing Bugfix: 17566694  ->  Patch 25768948
  Missing Bugfix: 20240480  ->  Patch 25768948
  Missing Bugfix: 19304738  ->  Patch 25768948
  Missing Bugfix: 20391574  ->  Patch 25768948
  Missing Bugfix: 22351071  ->  Patch 25768948
  Missing Bugfix: 21024122  ->  Patch 25768948
  Missing Bugfix: 19588847  ->  Patch 25768948
  Missing Bugfix: 19639173  ->  Patch 25768948
  Missing Bugfix: 20545718  ->  Patch 25768948
  Missing Bugfix: 22524329  ->  Patch 25768948
  Missing Bugfix: 23123655  ->  Patch 25768948
  Missing Bugfix: 23728755  ->  Patch 25768948
  Missing Bugfix: 24315226  ->  Patch 25768948
  Missing Bugfix: 24480018  ->  Patch 25768948
  Missing Bugfix: 24808044  ->  Patch 25768948
  Missing Bugfix: 24620875  ->  Patch 25768948
  Missing Bugfix: 25355211  ->  Patch 25768948
  Missing Bugfix: 23538157  ->  Patch 25768948
  Missing Bugfix: 23538170  ->  Patch 25768948
  Missing Bugfix: 13557392  ->  Patch 25768948
  Missing Bugfix: 25506193  ->  Patch 25768948
The above list shows missing bugfixes for Oracle Forms and Reports.

Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.

===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home = /apps2/oracle/product/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
  Missing Bugfix: 21300463  ->  Patch 22288381
  Missing Bugfix: 21892015  ->  Patch 22288381
The above list shows missing bugfixes for FMW - Web Tier.

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web tier.

===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

Oracle Home = /apps2/oracle/product/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
  Missing Bugfix: 9905685  ->  Patch 9905685
  Missing Bugfix: 17428617  ->  Patch 17428617
  Missing Bugfix: 21366277  ->  Patch 21366277
  Missing Bugfix: 21628307  ->  Patch 21628307
  Missing Bugfix: 24606362  ->  Patch 24606362
  Missing Bugfix: 24843064  ->  Patch 24843064
The above list shows missing bugfixes for FMW - oracle common.

===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).

Oracle Home = /apps2/oracle/product/fs1/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.
  Missing Patch ID: 23743997
The above list shows missing patches for Oracle WebLogic Server. 
If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed. 
Contact Oracle Support if you require assistance in determining whether this is the case.

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

Generating Patch Recommendation Summary.

===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------
Oracle Forms and Reports 10.1.2.3.0
-------------------------------------------------------------------------------
  Patch 25768948
    - Filename: p25768948_101232_LINUX.zip


-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
  Patch 22288381
    - Filename: p22288381_111190_Generic.zip


-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
  Patch 9905685
    - Filename: p9905685_111190_Generic.zip

  Patch 17428617
    - Filename: p17428617_111190_Generic.zip

  Patch 21366277
    - Filename: p21366277_111190_Generic.zip

  Patch 21628307
    - Filename: p21628307_111190_Generic.zip

  Patch 24606362
    - Filename: p24606362_111190_Generic.zip

  Patch 24843064
    - Filename: p24843064_111190_Generic.zip


-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]
    - Filename: p23743997_1036_Generic.zip


Apply the required patches and rerun this script. 

+-----------------------------------------------------------------------------+
A consolidated zip file with the required application tier patches is
available on My Oracle Support via:

  Patch 26821047
    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR OCT 2017

+-----------------------------------------------------------------------------+
[WARNING]  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing. 
This is the recommended minimum WLS patch set.
You should install it now, and then rerun this script to check for any
further fixes available.
+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions regarding these patches.
Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.
Tue Jan 23 11:30:35 EST 2018

Log file for this session: /scratch/r12patch/checkMTpatch_12087.log

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

oracle@suthakar$

Monday, January 22, 2018

checkDBpatch.sh will tell you Database EBS Technology Codelevel

checkDBpatch.sh

 +===============================================================+ 
 |    Copyright (c) 2005, 2017 Oracle and/or its affiliates.     | 
 |                     All rights reserved.                      | 
 |             Oracle E-Business Suite Release 12.2              | 
 |          Database EBS Technology Codelevel Checker            | 
 +===============================================================+ 

Using context file from currently set database environment:
/apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml

Starting Database EBS Technology Codelevel Checker, Version 120.55 
Mon Jan 22 12:01:40 EST 2018
Log file for this session : ./checkDBpatch_15647.log

Bugfix XML file version: 120.0.12020000.39
This file will be used for identifying missing bugfixes. 

Mapping XML file version: 120.0.12020000.12
This file will be used for mapping bugfixes to patches.


[WARNING] DB-ETCC: Bugfix XML file (./txk_R1220_DB_base_bugs.xml) in current directory is more than 30 days old.
 Check if a newer version is available in patch 17537119.

Identifying database release. 
Database release set to 12.1.0.2.

Connecting to database. 
Database connection successful. 

Database VIS is in READ WRITE mode.

Identifying APPS and APPLSYS schema names. 
 - APPS schema : APPS
 - APPLSYS schema : APPLSYS

Checking for DB-ETCC results table. 
Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled. 
InMemory option is not enabled in the database.

Checking Bugfix XML file for 12.1.0.2

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

  Missing Bugfix: 14666816  ->  Patch 26635276
  Missing Bugfix: 18793246  ->  Patch 18793246
  Missing Bugfix: 19239846  ->  Patch 26794113
  Missing Bugfix: 19591608  ->  Patch 19591608
  Missing Bugfix: 20627866  ->  Patch 26794113
  Missing Bugfix: 20766180  ->  Patch 20766180
  Missing Bugfix: 20868862  ->  Patch 26635276
  Missing Bugfix: 21099502  ->  Patch 25967939
  Missing Bugfix: 21028698  ->  Patch 22098146
  Missing Bugfix: 21106027  ->  Patch 26794113
  Missing Bugfix: 21321429  ->  Patch 21321429
  Missing Bugfix: 21387964  ->  Patch 26794113
  Missing Bugfix: 21614112  ->  Patch 25967939
  Missing Bugfix: 21751519  ->  Patch 26635276
  Missing Bugfix: 21813400  ->  Patch 26794113
  Missing Bugfix: 21864513  ->  Patch 21864513
  Missing Bugfix: 21904072  ->  Patch 21904072
  Missing Bugfix: 21967332  ->  Patch 21967332
  Missing Bugfix: 22024071  ->  Patch 26794113
  Missing Bugfix: 22229581  ->  Patch 26635276
  Missing Bugfix: 22452653  ->  Patch 26635276
  Missing Bugfix: 22496904  ->  Patch 22496904
  Missing Bugfix: 22568797  ->  Patch 26794113
  Missing Bugfix: 22660003  ->  Patch 25967939
  Missing Bugfix: 22666802  ->  Patch 26794113
  Missing Bugfix: 22731026  ->  Patch 22731026
  Missing Bugfix: 22737974  ->  Patch 26635276
  Missing Bugfix: 23089357  ->  Patch 23089357
  Missing Bugfix: 23220453  ->  Patch 26794113
  Missing Bugfix: 23604553  ->  Patch 26635276
  Missing Bugfix: 23632545  ->  Patch 26794113
  Missing Bugfix: 23645516  ->  Patch 26794113
  Missing Bugfix: 24326444  ->  Patch 26794113
  Missing Bugfix: 24385983  ->  Patch 26794113
  Missing Bugfix: 24560906  ->  Patch 24560906
  Missing Bugfix: 24589081  ->  Patch 26794113
  Missing Bugfix: 25099339  ->  Patch 26794113
  Missing Bugfix: 25139545  ->  Patch 26635276
  Missing Bugfix: 25643931  ->  Patch 25643931
  Missing Bugfix: 25906117  ->  Patch 25906117
  Missing Bugfix: 25971286  ->  Patch 26794113
  Missing Bugfix: 25919622  ->  Patch 26794113
  Missing Bugfix: 25995938  ->  Patch 25995938
  Missing Bugfix: 26658759  ->  Patch 26794113

Generating Patch Recommendation Summary.

===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2  (No PSU applied)
-------------------------------------------------------------------------------
  Patch 26635276
    - Filename: p26635276_121020_Linux-x86-64.zip

  Patch 18793246
    - Filename: p18793246_121020_Generic.zip

  Patch 26794113
    - Filename: p26794113_121020_Linux-x86-64.zip

  Patch 19591608
    - Filename: p19591608_121020_Linux-x86-64.zip

  Patch 20766180
    - Filename: p20766180_121020_Generic.zip

  Patch 25967939
    - Filename: p25967939_121020_Linux-x86-64.zip

  Patch 22098146
    - Filename: p22098146_121020_Linux-x86-64.zip

  Patch 21321429
    - Filename: p21321429_121020_Generic.zip

  Patch 21864513
    - Filename: p21864513_121020_Linux-x86-64.zip

  Patch 21904072
    - Filename: p21904072_121020_Linux-x86-64.zip

  Patch 21967332
    - Filename: p21967332_121020_Linux-x86-64.zip

  Patch 22496904
    - Filename: p22496904_121020_Linux-x86-64.zip

  Patch 22731026
    - Filename: p22731026_121020_Generic.zip

  Patch 23089357
    - Filename: p23089357_121020_Linux-x86-64.zip

  Patch 24560906
    - Filename: p24560906_121020_Linux-x86-64.zip

  Patch 25643931
    - Filename: p25643931_121020_Linux-x86-64.zip

  Patch 25906117
    - Filename: p25906117_121020_Linux-x86-64.zip

  Patch 25995938
    - Filename: p25995938_121020_Linux-x86-64.zip


Apply the required patches and rerun this script

You should check the patch READMEs for minimum opatch version requirements.
The latest opatch is available from My Oracle Support via Patch 6880880.


+-----------------------------------------------------------------------------+
A consolidated zip file with the required patches for Database release
12.1.0.2.0 is available on My Oracle Support via:

  Patch 26821046 [12.1.0.2.0 version]
    - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR OCT 2017

Note: This zip does not include any database bundle patches or PSUs.
+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions for these patches.
Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Stored Technology Codelevel Checker results in the database VIS successfully.

Finished checking fixes for Oracle Database: Mon Jan 22 12:01:53 EST 2018

Log file for this session: ./checkDBpatch_15647.log

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

oracle@suthakar$

R12.2 Latest AD and TXK Release

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

Tuesday, January 16, 2018

How to move space from one volume to another volume in oracle linux

[root@suthakar ~]# lvs
  LV         VG          Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  LogVol12   vg_suthakar -wi-ao----  58.59g                                                    
  lv_apps    vg_suthakar -wi-ao---- 195.31g                                                    
  lv_apps2   vg_suthakar -wi-ao---- 390.62g                                                    
  lv_home    vg_suthakar -wi-ao----  19.53g                                                    
  lv_local   vg_suthakar -wi-ao----  19.53g                                                    
  lv_opt     vg_suthakar -wi-ao----  19.53g                                                    
  lv_orafra  vg_suthakar -wi-ao---- 341.80g                                                    
  lv_ordata  vg_suthakar -wi-ao---- 341.80g                                                    
  lv_scratch vg_suthakar -wi-ao---- 427.80g                                                    
  lv_swap    vg_suthakar -wi-ao----  15.74g                                                    
  lv_swap1   vg_suthakar -wi-ao----   9.77g                                                    
  lv_tmp     vg_suthakar -wi-ao----   1.95g                                                    
  lv_var     vg_suthakar -wi-ao----  19.53g                                                    

umount /dev/mapper/vg_suthakar-lv_orafra
fsck -f  /dev/mapper/vg_suthakar-lv_orafra
resize2fs /dev/mapper/vg_suthakar-lv_orafra 300G
lvreduce -L -37G /dev/mapper/vg_suthakar-lv_orafra
mount /dev/mapper/vg_suthakar-lv_orafra
--
lvextend -L +37G /dev/mapper/vg_suthakar-lv_tmp
resize2fs /dev/mapper/vg_suthakar-lv_tmp

[root@suthakar ~]# lvs
  LV         VG          Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  LogVol12   vg_suthakar -wi-ao----  58.59g                                                    
  lv_apps    vg_suthakar -wi-ao---- 195.31g                                                    
  lv_apps2   vg_suthakar -wi-ao---- 390.62g                                                    
  lv_home    vg_suthakar -wi-ao----  19.53g                                                    
  lv_local   vg_suthakar -wi-ao----  19.53g                                                    
  lv_opt     vg_suthakar -wi-ao----  19.53g                                                    
  lv_orafra  vg_suthakar -wi-ao---- 304.80g                                                    
  lv_ordata  vg_suthakar -wi-ao---- 341.80g                                                    
  lv_scratch vg_suthakar -wi-ao---- 427.80g                                                    
  lv_swap    vg_suthakar -wi-ao----  15.74g                                                    
  lv_swap1   vg_suthakar -wi-ao----   9.77g                                                    
  lv_tmp     vg_suthakar -wi-ao----  38.95g                                                    
  lv_var     vg_suthakar -wi-ao----  19.53g        

Thursday, January 11, 2018

ADOP FSCLONE ERROR

adop phase=fs_clone.


Running /apps2/oracle/product/fs1/FMW_Home/oracle_common/bin/copyBinary.sh -javaHome /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/t2pjdk -al /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -smw /apps2/oracle/product/fs1/FMW_Home -ldl /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/logs -invPtrLoc /etc/oraInst.loc -silent true
Script Executed in 25117 milliseconds, returning status 255

Script failed, exit code 255

cd /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/logs
-rw-r-----. 1 oracle oinstall  1267 Jan 10 20:49 CLONE2018-01-10_20-49-02_362188416.error
-rw-r-----. 1 oracle oinstall 68055 Jan 10 20:49 CLONE2018-01-10_20-49-02_362188416.log


SEVERE : Jan 10, 2018 20:49:27 - ERROR - CLONE-20275   Insufficient space to create /tmp/CLONINGCLIENT-3018746357063923167.


Minimum required space was at least "2,343" MB, but only "1,922" MB was available for use.

Wednesday, January 10, 2018

Oracle Directory Integration Platform Using the dipStatus Utility

oracle@suthakar$pwd
/apps/oracle/product/fmw_oid/idm/bin
oracle@suthakar$

./dipStatus -h suthakar.prince -p 7005 -D weblogic
Picked up _JAVA_OPTIONS: -Xms512m -Xmx1024m
[Weblogic user password]
Connection parameters initialized.
Connecting at xxx.xxx:7005, with userid "weblogic"..
Connected successfully.

ODIP Application is active at this host and port.

Tuesday, January 9, 2018

R12.2.0.7 DB Clone

1 .DBTier Clone


DBTier
=====
/apps2/oracle/product/12.1.0/appsutil/scripts/VIS_suthakar

perl adpreclone.pl dbTier apps

                     Copyright (c) 2011, 2014 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.18

Enter the APPS User Password:
Running:
perl /apps2/oracle/product/12.1.0/appsutil/bin/adclone.pl java=/apps2/oracle/product/12.1.0/appsutil/jre mode=stage stage=/apps2/oracle/product/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml showProgress


Beginning database tier Stage - Tue Jan  9 20:11:57 2018

/apps2/oracle/product/12.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/apps2/oracle/product/12.1.0/oui -classpath /apps2/oracle/product/12.1.0/lib/xmlparserv2.jar:/apps2/oracle/product/12.1.0/jdbc/lib/ojdbc6.jar:/apps2/oracle/product/12.1.0/appsutil/java:/apps2/oracle/product/12.1.0/oui/jlib/OraInstaller.jar:/apps2/oracle/product/12.1.0/oui/jlib/ewt3.jar:/apps2/oracle/product/12.1.0/oui/jlib/share.jar:/apps2/oracle/product/12.1.0/oui/jlib/srvm.jar:/apps2/oracle/product/12.1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml -stage /apps2/oracle/product/12.1.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password :
Log file located at /apps2/oracle/product/12.1.0/appsutil/log/VIS_suthakar/StageDBTier_01092011.log

  /     50% completed

Completed Stage...
Tue Jan  9 20:12:18 2018
oracle@suthakar$



getConnection() -->
    sDbHost    : suthakar
    sDbDomain  : prince
    sDbPort    : 1525
    sDbSid     : VIS
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@suthakar.prince:1525:VIS
    Connection obtained

-------------------ADX Database Utility Finished---------------


Zip2 - Completed native zipping sh -c "cd /apps2/oracle/product/12.1.0/appsutil/out/VIS_suthakar/; zip  -q  -y /apps2/oracle/product/12.1.0/appsutil/clone/data/stage/adcrdb.zip -@ ; echo ERRORCODE = $? ERRORCODE_END"
Done...

END: Calling StageDatabase...


#############################################################
StageDBTier Finished at Tue Jan 09 20:12:15 EST 2018
Status: Completed Successfully
#############################################################

/apps2/oracle/product/12.1.0/appsutil
oracle@suthakar$ls -ltr
total 108
drwxr-xr-x.  6 oracle oinstall  4096 Mar  1  2013 jre
drwxr-xr-x.  2 oracle oinstall  4096 Dec 29  2015 sql
drwxr-xr-x.  3 oracle oinstall  4096 Dec 29  2015 java
drwxr-xr-x.  2 oracle oinstall  4096 Dec 29  2015 media
drwxr-xr-x.  4 oracle oinstall  4096 Dec 29  2015 perl
drwxr-xr-x.  3 oracle oinstall  4096 Dec 29  2015 html
drwxr-xr-x.  2 oracle oinstall  4096 Dec 29  2015 bin
drwxr-xr-x.  2 oracle oinstall  4096 Dec 27 09:19 temp
-rw-r--r--.  1 oracle oinstall 26452 Dec 27 09:20 conf_VIS.txt
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 09:23 log
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 10:20 outbound
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 10:20 scripts
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 10:20 install
-rw-r--r--.  1 oracle oinstall 14349 Dec 27 10:22 VIS_suthakar.xml
drwxr-xr-x.  4 oracle oinstall  4096 Jan  9 20:12 out
drwxr-x---.  2 oracle oinstall  4096 Jan  9 20:12 driver
drwxr-xr-x. 10 oracle oinstall  4096 Jan  9 20:12 clone
drwxr-xr-x.  2 oracle oinstall  4096 Jan  9 20:12 template
oracle@suthakar$ls -l clone
total 32
drwxr-x---. 2 oracle oinstall 4096 Jan  9 20:12 bin
drwxr-x---. 3 oracle oinstall 4096 Jan  9 20:11 context
drwxr-x---. 5 oracle oinstall 4096 Jan  9 20:12 data
drwxr-x---. 5 oracle oinstall 4096 Jan  9 20:12 dbts
drwxr-x---. 2 oracle oinstall 4096 Jan  9 20:11 html
drwxr-x---. 4 oracle oinstall 4096 Jan  9 20:12 jlib
drwxr-x---. 6 oracle oinstall 4096 Jan  9 20:12 jre
drwxr-x---. 3 oracle oinstall 4096 Jan  9 20:12 oui
oracle@suthakar$