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\)\"
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";
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