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
3answers
23k 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
130 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 ...
15
votes
5answers
902 views

Is my new Oracle DBA talking sense

When we setup FC LUNs for our MSSQL boxes we rarely have to present them with more than about 8 distinct LUNs of various kinds (Quorum, MSDTC, TempDB, Data, Logs, Backup and a few others). We have a ...
0
votes
1answer
634 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
260 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 ...
0
votes
2answers
2k views

How to get Sun X4100 Firmware updates from Oracle?

This document directs how to get there, but it is for the old Sun website. http://download.oracle.com/docs/cd/E19569-01/820-1188-12/core_ilom_firmware.html#50413605_67571 Download the flash image ...
1
vote
0answers
38 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
597 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
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
137 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
337 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
98 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
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. ...
2
votes
1answer
1k 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
604 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
217 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
373 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
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 ...
1
vote
2answers
641 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
149 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
916 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
358 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 ...
48
votes
10answers
130k 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 ...
1
vote
3answers
1k views

ORA-1034 Oracle Not Found

I have recently installed oracle 11g on Windows 7 Home Premium Operating System. I logged in as administrator into windows. I am trying to create a database using DBCA wizard. I started the wizard as ...
2
votes
1answer
4k views

Oracle Enterprise Manager showing Agent Unreachable, negative disk space?

I'm recently installed Oracle 11g on a Windows Server 2008 box and although the database appears to work just fine when I load up the Enterprise Manager in Firefox it tells me 'Agent Unreachable'. ...
7
votes
1answer
482 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
347 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
2answers
605 views

How to keep filesystem layout identical in every RedHat Installation?

I want to keep the following layout same in every installation on the identical servers: dm-0 /dev/VolGroup00/LogVol00 dm-1 /dev/VolGroup00/LogVol01 dm-2 /dev/VolGroup00/LogVol02 dm-3 ...
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 ...
0
votes
1answer
367 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: ...
1
vote
8answers
11k views

Oracle 11gR2 exp does not export some tables

I have an Oracle 11g (11.2.0.1) Database running on Linux (x64). Within the database I have a schema and 33 tables for it (all in the same tablespace). When I log in via sqlplus I can list all the ...
0
votes
0answers
175 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 ...
1
vote
3answers
4k views

Oracle 9i - delete Archive Logs without any concerns?

I have an Oracle 9i which creates Archive Logs since the year 2007. Can I delete them without any concerns? Or do I need to tell Oracle something before I delete them? (From time to time I do a cold ...
1
vote
4answers
24k 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
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
637 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
529 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
260 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
675 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
589 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
115 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
157 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
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 ...