Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java.

learn more… | top users | synonyms

0
votes
2answers
392 views

Fail to create temp files in Oracle 10g

My disk is full so I delete oracle temp files to gain space. I use oragle 10g with CentOS release 4.4 Operation System. First Search temp files SELECT tablespace_name, file_name, bytes FROM ...
-1
votes
2answers
916 views

How to create running live server images Windows 2003 Server?

We have Windows 2003 Server (Oracle, Exchange 2003) running on old hardware and these are very critical servers. My company is not investing in IT department. I am looking full server live IMAGE on ...
-1
votes
5answers
4k views

What are the most popular database vendors based on market share? [closed]

I am wondering if anyone can point me to research or a link to statistics regarding popularity of database deployment. Obviously, MySQL, Oracle, SQLServer are some of the major players but I am ...
1
vote
1answer
715 views

Sun Fire X4200 (not M2) Firmware (BIOS/ILOM)?

i've running BIOS/ILOM 1.0 and it sucks with the hyperthreading sync error flood :( I just got my hands on a nice Sun Fire x64 server but I'm in a bit of a bind.  I need BIOS and ILOM files for a Sun ...
1
vote
2answers
135 views

What if I follow Oracle Instructions for hostname [duplicate]

Oracle Docs requiring Hostname to be FQDN. What do you think? Not really what I want to do but... should I? Verifying Host Names Use the following to verify host name settings: For Oracle Linux 4 ...
0
votes
1answer
217 views

Remove some entries from oracle DMP file

I have a DMP file from a production database that i'm trying to import into a testing environment. The DMP file was exported with exp (full backup). I no longer have access to the production database ...
3
votes
2answers
4k views

Oracle Linux 6 kernel panic boot - anything I can do?

I'm running Oracle Linux 6 on a HP Proliant server. It's been running fine for the last week, but seemed slow earlier so the Oracle service was stopped. Rather than restart the service, I was asked to ...
0
votes
1answer
948 views

how to configure memcached for weblogic 10.x and oracle 10.g

Have some web app using java, jsp, servlet. too many times frequent queries to oracle 10g under load. Thinking to introduce memcached, Is it simple ? Can it be done without code change? are there any ...
0
votes
1answer
714 views

Oracle connection failure to service with 'HA Events=True' in connection string

I'm assuming this is a configuration problem. Some background. I'm running a Windows 7 VM with VM Player. I've installed Oracle 11gR2 within the VM along with clients, Enterprise Manager, ...
2
votes
2answers
3k views

How do I (or is it advisable) downgrade Redhat Enterprise from 5.9 to 5.8 and find out when the original upgrade happened?

Two fold question. How do I find out when the upgrade from 5.8 to 5.9 happened? Where is this logged? What is the process of rolling back or downgrading from 5.9 to 5.8? Background: Supporting a ...
1
vote
1answer
2k views

Anyway to find out who shutdown oracle database

In my oracle database alert log file, I saw someone issued the command to shutdown oracle database. I am not able to find out what caused this. Is there a way to find out which user/program that ...
-2
votes
2answers
49 views

Do any versions of Oracle have a user limit? [closed]

I'm not sure which version of Oracle we have at Work (Enterprise or Standard), but do either of them have a limit on how many user accounts you can create?
1
vote
0answers
595 views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
2
votes
1answer
299 views

How to configure multipath using Intel X520-SR2 10GB on Oracle Linux 6.2?

I've installed the Intel x520-sr2 Ethernet/Fibre card into a server that has Oracle Linux 6.2 Installed on it. When I boot the server I can go into a QLogic menu (screen has something for Intel on ...
2
votes
1answer
150 views

puppet templates: possible to print the size of an exported resource array?

I'm writing a puppet module for ocfs2 and making use of exported resources to populate the definitions of all the cluster nodes in the config file on each cluster. This all works well. The cluster ...
0
votes
1answer
2k views

Place for setting environment variables for WebSphere JVM process

I have a websphere application which runs under the user wsadmin. The application invokes the SQL bulk loader client ./sqlldr The sqlldr needs some environment variables predefined in order to work ...
0
votes
1answer
188 views

Different sqlldr locations on load balanced nodes

