Oracle is an RDBMS product and Oracle 11g is a specific version.

learn more… | top users | synonyms (1)

0
votes
0answers
25 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 ...
2
votes
0answers
20 views

zpool disappears whenever solaris cluster reboot or power cycle

I have following setup Oracle Solaris 10 -> 5.10 Generic_147147-26 sun4v sparc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit production Oracle Solaris Cluster 3.3u2 for Solaris ...
0
votes
0answers
20 views

How to check if restored database is the same as original [migrated]

Is there a way to check if restored backup of Oracle database is the same as the original database? Is there a simple way to check it if I have the original database?
1
vote
1answer
146 views

ORA-12505, TNS:listener does not currently know of SID after changing port number

I am trying to change oracle tnslsnr port number from default to some other port. After I change port number for tnslsnr from 1521 to 2000 I start geting ORA-12505, TNS:listener does not currently ...
0
votes
1answer
65 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
277 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 ...
2
votes
0answers
87 views

mod_ssl client certificates on a reverse proxy

I am trying to add client certificate authentication on a reverse proxy that proxies an oracle application. Before adding, and if i remove the subsequent code, the oracle application is able to start ...
0
votes
0answers
98 views

Oracle Wallet Add Trusted Intermediate CA?

I have a Oracle Wallet for use with a Oracle HTTP Server. I am trying to update my Trusted Certs in the wallet as they have changed for my client authentication for DOD CACs (Smart Cards). I have ...
2
votes
1answer
236 views

remote login failed on windows XP, but remote telnet successful on mac

I recently set up an Oracle DB, started the listener on port 1561, and enabled TCP access. I then opened that port to all incoming connections. When I get on my Mac - I can use telnet remoteserver ...
1
vote
0answers
87 views

WebLogic datasource timeout

We have WebLogic 10 with some services running on it. One of our datasources started throwing timeout exceptions. We set Configuration -> Connection Pool -> Test table Name to problem sql. ...
4
votes
1answer
7k views

Installing Oracle 32bit and 64bit client on the same machine

So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the ...
0
votes
0answers
26 views

Need help in installing Oracle RAC with EBS

I have an running Oracle 2 node RAC. I need to setup an single node Oracle EBS which need to use the RAC cluster for data. Is there any specific process I should follow. I heard that Oracle EBS ...
0
votes
2answers
186 views

High iowait despite small amount of write/read

I'm not sure how to interpret this or the next steps, but why is IOWait so high when I have not written/read much from any devices? Background: I am a developer trying to find why the DB seems to be ...
0
votes
1answer
29 views

Is there a way to find out the necessary users, roles, and privileges an Oracle Dump file needs?

I've been tasked with importing this old Oracle dump file from beyond my time - as such, the person that did the exporting, and the server on which it originally resides on is long gone. My knowledge ...
0
votes
2answers
35 views

How do I restore Oracle's default user tables?

The Problem: I've been trying to restore this dump file, but unfortunately, whoever did the exporting did not make it clear on what users, privileges, and roles are required for the database. So I ...
0
votes
0answers
1k 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 ...
1
vote
1answer
2k views

Unable to connect to an Oracle XE database from another PC, or a local program / webpage

I've installed an Oracle 11g XE on a Linux Fedora machine, successfully created a user, and imported a database into it. My ultimate goal here is to connect an existing PHP website (also residing on ...
0
votes
2answers
155 views

cannot connect to oracle after server crash

Our test server (based on windows 2008) crashed because of a power loss during the weekend. After the restart, all services started successfully but Oracle 11.2 didn't. I tried to start all services ...
0
votes
1answer
916 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 ...
1
vote
1answer
102 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 ...
1
vote
1answer
19 views

Retain SIDs and TNS when upgrading Oracle

I am researching the process to upgrade Oracle from 11.2.0.1 to 11.2.0.3. I am planning on using the DBUA utility. My question is, will the DBUA make the necessary changes to retain my SIDs and update ...
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
0answers
425 views

CentOS6 Oracle11g,I can not start em

I start the oracle with the command “dbstart” [oracle@myCentOS ~]$ dbstart Processing Database instance "orcl": log file /oracle/11g/startup.log and then start the listener [oracle@myCentOS ~]$ ...
1
vote
1answer
52 views

Dataguard needed for onsite virtualization?

In moving both an Oracle DB and it's corresponding dataguard box both to a Virtual Environment, (Same site, same VM Infrastructure) Does it make sense to keep the dataguard setup? The VM ...
1
vote
2answers
445 views

What kind of performance overhead with LVM on Fusion ioDrive2 as Oracle DB 11gR2's Flash Cache?

This is a bit wordy, so please bear with me. :) We have a RAC cluster of 3 Oracle 11gR2 servers and purchased FusionIO ioDrive2 PCIx cards for these servers to use as OracleDB's Flash Cache. These ...
0
votes
1answer
966 views

