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
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, 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
Answer Question | July 8, 2008 1:52 PM
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
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