Oracle is an RDBMS product and Oracle 11g is a specific version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

1
vote
2answers
3k 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 ...
1
vote
2answers
1k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
0
votes
2answers
130 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
2answers
104 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
2answers
129 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
1answer
632 views

When Installing Oracle Client 11.1.0.7 can I use a common directory for Oracle Base?

I am trying to install Oracle Client 11.1.0.7 on a Windows Server 2008 64-bit. To some this might not be rocket science but I can't understand what the options under the install screen "Specify Home ...
1
vote
1answer
1k views

ora-12505 error while starting new connection

I got this error while starting new connection in Oracle 11g: Listern refused the connection with the follwoing error: ORA-12505,TNS: Listner does not currently know of SID given in connect ...
0
votes
1answer
12 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
1answer
23 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
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
495 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 ...
0
votes
1answer
102 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 ...
0
votes
1answer
466 views

Can't connect to oracle remotelly

I've been trying to install oracle in my home for more than a month now, but I still having some issues. Currently I have the server installed and running on a dedicated Win2k8R2 virtual machine. The ...
0
votes
1answer
437 views

Oracle Alert Log is 4GB

We have a developer db server with 11g on Windows Server 2003 R2. I just noticed that the alert_dev11g.log file in the F:\Oracle11g\diag\rdbms\dev11g\dev11g\trace folder is nearly 4GB large. I'd like ...
0
votes
1answer
442 views

ORA-00257 even when Oracle is in NOARCHIVELOG mode

One of my jUnit tests fails with the following exception: java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed. The Oracle error code refers to (for lack of ...
0
votes
1answer
532 views

Unable to start Oracle Enterprise Manager

Had some passwords expire, and this knocked out my OEM (11g, SE). Cleared this up, so that SYSMAN is not locked or expired (nor is DBSNMP, SYS, SYSTEM, all of which may or may not affect OEM, ...
-1
votes
1answer
162 views

RMAN connecting to wrong target

When I run rman target / @mydb nocatalog cmdfile=%commands% msglog=%logfile%, I see connected to target database: OTHERDB (DBID=3786352837, not open).
2
votes
0answers
210 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 ...
1
vote
0answers
36 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. ...
1
vote
0answers
410 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 ...
1
vote
0answers
154 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 ...
1
vote
0answers
303 views

Oracle 11g R2 eats swap a lot

We have an oracle 11.2.0.1 server with 8 cores and 12gb ram. It's CentOS 5.6 and it has 12gb swap file. Oracle's memory target is 4gb and memory management is automatic. It has MegaSAS Raid controller ...
1
vote
0answers
430 views

Switched Oracle to use Shared Servers, now Java app throws SQLRecoverableExceptions

This issue might blur the line between Java and database problem, so I apologize if this is the wrong place for it. Not sure which side is to blame yet. I'm a Java developer temporarily playing DBA ...
0
votes
0answers
14 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 ...
0
votes
0answers
15 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
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 ...
0
votes
0answers
95 views

Can this RMAN setup give me a 7-day point-in-time recovery window and a stable size?

I have an RMAN setup on an Oracle 11g Windows 2003 R2 server, storing a steady stream of instrumentation values for various machinery. There are routines in place to automatically accumulate and ...
0
votes
0answers
50 views

Downgrading memory in CentOS VM Causes failure for Oracle11g startup

I have a CentOS 6.4 virtual machine with one vCPU and 2GB of RAM running on top of VMWare workstation 8, this VM Runs Oracle 11g. Whenever I downgrade The VM RAM to 1GB oracle refuses to start ...
0
votes
0answers
367 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 ~]$ ...