Tagged Questions

0
votes
0answers
102 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
157 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
239 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
625 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
92 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
83 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
78 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
64 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
271 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
1k 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
723 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
6k 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
112 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
2k 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
336 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
1k 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
0answers
1k 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
823 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
535 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
12k 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
217 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
308 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
2k 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
297 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
882 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
3k 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
735 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
2answers
626 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
291 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
3k 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
206 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
359 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
111 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
891 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
447 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
2k 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
0answers
419 views

Oracle 11g installation ERROR..?

Error No : INS-32010 - string contain invalid characters.?? (At Process -> TYPICAL INSTALLATION) How can i get rid of this error..?? Using VISTA Basic Edition..!
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
244 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
4k 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 ...
1
vote
3answers
10k views

Cannot log into Oracle Enterprise Manager 11g: ORA-28001

I can no longer log into Oracle Enterprise Manager 11g. I get this error message: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) I could log into the server using SQL*Plus. I ...
0
votes
2answers
5k views

Oracle 11gR2: NLS_CHARACTERSET accidentally removed with an UPDATE-Query

I have a fresh installation of Oracle 11gr2_x64 on CentOS. After the installation I wanted to get productive and started to import my dumps. One of the dumps caused characterset error so I tried to ...
0
votes
1answer
396 views

Oracle 11g RDBMS Enterprise Edition download?

I am looking for a URL where i can download the Enterprise Edition of Oracle 11g. I know that i can download the Standard Edition of 11g at Oracle's technet, but as i would like to use some of those ...
1
vote
1answer
143 views

Oracle Ordcom and Wallet Coexistence Problem

We use Oracle's ORDCOM infrastructure on our 11.1.0.7 database to interact with a COM object. The COM object doesn't do anything with the database. This process has been working fine for several ...
1
vote
2answers
19k views

Create user in Oracle 11g with same priviledges as in Oracle 10g XE

I'm a PHP developer (not a DBA) and I've been working with Oracle 10g XE for a while. I'm used to XE's simplified user management: Go to Administration/ Users/ Create user Assign user name and ...
0
votes
2answers
469 views

Why doesn't my oracle asm disks show up under dbca?

I am running into a problem where I have created some ASM disks under linux, they show up when I run oracleasm listdisks, but they are invisible when I use dbca and try to Configure Automatic Storage ...

1 2