ORA-12801 and ORA-01008 when running Oracle Reports
When I run the report from report builder I get following error ORA-12801: error signaled in parallel query server P001, instance db12:testdb(2) ORA-01008: Not all variables bound Any idea what could be the problem? Database is Oracle 10g.

Answer Question   |  July 16, 2008  3:45 PM
ORA-01008, ORA-12801, Oracle 10g, Oracle error messages, Oracle Reports

WIN2003 or redhat linux which is the best for oracle e-business
dear what will be better for oracle e-business linux or win2003 … here we face problem for linux professionals but can easly get win professional.. but at the same time we are thinking for security and stability etc.. we are new to linux but have experience on win2003.. plz share your experience good or bad [...]

Answer Question   |  March 17, 2009  3:14 PM
Oracle E-Business Suite, Red Hat Linux, Windows Server 2003

In DBCA, Its not Showing all the database in the list
In DBCA, After selecting the ” ORACLE SINGLE INSTANCE DATABASE” and Click next Button, There In list of Available database its not Showing all the database in that server Please let me know where we specify those database name to be picked by DBCA, I have checked in TNSNAMES.ora & LISTENER.ora but no Success..

Answer Question   |  January 26, 2011  6:17 AM
DBCA, LISTENER.ora, Oracle database availability, TNSNAMES.ora

export data based on date
Hi i’m new to oracle how can i use the export command to export data based on date and subsequenly purge the data exported from the database? Thanks for any info

Answer Question   |  August 23, 2008  3:55 AM
Oracle export, Oracle import/export

Getting the number of a row from a flat file source in SQL
How might I get the number of a row from a flat file source with a script component in SQL?

Answer Question   |  July 15, 2008  6:42 PM
ROW_NUMBER, Scripts, SQL

ORA-27101 error when migrating Oracle 9i to AD domain
We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this: ORACLE not available ORA-27101 When we back out of the changes, everything works fine again. Any ideas? Thank you.

Answer Question   |  August 5, 2008  5:22 PM
Active Directory, ORA-27101, Oracle 9i, Oracle migration, Windows Server 2003

How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?
I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created – as i can switch between them using the Home Selector. I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling [...]

Answer Question   |  July 15, 2008  5:17 PM
Oracle 10g, Oracle 9i, Oracle import/export

Best backup procedure for Oracle E-Business Suite?
We are using Oracle E-Business Suite R.12. Database and applications are running in two different nodes under hp-ux in NoArchivelog mode. In this scenario, a backup procedure is to be created. Can you suggest to me the steps involved in taking backup of both database and applications node, please?

Answer Question   |  July 15, 2008  5:11 PM
HP-UX, Oracle backup, Oracle E-Business Suite

Oracle export causes DBMS_EXPORT_EXTENSION error
I am facing a problem with the EXP command. The execution starts normally, but during the execution about midway, the command gives the error: dbms_export_Extension must be declared. After that, only the structure of the tables goes to backup and no data! This issue never happened in my 3-4 years working with Oracle data. But [...]

Answer Question   |  August 5, 2008  5:04 PM
DBMS_EXPORT_EXTENSION, Oracle import/export

Problem to transfer Proc C to Oracle 10g
Can you please tell me the procedure to run Proc C prpograms of Oracle 8i in Oracle 10g

Answer Question   |  August 22, 2008  8:55 AM
Oracle 10g, Oracle 8i, ProC

how to display gis maps on oracle forms
can any one tell me please. I want to access Arcgis Map on my oracle 6i forms & reports is it possible.

Answer Question   |  July 14, 2008  10:09 AM
ArcGIS, Oracle 6i, Oracle Forms, Oracle Reports

how can i resolve oracle error 00103
I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT= BUSINESS_UNIT1; C C1%ROWTYPE; BEGIN FOR C IN C1 LOOP BEGIN INSERT INTO SYSADM.voucher_tmp values (C.BUSINESS_UNIT,C.VOUCHER_ID,C.INVOICE_ID); COMMIT; END [...]

Answer Question   |  September 22, 2008  4:36 PM
ORA-00103, Oracle 9i, Oracle error messages, PL/SQL

ORA-01591
lock held by in-doubt distributed transaction iam running oracle9i relase 6.I get the following error

Answer Question   |  July 11, 2008  9:34 AM
Lock Held By In-doubt Distributed Transaction, ORA-01591, Oracle 9i, Oracle error messages

TNS-03505: Failed to resolve name
HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve name my listerner.ora file is LISTENER= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=CHANDU)) (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)) ) ) ) SID_LIST_LISTENER= (SID_LIST = (SID_DESC [...]

Answer Question   |  July 11, 2008  7:29 PM
Oracle 10g, Oracle error messages, Red Hat Enterprise Linux, RHEL, RHEL4, TNS-03505

CPU UTILIZATION IS SHOWING 0 IN SAR REPORT
Hi all I am facing problem on oracle 10g We have oracle 10g on solaries 5.9 We have database in RAC envinment with 2 nodes We have 10g AS as a front end application. My problem is when user fired user name and passwd the application page are coming very slow it is taking very [...]

Answer Question   |  February 4, 2009  5:54 PM
CPU, Oracle 10g, SAP, Solaris

Initialization DB-Connect Failed, Return Code 000256
I have migradted 4.6C with 4.6D Kernel from HPUNIX, and Oracle to Windows 2003 Server, 4.6C, and MSSQL 2000, when updating the Kernel getting above mentioned error, can someone please help

Answer Question   |  July 9, 2008  3:14 PM
HP Unix, Oracle, SAP R/3, SQL 2000, Windows Server 2003

Report Printing in Oracle
I need to create a multi-row report in Oracle Application Express. I can create the report, no problem. The question is, how can I setup printing in Oracle and print this report in PDF format?

Answer Question   |  July 8, 2008  3:52 PM
Oracle Application Express, Oracle printing

can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?
can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?

Answer Question   |  July 8, 2008  1:52 PM
Oracle 9i

Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user
Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information. Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the user that an invalid Region_id is [...]

Answer Question   |  July 8, 2008  7:04 AM
Database programming, PL/SQL

Tools & Utilities for e-Business Suite Oracle
What tools are available to analyze and managment ERP, in this case E-Business suite for Oracle

Answer Question   |  July 7, 2008  4:56 PM
E-Business Suite, ERP, Oracle