Resizing partitions/moving /u01 oracle directory

I've got a test server recently set up at work which has oracle installed under /u01 - but without realising it, I've set the root partition to be ~50GB, so have filled the partition very quickly once ...
3
votes
3answers
1k views

What to check during a periodic system health check

I have been tasked with preparing a list of checks to do as a part of a weekly system health check routine which my team is supposed to do. The problem is neither I nor any of my colleagues have ever ...
0
votes
1answer
189 views

Windows 2003 Near Freezing

Problem: Our server becomes very very slow (near freezing) if I copy a file from any directory on C: and D: to any other directory. In short It becomes very slow if I touch the hard disk. Currently I ...
0
votes
2answers
161 views

Oracle Golden gate version using shell scrip

I am trying to grep the Oracle golden gate from a remote machine, But along with version it is giving some error details also, How do I resolve it ? user@serverhost:/dbei > echo <golgengate ...
2
votes
2answers
6k views

Caused by: java.net.SocketException: Software caused connection abort: socket write error

I running JSP on Oracle 11g, Weblogic 10.3.4. I have 2 managed server and a oracle admin server installed. I am encountering an error where intermittently the log file of the 2 managed server and ...
0
votes
1answer
297 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 ...
0
votes
2answers
4k views

Why can't I grant exec on dbms_lock.sleep() OR create a procedure using it (but I can run it fine on its own)

I am trying to write a small bit of PL/SQL that has a non-CPU burning sleep in it. The following works in sqldeveloper begin dbms_lock.sleep(5); end; BUT (as the same user), I can't do the ...
1
vote
2answers
1k views

Ulimit settings in Oracle 11g on Linux 5

Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5. It is one of the settings that appears to be woefully short ...
2
votes
2answers
253 views

Oracle (xe) 10 vs 11 . Have I lost the SQL tuning pages ? Am I going out of my mind?

Ok .. so perhaps the title needs calming down a bit. Basically I am after the XE 11g equivalent of the pages that you can see here, in which you can then navigate to stuff like "top 50 queries" and ...
1
vote
2answers
3k views

Is there a way to setup Oracle on Mac Lion without VM?

I really would like to avoid having to install virtual box just to use Oracle 11g. Is there a way to install it into Mac OSX?
-1
votes
1answer
2k views

Symantec Netbackup : Oracle restore fails “exited with status 13: file read failed”

I am restoring Oracle datafile size of 1200GB. Datafile is read from backup piece size of 4000GB(4TB). Note: As I monitored 4TB is processed totaly to read all blocks of my datafile. I had several ...
1
vote
0answers
567 views

Oracle Database 11g Express Edition - Built-in backup files-to-be-saved

Considering the built-in 'Backup Database' script (backup.bat) that comes with a new instalation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
0
votes
1answer
644 views

How to add linked Oracle server to SQL 2008 Express?

I have tried to download Oracle Client 11g both 32 & 64 packages to Windows 2008 R2 with SQL server 2008 Express. However, I still cannot see Oracle provider in SQL server by using sa log in. Not ...
1
vote
0answers
199 views

ORA-32696: HTI: No free slot

I am getting the following error in oracle alert log file. ORA-32696: HTI: No free slot "Cause: There is not enough memory. Action: Increase memory." I have goggled this error but couldn't find the ...
-5
votes
1answer
86 views

Oracle database [closed]

what's the reason for Enterprise Manager is not able to connect to the database instance. ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) error? How to solve it?
0
votes
1answer
792 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
1k views

Recommended RAM and disc space for Oracle 11g on Windows

I need to provide the recommended amount of RAM and disc space (divided in two partitions) so the customer can create an appropriate virtual machine to run Oracle. All I could find in the ...
1
vote
0answers
391 views

migrate 10g xe to 11g xe

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
0
votes
1answer
1k views

INS-40719 error when Install Oracle RAC?

I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on ...
2
votes
0answers
257 views

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
-5
votes
1answer
106 views

What is the stability level of Oracle 11g? Is it suitable for production? [closed]

We are using both Express edition and Commercial edition to power up a Distributed application. Is Oracle 11g a good candidate for this application since we need data synchronization? Or is Oracle 10G ...
0
votes
2answers
116 views

Configuring swapfile error

I installed oracle linux 6 on my desktop but I forgot to configure the swapfile, I want to install oracle 11gr2 on it and it requires 2gig or ram, if I type the following commands on the terminal I ...
0
votes
1answer
108 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
1
vote
1answer
700 views

How to enable Oracle-Managed Files on Oracle Express for Windows XP

I'm trying to enable Oracle-Managed Files on Oracle Express for Windows XP. From everything I've read, I need to set db_create_file_dest to an existing directory in the file system. I've tried ...
3
votes
2answers
888 views

Force refresh of client's java cache.

I have an Oracle Application server that has been upgraded. It serves users a java file which they launch in their browser. After the upgrade user's browsers are still pulling the old java file from ...