AIX relink
Does Oracle need to be relinked after going from 5.3 ML4 to AIX 5.3 TL6 SP4. Any help is greatly apprecated

Answer Question   |  July 31, 2008  4:28 PM
AIX, Oracle

Windows 2003 ENterprise edition with Oracle 9i . And there are 32GB RAM in the server
We use Windows 2003 ENterprise edition with Oracle 9i . And there are 32GB RAM in the server. The 32GB RAM is recognized by the server with Win2003 in ‘properties’. My question is a) whether the 32GB RAM is recognized with Oracle 9i ? If not ,how can I do ? b) How can I [...]

Answer Question   |  July 31, 2008  2:17 PM
Oracle 9i, RAM, Windows Server 2003

Rman Backup
what’s the steps to take backup through RMAN and is it required RMAN Repository to backup?

Answer Question   |  July 31, 2008  9:03 AM
Oracle backup, Recovery Manager, RMAN

Clustering
I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

Answer Question   |  January 6, 2009  4:23 PM
Clustering, Oracle 10g, Oracle clustering

convert Oracle query into xml file
Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.

Answer Question   |  July 30, 2008  6:14 AM
Oracle import/export, XML

Report Query
Can I run a query in peoplesoft if I don’t have access to query manager?

Answer Question   |  July 28, 2008  7:59 PM
PeopleSoft, Query Manager, Reports

can VS 2005 support Oracle 10g?
can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

Answer Question   |  July 23, 2008  8:04 AM
Oracle 10g, SSRS, Visual Studio, VS 2005

Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit
We have procured an application for archiving of reports. Initially we were suggested to go for Windows 2003 ENterprise edition 32 bit (R2) with Oracle 9i 32 bit. After about 1 year of rolling out, we found that application became very slow. To enhance the room for memory, we went for memory upgrade from 4GB [...]

Answer Question   |  July 22, 2008  1:41 AM
Oracle 9i, Windows Server 2003

autobackup
How do you enable the autobackup for the controlfile using RMAN

Answer Question   |  August 23, 2008  2:57 PM
Backup, DBA, Oracle backup, Oracle Recovery Manager, RMAN

Installing oracle 9i
is it possible to install qracle 9i on a windows 2003 environment

Answer Question   |  July 21, 2008  10:02 AM
Oracle 9i, Oracle installation, Windows Server 2003

Suggestion/reminder How to get your question answered
This just an open reminder for all who post questions or plan to post questions. It is much easier and faster to provide an answer when you remember to include details such as what version of the product you are using. If there is an error message, please post the exact error and event id [...]

Answer Question   |  September 1, 2009  6:26 PM
AS/400, Database, Development, Exchange, ITKE, Lotus Domino, Oracle, SAP, Security, Storage, Virtualization, Windows

Oracle coding error ORA-06550
Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol “ELSE” when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << [...]

Answer Question   |  July 18, 2008  2:59 PM
ORA-06550, Oracle development, Oracle error messages

Syntex for storing combobox & redio button in oracle using VB.NET
How can i save combo box value & redio button in database using VB.NET form. For example as text value we write TEXTBOX1.TEXT????

Answer Question   |  July 18, 2008  11:52 AM
ComboBox, Oracle database design, Oracle development, VB.NET

Oracle App Server webcache and mod_gzip
Hi all, I am struggling since last few days to work these both together.Problem is: The web cache is compressing the content but i don’t want it to compress, i want the compression from server through mod_gzip. Even if i m disabling compression in webcache settings, its not working. In mod_gzip log it show NO_ACCEPT_ENCODING [...]

Answer Question   |  July 18, 2008  11:26 AM
MOD_GZIP, Oracle Application Server, Oracle error messages

OpenLDAP and Oracle Database
Hi, This is a question related to Oracle and OpenLdap. Can anybody please tell me how to setup the Oracle [10g] to use the installed OpenLdap server. I know we need to use netca and use the internet directory services; But how to set Open Ldap is the question here. Your help is greatly appreciated! [...]

Answer Question   |  July 17, 2008  5:48 PM
Authentication, OpenLDAP, Oracle 10g

report server error using oracle 10g
Hi. I an using oracle 10g. when i run 10g reports individually it works fine but when i try it to connect with forms it gives error ‘cannot connect toserver’ please help how could i connect it to server.

Answer Question   |  August 22, 2008  9:11 AM
Oracle 10g, Oracle error messages, Oracle Reports

How to deploy database application built on VB 6 and Oracle?
I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you.

Answer Question   |  July 16, 2008  3:51 PM
Application deployment, Database programming, Oracle 8i, VB

How to create a trigger for updating a table for a quantity decrease?
How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for [...]

Answer Question   |  July 16, 2008  3:48 PM
Oracle development, Triggers

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