We have two nodes in a cluster in a load balancer running third party WebSphere application. We have noticied that ./sqlldr location is different for both the nodes. For one node , its: ...
0
votes
2answers
498 views

MS Project Server 2010 and Oracle Database Backend?

After searching far and wide across the internet for an answer I have come here in hope of help. I am aware that MS Project Server 2010 requires a SharePoint server, but does anyone know if it is ...
0
votes
1answer
1k views

Configuring DHCPD to use option 66, in a specific subnet

I am trying to configure DHCP to use option 66 to provide a TFTP server to Sunray thin clients. The clients in a specific subnet must use a specific TFTP server so that they are served configuration ...
3
votes
1answer
751 views

Oracle with Kerberos authentication and Windows 2003 Server as KDC

I am running Oracle 10.2 on a Windows 2003 Server SP2 which is also the domain controller on the network. I wish to switch authentication method from NTS to Kerberos. I have spent a lot of time ...
0
votes
1answer
463 views

install kernel-uek-2.6.32-300.7.1.el5uek.x86_64.rpm fails

While trying to install kernel-uek-2.6.32-300.7.1.el5uek.x86_64.rpm I got following error :( Pls help, really in trouble [root@nonprodsrv02 kdumprpm]# rpm -ivh ...
0
votes
2answers
89 views

Filessystem sizing issues on root

I recently installed a VM version of Oracle Linux 6.3 and began installing applications for testing. I realized that the "/" mount is small and the "/home" mount is way oversized, See output below. ...
0
votes
1answer
296 views

JBoss 5.1.0 GA configuration for Oracle Data Guard

Can someone please point me to some tutorial or "how to" for configuring Jboss to work along with Oracle Data Guard. Motivation behind this is pretty standard, move some of the users to read from the ...
1
vote
1answer
1k views

Root SSH login works, but su/sudo to root does not work

Im recently working on a clients box, and SSH into the box with root credentials work but when i try to su or sudo to root user it states incorrect password. I tried changed the root password and know ...
1
vote
4answers
13k views

SQL Navigator startup error: Unhandled Exception at startup - Cannot find OCI DLL: oci.dll

I am using 64 bits Windows 7. Oracle Development Tool: SQL Navigator 5.5 was installed on my computer. When I try to start the program I get this error: "Unhandled Exception at startup - Cannot ...
1
vote
1answer
82 views

Oracle xml column to xml file

I want to automatically generate an xml file for every record found in an xml column in a table. Is there a script using a cursor or another method to do that?
1
vote
0answers
123 views

iPlanet Authentication provider

Good day. I have stepped into project that requires a server migration that would change the means of authentication for our CAC/PKI SSL enabled website. We are using iPlanet 7 and Oracle Directory ...
0
votes
1answer
243 views

Windows 2003 server with oracle freezes

I am newbie to servers n all.. Please do help. We are having a windows 2003 machine with the latest hardware configuration (i3 processor) which runs an ORACLE 8 Database server. The machine freezes ...
0
votes
1answer
535 views

SSL certificate for Oracle Application Server 11g

I was asked to get an SSL certificate for an "Oracle Application Server 11g" which has a soon-to-expire certificate. Brushing aside the fact that 10g seems to be the newest version, I got a ...
1
vote
2answers
6k views

Can't install kernel-uek-headers for currently running kernel

I have just created a VM in VMWare and installed a minimal install of Oracle Enterprise Linux 6.3. # cat /etc/oracle-release Oracle Linux Server release 6.3 It is running with the UEK kernel. # ...
2
votes
2answers
6k views

Extremely High V_$SYSTEM_EVENT Wait Times on Oracle DB

I'm working on troubleshooting an oracle DB that's having some general performance problems. I ran the following query: SELECT event AS "Event|Name", total_waits "Total|Waits", ...
1
vote
0answers
473 views

Oracle Virtual Server OEL vm fails to start - kernel panic on cpu identify

I am in the process of following a guide to setup various oracle vm templates, so far I have installed OVS 2. 2 and got the OVM Manager working, imported the template for OEL5U5 and created a vm from ...
3
votes
2answers
362 views

Is disconnecting a network cable different from VMware “Connected” option?

I have an application that connects to a database and retrieves information from it. The way it is written is: for every request received, create a new connection to the DB server and retrieve data. ...
0
votes
1answer
316 views

2 RAC node clusters with different RAID layouts?

I am comparing RAID 10 and RAID 5 configurations for Oracle database in order to determine the best choice in terms of performance for mixed workloads. Is it possible to have 2 RAC node clusters and ...
1
vote
2answers
118 views

OID (directory service) Installation and configuration on Windows 2003 R2

I need your help in installing and configuring Oracle Internet Directory service on Windows 2003 R2 server machine, I was wondering if anyone can provide any useful tutorial links on the same. I did ...
1
vote
1answer
2k views

Oracle- Can't access objects from other users schema

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I ...
0
votes
1answer
113 views

Oracle Import Dump [closed]

After system failure I have bought a new server and now Im trying to recreate the oracle database I had. I have a dump file which was made with the command exp and full=y. So can I restore the full ...
0
votes
1answer
61 views

Oracle replication A->B and B<-A?

If you have two unrelated Oracle databases on separate servers, can you replicate A to B and B to A so both servers have a copy of both db's? Idea is for DR "on the cheap" without buying more Oracle ...
0
votes
2answers
106 views

How Oracle is doing high availability? [closed]

We are searching for some replacement of our mysql cluster - Oracle or pgsql. I read the whole document about HA in Oracle 11 database system, but I really was not able to understand it quite enough. ...
0
votes
1answer
322 views

Are Oracle Database CPU license limits enforced by software, and how do I check them? [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? I've inherited a windows VM running Oracle Database 10g. Currently the VM has only one CPU assigned to it, but I can ...
0
votes
2answers
395 views

Performance-optimizing Oracle 10g on a server that is also a Tomcat JSP app server?

I have inherited a simple RedHat 5 - 64bit platform. It has SCSI disks on RAID1, with 16GB of RAM. Double Core CPU. Oracle 10g, Release 2. This would be a decent platform for running the DB ...
-1
votes
2answers
204 views

display sql syntax in Oracle's sqlplus? [closed]

What is in Oracle's sqlplus equivalent of Linux's man or --help ? When I'm in sqlplus and type help index, I get some commands displayed, but there is no way to get specific sql syntax. For example ...
0
votes
1answer
823 views

Oracle redo log performance degradation when inserting

I have a oracle 11g database. I'm testing in for inserts. The database running in noarchive mode. I have 3 redo log configured, each 2gb. I'm trying to insert data into test table. At begin it goes ...
0
votes
1answer
51 views

Does Oracle database need to be restarted to use Rman?

We have an Oracle database which uses Rman. The server hosting Rman repositories crashed. We've put the Rman server back online, but do we need to bounce the Oracle database to get it to start using ...
3
votes
1answer
543 views

Error ORA-01034: Oracle not available

I have an old Novell server which runs DocsOpen. I know very little about this system, basically we had a disk fault which halted the system. The server was rebooted and came up, I had to manually ...
1
vote
3answers
17k views

Cannot log into Oracle Enterprise Manager 11g: ORA-28001

I can no longer log into Oracle Enterprise Manager 11g. I get this error message: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) I could log into the server using SQL*Plus. I ...
2
votes
4answers
253 views

Oracle performance problem

We are using an Oracle 11G machine that is very powerful; has redundant storage etc. It's a beast from what I have been told. We just got this DB for a tool that when I first came on as a coop had ...
0
votes
1answer
107 views

How does Oracle Streams prevent the execution of code during the distribution process?

I thought about Oracle Streams and stumpled into a question. Oracle Streams is used on the database I am programming for, but I am not the DBA. Therefore I am not familiar with the configuration of ...
0
votes
2answers
688 views

Oracle Database Recovery Problem

I am very new to Oracle, and trying to restore a oracle 8i database on win 2000 server. I have one week old database backup (backup taken with exp command), and i want to restore it now. Now I am ...
2
votes
2answers
3k views

Executing Oracle SQLPlus in a Powershell Invoke-Command statement against a remote machine

We have a basic powershell script that attempts to execute SQLPlus.exe on a remote machine. The remote does not have Oracle Instant client installed, but we have bundled all the necesary dlls in a ...