Saturday, 24 January 2015

Oracle 10g/11g: Create database wallet

server705[/oracle/product/11.2.0/db/network/admin]>>cat sqlnet.ora
bequeath_detach=yes
WALLET_LOCATION =
   (SOURCE =
     (METHOD = FILE)
     (METHOD_DATA =
       (DIRECTORY = /oracle/product/11.2.0/db/network/admin)
     )
   )
server705[/oracle/product/11.2.0/db/network/admin]>>mkstore -wrl "/oracle/product/11.2.0/db/network/admin" -create
Oracle Secret Store Tool : Version 11.2.0.3.0 - Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.

Enter password:
Enter password again:
server705[/oracle/product/11.2.0/db/network/admin]>>
server705[/oracle/product/11.2.0/db/network/admin]>>
server705[/oracle/product/11.2.0/db/network/admin]>>
server705[/oracle/product/11.2.0/db/network/admin]>>ls -ltr
total 176
-rw-r--r--    1 oracle   dba             205 May 11 2011  shrept.lst
drwxr-xr-x    2 oracle   dba             256 Sep 23 2012  samples
-rw-r--r--    1 oracle   dba            7062 Sep 27 2012  tnsnames1209274PM4515.bak
-rw-r--r--    1 oracle   dba           11545 Jan 14 2014  tnsnames.ora_140114
-rw-r--r--    1 oracle   dba           11954 Jan 19 2014  tnsnames.ora_12052014
-rw-r--r--    1 oracle   dba           12130 Nov 12 14:13 tnsnames1411122PM1327.bak
-rw-r--r--    1 oracle   dba              20 Nov 12 14:13 sqlnet1411122PM1327.bak
-rw-r--r--    1 oracle   dba            1660 Nov 12 14:13 listener1411122PM1327.bak
-rw-r--r--    1 oracle   dba            1660 Dec 17 15:19 listener.ora
-rw-r--r--    1 oracle   dba           12942 Dec 17 15:36 tnsnames.ora
-rw-r--r--    1 oracle   dba             165 Jan 25 10:02 sqlnet.ora
-rw-------    1 oracle   dba            3512 Jan 25 10:04 ewallet.p12
-rw-------    1 oracle   dba            3589 Jan 25 10:04 cwallet.sso

server705[/oracle/product/11.2.0/db/network/admin]>>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Jan 25 10:06:57 2015

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


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

SQL> alter system set wallet open identified by  "pcard001";

System altered.

SQL>

Tuesday, 20 January 2015

How to find Applied/Present Patches, Mini Packsand Family Packs

SELECT a.application_name,
DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
patch_level
FROM apps.fnd_application_vl a, apps.fnd_product_installations b
WHERE a.application_id = b.application_id;

SELECT patch_name, patch_type, maint_pack_level, creation_date
FROM applsys.ad_applied_patches
ORDER BY creation_date DESC

Number of Visitors