Monday, 2 March 2015

Windows 7 as a Wireless Access Point netsh

netsh wlan stop hostednetwork
netsh wlan set hostednetwork mode=allow ssid=SomeSSID key=11111111
netsh wlan start hostednetwork

Tuesday, 24 February 2015

Saturday, 21 February 2015

LRM-00116: syntax error at ')' following

Cause of The Problem:
------------------------------------------------
double quotes ("), single quotes (') parentheses () are termed as special character on unix system. To know the list of special character on unix please have a look at Special Character on Unix. In order to use specual character on unix you have to use escape characters. How you can use escape character are discussed on How does one escape special characters.
If you don't use escape characters while using special character above error will arise.

Solution of The problem:
---------------------------------
Use escape character before using special character. Like in stead of using
expdp system/manager DUMPFILE=PWR19JAN.dmp  LOGFILE=expPWR19JAN.log DIRECTORY=DUMPS INCLUDE=TABLE:"in(SELECT t FROM tlist)"

Use,
expdp system/manager DUMPFILE=PWR19JAN.dmp  LOGFILE=expPWR19JAN.log DIRECTORY=DUMPS INCLUDE=TABLE:\"in\(SELECT t FROM tlist\)\"

AIX chfs change filesystem size

chfs -a size=3G /home
chfs -a size=3000M /home
chfs -a size=+1G /home
chfs -a size=+500M /home

Tuesday, 17 February 2015

Oracle: Grant view without execute permission on package source

1-  grant debug any procedure to scott; -- The user will be able to see all objects in all schemas

2- grant select on dba_source; 

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