is it because we deleted extproc from a listener.ora?
It might be a permission problem - did you grant the appropriate Java permission to the schema owner ?
Also, check for messages in your trace file. Log in to SYS or any user that has DBA privileges and -
Then change to the directory (specified in the VALUE column) and check if there are any "*.trc" files generated after you run your anonymous PL/SQL block. It should tell you what's wrong.
If there are no "trc" files then we really don't know that it is running.
Hello again,
I would like to know if the following commands:
diag, errpt, lscfg, lspv, lsvg, lsps, lslv for AIX and
prtdiag, psrinfo, sysdef for SUN are native to these systems or if they are in fact scripts that are added after the unix installation.
Thank you in advance.
Have a nice day (4 Replies)
I have created 3 Procedures all similar to this one:
I then created 3 shell sripts which will call the sql? finally created a calling script to call the procedure. I am a bit unsure how to this all works, can someone check my code and I am doing this right? Also could I add my procedure (first... (0 Replies)
if ( system ("/bin/cat $File1 >> $File2") ) {
print("#WARNING RAISED : /bin/cat File1 >> File2 - FAILURE!\n"); } I came across this code, would appreciate if someone can tell me if my understanding is correct?
the perl code tell the system to cat file 1 into file 2, if command fails, print... (4 Replies)
hai,
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
by,
leo (2 Replies)
Hi,
I have just started off with the shell programming.
I need to execute a GDB command from a shell script. I have been trying to get this working from quite sometime but not getting it quite right.I have this specific requirement that i read byte data from a file and write that data to the... (0 Replies)
hi Guys,
I am planning to write a program which can be able to execute scripts/commands which needs a user to be root.
Note: we are not interested to use sudoers option.
.e.g. The requirement can be explaind as:
A normal UNIX system user cannot execute above command(veritas cluster... (3 Replies)
Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
i have four commands
1. perl -MCPAN -e shell
2. o conf prerequisites_policy follow
3. o conf commit
4. exit
I am attempting to streamline a bunch of yum commands and cpan installations and want to remove the confirmation portion of the cpan these four commands will do just that. my... (2 Replies)
Hi,
I am not able to run below command on linux, it however works on solaris. If anyone knows the reason and a solution for it can you please let me know ?
Linux
-----
$> ksh 'echo hi'
ksh: echo hi: No such file or directory
$> which ksh
/usr/bin/ksh
Solaris
------
$> ksh 'echo... (2 Replies)