The oracle11g tag has no wiki summary.
0
votes
1answer
78 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 ...
1
vote
0answers
32 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
52 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
34 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
38 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
71 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
185 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
1answer
102 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
1answer
134 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
1answer
149 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:
...
0
votes
2answers
144 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 ...
1
vote
1answer
325 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 ...
1
vote
0answers
1k 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 ...
0
votes
0answers
37 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
1answer
83 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
0answers
69 views
Error in Calling Oracle Web Service through Eclipse-indigo
I'm getting an below error when trying to call my oracle web service through Eclipse-indigo.
Error:-
IWAB0135E An unexpected error has occurred.
502
Bad Gateway
Steps followed to ...
1
vote
1answer
244 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
1answer
162 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 ...
1
vote
1answer
126 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
0answers
23 views
OracleXEService is not installed
I've downloaded Oracle 11g release 2 express edition. I want to install Oracle on my computer in order to prepare for an Oracle certificate exam. The installation goes normally, it askes me to ...
-1
votes
1answer
71 views
handling large no. of data oracle 11g vs ms sql server 2008 r2 [closed]
I had 1 million records inserted par day. and my front end is c#.net 4.0.
So what is the best option for database server to gain the best performance. this is my par day traffic.
Oracle 11g vs ...
1
vote
0answers
523 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'.
...
1
vote
1answer
342 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), ...
0
votes
0answers
117 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
0answers
83 views
Oracle JDBC Driver - which version to use
I am helping to evaluate a J2EE application that will use Oracle as its database.
We have identified 3 possible JDBC driver versions to use:
11.2.0.1.0
11.1.0.6.0
11.1.0.7.0
The version of the ...
0
votes
1answer
147 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 ...
1
vote
2answers
295 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
1answer
43 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 ...
1
vote
4answers
3k 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 ...
2
votes
1answer
92 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
2answers
95 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
2answers
83 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
0answers
215 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
1answer
983 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
1answer
106 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
1answer
144 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 ...
0
votes
1answer
505 views
ora-12505 error while starting new connection oracle 11g
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 ...
1
vote
2answers
1k 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
2answers
339 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 ...
0
votes
1answer
556 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 ...
1
vote
1answer
2k views
Initialization error while trying to connect to Oracle using SQLDeveloper
I've installed Oracle 11.2.0 and Allround Automations' SQLDeveloper on Windows 7 64-bit.
When I run SQLDeveloper and and try to connect to Oracle, I get the below error:
Initialization error
Could ...
1
vote
2answers
324 views
ORA-1034 Oracle Not Found
I have recently installed oracle 11g on Windows 7 Home Premium Operating System. I logged in as administrator into windows. I am trying to create a database using DBCA wizard. I started the wizard as ...
0
votes
1answer
74 views
Common use cases of RMAN restore/recovery
To test our Oracle backup & recovery process, I would like to simulate some common fail case scenarios. Any suggestions?
2
votes
1answer
704 views
When RAID 10 is SLOWER than RAID 1, why?
We have a new Dell 2950 with PERC 6/e and 14 external SAS 15K 73GB drives. An Oracle 11g database job takes 3 hours to run with the drives set as hardware RAID 10 (striped across 7 mirrored pairs). ...
0
votes
3answers
90 views
Quickly revert an Oracle Database to a known state
I would like to use Selenium to test a web application but in order to do that successfully the tests must be run against a database at a known state.
The recording and running of the Selenium tests ...
1
vote
2answers
386 views
Oracle VSS Writer vs. RMAN
I am unable to find any literature to evaluate which solution to use when backing up my Oracle 11g DB. The attempt is to perform online backups by enabling ARCHIVELOG mode.
Edit: I have gone through ...
1
vote
4answers
163 views
How to wipe the slate clean on an Oracle installation?
After a basic, successful installation of Oracle 11g, I ran dbca again to enable Enterprise Manager on my database. The operation hung at around 67% for half an hour or more, so I clicked Stop to ...
0
votes
2answers
736 views
Oracle 11g: Why doesn't “grant create session” allow user to log in?
I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there ...
2
votes
4answers
166 views
Oracle performance problem
We are using an Oracle 11G machine that is very powerful; has redundant storage etc. It's a beast from what I have been told.
We just got this DB for a tool that when I first came on as a coop had ...
1
vote
3answers
184 views
How do I find the query parameters for a prepared statement in an oracle .trc file?
I have an oracle query generating a 3137 error, and the trace file contains the query.
For example:
select x from y where z = :1
I think it would help to isolate the problem if I could determine ...
