16/11/2018 11:47
Just about to set up our new Oracle server. The box is a Dell PowerEdge 2850, Dual Xeon 3.6GHz with 4 Gb RAM and 4x 18Gb 15,000 RPM Drives. I am about to set up the RAID array and am unsure as what would be best. I was originally going to use RAID 5 but am unsure now as I have read so many bad things about using it with Oracle. Some form of redundancy is requred so here are my proposed alternatives: 1) 2x RAID 1 arrays - this would give me a total of 36Gb and as each volume would be mirror.... read more

3 answersclick here to view

15/11/2018 11:47
I would like to know how can i create RAC db manually on Linux. When iam using dbca to create rac i am getting all kind of error like unableto write to controlfile etc.
My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit Thanks for your help.

1 answersclick here to view

14/11/2018 11:47
We are glad to introduce you our collection of best eBooks covering different fields of Information Technologies. Totally, our collection includes 1000 books from different areas of IT: .NET, Java, C#, C++, Perl, PHP, Python, XML, Oracle, Microsoft SQL Server, MySql, UNIX, Linux, CISCO, TCP/IP etc. You can purchase the collection only for $60. If you are interested, visit the following web site: http://www.best-it-ebooks.com

2 answersclick here to view

13/11/2018 11:47
We currently run Oracle Applications 10.7, Oracle 8 db. We areupgrading to Oracle Applications 11.5.10 with new hardware. We plan onrunning Oracle db on Red Hat Linux. My problem is with the hardwarethat our hardware vendor is recommending we purchase.
This is what I am hoping the people with real-life experience, withopinions based in reality, can give me: a recommendation on what wereally need, not what our hardware vendor needs to sell.
I'll tell you all about our current environment.... read more

3 answersclick here to view

12/11/2018 11:47
Hi, If I have DB on my own local machine, I'm able to run this command,which modify outfile to csv-format: INTO OUTFILE '/Temp/statistic/payment_per_week.csv'FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''LINES TERMINATED BY ' ' but If I'm running same command from client machine and my DB serveris other machine I have to use this format to get that outfile to my machine: C:>mysql --host=211.37.6.12 --port=3306 --database=testing--local -umyown -p .... read more

4 answersclick here to view

11/11/2018 11:47
I can do this, probably the long way with PLSQL code. I was justseeing if someone knew of a better way.
Here is our query: v_select := 'SELECT my_left_table.fund_name, my_left_table.ticker, DECODE(fund_rank.curr_rank,NULL,'NA',fund_rank.curr_rank)AS fund_rank, my_left_table.total_return_ytd, my_left_table.total_return_1mt, my_left_table.total_return_3mt, my_left_table.total_return_1yr, my_left_table.total_r.... read more

3 answersclick here to view

10/11/2018 11:47
Server is 11.1.0.7 on Linux/x86. I noticed processes sometimes holding an edition lock on object ORA$BASE. The V$LOCK_TYPE table says the following: Prevent Dropping an edition in use. To make things even more confusing, there is a very well hidden view named '_CURRENT_EDITION_OBJECT'. Here is the text: <code>select textfrom dba_views where view_name = '_CURRENT_EDITION_OBJ'; TEXT -------------------------------------------------------------------------------- select o.OB.... read more

2 answersclick here to view

09/11/2018 11:47
Hello.
I am relatively new to Oracle as a DB, but we use Oracle 9i under thefollowing conditions.
A sun e6500 ten processor system is direct connected to a sunfire V240 twoprocessor system with 8 GB RAM.
Here is my problem. The V240 has high IO wait times when large numbers ofprocesses are underway. The swap in use number goes through the roof whenoracle is running and I still have some 60+% of system memory listed asfree. I also cannot seem to increase the total SGA size beyond what itpresent.... read more

5 answersclick here to view

07/11/2018 11:47
Is there are any way to prevent jobs from being imported under wrongusername (SYS) when schema exp/imp is being done (e.g. schemamovement?) I suspect this has to do with user_id's not matching..
Thanks.
.......
We run Oracle 9.2.0.6 on RH4 AMDremove NSPAM to email

1 answersclick here to view

06/11/2018 11:47
Hi, System is MySQL 5.0.51a-3ubuntu5.1 on Ubuntu 8.04 running on VMWare. I'veassigned the virtual machine 1GB of ram.
I'm currently running a join on a couple of views that cause the server torespond with Error Code : 2013Lost connection to MySQL server during query(0 ms taken) The same query runs fine if you trim the where clause (by taking out an isnull check).
I've had a look at the syslog and get the following: Jul 14 19:34:26 vmsql mysqld[6962]: 080714 19:34:26 - mysqld got s.... read more

3 answersclick here to view

05/11/2018 11:47
Test ManagerDuration; 3 Months +Location: PhoenixSkills: Candidate needs to work on the PeopleSoft / Payroll testinginitiative.
The following would be good experience: Mercury Quality Center, MQCSDLCAmerican Express experienceSIT, UAT, testing experience Please send your updated Resume to jobs@mapleresource.net

7 answersclick here to view

04/11/2018 11:47
Hi,I try to register in Oracle metalink and it asks me for customersupport identifier. May I know what is customer support identifier andhow can i get that.
Thanks and Regards,Kalaivanan

3 answersclick here to view

03/11/2018 11:47
Hello all, I have a simple (?) question.
In an update trigger I want to delete a record.
For example: If :new.correctprocessed = 1 then delete this record;end if; Is this possible or do I have to do it another way? Thanks and regards,Anneke

3 answersclick here to view

02/11/2018 11:47
Hi,Anyone know if exist any document that describe how to install ora 9ir2 on fedora fc4?Thank You

2 answersclick here to view

01/11/2018 11:47
Hello everybody, I am installing oracle 8i on a hpux 11.00 and after choosing what I want toinstall in oracle installer , I havethis message: Thrown when the ip adress of a host cannot be determined Everything seem ok for my network. my dns is working, my host can be pingedand telneted without problem. Eveything seems perfect but always the samemessage.
Can somebody help me or direct me to a solution.
Thanks in advance Gilles

3 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS