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
1answer
54 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
0
votes
1answer
202 views

Oracle 11g TNSLSNR LAST_ACK connection flooding

We have Windows 2k3 EE SP2 with Oracle 11.2.0.1.0 DB installed. The DB is used by different applications (including web-apps and services). From time to time, we have some problems with the web ...
0
votes
1answer
83 views

Websphere shutdown not releasing database locks

Sometimes when shutting down Websphere there are database locks not released. As a result, when WAS is restarted nobody can work because of these locks, that must be removed manually by the DBA. It's ...
2
votes
1answer
4k views

Cannot create Oracle ODBC source on 64bit Windows 7

I have installed the 64-bit version of the Oracle ODBC driver (instantclient-odbc-windows.x64-12.1.0.1.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html) on my 64 bit Windows 7 ...
13
votes
3answers
1k views

Does my Oracle DBA need root access?

My Oracle DBA Colleague is requesting root access on our production servers. He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not ...
2
votes
0answers
131 views

MICR check printing through Linux (EBS)

We are currently working to get a new MICR check printer (Troy Micr - HP Laserjet 600 M601) printing correctly with Oracle EBS. Our EBS installation runs on Oracle Enterprise Linux (Redhat Based). The ...
1
vote
1answer
100 views

Ganglia Oracle plugin?

Can't seem to find a good Oracle plugin for Ganglia. I was hoping someone could point me in the right direction? I'm not hugely familiar with Oracle so I'm assuming it exposes the various metrics via ...
0
votes
1answer
650 views

ORA-12154: TNS:could not resolve the connect identifier specified

I'm trying to use bat file/CLI to run SQL script against certain Oracle database with following syntax: sqlplus -L user_name/database_name@Password @d:\my_bat_file\sql_script.sql If I run this ...
0
votes
0answers
266 views

Username/password for Oracle Linux 5.8 VirtualMachine

I have the Oracle Linux 5 ova (converted to VirtualBox). The documentation I have seen mentions using either root/oracle or oracle/oracle to login. However that is not working. Any ...
1
vote
0answers
39 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
0
votes
1answer
393 views

How do I install Oracle Linux 6 with the UEK over the Internet?

Is it possible to use the Oracle Linux 6 UEK download and download the rest of the OS over the Internet? I have UEK running. I selected URL for the Installation Method. I tried various URLs for ...
0
votes
1answer
93 views

IBM System X M4 Series Servers Oracle Linux Support

Is Oracle Linux runnable/compatible with the M4 Series of the IBM System X Servers? In their compatibility website, most compatible machines listed are those from Dell and HP..there are IBM system ...
0
votes
1answer
341 views

Error installing Oracle-Java6

I'm attempting to install Oracle-Java6 on my VPS, running ubuntu-10.04 for the purpose of running Openmeetings. I installed the ppa webupd8team/java, updated and ran sudo apt-get install ...
0
votes
2answers
41 views

Oracle 10g backup issue

Introduction: I have to set up a backup concept for an old Oracle 10g installation. The server is old and poorly managed, but I have to ensure we have rock solid backups until the system will be taken ...
0
votes
3answers
2k views

Can Docker help me install Oracle 11g database on Ubuntu?

We are struggling with a common problem of trying to provide an Oracle 11g instance for our developers to test with. Our standard build agents are based on Ubuntu 12.04 but Oracle supports only RedHat ...
0
votes
1answer
139 views

Error while using oraenv

I'm using Oracle RAC in RH6, and when i try to use the 'oraenv' utility to set the variables with the user oracle, i get an error: [oracle@vhor12 ~]$ . oraenv /bin/.: Permission denied. Using it in ...
0
votes
1answer
154 views

SQLPlus for Oracle 11 not rolling back

I have a shell script which invokes an SQL file. However even with AUTOCOMMIT OFF and on SQLERROR EXIT ROLLBACK. Sqlplus fails to rollback. My sql file has 3 lines 3 are correct and 1 is incorrect. ...
0
votes
1answer
219 views

