ERPstuff - Oracle EBS Community

Dear,

I run the script individually, the error occured

dbora: execvp: no such file or directory
rc: starting dbora: failed.

any help?

Thanks,

hi,

when i direct run the script

etc/init.d/dbora

then error occured no such file or directory? but root have the 755 permissions on the script dbora.

some time usb external hard disk double icon show on linux desktop. like usbdisk, usbdisk1, usbdisk2 etc. but in actual there is only one external harddisk attached with system.

if anyone have any idea, kindly help me.

no such file exist in the location
/etc/sysconfig/

Thanks,

Dear Amir,

My database version is 10g 2.0 and I already perfomed all the steps like you mentioned.

but after all this error occured:

dbora: execvp : no such file or directory exist.
rs: starting dbora: failed.


Here is my script dbora:

#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto ...

How can we automate database startup shutdown on linux reboot?

Dear,

I am unable to understand your question. Plz give some detail about your question.

Thanks,
Farooq

Hi,

I have a task to move Oracle report data directly to Excel sheet.

If anyone have idea or information about it then kindly guide me.

Thanks,
Farooq

Suppose you have table1, in which you have invoice_no column.

Now you want to show invoice_no,srno .....if i m right then
write the following query to acheive the result.

SELECT INVOICE_NO,ROW_NUMBER() OVER (PARTITION BY INVOICE_NO ORDER BY ROWNUM) SRNO
FROM TABLE1

I Think you got the desired ...

IF YOU WANT TO EXTRACT DATES OF ALL SATURDAYS AND SUNDAYS BETWEEN TWO DATES THEN EXECUTE THE FOLLOWING QUERY TO FIND RESULTS:
-----------------------------------------------------------------------
SELECT D DAY,DT DATE1 FROM (
SELECT UPPER(TRIM(TO_CHAR(TO_DATE(:FDATE)+ROWNUM-1,'DAY'))) D,TO_DATE ...

SELECT SUM(TOT_SUNDAY) TOT_SUNDAY,
SUM(TOT_SATURDAY) TOT_SATURDAY
FROM (
-----------------
SELECT COUNT(*) TOT_SUNDAY,0 AS TOT_SATURDAY FROM (
SELECT UPPER(TRIM(TO_CHAR(TO_DATE(:FDATE)+ROWNUM-1,'DAY'))) D
FROM ALL_OBJECTS WHERE TO_DATE(:FDATE)+ROWNUM-1 BETWEEN
TO_DATE(:FDATE) AND TO_DATE(:TDATE ...

SELECT SUBSTR(Column_Name,1,INSTRB(Column_Name,'-',1,2)-1) FROM table

I think it solve ur problem.

Pray for me.
Farooq