Questions tagged [oracle-11g]

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

Filter by
Sorted by
Tagged with
1 vote
2 answers
688 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 ...
Arn's user avatar
  • 13
3 votes
2 answers
23k views

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

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 ...
jrishere's user avatar
0 votes
1 answer
638 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 ...
rrazd's user avatar
  • 105
0 votes
2 answers
14k 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 ...
Richard Green's user avatar
1 vote
2 answers
2k 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 ...
Stuart's user avatar
  • 21
2 votes
2 answers
349 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 "...
Richard Green's user avatar
1 vote
2 answers
5k views

Is there a way to set up 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?
Strawberry's user avatar
  • 1,152
-1 votes
1 answer
4k 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 ...
kupa's user avatar
  • 381
1 vote
0 answers
1k 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 ...
J.Hudler's user avatar
  • 151
-1 votes
1 answer
1k 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 ...
David.Chu.ca's user avatar
-5 votes
1 answer
98 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?
Saravana Karthikeyan's user avatar
0 votes
1 answer
2k 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 ...
Aldarund's user avatar
  • 123
0 votes
1 answer
4k 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 ...
Álvaro González's user avatar
1 vote
0 answers
776 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 ...
zapping's user avatar
  • 183
0 votes
2 answers
5k 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 ...
Data-Base's user avatar
  • 185
2 votes
0 answers
524 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 ...
user361045's user avatar
-5 votes
1 answer
122 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 ...
Chan's user avatar
  • 101
0 votes
2 answers
170 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 ...
kryticrecte's user avatar
0 votes
1 answer
137 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 ...
Autobyte's user avatar
  • 171
1 vote
1 answer
1k 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 ...
Wavy Crab's user avatar
  • 183
3 votes
2 answers
2k 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 ...
ckliborn's user avatar
  • 2,778
1 vote
2 answers
7k views

Setting ORACLE_HOME in Oracle RAC 11g

I've got two (2) nodes in an Oracle RAC 11g in Windows Server 2008. Oracle software is installed in C:\app. I realized that the ORACLE_HOME path has not been set.. In System Properties-> Advanced -> ...
Delmonte's user avatar
  • 301
0 votes
1 answer
1k 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 ...
Gama Felix's user avatar
1 vote
1 answer
4k views

Unable to delete a folder? Read Only Attribute locked?

We have a Windows 2008 R2 with Oracle11g and I need to uninstall the server and to reinstall again. I was following this Oracle Uninstall guide here: http://www.oracle-base.com/articles/misc/...
Spirit's user avatar
  • 1,164
0 votes
2 answers
8k views

Howto enable remote login for a Oracle db user?

Stupid question: I've successfully installed Oracle 11g on my Linux box. I can connect to it and retrieve the countries table via C#/mono just fine, with the below connectionstring, which uses the ...
Quandary's user avatar
  • 1,024
2 votes
1 answer
4k views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
FoxyBOA's user avatar
  • 417
3 votes
2 answers
35k views

How can I resolve Oracle 11g XE connection failure straight after installation?

I have just installed Oracle 11g XE on a Windows 7 VirtualBox VM, using all the default options. "Getting Started" fails When I click on Getting Started I get taken to http://127.0.0.1:8080/apex/f?...
lofidevops's user avatar
  • 1,325
0 votes
1 answer
505 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
Mehmet Balioglu's user avatar
0 votes
1 answer
1k 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 ...
PEBKAC's user avatar
  • 21
1 vote
1 answer
16k views

Use LDAP to authenticate oracle database users

I have Oracle Database 11g set up in few locations in either pure Linux/OpenLDAP, Samba/OpenLDAP environment and a full-blown Windows/AD environment. The applications that will be using those ...
Hubert Kario's user avatar
  • 6,401
0 votes
1 answer
1k views

oracle enterprise manager agent unreachable (windows)

Since yesterday, the oracle enterprise manager tool on my windows 7 machine is saying that the agent is unreachable. I didn't do anything unusual before this appeared, if I remember correctly I only ...
user1039665's user avatar
0 votes
1 answer
4k views

oracle - grant all privileges to schema

i've used mysql before and i'm now switching to oracle. I've already created a user in oracle. Now i want to give it "all privileges" for a schema. In mysql i can give all privileges (DML/DDL) for a ...
JMW's user avatar
  • 1,473
1 vote
1 answer
14k 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'. ...
Ron Warholic's user avatar
0 votes
1 answer
2k views

Large amount of cursors causing slow response and massive CPU usage - cursor: mutex s

We have a problem with our Oracle server. It was upgraded to 11g a couple of months ago and is running a third-party system. The system has been running for years (and has had several other issues), ...
user avatar
1 vote
0 answers
411 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 ...
Troydm's user avatar
  • 364
0 votes
1 answer
911 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 better ...
publicRavi's user avatar
2 votes
2 answers
4k 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 ...
MacAnthony's user avatar
0 votes
1 answer
2k views

'impdb' is not recognized as an internal or external command, operable program or batch file

I can see impdb.exe in E:\Oracle\product\11.2.0\dbhome_1\bin, and that folder is in the PATH. But when I open a CMD window and try to run impdb, I get the error in the title. I can verify the PATH is ...
bobmcn's user avatar
  • 99
7 votes
5 answers
123k 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 ...
user avatar
1 vote
1 answer
317 views

Oracle IIg Windows 64 Install

Tryine to do local install of Oracle 11g 64 on Win 7, everything goes fine but when I try to launch enterprise manager at https://localhost:1158/em I get a security certificate error. Where in the ...
user avatar
1 vote
2 answers
151 views

sql-server 2008 vs oracle 11g certification

I a have been working at my job for around a year doing database and development work and we currently use sql server 2005, which you think would make my decision easy to pursue a certification in sql ...
NEWprogrammer's user avatar
1 vote
2 answers
190 views

How to connect an Oracle server between two countries and maintain high speeds for read & write

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
Amir's user avatar
  • 143
1 vote
0 answers
675 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 ...
Mike's user avatar
  • 11
1 vote
1 answer
6k views

MS SQL 2008 - Setup Oracle Linked Server [SERVICE_NAME not given error]

I'm trying to setup a linked server on MS SQL 2008 R2 to an Oracle 11g server. I've got the Oracle client installed and sqlnet.ora, tnsnames.ora & listener.ora copied from the server and in place ...
cander's user avatar
  • 113
-1 votes
1 answer
747 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).
publicRavi's user avatar
1 vote
1 answer
548 views

Oracle Internet Directory implementation questions?

I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the TNSNAMES....
Senior Systems Engineer's user avatar
1 vote
1 answer
7k 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 ...
sasola's user avatar
  • 133
2 votes
2 answers
20k views

Installing oracle 11g on windows 7, why getting errors?

While installing Oracle 11g on windows 7, I get these errors: Checking operating system requirements ... Expected result: One of 5.0,5.1,5.2,6.0 Actual Result: 6.1 Check complete. The overall result ...
sasola's user avatar
  • 133
2 votes
2 answers
6k views

Disable RMAN backups in Oracle 11g

Recently I tinkered around with RMAN to see how it works, and somehow managed to get a regularly scheduled backup going. I don't really have the disk space or the need for RMAN to run, but I can't ...
nw.'s user avatar
  • 723
1 vote
1 answer
5k views

Unable to access Oracle DB from SQL Server with ODAC?

I've downloaded and install the ODAC for connecting oracle DB into my SQL Server 2008 using http://download.oracle.com/otn/other/ole-oo4o/ODAC112021Xcopy_x64.zip The OleDB data provider for Oracle ...
Senior Systems Engineer's user avatar