Create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
Answer Question
| April 26, 2009 6:25 PM
Oracle Streams, SQL Server, SQL Server Service Broker
Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
Answer Question
| April 26, 2009 6:25 PM
Oracle Streams, SQL Server, SQL Server Service Broker
Is the Oracle client 9 compatible with Forms 6i
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don’t believe this is a supported combination and need to know what problems we may encounter
Answer Question
| April 24, 2009 10:47 AM
Citrix, Oracle, Oracle 9i, Oracle Forms, Oracle Forms 6i, Windows Server 2003
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don’t believe this is a supported combination and need to know what problems we may encounter
Answer Question
| April 24, 2009 10:47 AM
Citrix, Oracle, Oracle 9i, Oracle Forms, Oracle Forms 6i, Windows Server 2003
Oracle EE Named User Plus Licensing
I want to license 50 users (NUP) on 2 new Oracle systems (on separate servers). Because of Named User Plus minimums on each server I require: 100 NUP licenses (for server/system 1 & 50 NUP licences for system/server 2) – Total 150 NUP licenses. My question is, how should this model take into account the [...]
Answer Question
| April 24, 2009 8:57 AM
Oracle, Oracle licensing, Oracle Permissions, Oracle User Profiles
I want to license 50 users (NUP) on 2 new Oracle systems (on separate servers). Because of Named User Plus minimums on each server I require: 100 NUP licenses (for server/system 1 & 50 NUP licences for system/server 2) – Total 150 NUP licenses. My question is, how should this model take into account the [...]
Answer Question
| April 24, 2009 8:57 AM
Oracle, Oracle licensing, Oracle Permissions, Oracle User Profiles
convertion of excel into report generating tool
how to convert excel sheet into oracle report generating tool
Answer Question
| April 24, 2009 8:00 AM
Microsoft Excel, Oracle Reports
how to convert excel sheet into oracle report generating tool
Answer Question
| April 24, 2009 8:00 AM
Microsoft Excel, Oracle Reports
Validation error in Oracle10g
If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error”Validation error” and followed by another error message “oracle executable manager stopped working and was closed”. please what will I do? How can I create additional listener in [...]
Answer Question
| April 24, 2009 12:20 PM
Oracle 10g, Oracle error messages, Oracle Validation Error
If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error”Validation error” and followed by another error message “oracle executable manager stopped working and was closed”. please what will I do? How can I create additional listener in [...]
Answer Question
| April 24, 2009 12:20 PM
Oracle 10g, Oracle error messages, Oracle Validation Error
Converting and deploying 6i Forms to Forms 10g
I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that’s true, then how do I run them? Is there a runtime with 10g? I feel [...]
Answer Question
| March 23, 2011 8:17 PM
Converting 6i to 10g, Forms 10g, Forms 6i
I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that’s true, then how do I run them? Is there a runtime with 10g? I feel [...]
Answer Question
| March 23, 2011 8:17 PM
Converting 6i to 10g, Forms 10g, Forms 6i
excuting sql loader from runrmtcmd from as400 to unix
I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code, RUNRMTCMD CMD(‘cd /home/dekbf/e3data;$sqlldr ekbf/ekbf + control=EPINTORD2CTL.CTL’) RMTLOCNAME(’191.0.0.9′ + *IP) RMTUSER(‘dekbf’) RMTPWD(‘ekbf’) Here is the error returned, ksh: ekbf/ekbf: not found.
Answer Question
| April 22, 2009 6:46 PM
AS/400, RUNRMTCMD, SQL Loader, Unix
I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code, RUNRMTCMD CMD(‘cd /home/dekbf/e3data;$sqlldr ekbf/ekbf + control=EPINTORD2CTL.CTL’) RMTLOCNAME(’191.0.0.9′ + *IP) RMTUSER(‘dekbf’) RMTPWD(‘ekbf’) Here is the error returned, ksh: ekbf/ekbf: not found.
Answer Question
| April 22, 2009 6:46 PM
AS/400, RUNRMTCMD, SQL Loader, Unix
Would like to upgrade to 10.2.0.4 from 9.2.0.7
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question
| April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question
| April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
Can I run Seconds on an Alert in Oracle Forms 6i
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.
Answer Question
| April 22, 2009 5:53 AM
Oracle development, Oracle Forms 6i, Time On Alerts in Oracle Forms 6i
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.
Answer Question
| April 22, 2009 5:53 AM
Oracle development, Oracle Forms 6i, Time On Alerts in Oracle Forms 6i
Oracle 10g process each record exactly on time multiple processes
I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to [...]
Answer Question
| April 29, 2009 3:19 AM
Oracle 10g, Oracle 10g administration, Oracle ROWNUM, SELECT statement, UPDATE statement
I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to [...]
Answer Question
| April 29, 2009 3:19 AM
Oracle 10g, Oracle 10g administration, Oracle ROWNUM, SELECT statement, UPDATE statement
Oracle acquires SUN: implications ?
What do you think will be the implications of Oracle’s Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?
Answer Question
| October 29, 2009 12:35 AM
Database Management Systems, Hardware, Operating systems, Oracle, Sun Microsystems, Virtualization
What do you think will be the implications of Oracle’s Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?
Answer Question
| October 29, 2009 12:35 AM
Database Management Systems, Hardware, Operating systems, Oracle, Sun Microsystems, Virtualization
Oracle Communication between 11g and 8i
We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is any communication [...]
Answer Question
| April 22, 2009 11:28 PM
Oracle 10g, Oracle 11g, Oracle 8i, Oracle 8i migration, Oracle migration, Oracle upgrades
We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is any communication [...]
Answer Question
| April 22, 2009 11:28 PM
Oracle 10g, Oracle 11g, Oracle 8i, Oracle 8i migration, Oracle migration, Oracle upgrades
How number of processors correlated to Oracle database size
Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?
Answer Question
| April 27, 2009 9:16 PM
Oracle on Linux, Oracle performance, Unix Server sizing, Unix Servers
Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?
Answer Question
| April 27, 2009 9:16 PM
Oracle on Linux, Oracle performance, Unix Server sizing, Unix Servers
Importing dmp file
What is the procedure for importing a dmp file?
Answer Question
| July 22, 2009 7:47 PM
DMP Importing, Oracle import/export
What is the procedure for importing a dmp file?
Answer Question
| July 22, 2009 7:47 PM
DMP Importing, Oracle import/export
Database
How do I create an oracle database?
Answer Question
| April 20, 2009 6:06 PM
Oracle Database, Oracle database administration
How do I create an oracle database?
Answer Question
| April 20, 2009 6:06 PM
Oracle Database, Oracle database administration
Generating multiple pdf files using oracle report builder
I have about 25000 pages in a pdf file. I want to split this into multiple files. Please help me out to generate this using Oracle Report Builder 10g.
Answer Question
| March 25, 2010 4:10 PM
Oracle 10g, Oracle Reports, Oracle Reports 10g
I have about 25000 pages in a pdf file. I want to split this into multiple files. Please help me out to generate this using Oracle Report Builder 10g.
Answer Question
| March 25, 2010 4:10 PM
Oracle 10g, Oracle Reports, Oracle Reports 10g
Connect to Oracle 10g with VB6 using ADO
I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!
Answer Question
| May 8, 2013 6:46 AM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6
I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!
Answer Question
| May 8, 2013 6:46 AM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6
How to config iSQL Plus on computer without a domain
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]
Answer Question
| April 20, 2009 3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]
Answer Question
| April 20, 2009 3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
Does something similar to Oracle’s optimizer hints exist in SQL Server ?
In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc… Does something similar exist in Microsoft Sql Server ?
Answer Question
| April 19, 2009 8:59 PM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning
In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc… Does something similar exist in Microsoft Sql Server ?
Answer Question
| April 19, 2009 8:59 PM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning
log sql queries?
queries seem get mangled by our report writer middleware; I’d like to see the actual SQL received by Oracle9i from a particular user. how?
Answer Question
| April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
queries seem get mangled by our report writer middleware; I’d like to see the actual SQL received by Oracle9i from a particular user. how?
Answer Question
| April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
