not able to print if login as sqlplus username@RMSPRD [message #569092] |
Fri, 19 October 2012 15:31 |
|
nghuman
Messages: 2 Registered: March 2011
|
Junior Member |
|
|
We have a customized form to print some orders. I am able to run this package without any error if I login using
sqlplus
username
password
but it doesn't work with
sqlplus username@RMSPRD
Password
dbrmsproddb:/app/oracle/product/10.2.0/network/admin $ sqlplus nghuman@RMSPRD
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 16 15:29:56 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec run_unix_cmd('/usr/bin/lpstat 2> /tmp/lptst3.txt');
PL/SQL procedure successfully completed.
SQL> !cat /tmp/lptst3.txt
enq: (FATAL ERROR): 0781-167 Could not get process credentials. Errno = 2.
enq: errno = 2: A file or directory in the path name does not exist.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
dbrmsproddb:/app/oracle/product/10.2.0/network/admin $ sqlplus
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 16 15:33:32 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter user-name: nghuman
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec run_unix_cmd('/usr/bin/lpstat 2> /tmp/lptst3.txt');
PL/SQL procedure successfully completed.
SQL> !cat /tmp/lptst3.txt
|
|
|
|
|
|