Oracle Counters for Perfmon

How to install Oracle Counters for Windows Performance Monitor (and operfcfg.exe) on a separate machine (other than the machine where Oracle Database Server is installed) ? The Oracle database version ...
0
votes
1answer
611 views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details Net ...
2
votes
1answer
413 views

How to recover from a power loss on an OVM server

We had a UPS error and lost power on a physical server hosting about 10+ virtual machines using Oracle VM platform. We got it back up and running, but I am wondering what is the best way to recover ...
0
votes
2answers
150 views

Set up JDBC DataSource in LDAP

How do I create a JDBC DataSource in an OpenLDAP server? The problem is that jdbc/something is not a valid DN or RDN. But that is the format of the name that you are supposed to use for JDBC ...
0
votes
1answer
42 views

Oracle application and DB scale out in private cloud

I have a client who was looking to migrate their Oracle environment to Amazon - probably Amazon RDS but were unable to get the SLA they wanted from it. I need to know if deploying something to ...
1
vote
2answers
643 views

Install an Oracle DB in a linux VM

I am trying to set up an Oracle database server (at the moment just for testing purposes) in a virtual machine. The setup I'm using: VirtualBox Network adapter in NAT mode (redirecting ports ...
2
votes
4answers
2k views

How to make RHEL have persistent local hdd name?

I have 2 identical Dell R720 servers running identical Oracle Enterprise Linux(RHEL)6.4. Both servers (supposedly) configured in exactly the same way. However, one of the servers is behaving ...
7
votes
1answer
484 views

LSI RAID controller errors on DB import - How to troubleshoot?

We're running an import of a database dump on an Oracle system - (RHEL 5.9, 2.6.18-348.6.1.el5). The import does not complete, eventually erroring-out with: ORA-15080: synchronous I/O operation to a ...
3
votes
1answer
351 views

Oracle Audit Vault and Database Firewall on Hyper-V

I am trying to configure an Oracle Database Firewall / Audit Server as virtual machines on Hyper-V. The problem is that, for example, to install the Database Firewall on a virtual machine, the VM ...
2
votes
0answers
221 views

Dtrace Oracle show high fsflush on solaris 10

Solaris 10 - Oracle 11G in a zone Running mpstat , i've noticed that one CPU was at 100% used every 5 seconds for 5 seconds while all other CPU were fine, in used but nicely spread. 1 0 0 0 ...
1
vote
1answer
95 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
0
votes
1answer
369 views

Cannot open oracle 9i database: ORA-16038: log 4 sequence# 1781 cannot be archived

my server was unexpectedly rebooted. after the server boot up I received the following error when trying to start up the database: ORA-16038: log 4 sequence# 1781 cannot be archived ORA-19504: ...
0
votes
0answers
375 views

Oracle 11gR2 Listener stop automatically

My problem is after I started Oracle Listener succesfully, it will stop automatically after a few seconds. cache1-> lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-MAY-2013 ...
0
votes
0answers
178 views

can not get required packages with yum

I wound like to install Tuleap - on Oracle Linux 6.4 [ebalbar@puding ~]$ yum repolist Loaded plugins: refresh-packagekit, security repo id repo name ...
0
votes
1answer
2k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
0
votes
1answer
57 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
1answer
121 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
642 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 ...
3
votes
1answer
531 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
263 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
681 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
vote
1answer
592 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
116 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
158 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 ...
0
votes
1answer
99 views

Prevent UNDOTBS to abort import

I have a dumpfile that I want to import in an Oracle 10g database in a virtual machine (with limited disk space). The dump file is about 3.5GB. When I try to import the dump, the size of the ...
0
votes
3answers
892 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
719 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 ...
3
votes
2answers
3k 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 ...
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
993 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
48 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
430 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 ...
0
votes
1answer
552 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, ...