tag:blogger.com,1999:blog-13918898.post1651279329654897953..comments2023-07-20T05:42:53.557-07:00Comments on <img src="http://i.imgur.com/qRFcKXV.jpg"> Rick Upton's Grab Bag: Oracle Wallet and tracing didn't work when executed by cron jobsRick Uptonhttp://www.blogger.com/profile/08025570329489102114noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-13918898.post-41072350723365105562011-06-02T04:54:39.516-07:002011-06-02T04:54:39.516-07:00Hi Rich,
ewallet.p12,cwallet.sso also needs to ha...Hi Rich,<br /><br />ewallet.p12,cwallet.sso also needs to have read permission if the jobs are executed from different Os Id.<br /><br />Eg: Didnt worked:<br /><br />-rw------- 1 oracle oinstall 8280 Jun 01 16:20 ewallet.p12<br />-rw------- 1 oracle oinstall 8308 Jun 01 16:20 cwallet.sso<br /><br /><br />jobs ran from test OS id.<br /><br /> sqlplus /@test<br /><br />SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jun 2 12:42:35 2011<br /><br />Copyright (c) 1982, 2007, Oracle. All Rights Reserved.<br /><br />ERROR:<br />ORA-12534: TNS:operation not supported<br /><br /><br />Worked:<br /><br />total 56<br />-rwxr-xr-x 1 oracle oinstall 8280 Jun 01 16:20 ewallet.p12<br />-rwxr-xr-x 1 oracle oinstall 8308 Jun 01 16:20 cwallet.sso<br /><br /><br />$ sqlplus /@test<br /><br />SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jun 2 12:46:52 2011<br /><br />Copyright (c) 1982, 2007, Oracle. All Rights Reserved.<br /><br /><br />Connected to:<br />Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production<br />With the Partitioning, Data Mining and Real Application Testing options<br /><br />SQL> show user<br />USER is "TEST"mallihttps://www.blogger.com/profile/04647920393300701688noreply@blogger.com