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

1
vote
4answers
18k views

Oracle database is very slow - Where to start and how to find the cause?

Our Oracle database(11g) is very slow all of a sudden. I donno where to start the debugging process to find what actually is the problem? I tried generating table stats and looked for locks..but i ...
0
votes
3answers
1k views

Cannot connect to oracle using oci_connect() on reboot

I am trying to setup a local development box. The box's on Linux Mint. Installed apache, php and mysql without any problem, then I proceeded to install Oracle Xpress Edition as my newest project ...
0
votes
0answers
105 views

PLSQL-Developer debug session crashed > database slowed down > restart VM> ORA-01034 & ORA-27101 (Oracle 11G- WIN7)

I recently started a debug session to debug a package function, this session crashed the PLSQL-Developer at one of the first lines (that havent changed & always worked fine (its ony variable ...
0
votes
1answer
44 views

Oracle APEX in browser over VPN

After lots of futzing around with all of the settings, I finally managed to get APEX to work on a remote server. To get that to happen, I had to grant my user the SYSDBA role, and I also included ...
1
vote
6answers
1k views

Linux database diff tool

I'm looking for a database schema comparison tool that runs on Linux, handles Oracle databases, and can generate a synchronization script to migrate one schema to another. TOAD does this very well on ...
1
vote
1answer
88 views

LSI 3042 supported with Oracle VM Server

Trying to install an HP DL165 1U server with an LSI 3042 SAS card. I get to the install, selected a language, select a keyboard screens then it asks me for a location for the driver (it doesn't tell ...
0
votes
2answers
330 views

Oracle 10g on RHEL - All memory gets eaten up nightly at 20.15

Okay, to start things off, I'm brand new to Oracle DB. Much experience with Microsoft products (boo) and Ubuntu linux, but RHEL and Oracle are very new to me. The environment ... Oracle DB 10g ...
1
vote
1answer
1k views

Oracle 'sysman' account

In Oracle, is sysman is the most powerful user or are there other equally privileged users?
3
votes
1answer
203 views

CPU Sockets vs. Cores

We are looking at software that is licensed by socket. Right now our hypervisor (EXSi) underutilizes the 2 socket 8 core processing power it has. Most guests only have 4 virtual cores. In order be ...
0
votes
2answers
126 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
329 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
362 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
85 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
101 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 ...
2
votes
2answers
2k 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 ...
1
vote
1answer
1k views

Configure Perl DBI and DBD in Linux

I am new to Perl and I work in a Linux OEL 5x server. I am trying to configure the Perl DB modules for Oracle connectivity (DBD and DBI modules). Can anyone help me out in the installation procedure? ...
0
votes
1answer
812 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
3answers
522 views

How do I redirect Weblogic logging to database?

Is there a way to send or redirect Weblogic (or Fusion Middleware) logging output to a database, without having to write a custom application? All the documentation I've read seem to deal exclusively ...
1
vote
1answer
227 views

Can't start WebLogic admin console

I'm wondering how to fix this error. We had the wrong Java installed on my machine when I got it, so my boss installed JRocket to fix things. WebLogic has been having problems ever since. I cannot ...
0
votes
1answer
291 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
2k 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
416 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
45 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
266 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 ...
1
vote
5answers
23k views

TNS-12535: TNS:operation timed out — Oracle DB

I'm seeing a lot of queries from a .Net data access server I maintain timing out. It appears to be totally random with no relationship to data or data locks. For example, the following query timed ...
8
votes
2answers
11k views

Disable CPU cores in bios?

Is it possible to disable CPU (Intel) cores in BIOS, and if yes what HP/DELL (others?) 1U/2U servers would allow this? It is becoming difficult to find new server hardware with dual core CPUs, most ...
2
votes
1answer
177 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
96 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
364 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
115 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
359 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
583 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
3answers
2k views

How to delete data and free up disk space in Oracle DBMS 9i

I would like to know how usually one would delete data from an Oracle 9i DBMS which actually frees up disc space. Past scenario, we have had cases where clearing up 1-2 million rows of data does not ...
3
votes
1answer
715 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
278 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
70 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
139 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 ...
0
votes
0answers
234 views

ORA-00942: table or view does not exist & ORA-01031: insufficient privileges

I can't access any tables on my oracle database. When selecting the table product I get ORA-00942: table or view does not exist I have tried this solution but I don't have sufficiënt rights to add a ...
1
vote
1answer
407 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
10k 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
56 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
82 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
159 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
231 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
4k 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
4k 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
257 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 ...
1
vote
1answer
444 views

How do I ensure that the SQL*Net keepalive is turned on?

I have a public facing application server that accesses an Oracle database that resides behind a firewall. Some of the processes that are executed through the application server can run for over an ...
3
votes
2answers
214 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. ...