calling reports
i am trying to call oracle 9i report through 9i forms but getting the error: REP-0503 YOU DID NOT SPECIFY THE NAME OF THE REPORT please help me and tell me the complete steps of calling the report through forms

Answer Question   |  April 28, 2008  8:01 PM
Oracle error messages, Oracle Forms, Oracle Reports

Build 09.00.3239.00 (cumulative update)
I just patched my servers to this build and noticed that the time used to ‘Delete files based on the age of the file at task run time’ within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed this with [...]

Answer Question   |  April 25, 2008  5:53 PM
Hot fixes, SQL Server 2005, upgrades and patches

connect sys as sysdba
how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as “sys as sysdba” i got the error. please give me a solution.

Answer Question   |  April 25, 2008  4:00 PM
connect sys as sysdba, iSQL*Plus, SYSDBA, TOAD

Oracle Query: Return a date eg 29 February 2008
Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

Answer Question   |  May 12, 2008  11:45 AM
Oracle, Query

Calling a report from form
Hello all We recently have migrated from oracle 6i to 9i DS. We have some forms which are calling a report. I have used the run_report_object() instead of run_product() in 9i. Previously the forms were displaying the reports properly. But I have re-installed the windows and oracle due to some problem after which my reports [...]

Answer Question   |  April 24, 2008  4:22 AM
Oracle 9i, Oracle error messages, Oracle Reports

Options available for implementing external account authentication with Windows AD with Oracle 10.2.0.3 on Linux
Scenario: Windows desktop user logs in to the Windows domain and is authenticated by Windows Active Directory. The same user then lauches a Citrix session to connect to an application running on a Windows Citrix server and is authenticated using Windows passthrough authentication. The application then connects to a remote Oracle 10.2.0.3 database on Linux [...]

Answer Question   |  April 23, 2008  5:17 PM
Active Directory, Linux, Oracle 10, Oracle 10.2.0.3, Oracle Internet Directory

BLOB Data move from Oracle 9i to Oracle 10g
I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

Answer Question   |  April 24, 2008  3:58 PM
BLOB, Database, ORA-00942, Oracle 10g, Oracle 9i

oar-01033
ORA-01033 and from I understand from reading posts..i’m to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I’ve tried several different usernames…but SYS should work as i’ve used this many many times in the past “as sysdba”. Does anyone know what to do [...]

Answer Question   |  April 21, 2008  8:21 AM
ORA-01031, ORA-01033, Oracle error messages, SQLPlus

ORACLE REAL APPLICATION CLUSTER
Hi to all In Oracle RAC what is menat by split brain syndrome ? What happens when it happens? I mean to say RAC database hangs or crashes ? thanks in advance

Answer Question   |  December 24, 2008  7:44 PM
Oracle administration, Oracle RAC

Subquery?
I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same. I have 3 tables. customer general customer detail location I have used a join to [...]

Answer Question   |  April 17, 2008  3:25 PM
Oracle, SQLPlus, Subquery

JDE World
How to write a credit memo. Are they made up of line types and doc types?

Answer Question   |  April 17, 2008  3:01 PM
JD Edwards (JDE), Oracle development

i need help urgently
hello fellow IT friends,i just installed oracle10g on window xp, and i cant seem to open my enterprise manager.am a new user of this software can someone help me?

Answer Question   |  April 17, 2008  4:13 PM
Oracle 10g, Oracle Enterprise Manager, Oracle installation

Calling a report from a form
Hello experts I hope you all are fine & enjoying good health. I am facing a problem after migration from oracle 6i to oracle 9i, I wonder if someone can help me in calling a report from a form. I have used RUN_REPORT_OBJECT instead of RUN_PRODUCT but I am getting error FRM-41214 unable to run [...]

Answer Question   |  March 5, 2009  4:07 AM
FRM-41213, FRM-41214, Oracle 9i, Oracle error messages, Oracle migration

ASM State in GMON Trace File
Oracle 10.2.0.3 RAC using ASM: Red Hat Enterprise 2.6.9.44 (RHEL 4.4) I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says “Member state = 4″. What’s a member state and [...]

Answer Question   |  April 14, 2008  2:39 PM
ASM, GMON, Oracle 10, Oracle administration, Red Hat Enterprise Linux

Truncate or not Truncate SQL
What are the pros/cons of truncate a table export/import to just drop table?

Answer Question   |  April 14, 2008  3:37 PM
PL/SQL, SQL

trying to install oracle 10g
I’M TRYING TO INSTALL ORACLE 1OG ON AN ACER 5520-5334 COMPUTER AND IT HAS BEEN GIVING ME A PARTICULAR ERROR ‘NO VALID DEVICES FOUND ……. etc. from my research it seemed like the versions of red hat os ( rhel 3.0,4.0) were not compatible with my computer. pls can any one give me advice on [...]

Answer Question   |  February 24, 2011  9:11 AM
Oracle 10g, Oracle error messages, Oracle installation, Red Hat Enterprise Linux

view color codes
Hello… i m beginner in lotus notes and would like to know how to change/set color code to particular row in the view based on formula or condition…?? For ex. if the column value is vacant i have to set green color for that entire row in the view. if the column value is occupied [...]

Answer Question   |  April 11, 2008  7:03 AM
Formula Language, Lotus Notes, Oracle Views

How to import .doc files into Oracle 10g
I am using Oracle 10g, and i have around 500 tables sitting in .doc file. How can i import those tables into Oracle 10g. Please help me out with this issue.

Answer Question   |  April 12, 2008  5:04 PM
Oracle 10g

Where does Oracle automatic backup create the backup file?
I have created one database through DBCA on Oracle 10.1.0.2.0 and choose automatic backup daily at 2 am. But I cannot see any backup that is done under Oracle flash recovery area. Does it create in any other place? No error message was found in alertlog. Any ideas?

Answer Question   |  September 9, 2011  3:18 PM
DBCA, Flash Recovery, Oracle 10, Oracle backup

Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560
Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560 – TNS Protocol Adapter error. In RMAN cmd file I’ve tried re-directing to OraHome with dev-oraclec$oracleora92 as well as directly to the mapped drive: Z:oracleora92. Both fail with same error. I also set TARGET_INIT_FILE to its’ location using the same redirect. Must I get [...]

Answer Question   |  April 10, 2008  3:08 PM
ORA-12560, Oracle 9, Oracle Recovery Manager, RMAN