Connect to Oracle from AS/400
I need to connect to an Oracle database from an AS/400 (RPG III/CL program). Because I need to get some data. How can I do it? What do I need?
Answer Question
| November 28, 2011 12:21 PM
CL Program, Oracle Database, RPG, RPG III
I need to connect to an Oracle database from an AS/400 (RPG III/CL program). Because I need to get some data. How can I do it? What do I need?
Answer Question
| November 28, 2011 12:21 PM
CL Program, Oracle Database, RPG, RPG III
multiple instances of an Oracle database
how can i create multiple instances on one oracle database on my machine
Answer Question
| March 4, 2010 9:54 AM
Oracle 10g, Oracle Database, Oracle Database 10g
how can i create multiple instances on one oracle database on my machine
Answer Question
| March 4, 2010 9:54 AM
Oracle 10g, Oracle Database, Oracle Database 10g
high-values low-values (microfocus COBOL in Oracle/Linux environment)
Successfully remediated 80+ programs from mainframe env to run in microfocus cobol against Oracle DB in Linux env. I have one pgm that is moving high and low values to output header trailer records per requirement. Leading 9 bytes of each record. My problem is that when it ran on the mainframe I got hex x’00′ in the [...]
Answer Question
| February 22, 2010 12:25 PM
COBOL, Linux, Oracle Database
Successfully remediated 80+ programs from mainframe env to run in microfocus cobol against Oracle DB in Linux env. I have one pgm that is moving high and low values to output header trailer records per requirement. Leading 9 bytes of each record. My problem is that when it ran on the mainframe I got hex x’00′ in the [...]
Answer Question
| February 22, 2010 12:25 PM
COBOL, Linux, Oracle Database
What steps are involved when source DB is a Oracle and target db is SQL Db?
How to test when source DB is a Oracle and target db is SQL Db? What to test in particular when source DB is a Oracle and target db is SQL Db? I have worked on when both the target DB and Source Db was SQL Server.How is it different when Source Db is ORacle [...]
Answer Question
| January 2, 2010 9:23 AM
Data Migration Testing, Manual Testing, Oracle Database, Quality assurance
How to test when source DB is a Oracle and target db is SQL Db? What to test in particular when source DB is a Oracle and target db is SQL Db? I have worked on when both the target DB and Source Db was SQL Server.How is it different when Source Db is ORacle [...]
Answer Question
| January 2, 2010 9:23 AM
Data Migration Testing, Manual Testing, Oracle Database, Quality assurance
Oracle DB import/export
hi everybody! I’m using oracle 10g db. I do have an oracle instance with user name aa and password aa. And also I do have another oracle instance with user name bb and password bb. I want to import a data base from aa into bb. I know that bb has to have accesses atleast [...]
Answer Question
| December 28, 2009 11:40 AM
Oracle, Oracle 10g, Oracle Database, Oracle Database 10g, Oracle import/export
hi everybody! I’m using oracle 10g db. I do have an oracle instance with user name aa and password aa. And also I do have another oracle instance with user name bb and password bb. I want to import a data base from aa into bb. I know that bb has to have accesses atleast [...]
Answer Question
| December 28, 2009 11:40 AM
Oracle, Oracle 10g, Oracle Database, Oracle Database 10g, Oracle import/export
Updating a test database without disrupting production?
We have an Oracle 9i (9.2.0.3) database and we need to update my test database many times a day. What is the best manner to update my test database without stopping my production database?
Answer Question
| December 4, 2009 9:05 PM
Oracle 9i, Oracle Database, Oracle database testing, Production environments
We have an Oracle 9i (9.2.0.3) database and we need to update my test database many times a day. What is the best manner to update my test database without stopping my production database?
Answer Question
| December 4, 2009 9:05 PM
Oracle 9i, Oracle Database, Oracle database testing, Production environments
Oracle database access problem over WAN
We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure error, this happens particularly when [...]
Answer Question
| November 23, 2009 1:12 PM
Oracle 10g, Oracle Database, Oracle Database 10g, WAN
We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure error, this happens particularly when [...]
Answer Question
| November 23, 2009 1:12 PM
Oracle 10g, Oracle Database, Oracle Database 10g, WAN
Oracle Certification?
Hi, I want to know, the total procedure for Oracle data base certification. Thanks
Answer Question
| November 9, 2009 5:28 AM
Oracle certifications, Oracle Database
Hi, I want to know, the total procedure for Oracle data base certification. Thanks
Answer Question
| November 9, 2009 5:28 AM
Oracle certifications, Oracle Database
Calculating concurrent users based on active members in DB
Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address penetration. Based on this [...]
Answer Question
| November 5, 2009 7:30 AM
Oracle Database, Oracle Siebel, Siebel
Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address penetration. Based on this [...]
Answer Question
| November 5, 2009 7:30 AM
Oracle Database, Oracle Siebel, Siebel
Using Multiple Oracle Homes patchset application
Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2, patch that and then switch the Oracle Home from [...]
Answer Question
| October 22, 2009 10:05 AM
Oracle 10.2.0.1, Oracle Database
Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2, patch that and then switch the Oracle Home from [...]
Answer Question
| October 22, 2009 10:05 AM
Oracle 10.2.0.1, Oracle Database
get a anr record from databse by using max (one Field) and orderby (one filed) desc
Hi, I have a table. It can have multiple records for the key value. Ex secid time source 1 02:04 a 1 02:04 b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with the [...]
Answer Question
| October 22, 2009 1:12 PM
Database issues, JOIN statement, Oracle Database
Hi, I have a table. It can have multiple records for the key value. Ex secid time source 1 02:04 a 1 02:04 b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with the [...]
Answer Question
| October 22, 2009 1:12 PM
Database issues, JOIN statement, Oracle Database
Create an Oracle database in a specified location
how to create database at speciied location in oracle 10g
Answer Question
| October 19, 2009 5:29 PM
Oracle Database, Oracle database design
how to create database at speciied location in oracle 10g
Answer Question
| October 19, 2009 5:29 PM
Oracle Database, Oracle database design
Deploying Oracle Database
I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I’m waiting for your help. Thanks a lot
Answer Question
| October 21, 2009 10:36 AM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Database Migration
I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I’m waiting for your help. Thanks a lot
Answer Question
| October 21, 2009 10:36 AM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Database Migration
Bulk update for every 10k rown among 2L
Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this
Answer Question
| October 22, 2009 1:43 PM
Oracle, Oracle Database, Scripting
Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this
Answer Question
| October 22, 2009 1:43 PM
Oracle, Oracle Database, Scripting
calling trigger in oracle db 10g
hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows’ history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I’m waiting for your help. Thanks!
Answer Question
| October 16, 2009 7:32 AM
ASP.NET 2.0, C#, Oracle 10g, Oracle Database, Oracle Database 10g, Oracle developers
hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows’ history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I’m waiting for your help. Thanks!
Answer Question
| October 16, 2009 7:32 AM
ASP.NET 2.0, C#, Oracle 10g, Oracle Database, Oracle Database 10g, Oracle developers
Microsoft Server 2003 to Oracle migration
Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.
Answer Question
| October 13, 2009 3:23 PM
Microsoft Server 2003, Oracle Database, RHEL, RHEL 5
Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.
Answer Question
| October 13, 2009 3:23 PM
Microsoft Server 2003, Oracle Database, RHEL, RHEL 5
ORA-02019: Connection description for remote database not found
I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of [...]
Answer Question
| October 9, 2009 3:22 PM
Oracle Database, Oracle database administration, Oracle error messages
I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of [...]
Answer Question
| October 9, 2009 3:22 PM
Oracle Database, Oracle database administration, Oracle error messages
Oracle ODBC Windows Server 2003 scheduling issue
I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems like the [...]
Answer Question
| September 14, 2009 3:45 PM
ODBC, Oracle Database, Windows Server, Windows Server 2003
I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems like the [...]
Answer Question
| September 14, 2009 3:45 PM
ODBC, Oracle Database, Windows Server, Windows Server 2003
SQL loader
Like to hear best practices to be followed to increase performance of SQL loader.
Answer Question
| August 25, 2009 6:16 AM
Oracle 11g, Oracle Database, Oracle Database 11g, SQL Loader
Like to hear best practices to be followed to increase performance of SQL loader.
Answer Question
| August 25, 2009 6:16 AM
Oracle 11g, Oracle Database, Oracle Database 11g, SQL Loader
Problem in connection oracle lower version client with oracle database
Problem in connection oracle lower version client with oracle database.
Answer Question
| April 15, 2010 3:31 AM
Oracle, Oracle Database
Problem in connection oracle lower version client with oracle database.
Answer Question
| April 15, 2010 3:31 AM
Oracle, Oracle Database
