2
votes
0answers
233 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
7 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
327 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
47 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
27 views

Oracle remote_os_authent works locally but not remotely

An oracle 11g server is configured to use the remote os authentcation option for select few users. Everything works fine from the shell of the DB server (e.g. you type sqlplus / and login is ...
0
votes
1answer
222 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
76 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 ...
0
votes
1answer
1k 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
224 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
1answer
481 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

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
172 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
94 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
107 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
98 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
442 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 ...
0
votes
2answers
2k 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
1k 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
2answers
10k 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
1answer
180 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 ...
1
vote
1answer
3k 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
530 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
2k 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 ...
2
votes
1answer
3k 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
1k 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
2answers
741 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 ...
1
vote
4answers
20k 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
248 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
0answers
389 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
3k 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
vote
1answer
367 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 ...
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 ...
2
votes
2answers
5k 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
1k 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
1answer
1k 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
3answers
899 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 ...
1
vote
4answers
378 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
4k 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
229 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
578 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 ...
2
votes
3answers
124 views

Oracle Move from 9 to 11

I have an oracle 9 database. There is a requirement to move this to Oracle 11. What is the best way to achieve this. Is it enough to export the database on 9 and import it again on 11 or is there an ...
0
votes
2answers
1k views

Can I upgrade Oracle 11g 11.2.0.1 to 11.2.0.2 and keep my database intact?

I'm new to oracle, but I'm looking to upgrade an existing oracle database 11.2.0.1 to 11.2.0.2. Can anyone tell me if this will require wiping my existing database or will it remain intact? Thanks in ...
0
votes
1answer
995 views

Orcale 11g client installs error on 64 bit win server 2008 OS

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 of this check is: Failed <<<< Problem: Oracle ...
0
votes
1answer
506 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, ...
3
votes
2answers
3k views

Oracle 11g R2 Install Guide

I have a need to install Oracle 11g R2 on Windows Server 2008 R2. I have downloaded the two files from Oracle (win64_11gR2_database) and the client (win64_11gR2_client). Does anyone have a guide or ...
3
votes
1answer
2k views

installing oracle 11g in ubuntu 10.10

i'm trying to install oracle 11g database in my ubuntu 10.10, following this tutorial http://oracleabc.com/b/archives/167 but, at the step 11, the system asks for oracle password! which password is ...
0
votes
5answers
1k views

What is the Best HW / OS Combination for Oracle 11g?

My company is in the midst of upgrading our database hardware / software to support Oracle 11g. We're considering the following hardware / OS combinations for the database server: Sun v890 (current ...
5
votes
5answers
3k views

Setting up array of SSDs for Oracle Database, recommendations?

I am configuring a server for a small, but read I/O intensive database. It serves as a master index for public access to a larger Oracle RAC database. When looking at the requirements for I/O, it was ...
0
votes
2answers
250 views

How do I get Oracle 11g to install on Vista when it gives an error about the listener port?

I'm trying to do an install of Oracle 11g.R2 taking the defaults, but the installers keeps generating and error message when trying to setup the listener. If I have the installer just install the ...
2
votes
2answers
5k views

Fixed expired accounts in Oracle 11g

I have an Oracle 11g server that's used for PHP development. Recently, I had a problem logging into the Enterprise Manager due to expired passwords. I've already changed settings so passwords no ...