Questions tagged [oracle-11g]
Oracle is an RDBMS product and Oracle 11g is a specific version.
169
questions
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 ...
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 ...
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 ...
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 ...
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 ...
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 "...
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?
-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 ...
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 ...
-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 ...
-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?
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 -> ...
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 ...
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/...
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 ...
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 ...
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?...
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 ...
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 ...
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 ...
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 ...
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 ...
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'.
...
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), ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
-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).
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....
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 ...
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 ...
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 ...
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 ...