Recent content by fayevalentine

Also I tried with new path outside of oracle install home: BDSID.LOG_ARCHIVE_DUPLEX_DEST= '/app/archive_log/dest0' with permissions: drwxr-xr-x. 3 oracle dba 4096 Nov 27 14:22 app SQL> STARTUP NOMOUNT PFILE='/oracle/product/11.2.0/dbhome_2/dbs/pfileBDSID.ora'; ORACLE instance started...

Hello Beilstwh Thank you very much these were the folder permissions: [oracle@machinedb dbs]$ ls -la /oracle/log_archive/ total 136 drwxr-xr-x. 34 oracle oinstall 4096 Nov 25 12:53 . drwxr-xr-x. 8 oracle oinstall 4096 Nov 26 13:18 .. drwxr-xr-x. 2 oracle oinstall 4096 Nov 25 12:52 dest0...

Hello Trying to restore an Oracle 11g database in linux I get this message: ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified These are the steps I do: SQL> STARTUP NOMOUNT PFILE='/oracle/product/11.2.0/dbhome_1/dbs/pfileEMR.ora'; ORACLE instance started. Total...

Hello again, I am having trouble with a functionality in my java web application using PrimeFaces, I hope someone can guide me. I launch a query in an Oracle database when I click a button (this query can last a little based in a date range the user selects) so I have more or less this code...

Hello, everyone, I hope you have the patient to read my problem. Any advice would be greatly appreciated, thanks in advance. I want to create a report in a java web application with primefaces, deployed in Glassfish v4.0, I use poi-3.10 library to write to Excel File. My query is very simple...

Hi, here is my problem I have a folder under user1 home directory /home/user1/wanttosharefolder I created a group called 'histo' I added user1 and user2 to group 'histo' usermod -a -G histo user1 usermod -a -G histo user2 I changed permissions to whattosharefolder (this folder was...

Hello Dian My query is also very slow because I make several UNIONs it takes between 30 and 40 minutes, I make JDBC connection but I think the result is not that big, The code above sometimes give me OutOfMemory Error when it is creating excel file but sometimes not. Right now I am trying with...

Hello, I am trying to generate an excel file with POI Library, so far here is a piece of code, I get about 150,000 registers between 2 dates FileInputStream fis = new FileInputStream(new File(my_template)); XSSFWorkbook workbook = new XSSFWorkbook (fis)...

HI I find a posible solution I find this instruction select id_episode, listagg(nvl(name,'noname'), '|' ) within group (order by name) as names from opinion where id_episode = 1 group by id_episode order by id_episode this returns: id_episode names 1 john|mary|noname This...

Hello I have my select statement returns something like this: id episode name 1 1 john 2 1 mary 3 1 null is it posible get a result like this? episode 1 john mary null I have tried with pivot but with I need an aggregate function which I do not use, can...

Thank you very much, yes, I did what taupirho suggested. It was a very simple solution but I was stucked and didn't see it.

Hi I have a little problem with this query, I want to know if it is the first time something happen, so I use OVER instruction, but inside my application I could insert a date range and my query just count the data selected and I have to count all table: example date event result...

hi blacktom this is a part of the Synthesis Report from ISE Foundation: -------------------------------------------------------------------------- Device utilization summary: --------------------------- Selected Device : 5vlx85ff676-2 (a Virtex-5 device :) ) Slice Logic Utilization: Number...

Hi guys! This is my issue, I have a module with 8 entries, up to four can be high level, but I do not know which ones, so I use a loop for to look for them, activating the outputs, this works for me but sinthesizing uses many resources. (I am using Xilinx software) Is there a way to do this...

Thanks ZasTer I suppose we can not see the usb because of when I insert my usb memory, the led does not turn on. unfortunately my laptop is HP, so its BIOS is very simple and does not have many options. I am triying recompiling the newest kernel, I hope this can help me, besides I am checking...