Home » RDBMS Server » Server Administration » not able to print if login as sqlplus username@RMSPRD (10.2.0.5 running on aix 6.1)
not able to print if login as sqlplus username@RMSPRD [message #569092] Fri, 19 October 2012 15:31 Go to next message
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
Re: not able to print if login as sqlplus username@RMSPRD [message #569111 is a reply to message #569092] Sat, 20 October 2012 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you are remotely logged you have (most often) no rights on the remote server directories/files (even if the remote server is the local one).

Regards
Michel

[Updated on: Sat, 20 October 2012 10:07]

Report message to a moderator

Re: not able to print if login as sqlplus username@RMSPRD [message #569207 is a reply to message #569111] Mon, 22 October 2012 13:57 Go to previous messageGo to next message
nghuman
Messages: 2
Registered: March 2011
Junior Member
I am trying the both ways on the local server. Please help me how I cna solve this issue.
Re: not able to print if login as sqlplus username@RMSPRD [message #569217 is a reply to message #569207] Tue, 23 October 2012 01:04 Go to previous message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect locally that is WITHOUT "@RMSPRD" and check Oracle has the appropriate privileges on the directory and file.

Regards
Michel
Previous Topic: about oracle memory
Next Topic: move file system datafile to asm?
Goto Forum:
  


Current Time: Fri Apr 18 17:20:50 CDT 2014

Total time taken to generate the page: 0.08402 seconds