not able to print if login as sqlplus username@RMSPRD [message #569092] |
Fri, 19 October 2012 15:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/02d072d9878f859e9bd7c572b4309382?s=64&d=mm&r=g) |
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
|
|
|
|
|
|