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

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
1k 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
542 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
27k 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 ...
2
votes
1answer
283 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
149 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
1k 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
179 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
485 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
749 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
448 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
85 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
281 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
12k 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
60 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
117 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
236 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
490 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
5k 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
455 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
351 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
291 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
111 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
111 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
60 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
105 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
313 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
378 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
199 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
777 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
50 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
250 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
99 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
685 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 ...
2
votes
3answers
2k views

SELinux is preventing Perl CGI script from accessing Oracle libraries

I'm trying to configure SELinux on a Red Hat Enterprise Linux 6.2 web server that runs Apache 2.2.15 and Perl 5.10.1, and connects to remote Oracle databases. The Oracle 11.2g client is installed. The ...
2
votes
2answers
831 views

How to mount an Oracle database to new instance?

I have an instance of Oracle 10g R2 installed on Windows Server 2003. This instance was running a database which does not have any backup. Now the OS went down, could not be repaired, and all I got is ...
1
vote
1answer
312 views

Install Oracle Java JRE 7 on Ubuntu with just the command line

I can't use openjdk because it doesn't have native .jpg support. I can't use sudo apt-get install sun-java6-jre sun-java6-plugin any more because apparently those have been pulled. JRE version 7 ...
2
votes
3answers
694 views

Getting an alert when my oracle database goes up or down

How can I get an e-mail alert when my oracle database comes up or down? I have a database that I need to know when it goes down (it would be nice to know if it has come back up), preferably from a ...
0
votes
1answer
77 views

Jmeter gets Apache lost db connection

I have a web app that makes to many ajax requests (update data with a grid). When I use JMeter to make a stress test with 20 threads and 10 loops, my web application canno't connect to the database ...
3
votes
2answers
588 views

Why would adding a datafile cause a deadlock in Oracle?

I have noticed something in Oracle which never happened before to me. Though I frequently do this kind of thing for many years now. In this case it's an Oracle11 instance (Oracle Database 11g ...
2
votes
5answers
18k views

Why Oracle database generates lots of archived log per day when there is a small changes to the database?

I'm currently using Oracle database 11g on RHEL5. My database generates a lot of archived logs per day even there is a small amount of changes to the database (about 500 transactions a day). I also ...
0
votes
1answer
545 views

Exception thrown when trying to access a web service (Weblogic) - java.lang.LinkageError

I've installed Adobe LiveCycle for Weblogic 10.3.4, and when I try to access one of the web services it deployed, I'm getting the following exception: Exception - java.lang.LinkageError: loader ...