Configuring OEM to access Oracle on 2 systems
Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform–not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in oracleora92networkadmin folder) on my PC. Q1: How can i configure the current OEM to access to [...]
Answer Question
| July 27, 2005 10:33 PM
Oracle, Oracle 9i
Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform–not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in oracleora92networkadmin folder) on my PC. Q1: How can i configure the current OEM to access to [...]
Answer Question
| July 27, 2005 10:33 PM
Oracle, Oracle 9i
Trying to solve ORA-00980: synonym translation is no longer valid
I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran the catalog.sql script per the [...]
Answer Question
| July 27, 2005 10:13 PM
Oracle 9i, Standard Edition
I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran the catalog.sql script per the [...]
Answer Question
| July 27, 2005 10:13 PM
Oracle 9i, Standard Edition
Tablespace recovery
Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile (if only a datafile [...]
Answer Question
| July 26, 2005 4:53 AM
Oracle 9i
Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile (if only a datafile [...]
Answer Question
| July 26, 2005 4:53 AM
Oracle 9i
Should you ever consider creating a fresh database for a user’s e-mail?
On our Domino server, there is one mailbox that keeps generating errors. It is flagged in STATREP.nsf daily because documents can’t be created or mail rules are problematic. I am unable to view the Rules in the database, and in Domino Administrator, it’s the only mail file that doesn’t show a template. I’ve tried tackling [...]
Answer Question
| August 3, 2005 12:39 PM
Administration, Database, DB2, Lotus Domino, Oracle
On our Domino server, there is one mailbox that keeps generating errors. It is flagged in STATREP.nsf daily because documents can’t be created or mail rules are problematic. I am unable to view the Rules in the database, and in Domino Administrator, it’s the only mail file that doesn’t show a template. I’ve tried tackling [...]
Answer Question
| August 3, 2005 12:39 PM
Administration, Database, DB2, Lotus Domino, Oracle
SQL Server worst practices
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers [...]
Answer Question
| July 26, 2005 12:16 PM
Administration, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Development, Hardware, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Version 7 and earlier
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers [...]
Answer Question
| July 26, 2005 12:16 PM
Administration, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Development, Hardware, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Version 7 and earlier
Packages, Procedures & Functions
What are the best practices for design with regards to packages, procs and funcs. More specifically, which schema to place these objects? The database contains a couple of schemas with tables that support the system. This is a DW system and one schema contains stage tables and the other holds the dimension and fact tables. [...]
Answer Question
| July 22, 2005 3:21 PM
Oracle
What are the best practices for design with regards to packages, procs and funcs. More specifically, which schema to place these objects? The database contains a couple of schemas with tables that support the system. This is a DW system and one schema contains stage tables and the other holds the dimension and fact tables. [...]
Answer Question
| July 22, 2005 3:21 PM
Oracle
Email alerts and export report to Excel
I’m running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily [...]
Answer Question
| July 20, 2005 3:12 AM
E-mail applications, Exchange, Oracle, Oracle 9i, Sendmail
I’m running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily [...]
Answer Question
| July 20, 2005 3:12 AM
E-mail applications, Exchange, Oracle, Oracle 9i, Sendmail
Upgrade to SQL Server 2005 sooner or later?
Hello, I’m the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization’s plans? 58% delays had no [...]
Answer Question
| July 22, 2005 10:19 AM
Administration, Architecture/Design, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Implementation, Installation/Upgrade, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier
Hello, I’m the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization’s plans? 58% delays had no [...]
Answer Question
| July 22, 2005 10:19 AM
Administration, Architecture/Design, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Implementation, Installation/Upgrade, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier
Naming Constraints and Moving Tables
Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to “clean-up” his act 1)Move all my uses even SYS to use [...]
Answer Question
| July 15, 2005 10:57 PM
Oracle 9i
Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to “clean-up” his act 1)Move all my uses even SYS to use [...]
Answer Question
| July 15, 2005 10:57 PM
Oracle 9i
Technical College vs. University
Hello all- Would it be more beneficial to attend a technical college or university? A certain technical college, ECPI (www.ecpi.edu) in VA, has sparked my interest because they advertise ‘they meet with some industry experts to discuss tech trends and what education needs to be put out to keep up with today’s skills.’ I want [...]
Answer Question
| January 10, 2010 4:20 PM
Career development, CCNA, Certifications, Data analysis, Data center operations, Data mining/analysis, Data warehousing applications, DataCenter, Development, DHCP, DNS, E-mail applications, Ecommerce applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Hardware, Help Desk, IBM, Knowledge management applications, Lotus Domino, Mail protocols, Microsoft Windows, Network management software, Networking, Networking certifications, Networking Equipment, Networking services, Oracle, Outlook, Security, Security management, Systems management software, Tech support, Vendors
Hello all- Would it be more beneficial to attend a technical college or university? A certain technical college, ECPI (www.ecpi.edu) in VA, has sparked my interest because they advertise ‘they meet with some industry experts to discuss tech trends and what education needs to be put out to keep up with today’s skills.’ I want [...]
Answer Question
| January 10, 2010 4:20 PM
Career development, CCNA, Certifications, Data analysis, Data center operations, Data mining/analysis, Data warehousing applications, DataCenter, Development, DHCP, DNS, E-mail applications, Ecommerce applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Hardware, Help Desk, IBM, Knowledge management applications, Lotus Domino, Mail protocols, Microsoft Windows, Network management software, Networking, Networking certifications, Networking Equipment, Networking services, Oracle, Outlook, Security, Security management, Systems management software, Tech support, Vendors
Oracle Forms
Is there a way to use a Oracle Form to Upload a file to a specific folder and store the filename in the database? I know how to do this through HTML/ASP/VBS, but my company wants it through Oracle Forms. Also, how would I make a hidden field appear when a LOV Item is selected [...]
Answer Question
| July 8, 2005 11:43 AM
Database Management Systems, Implementation, Oracle, Tech support, Web development tools
Is there a way to use a Oracle Form to Upload a file to a specific folder and store the filename in the database? I know how to do this through HTML/ASP/VBS, but my company wants it through Oracle Forms. Also, how would I make a hidden field appear when a LOV Item is selected [...]
Answer Question
| July 8, 2005 11:43 AM
Database Management Systems, Implementation, Oracle, Tech support, Web development tools
Oracle Forms Developer/Builder for Oracle 9
I have two questions. The first is, how would you go about changing the applet size when running a form? Or, is there a way? The other question is, how can you use Forms Builder to upload a file/document to the database? I need to load a filepath but I’m not quite sure how I [...]
Answer Question
| July 7, 2005 3:19 PM
Database Management Systems, Development, Oracle, Web development tools
I have two questions. The first is, how would you go about changing the applet size when running a form? Or, is there a way? The other question is, how can you use Forms Builder to upload a file/document to the database? I need to load a filepath but I’m not quite sure how I [...]
Answer Question
| July 7, 2005 3:19 PM
Database Management Systems, Development, Oracle, Web development tools
What are the requirements for oracle10g Real Application clusters using ASM?
Dear sir, what are the software reqiurements for configuring Oracle 10g real application clusters?
Answer Question
| July 5, 2005 3:30 AM
Database Management Systems, Development, Hardware, Oracle, Web services
Dear sir, what are the software reqiurements for configuring Oracle 10g real application clusters?
Answer Question
| July 5, 2005 3:30 AM
Database Management Systems, Development, Hardware, Oracle, Web services
How to configure oracle 10g databses in two nodes and automatic storage management?
I have a good knowledge about oracle 10g database configuration and oracle appln server configuration.We would like to configure that’s as like a cluster.How to configure oracle 10g databses in two nodes and automatic storage management?
Answer Question
| July 4, 2005 6:22 AM
Development, DHCP, DNS, Networking services, Oracle, Performance management
I have a good knowledge about oracle 10g database configuration and oracle appln server configuration.We would like to configure that’s as like a cluster.How to configure oracle 10g databses in two nodes and automatic storage management?
Answer Question
| July 4, 2005 6:22 AM
Development, DHCP, DNS, Networking services, Oracle, Performance management
Number Crunching Machines
I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I’m not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc. What concerns me though is that I have worked on AS400′s now for 10years [...]
Answer Question
| June 20, 2005 8:05 AM
Database Management Systems, DataCenter, DB2, Desktops, Hardware, IT architecture, Networking, Oracle, Servers, SQL Server
I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I’m not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc. What concerns me though is that I have worked on AS400′s now for 10years [...]
Answer Question
| June 20, 2005 8:05 AM
Database Management Systems, DataCenter, DB2, Desktops, Hardware, IT architecture, Networking, Oracle, Servers, SQL Server
Sql ( I think i am almost there)
after selecting all of my columns i joined the tables as follows FROM EMPL B, HB_EMPL_PKG_ELEC D, HB_EMPL_DEP_BNFIC A, HB_EMPL_MED_DEP C WHERE B.EMPL_ID = A.EMPL_ID(+) AND C.EMPL_ID = A.EMPL_ID AND C.BEN_PLAN_CD IN (‘UHCALL’,'UHCBASIC’) AND B.EMPL_ID = D.EMPL_ID(+) AND D.BEN_PLAN_CD IN(‘UHCALL’,'UHCBASIC’) AND B.S_EMPL_STATUS_CD=’ACT’; and i am duplicating the employee file, for example; v1.20abcdef 1800123456689 lastname1 firstname… [...]
Answer Question
| June 15, 2005 7:41 AM
Oracle, SQL
after selecting all of my columns i joined the tables as follows FROM EMPL B, HB_EMPL_PKG_ELEC D, HB_EMPL_DEP_BNFIC A, HB_EMPL_MED_DEP C WHERE B.EMPL_ID = A.EMPL_ID(+) AND C.EMPL_ID = A.EMPL_ID AND C.BEN_PLAN_CD IN (‘UHCALL’,'UHCBASIC’) AND B.EMPL_ID = D.EMPL_ID(+) AND D.BEN_PLAN_CD IN(‘UHCALL’,'UHCBASIC’) AND B.S_EMPL_STATUS_CD=’ACT’; and i am duplicating the employee file, for example; v1.20abcdef 1800123456689 lastname1 firstname… [...]
Answer Question
| June 15, 2005 7:41 AM
Oracle, SQL
Calculation at database level
Hi! Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to calculate the [...]
Answer Question
| June 13, 2005 3:47 PM
Database, DB2, Development, Oracle, Security, Software Quality Assurance, Software testing
Hi! Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to calculate the [...]
Answer Question
| June 13, 2005 3:47 PM
Database, DB2, Development, Oracle, Security, Software Quality Assurance, Software testing
Oracle Inbound 850 Customer PO’s with Multiple Documents – Odd failure
Ok, I know I might be sotgunning here, but so far I canna find even a glimmer of an answer to this. Oracle Apps 11.5.9 Oracle eCommerce Gateway Inbound EDI 850 Customer PO’s I’m developing this process for a client, and I’m in the middle of testing my solution. Everything works fine when an 850 [...]
Answer Question
| June 22, 2011 3:49 PM
ERP, Oracle, Oracle Financials, Order Management, Procurement, SQL
Ok, I know I might be sotgunning here, but so far I canna find even a glimmer of an answer to this. Oracle Apps 11.5.9 Oracle eCommerce Gateway Inbound EDI 850 Customer PO’s I’m developing this process for a client, and I’m in the middle of testing my solution. Everything works fine when an 850 [...]
Answer Question
| June 22, 2011 3:49 PM
ERP, Oracle, Oracle Financials, Order Management, Procurement, SQL
Oracle applications Development
I cant run net8 easy config after installing oracle6i on a machine currently running Developer 2000 forms 5. What do I do. Lekan
Answer Question
| July 8, 2005 6:08 AM
Development, Oracle
I cant run net8 easy config after installing oracle6i on a machine currently running Developer 2000 forms 5. What do I do. Lekan
Answer Question
| July 8, 2005 6:08 AM
Development, Oracle
Please help
Yet another question, and an example of my code. i have pulled some of the information that i need for the flat file by connecting to 3 tables, then sending the information i have chosen from the table into columns. i need to connect to another 2set of tables to add further information to my [...]
Answer Question
| June 7, 2005 10:08 AM
Oracle, SQL, Visual Basic
Yet another question, and an example of my code. i have pulled some of the information that i need for the flat file by connecting to 3 tables, then sending the information i have chosen from the table into columns. i need to connect to another 2set of tables to add further information to my [...]
Answer Question
| June 7, 2005 10:08 AM
Oracle, SQL, Visual Basic
