Developing a Java application(a batch)that transfers data from SAP to Oracle DB and vise versa. HELP ME PLEASE!
Never underestimate the power of Google. I did a search on ‘java rfc sap’ and found this: http://help.sap.com/saphelp_46c/helpdata/de/8c/20e8e9493311d1894a0000e829fbbd/content.htm Please do some more research based on the keywords found in this page. I know Java but not SAP so I can’t go deeper on this question.
View Answer
| January 13, 2005 9:38 AM
Development, Lifecycle development, Oracle
Never underestimate the power of Google. I did a search on ‘java rfc sap’ and found this: http://help.sap.com/saphelp_46c/helpdata/de/8c/20e8e9493311d1894a0000e829fbbd/content.htm Please do some more research based on the keywords found in this page. I know Java but not SAP so I can’t go deeper on this question.
View Answer
| January 13, 2005 9:38 AM
Development, Lifecycle development, Oracle
Wireless University
There are a lot of factors in your dilemna. I have installed a wireless infrastructure 802.11 super g, for a 60,000 sq foot facility. which required two repeaters and three access points, some electrical runs and a couple of days to configure. The facility had several internal concrete structures and firewalls. The cost for equipment [...]
View Answer
| December 30, 2004 9:42 AM
802.11 networking equipment, Data analysis, ERP, Human resource applications, Networking, Training, Wireless standards
There are a lot of factors in your dilemna. I have installed a wireless infrastructure 802.11 super g, for a 60,000 sq foot facility. which required two repeaters and three access points, some electrical runs and a couple of days to configure. The facility had several internal concrete structures and firewalls. The cost for equipment [...]
View Answer
| December 30, 2004 9:42 AM
802.11 networking equipment, Data analysis, ERP, Human resource applications, Networking, Training, Wireless standards
8i external procedures and 9i listener configuration issues
The resolution to this issue was to use 2 listeners (8i,9i)using 2 different ports. This allowed each version of extproc to find the corresponding executables. Here is a sample of the listener.ora for 9i; 8i listener.ora is the same except for the ENVS clause and the extproc executables defined. A tnsnames.ora file is also needed. [...]
View Answer
| December 28, 2004 9:48 AM
Oracle
The resolution to this issue was to use 2 listeners (8i,9i)using 2 different ports. This allowed each version of extproc to find the corresponding executables. Here is a sample of the listener.ora for 9i; 8i listener.ora is the same except for the ENVS clause and the extproc executables defined. A tnsnames.ora file is also needed. [...]
View Answer
| December 28, 2004 9:48 AM
Oracle
How to purge records from the database?
Aghhhhhhh. You said the D word. If and when possible you should avoid using the delete function. Try to create a field to mark the records you do not think you need (you may need them again) and redesign your views and stored procs to filter out the marked records. But in all seriousness try [...]
View Answer
| December 21, 2004 5:02 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
Aghhhhhhh. You said the D word. If and when possible you should avoid using the delete function. Try to create a field to mark the records you do not think you need (you may need them again) and redesign your views and stored procs to filter out the marked records. But in all seriousness try [...]
View Answer
| December 21, 2004 5:02 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
Stored Procedure Error
I am not able to run this but purely looking at the syntax it may be as simple as requiring a ‘;’ after your final FETCH statement.
View Answer
| December 17, 2004 6:11 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
I am not able to run this but purely looking at the syntax it may be as simple as requiring a ‘;’ after your final FETCH statement.
View Answer
| December 17, 2004 6:11 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
Upgrade to Oracle/Intel: Go Linux vs Windows
We migrated 4 servers running Windows Oracle databases to one Linux server (Dell Poweredge with external Scsi). The advantage to us is Redhat AS Linux is able to address the 8+ Gig of RAM for Oracle vs only 2 Gig for Windows standard server. The Enterprise CPU licenses we freed from the Windows servers are [...]
View Answer
| November 9, 2012 1:51 PM
CIO, Hardware, Linux, Oracle, Oracle 9i, Windows
We migrated 4 servers running Windows Oracle databases to one Linux server (Dell Poweredge with external Scsi). The advantage to us is Redhat AS Linux is able to address the 8+ Gig of RAM for Oracle vs only 2 Gig for Windows standard server. The Enterprise CPU licenses we freed from the Windows servers are [...]
View Answer
| November 9, 2012 1:51 PM
CIO, Hardware, Linux, Oracle, Oracle 9i, Windows
Tunning of query
I haven’t done sql for a while but i think that maybe you can try : insert into tblsap_history ( select * from tblsap ts where ( (ts.css_database,ts.sap) in ( select SUBSTR(source_account, 1, 2),SUBSTR(source_account, 3, 18) from ds_account a where a.source_system = 1 and ts.taig=’ISY002′ and (sysdate-required_by) >= 180 ) or (ts.css_database,ts.sap) not in ( [...]
View Answer
| December 13, 2004 7:14 AM
Oracle
I haven’t done sql for a while but i think that maybe you can try : insert into tblsap_history ( select * from tblsap ts where ( (ts.css_database,ts.sap) in ( select SUBSTR(source_account, 1, 2),SUBSTR(source_account, 3, 18) from ds_account a where a.source_system = 1 and ts.taig=’ISY002′ and (sysdate-required_by) >= 180 ) or (ts.css_database,ts.sap) not in ( [...]
View Answer
| December 13, 2004 7:14 AM
Oracle
Oracle database authentication in VB
When you connect to the Oracle DB, you supply a userid and pwd. this is the user that is authenticated by Oracle and access privleges checked. If you are using a generic userid, then you have chosen to bypass Oracle security.
View Answer
| November 26, 2004 11:09 AM
Development, Oracle
When you connect to the Oracle DB, you supply a userid and pwd. this is the user that is authenticated by Oracle and access privleges checked. If you are using a generic userid, then you have chosen to bypass Oracle security.
View Answer
| November 26, 2004 11:09 AM
Development, Oracle
ORA-03113 error while compiling Oracle packages
I have seen this error when your session times out. Check your session/user settings. Stefan
View Answer
| November 24, 2004 8:13 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
I have seen this error when your session times out. Check your session/user settings. Stefan
View Answer
| November 24, 2004 8:13 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
Performance Tuninig of a Select Query.
Have you tried doing an Explain Plan on your query?
View Answer
| November 18, 2004 10:04 PM
Development, Oracle, SQL
Have you tried doing an Explain Plan on your query?
View Answer
| November 18, 2004 10:04 PM
Development, Oracle, SQL
switching between instances without down time
I assume the connections are straight SQL*NET. If so, each desktop would have its own tnsnames.ora file. At a minimum, these would have to be updated to be made aware of the new instance. The last couple of places I worked had a PC support team with software that could push a new tnsnames.ora to [...]
View Answer
| November 11, 2004 6:42 PM
Oracle, Oracle 9i
I assume the connections are straight SQL*NET. If so, each desktop would have its own tnsnames.ora file. At a minimum, these would have to be updated to be made aware of the new instance. The last couple of places I worked had a PC support team with software that could push a new tnsnames.ora to [...]
View Answer
| November 11, 2004 6:42 PM
Oracle, Oracle 9i
Best IDE for building JSP pages
Altova XMLSpy 2005 is one of the latest jsp editors. IT has intellisense for quick coding and can also handle xml, xslt, etc.
View Answer
| November 5, 2004 5:38 PM
BEA Systems, BEA WebLogic, C, Computer Associates, HTML, IBM, IBM WebSphere, J2EE, Java, JavaScript, JBoss, JSP, Servers, Sun, Sun ONE Application Server, Web development tools, WebSphere Studio
Altova XMLSpy 2005 is one of the latest jsp editors. IT has intellisense for quick coding and can also handle xml, xslt, etc.
View Answer
| November 5, 2004 5:38 PM
BEA Systems, BEA WebLogic, C, Computer Associates, HTML, IBM, IBM WebSphere, J2EE, Java, JavaScript, JBoss, JSP, Servers, Sun, Sun ONE Application Server, Web development tools, WebSphere Studio
C# sample code for copying a table from oracle to ms sql with ODP.NET needed
I found a solution now: The way to go is as I thought to use a OracleDataAdapter, then filling a DataSet und using this DataSet to Update a SQLAdapter. But this only works if you set the property AcceptChangesDuringFill = false from the OracleDataAdapter !!
View Answer
| October 21, 2004 1:24 AM
C, Oracle, SQL
I found a solution now: The way to go is as I thought to use a OracleDataAdapter, then filling a DataSet und using this DataSet to Update a SQLAdapter. But this only works if you set the property AcceptChangesDuringFill = false from the OracleDataAdapter !!
View Answer
| October 21, 2004 1:24 AM
C, Oracle, SQL
Upgrading Oracle on Windows 2000
Hate to pass out the RTFM message, but a good read of the upgrade manual will answer all of those questions. But generally speaking what your suggesting is absolutely doable and a good idea. The upgrade process for one database can take a significant amount of time, on the order of an hour or more [...]
View Answer
| October 19, 2004 10:56 AM
Oracle, Oracle 9i
Hate to pass out the RTFM message, but a good read of the upgrade manual will answer all of those questions. But generally speaking what your suggesting is absolutely doable and a good idea. The upgrade process for one database can take a significant amount of time, on the order of an hour or more [...]
View Answer
| October 19, 2004 10:56 AM
Oracle, Oracle 9i
Oracle In Linux
Pretty broad question, but for installation issues with Oracle on Linux, I have found this site very helpful if used with the installation notes as well as some the documents available on Metalink. Good Luck http://www.puschitz.com/OracleOnLinux.shtml
View Answer
| October 15, 2004 10:15 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Pretty broad question, but for installation issues with Oracle on Linux, I have found this site very helpful if used with the installation notes as well as some the documents available on Metalink. Good Luck http://www.puschitz.com/OracleOnLinux.shtml
View Answer
| October 15, 2004 10:15 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Db2 to Oracle porting
Sorry this is a late response but the major differences will be in the datatypes used and some of the objects such as sequences. This I learnt from going between Informix and oracle.
View Answer
| October 13, 2004 5:39 AM
Database Management Systems, DB2, Oracle
Sorry this is a late response but the major differences will be in the datatypes used and some of the objects such as sequences. This I learnt from going between Informix and oracle.
View Answer
| October 13, 2004 5:39 AM
Database Management Systems, DB2, Oracle
ORA-01033 Oracle Initialization or Shutdown in progress & cannot log into sqlplus.
What Oracle version you are using and on what platform/OS?
View Answer
| October 7, 2004 10:52 PM
DataCenter, Development, Oracle, Storage, Tech support
What Oracle version you are using and on what platform/OS?
View Answer
| October 7, 2004 10:52 PM
DataCenter, Development, Oracle, Storage, Tech support
Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?
I am in the process of doing a similar thing. Installing Oracle EE 9.2.0.1.0 on Win 2003. The box is 64 bit but the op system is 32 bit. So I am installing the 32 bit version of Oracle. In order to do this the recomendation was to add a patch to the Oracle Installation [...]
View Answer
| September 27, 2004 5:57 AM
Database Management Systems, Hardware, Intel PC hardware, Intel servers, Java, Microsoft Windows, Oracle, Standard Edition, Tech support, Windows on Intel, Windows Server 2003
I am in the process of doing a similar thing. Installing Oracle EE 9.2.0.1.0 on Win 2003. The box is 64 bit but the op system is 32 bit. So I am installing the 32 bit version of Oracle. In order to do this the recomendation was to add a patch to the Oracle Installation [...]
View Answer
| September 27, 2004 5:57 AM
Database Management Systems, Hardware, Intel PC hardware, Intel servers, Java, Microsoft Windows, Oracle, Standard Edition, Tech support, Windows on Intel, Windows Server 2003
Oracle 9.2.0.4 and gcc compiler
You GCC version is quite old; looks like the oracle library’s been compiled for 64-bit memory addresses. Perhaps your code isn’t compiled that way, which would explain the link problems. Try recompiling you code. Otherwise, I recommend consulting minimum requirements for gcc. It’s up to 3.3 or higher these days.
View Answer
| September 24, 2004 5:55 AM
C, Oracle, Oracle 9i
You GCC version is quite old; looks like the oracle library’s been compiled for 64-bit memory addresses. Perhaps your code isn’t compiled that way, which would explain the link problems. Try recompiling you code. Otherwise, I recommend consulting minimum requirements for gcc. It’s up to 3.3 or higher these days.
View Answer
| September 24, 2004 5:55 AM
C, Oracle, Oracle 9i
OBJECTIVE comparison (with independant references) between MS SQL and Oracle 10g
Hello there, I am a DBA originally started with Oracle 5 and have 13 years of experience using Oracle database. For last five years, I have also been using and administring SQL Server. In my opinion both have pluses an minuses of their own. Here is the comparison between the two based on features you [...]
View Answer
| September 2, 2004 11:49 AM
Oracle, SQL Server
Hello there, I am a DBA originally started with Oracle 5 and have 13 years of experience using Oracle database. For last five years, I have also been using and administring SQL Server. In my opinion both have pluses an minuses of their own. Here is the comparison between the two based on features you [...]
View Answer
| September 2, 2004 11:49 AM
Oracle, SQL Server
