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

4
votes
1answer
5k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
2
votes
1answer
381 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
2k 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 ...
2
votes
1answer
1k 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
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1
vote
1answer
94 views

Can I “flush and lock” an Oracle database to do a filesystem backup?

I'm using ZFS to take snapshots of running OpenVZ containers. For MySQL databases I can use flush tables with read lock to put them in a flushed & locked state. This will put the underlying files ...
1
vote
1answer
706 views

Powershell execute Queries using SQLPLUS

I have a RHEL server with Oracle 10G installed. I need to write a powershell script to query my database and get the output. I have imported Posh-SSH module and am able to connect to my RHEL server ...
1
vote
1answer
154 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 ...
1
vote
1answer
867 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
1
vote
1answer
171 views

Alternative for OPTIMIZER_FEATURES_ENABLE

I've installed a PHP driven application in a client's 9i server (Oracle9i Release 9.2.0.1.0 - 64bit Production). Certain queries are having an awful performance (it can use from 15 minutes to hours ...
1
vote
1answer
400 views

Oracle 10g cannot see any data in tables

Im getting this error in Oracle 10g log file 2010-11-12 16:07:41.838: [ OCROSD][3069777600]utgdv:2:ocr loc file cannot be opened 2010-11-12 16:07:41.865: [ OCROSD][3069777600]utopen:1: Couldnt ...
1
vote
1answer
37 views

What are the contents of the Headers in Control,Redo log and data file in a typical Oracle DB?

Where can i find the contents contents of the Headers in Control,Redo log and data file in a typical Oracle DB.
1
vote
1answer
926 views

Oracle physical standby database received redo has not been applied

I followed the steps in oracle documentation on creation of a physical standby database. The link to the configuration steps, http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/create_ps....
1
vote
1answer
416 views

Broker vs. SQLPLUS to manage Data Guard configuration

Can anyone tell me the link to the comparison between using SQLPLUS and Data Guard Broker to manage data guard configuration? Advantages and disadvantages of those two command line interfaces? Thanks,...
1
vote
1answer
143 views

Find wait reason in Oracle

I'm running a Java application with an Oracle 10g. I've discovered kind of a race condition that leads to an inifite long waiting time for an UPDATE statement. To solve this situation I'd like to ...
1
vote
1answer
86 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?
0
votes
1answer
35 views

pear/MDB2_Driver_oci8 requires PHP extension “oci8”

I got this Error: unable to find package 'MDB2_Driver_oci8' file 'MDB2/Driver/oci8.php' so I tried to install it with pear install MDB2_Driver_oci8-1.4.1 but following Error is showing up pear/...
0
votes
1answer
31 views

Port forwarding via Watchguard

I have problem with accessing oracle database with oracle SQL developer. I'm using Watchguard m400 as my firewall/router and Windows Server 2012 R2 as Oracle DB Server. I have server with local IP, ...
0
votes
1answer
61 views

Weblogic server hangs when “Creating data source connection pool named”

I have just installed Weblogic version 10.3.6.0 and created a data source which connects to MSSQL on my localhost. I have tested my connection and verified that a successful connection can be made ...
0
votes
1answer
16 views

Oracle RMAN full backup due to gaps in ARCHIVE LOGs

I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard. Because it's been on-line for a sustained period, some logs are missing and I ...
0
votes
1answer
52 views

Oracle Database with autofs

We run our oracle databases (11 & 12) on NFS on Redhat 6. We do not use ASM. Is it acceptable to use autofs for all of the various oracle files? Thanks, Al
0
votes
1answer
103 views

How to find database connection information for Oracle on VirtualBox?

I am attempting to run an Oracle database on a Mac OS X system. To do so, I have followed the following guide: https://dimitrisli.wordpress.com/2012/08/08/how-to-install-oracle-database-on-mac-os-any-...
0
votes
1answer
308 views

Creating javaroles in Oracle 11g XE

I have installed Oracle 11g Express Edition in my system.I want to create user who has got the role javauserpriv. After creating the user I ran the following command grant javauserpriv to dbuser(new ...
0
votes
1answer
900 views

yum Cannot open: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm. Skipping

I am following this article on installing the oracle client RPMs on a CentOs 6.x server using yum localinstall.for some reason yum cannot open the RPMs - and I am at a loss as to what the next step ...
0
votes
1answer
963 views

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle ...
0
votes
1answer
114 views

Remote desktop disabled for oracle user

Recently while installing Oracle 12C DB on Windows server 2008 R2. I created an user called Oracle through the Oracle DB installation setup. Now am unable to login remotely into the machine with this ...
0
votes
1answer
842 views

Unable to connect to Oracle database from certain client machines

I have an application that connects to an Oracle database that works fine in development on any development machine I can find but falls over with the following error when being ran from a production ...
0
votes
1answer
708 views

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...
0
votes
1answer
391 views

ERROR: Not enough space?

Now this is a very unspecific question. I'm trying to figure out what this message would mean. Here is the story behind it: I'm installing Oracle enterprise manager cloud control (12c r3) on Solaris ...
0
votes
1answer
237 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
1answer
458 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
149 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 ...
0
votes
1answer
437 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 oracle-java6-...
0
votes
1answer
415 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
49 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 ...
0
votes
1answer
241 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
544 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 kernel-uek-2.6.32-300.7.1.el5uek....
0
votes
1answer
680 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 ...
0
votes
1answer
63 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
0answers
121 views

What is the difference between Oracle WebCenter Content and Oracle Portal?

I'm having a difficult time understanding the difference between these two technologies. What I have understood is: The business logic, and DB connections lies in the Oracle Portal (weblogic server) ...
0
votes
0answers
85 views

siginificance of /dev/oracleasm/iid/*

I am a backup admin and our DB team says these files are required in backups. backups usually cannot protect /dev/ and /proc. kind request for any Oracle DBA to help me here to know siginificance of ...
0
votes
0answers
31 views

Is using sqlplus in a server environment considered as a bad practice?

We have a web application (a COTS product) and we need to query the application DB periodically using an external scheduler for alert purposes. DB is Oracle, se we decided to schedule a job on the ...
0
votes
0answers
626 views

Oracle UTL_HTTP with SHA-256

I use Oracle Express Edition 11G (11.2.0.2.0). Sometimes we need to call a webservice using UTL_HTTP. If the webservice is using https we need to use Oracle Wallet where we download the server's SSL ...
0
votes
0answers
228 views

Oracle 6i reports engine crash on Windows server 2008r2

Background: We have Oracle 6i applications that used to run on Windows server 2003. We've migrated to 2008r2, and we managed to get these applications running almost perfectly (took a while and a lot ...
0
votes
0answers
24 views

What does Oracle Data Access Components Release number mean?

I need to document the Oracle Data Access Component installed on our system. The current version we have installed is 12.1.0.1.2. What does each number indicate ? I searched but could only find ...
0
votes
0answers
200 views

Oracle GNS (Grid Naming Service) Breaks DNS

Am running a 2-node Oracle 12.1.0.2.0 ASM Flex Cluster using Oracle GNS which I believe uses zeroconf to create it's adhoc network. Before GNS starts, DNS works, i.e. nslookup, dig, ping, ssh all ...
0
votes
0answers
169 views

Apache mod_authn_dba with Oracle on Windows

How can I configure Apache to authenticate against Oracle dbms? According to this link Oracle database is natively supported. No additional software required. Loading those modules: LoadModule ...
0
votes
0answers
2k views

PL-SQL Developer not connecting to remote oracle database , error ORA-01034

![Oracle error in PL SQL Developer][1] I am facing issues while trying to connect my database through PL-SQL Developer. It throws error - ORA-01034 everytime. Please note the below. 1.I am using ...
0
votes
0answers
2k 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 ...