Remote Operation Error
I am trying to create a standby database using oracle’s enterprise manager gird control. I have to specify the login credentials of the host machine that houses the production and the standby. For some reason it only accepts my login credentials once when it gets to the next step it gives a Remote Operation Error [...]

Answer Question   |  May 23, 2008  3:15 PM
Oracle Enterprise Manager, Remote Operation Error, Windows Server 2003

ORA-01925: maximum of 145 enabled roles exceeded
I’m getting ORA-01925: maximum of 145 enabled roles exceeded and I can’t change the max_enabled_role. I dropped some roles but still face the same issue. Not able to login as system. Please suggest. Thanks.

Answer Question   |  August 23, 2008  3:12 PM
ORA-01925, Oracle, Oracle error messages

Need help with CORBA object error in Oracle Management Server
When I am in OMS, and try to shut the DB down, I receive a CORBA Object_not_found error. Does this mean that I have not installed the CORBA objects correctly?

Answer Question   |  May 23, 2008  3:07 PM
CORBA, OMS (Oracle Management Server), Oracle, Oracle error messages, Oracle Management Server

Need help with a slow pl/sql script
Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ———————————- spool noaddressusagerelfix.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES TableB.I_OCPOSTAD_USAGES%TYPE; vC_OCPOSTAD_USAGES TableB.C_OCPOSTAD_USAGES%TYPE; vpartyAddressUsageIValue TableB.I%TYPE; vpartyAddressUsageCValue TableB.C%TYPE; vCounter NUMBER(10):=0; CURSOR cursor1 IS SELECT C, I, I_OCPRTY_USAGES FROM TableB WHERE I_OCPOSTAD_USAGES IS NULL AND [...]

Answer Question   |  June 17, 2008  11:00 AM
Oracle 10, PL, PL/SQL, script, SQL

Oracle -fetched column value truncated error
Hi I am using ASP.net using C# in my application which connects to Oracle 9i DB with a UTF8 character set. On of my columns in a table has datatype Nvarchar2(4000), when I try to fetch data through a Stored proecedure using execute Dataset command in C# it throws error “ORA 01406 -fetched column value [...]

Answer Question   |  May 23, 2008  7:31 AM
ASP.NET, C#, ORA-01406, Oracle, Oracle 9i, Oracle error messages

Two Applications sharing the same database
Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question: Can we add another server and install [...]

Answer Question   |  May 22, 2008  7:21 AM
Database administration, Database security, Oracle, Oracle 9, Oracle E-Business Suite, Oracle security, Shared databases, Solaris, Solaris 10

Oracle 10g Standby Database not opening readonly
Hiii, I have created Oracle 10g Primary database where control file locations are as follows: *control_files=’P:oracleproduct10.1.0oradatatcengcontrol01.ctl’,'C:oradatatcengcontrol02.ct l’,'E:oradatatcengcontrol03.ctl’ Then I have created standby database in standby server where the control file locations are as follows: *control_files=’C:oracleproduct10.1.0oradatatcengcontrol01.ctl’,'D:oradatatcengcontrol02.ct l’,'D:oradatatcengcontrol03.ctl’ Now if I give command ‘alter system switch logfile;’ no. of times in Primary server then check it in [...]

Answer Question   |  May 22, 2008  5:47 AM
ORA-01110, ORA-01157, ORA-16004, Oracle 10g, Oracle DBA, SQL

Pl/sql code for queries
Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select statements. the queries are [...]

Answer Question   |  May 22, 2008  5:20 PM
Oracle developers, PL/SQL

oracle form:export to excel
I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

Answer Question   |  September 13, 2008  10:06 AM
Microsoft Excel, Oracle, Oracle Forms, Oracle import/export

Not able to set preferred credentials on OEM console
using Oracle 10gR2 on Windows 2003 server. I can’t setup the preferred credentials on the Job scheduler screen on the console. I also have the email issue. I tried to use DBCA and clicked on database options and everything is greyed out and I cant seem to proceed. How can I configure to receive emails [...]

Answer Question   |  May 21, 2008  5:35 PM
DBCA, Oracle 10g, Oracle 10g R2, Preferred credentials, Windows Server 2003

Oracle Enterprise Edition versus Standard Edition
We are looking at converting our “enterprise database” licenses to “standard edition”. I need to know what to look out for. I have read the Oracle notes on the differences but you know how that goes. We are doing this as a cost cutting measure. Has anyone done this ? What should I be aware [...]

Answer Question   |  May 19, 2008  2:25 PM
Oracle, Oracle Enterprise Edition, Oracle ROI and TCO, Oracle Standard Edition

how to install oracle 7 in XP
There is an application which runs using oracle 7 and it is running in system which is win NT but now need to run that application in XP which does not have oracle 7 it has higher version 8.1.7 and 9. Can anybody help me in finding the solution here…how can i install oracle 7 [...]

Answer Question   |  May 28, 2008  11:57 AM
Oracle 7, Windows XP

VB.NET ans ORACLE database
Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need [...]

Answer Question   |  May 16, 2008  6:59 AM
Database connectivity, Oracle 10g, VB.NET 2005 Express Edition, Visual Basic 2005

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

Answer Question   |  May 14, 2008  3:24 AM
Data availability, Enterprise Manager, Indexes, SQL Server 2000, SQL Server Enterprise Manager

Validation Error – Oracle database on Windows Server 2003
I am trying to log into an oracle database residing on a windows 2003 server through enterprise manager. I keep getting the error Validation error – �. I have added my username to the “log on as bacth job” properties. but I still keep getting this error. Please help

Answer Question   |  May 14, 2008  3:13 PM
Administrative privileges, Oracle, Windows Server 2003

copy files
Using SQLPLUS how do you copy files from one location to another

Answer Question   |  May 19, 2008  1:09 PM
SQLPlus

date functions using Oracle
Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in ‘yyyymm’ format. ex, select year_mnth,benefits_paid from tablename where year_mnth in (’200603′,’200602′,’200601′) note:it is in ‘yyyymm’ format group by year_mnth the benefits paid must [...]

Answer Question   |  September 22, 2008  6:59 AM
Oracle, Oracle development, Oracle SQL, SQL

How to pass data from JDE to web page
There is a requirement wherein data which is on a JDE World screen should be passed to a web page when a function key is pressed. On pressing of the particular function key, data which is on the JDE World screen must be passed to and displayed on the web page. I need ideas about [...]

Answer Question   |  May 9, 2008  5:10 PM
AS/400, JDE World

Oracle 11g RAC on HP C3000 blade with Bl460c servers using SB40c as storage
Has anyone built a oracle 11g or 10g RAC on HP Blade C3000. A typical setup could be 4 X Bl460c blade servers using 4 X SB40c storage blade ( giving 24 X 146 GB SAS drives ). Both the blade servers and storage will fit in the same blade enclosure. OS could be oracle [...]

Answer Question   |  June 21, 2011  2:00 AM
HP BladeSystem c3000, HP ProLiant BL460c Blade Server, HP StorageWorks SB40c, Oracle 10g, Oracle 11g, Oracle on Linux, Oracle RAC

row_number in sql 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005

Answer Question   |  March 11, 2010  10:51 PM
ROW_NUMBER, SQL Query, SQL Server 2000