Upgrading Oracle on Windows 2000
I am preparing an Oracle upgrade from 8.1.7.4 to 9.2.0.5 on a Windows 2000 environment. The server has 3 instances on it, and the possibility of upgrading them one at a time is a real one. My question is, is it OK to just run the upgrade assistant against each database one at a time, [...]
Answer Question
| October 29, 2004 5:30 PM
Oracle, Oracle 9i
I am preparing an Oracle upgrade from 8.1.7.4 to 9.2.0.5 on a Windows 2000 environment. The server has 3 instances on it, and the possibility of upgrading them one at a time is a real one. My question is, is it OK to just run the upgrade assistant against each database one at a time, [...]
Answer Question
| October 29, 2004 5:30 PM
Oracle, Oracle 9i
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 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
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 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
Database Replication
Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?
Answer Question
| July 21, 2004 3:01 AM
Architecture/Design, Development, Installation/Upgrade, Oracle, Oracle 8i, Oracle 9i, SQL
Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?
Answer Question
| July 21, 2004 3:01 AM
Architecture/Design, Development, Installation/Upgrade, Oracle, Oracle 8i, Oracle 9i, SQL
Data Guard Implementation
Does anyone have any experience and/or issues with implementing a logical standby database for disaster recovery? We have enough disk for 1 standby database and the users want to query it as well as have it for disaster recovery.
Answer Question
| July 15, 2004 10:38 AM
Oracle, Oracle 9i
Does anyone have any experience and/or issues with implementing a logical standby database for disaster recovery? We have enough disk for 1 standby database and the users want to query it as well as have it for disaster recovery.
Answer Question
| July 15, 2004 10:38 AM
Oracle, Oracle 9i
RAID configuration for Oracle database
Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi terabyte). Their [...]
Answer Question
| August 28, 2008 10:34 AM
DB2, Oracle 9i, Oracle database design, RAID configuration
Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi terabyte). Their [...]
Answer Question
| August 28, 2008 10:34 AM
DB2, Oracle 9i, Oracle database design, RAID configuration
Oracle 9.2.0.4 and gcc compiler
We just upgraded to Oracle 9.2.0.4. When we try to compile a program, we get the following error: ld: fatal: file /u100/app/oracle/product/9.2.0/lib//libclntsh.so: wrong ELF class: ELFCLASS64 error when trying to compile with GCC version 2.95.3. I was wondering if anyone had run across this, and, if so, is it telling us to upgrade gcc, or [...]
Answer Question
| September 24, 2004 1:16 PM
C, Oracle, Oracle 9i
We just upgraded to Oracle 9.2.0.4. When we try to compile a program, we get the following error: ld: fatal: file /u100/app/oracle/product/9.2.0/lib//libclntsh.so: wrong ELF class: ELFCLASS64 error when trying to compile with GCC version 2.95.3. I was wondering if anyone had run across this, and, if so, is it telling us to upgrade gcc, or [...]
Answer Question
| September 24, 2004 1:16 PM
C, Oracle, Oracle 9i
Uninstalling Oracle 9i products from a Window Server
Hello how is everyone today? When your removing all Oracle components and services from a Windows 2003 Server what method is used more. The manual method or using Universal Installer? Can you please provide me a link to white papers that take me through the process of using the Universal Installer to uninstalling all the [...]
Answer Question
| June 15, 2004 12:03 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition
Hello how is everyone today? When your removing all Oracle components and services from a Windows 2003 Server what method is used more. The manual method or using Universal Installer? Can you please provide me a link to white papers that take me through the process of using the Universal Installer to uninstalling all the [...]
Answer Question
| June 15, 2004 12:03 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition
Passing array as output parameter through procdure/function
Any suggestions on implementing a procedure that passes an array as output parameter and using this as an input to a second procedure and manipulating it?
Answer Question
| June 7, 2004 11:41 AM
Oracle 9i
Any suggestions on implementing a procedure that passes an array as output parameter and using this as an input to a second procedure and manipulating it?
Answer Question
| June 7, 2004 11:41 AM
Oracle 9i
Support of Oracle 8 and 9i
We currently support several systems running Oracle 8 that are upgrading to 9i. From a support perspective, can someone help me identify any key differences that might need special attention the my Oracle 8 experience does not cover? Thank you.
Answer Question
| June 3, 2004 2:48 PM
Oracle, Oracle 8i, Oracle 9i
We currently support several systems running Oracle 8 that are upgrading to 9i. From a support perspective, can someone help me identify any key differences that might need special attention the my Oracle 8 experience does not cover? Thank you.
Answer Question
| June 3, 2004 2:48 PM
Oracle, Oracle 8i, Oracle 9i
RAC and parallel server
What is difference between RAC and parallel server?
Answer Question
| May 28, 2004 4:56 PM
Oracle 10g, Oracle 8i, Oracle 9i
What is difference between RAC and parallel server?
Answer Question
| May 28, 2004 4:56 PM
Oracle 10g, Oracle 8i, Oracle 9i
Tools for Oracle database admin, and also Design and Development
I was out of the Oracle world for three years (using 7.4?), and now knee deep in alligators with little time to review market offerings. I am using Oracle Enterprise Manager for 9i and very happy with it. An Embarcardero vendor has contacted me a couple of times, but I’ve had little time to investigate [...]
Answer Question
| June 3, 2004 2:23 PM
Oracle 9i
I was out of the Oracle world for three years (using 7.4?), and now knee deep in alligators with little time to review market offerings. I am using Oracle Enterprise Manager for 9i and very happy with it. An Embarcardero vendor has contacted me a couple of times, but I’ve had little time to investigate [...]
Answer Question
| June 3, 2004 2:23 PM
Oracle 9i
ORA-01436 error
We are trying to use connect by ..prior feature of oracle. Having said that we had used this type of queries and now we are facing this loop error for connect by prior. Any suggestions.
Answer Question
| June 1, 2004 3:59 PM
Oracle 9i
We are trying to use connect by ..prior feature of oracle. Having said that we had used this type of queries and now we are facing this loop error for connect by prior. Any suggestions.
Answer Question
| June 1, 2004 3:59 PM
Oracle 9i
Adding column to an exiting primary key
We have a table which already has a primary key. We want to make this have a composite primary key with another column. Is there any other way to do this without dropping the primary key and recreating a composite PK. Thanks in advance.
Answer Question
| May 26, 2004 3:55 PM
Oracle 9i
We have a table which already has a primary key. We want to make this have a composite primary key with another column. Is there any other way to do this without dropping the primary key and recreating a composite PK. Thanks in advance.
Answer Question
| May 26, 2004 3:55 PM
Oracle 9i
Getting duplicate records
I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records. Our requirement is to find both (or multiple) duplicate records from a table. We are using Oracle 9i. Regards
Answer Question
| May 27, 2004 7:48 AM
Oracle 9i
I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records. Our requirement is to find both (or multiple) duplicate records from a table. We are using Oracle 9i. Regards
Answer Question
| May 27, 2004 7:48 AM
Oracle 9i
Using Record Type
We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk [...]
Answer Question
| May 26, 2004 7:44 AM
Oracle 9i
We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk [...]
Answer Question
| May 26, 2004 7:44 AM
Oracle 9i
Novell EDirectory synching with Oracle Internet Directory 10G using Novell IDM2 (previously DirXML)
Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?
Answer Question
| June 3, 2004 5:40 AM
General Directories, LDAP, Novell NDS, Oracle 10g, Oracle 8i, Oracle 9i
Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?
Answer Question
| June 3, 2004 5:40 AM
General Directories, LDAP, Novell NDS, Oracle 10g, Oracle 8i, Oracle 9i
Privileges for DBA role
In an Oracle 9.2.0.4 database I have a user with DBA as the default role. But I had to grant explicitly via “grant SELECT on …” to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant [...]
Answer Question
| May 20, 2004 10:49 AM
Oracle 9i
In an Oracle 9.2.0.4 database I have a user with DBA as the default role. But I had to grant explicitly via “grant SELECT on …” to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant [...]
Answer Question
| May 20, 2004 10:49 AM
Oracle 9i
Full Export on Win 2000
I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can’t get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well [...]
Answer Question
| May 13, 2004 5:08 PM
Oracle 9i, Windows 2000 Server
I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can’t get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well [...]
Answer Question
| May 13, 2004 5:08 PM
Oracle 9i, Windows 2000 Server
NLS Parameters, Character Set Selection for Saudi Arabia
HI, I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to support Chinese [...]
Answer Question
| May 21, 2004 12:58 PM
Installation/Upgrade, Oracle 9i
HI, I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to support Chinese [...]
Answer Question
| May 21, 2004 12:58 PM
Installation/Upgrade, Oracle 9i
Problem with dblinks generated from Oracle Warehouse Builder
Hi, I am using Oracle Warehouse Builder 9i to implement my data warehouse. Normally, it generates dblinks containing a TNS reference: create database link <hostname>@<connector> connect to <user> identified by <password> using ‘<hostname>’; But sometimes it generates dblinks containing a TNS *definition* instead: create database link <hostname>@<connector> connect to <user> identified by <password> using ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) [...]
Answer Question
| May 14, 2004 11:19 AM
Oracle, Oracle 9i, Tech support
Hi, I am using Oracle Warehouse Builder 9i to implement my data warehouse. Normally, it generates dblinks containing a TNS reference: create database link <hostname>@<connector> connect to <user> identified by <password> using ‘<hostname>’; But sometimes it generates dblinks containing a TNS *definition* instead: create database link <hostname>@<connector> connect to <user> identified by <password> using ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) [...]
Answer Question
| May 14, 2004 11:19 AM
Oracle, Oracle 9i, Tech support
