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
1answer
2k views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
0
votes
1answer
161 views

Oracle Database suddenly fills storage device in about 20 minutes

My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out ...
1
vote
2answers
3k views

Running SQL*Plus with bash causes wrong encoding

I have a problem with running SQL*Plus in the bash. Here is my code #!/bin/bash #curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql wget -O script.sql ...
0
votes
1answer
133 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
0
votes
2answers
93 views

Oracle database installation file limits

I'm reading a oracle guide for installing a Database on redhat 6, but i don't understand why oracle recommend to set the file-max system parameter and nofile in /etc/sysctl.conf ...
1
vote
1answer
133 views

How can I plan a DR solution for an SAP Instance running on HP-UX

I'm supporting an environment that runs SAP on HP-UX. The HP Blade running the SAP Instance is connected to IBM Storage over FC connection. SAN Infrastructure is duplicated by redundant ...
2
votes
2answers
16k views

Setup Oracle instant client on CentOS/RHEL Linux - for PHP and Perl

I'm trying to setup a CentOS 5.5/64 bit VM to access a remote Oracle database with PHP and Perl scripts. (I have no experience with Oracle, have only programmed and administrated some PostgreSQl and ...
9
votes
2answers
1k views

How do you get the latest update for Java 6?

An application my company is considering buying requires Java 6. I am concerned that this is quite out of date and am recommending against the application as a result. But it seems that Oracle do ...
0
votes
1answer
197 views

Tomcat - JDBC Data Access Exception

My company has a web application that allows users as part of their business process to upload large documents (10+ MBs) into the application. For fast connections it works great with the document ...
0
votes
1answer
25 views

“Raw” Packages of Oracle JDK for Linux

Is there any public source of zipped JDKs for Linux (64bit) that can be downloaded and used more easily than the original installers or the PPA? Currently we create them ourselves manually, but that ...
0
votes
0answers
703 views

ORACLE Forms app throws error: “Failed to open file: ifrun60_dump_” on terminal server

Scenario We have an ORACLE Forms client application deployed on multiple Windows clients and one Microsoft Terminal Services server. The application has scarce documentation and largely inefficient ...
2
votes
2answers
3k views

Oracle: replacing tnsnames.ora with LDAP lookup?

How do I go about replacing client-side tnsnames.ora with an ldap query? I'm not interested in running Oracle LDAP, we have an existing LDAP infrastructure. I need: format of LDAP entry how client ...
1
vote
0answers
46 views

Oracle Identity Manager and Microsoft Read-Only Domain Controllers

Is Oracle Identity Management 11g (OID) compatible with Microsoft Active Directory Read-Only Domain Controllers? (RODC) My setup has OID importing users from AD RODC. Is this configuration ...
0
votes
1answer
63 views

Can you restore multiple Oracle databases with the same tablespace name?

I am in the process of setting up an Oracle instance for customer database restores. The vast majority of our customers use the same tablespace name for their databases, which leads to us needing a ...
2
votes
3answers
4k views

How to have oracle database accessible remotely

I can connect to my oracle database using localhost:1521. However, connecting to the IP address does not work. I'm trying to do this because I am trying to connect to my database using another ...
3
votes
2answers
2k views

Install Oracle Linux 6.4 on HP ProLiant DL380e Gen8 server

installation does not detect the raid 1 logical drive created from ACU. the installation shows the two 2T disks, and after the installation is complete, I can not boot up to the system. I have been ...
-2
votes
1answer
227 views

Adding secondary groups and running processes

I made oracle member of a secondary group. Do I have to restart Oracle before it can write to directories owned by this secondary group?
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 ...
1
vote
0answers
445 views

What would cause RMAN backups over NFS to kill SAN performance?

I've been trying to figure out this problem for several weeks now, we are using an Exadata that runs nightly RMAN jobs to backup the database to a NFS mount. When these jobs occur, the average latency ...
0
votes
1answer
227 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 ...
1
vote
2answers
69 views

OEL fresh install while keeping old LogVols

I've been asked to install OEL 5.x on a server and setup a disk with a few directories (there's only one disk in the server). So I have an OEL 5.x server wtih multiple log volumes in a volume group: ...
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 ...
0
votes
1answer
94 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 ...
0
votes
1answer
337 views

Where to get FW/BIOS for Sun Fire X4150

I have been trying to get the lastest software for the X4150. I get to this link http://www.oracle.com/technetwork/systems/patches/firmware/release-history-jsp-138416.html#X4150 but it gets me no ...
0
votes
2answers
238 views

Oracle disaster recovery on Linux

My Oracle database is stored on a Linux system. That Linux system is down. So I want to restore my Oracle database as soon as I set up the Linux system. I don't know how to restore it. Can anyone help ...
2
votes
1answer
5k 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 ...
1
vote
3answers
24k views

How do I fix “ORA-01033: ORACLE initialization or shutdown in progress” error?

I have an Oracle 9.2 database. The server has crashed. After rebooting any attempt to connect to the Oracle server returns error ORA-01033 (as in title). I've tried stopping and starting the Oracle ...
2
votes
0answers
145 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 ...
0
votes
1answer
841 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
405 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
43 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 ...
2
votes
3answers
632 views

Sunfire v100 Reinstall Problems

I own two Sunfire v100 servers, and I use hyperterminal to connect to them. I am trying to re-install Solaris on one of them, so I put in the LOM cable and unplugged the harddrives. Here's the ...
0
votes
1answer
465 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
100 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
167 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
373 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
1answer
105 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
1answer
187 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. ...
2
votes
1answer
2k views

Installation ORACLE 11g in an external hardrive

I am working on a project in which i have to deal with oracle 11g. My project manager wants me to install Oracle 11g in an external hard drive. I already installed it in the hard drive, though when ...
0
votes
1answer
752 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 ...
0
votes
1answer
260 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 ...
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 ...
2
votes
1answer
422 views

Cant open up oracle web console after install db 11gr2 and show weird symbols?

i just finished installing oracle database 11gR2. after successful install, i will usually want to open up web console at http://localhost:1158/em.. however if i open up the page i get a weird symbol ...
2
votes
1answer
481 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 ...
1
vote
2answers
705 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 ...
0
votes
2answers
167 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 ...
2
votes
2answers
925 views

How do I setup Red Hat Enterprise Cluster and oracle 9 to support failover?

I am trying to figure out how to use RHEL cluster to have automatic failover of an oracle 9 database from one physical machine to another. Ideally this solution would be fully hardware redundant in ...
0
votes
1answer
384 views

Switch RAC nodes using dbconsole in Oracle 11g

Is it possible to use dbconsole (Enterprise Manager) to switch the active node of a Oracle 11gR2 cluster? The idea is to tell the active instance to go down and have another node take over. I want to ...
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 ...
50
votes
10answers
139k views

Run Oracle SQL script and exit from sqlplus.exe via command prompt

I would like to run an Oracle script through SQL Plus via a Windows command prompt. The script does not contain an "exit" command, but I would still like SQL Plus to exit, returning control to the ...