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

learn more… | top users | synonyms (1)

1
vote
1answer
45 views

Problems installing Oracle Database 11 on solaris 11.3

i'm trying to install Oracle Database on Solaris 11.3 and i'm getting the following error: INFO: /usr/ccs/bin/make -f /u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk relink ...
0
votes
0answers
5 views

Access to Network Services in Oracle Database 11g

Recently we have switched from Oracle 10g to 11g, and only now I noticed that my mailing function does not work, I now get an error: ORA-24247: network access denied by access control list (ACL) So ...
0
votes
0answers
10 views

Unable to get to Administration Page after installing oracle 11g XE

I have installed the Oracle 11g Express edition on Windows 7 64 bit. Whenever I try to click on get started button, I ended up getting the following page: Upon changing the URL to localhost, I get ...
-1
votes
1answer
45 views

Unable to connect to an Oracle XE database from Oracle Sql Devloper

I've installed an Oracle 11g XE on a Linux ubuntu 14.04, successfully created a user, and imported a database into it. my problem is , if when I want create new connection for connect with DATABASE hr ...
0
votes
0answers
13 views

My server side migration setting doesn't seem to work in SSMA

My server side migration setting doesn't seem to work. It fails without any error message. Any fix resolutions you can suggest to me? Also i see only one table under the sysdb in SQL server 2012 ...
0
votes
0answers
23 views

Increase Memory and downgrade CPU on RAC 11.2.0.4 with 2 nodes

I have a RAC 11.2.0.4 on Linux x86 with 2 nodes with 3 databases with a total of 300GB(SGA and PGA) among all. What if a node has 512 of RAM and another node has 1 TB of RAM? What if one node has 2 ...
0
votes
1answer
117 views

Installing Oracle 11g on CentOS via Yum

I'm trying to set up a CentOS 7 VM to host an Oracle 11gR2 database. There is no desktop/x window system software, but I did try installing the 11gR2 zips with ./runInstaller -silent -noconfig -...
-1
votes
1answer
55 views

Migration between Oracle and Azure SQL Data warehouse using SSMA

I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database ...
0
votes
1answer
33 views

sql server migration assistant for oracle to azure sql

I am facing below error while syncing table from oracle to Azure SQL database using SSMA tool(A tool used to migrate data from oracle to azure SQL). Please suggest a solution. Errors: USE ...
0
votes
0answers
41 views

SLQPlus not working after Oracle XE installation

I just installed Oracle XE 11.2 on Windows 7 64. According to the manual I should be able to start SQLPlus just right after the installation. However if I try to run it, I get the following message: ...
-1
votes
2answers
28 views

Save ODBC credentials for Oracle on Windows

On my dev machine (Mint Linux), I have ODBC set up with credentials so that I only have to specify DRIVER and DBQ in the connection string. Unfortunately, the script will have to run on a Windows ...
0
votes
0answers
173 views

Error while running sqlplus after installing Oracle Client 11g R2 on RHEL 7

I am facing issue while running ./sqlplus command after installing Oracle Client 11g R2 on RHEL 7 here's is the error: $ ./sqlplus ./sqlplus: symbol lookup error: /home/oracle/app/oracle/product/11....
1
vote
0answers
15 views

How to delete alogs fom Oracle downstream target

I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query: SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG; ...
0
votes
1answer
312 views

Cannot start Weblogic managed node : Stuck at <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>

Appreciate you expert help on this issue . Two weblogic managed nodes running in the same machine went down one day , on trying to start them up again using the startManagedWebLogic.sh , observed ...
1
vote
0answers
139 views

ORA-12154 :TNS:could not resolve the connect identifier specified

I have recently migrated one of our web site from Windows Server 2003 IIS 6.0 to Windows Server 2012 R2 IIS 8.5. The site utilises an Oracle DB via an Oracle 11g ODBC driver. An ODBC connection using ...
0
votes
0answers
35 views

RAC disk timeouts vs powerpath

what precautions one needs to take at OS disk timeout , powerpath(possible tunings) and oracle CRS level as well ...to make sure when there is a path failure oracle RAC would not start evicting nodes ...
0
votes
1answer
772 views

Install Oracle 11.2.0.4 to Win2012srvR2

I'm starting to prepare my server to install a new version of Oracle 11.2.0.4 Database. I'm reading some forum... there is problem about thin installation ? Is supported Oracle 11.2.0.4 version into ...
0
votes
0answers
127 views

What is the difference between Oracle WebCenter Content and Oracle Portal?

I'm having a difficult time understanding the difference between these two technologies. What I have understood is: The business logic, and DB connections lies in the Oracle Portal (weblogic server) ...
0
votes
1answer
79 views

DataSet.Fill slower after upgrading to oracle 11g

We have migrated from an oracle 10g to an oracle 11g Database. The instance of Database 11g is totally new an installed on a VirtualMachine in a different HW. The new DB is on Windows Server 2013 ...
3
votes
1answer
218 views

zpool disappears whenever solaris cluster reboot or power cycle

I have following setup Oracle Solaris 10 -> 5.10 Generic_147147-26 sun4v sparc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit production Oracle Solaris Cluster 3.3u2 for Solaris ...
1
vote
1answer
3k views

ORA-12505, TNS:listener does not currently know of SID after changing port number

I am trying to change oracle tnslsnr port number from default to some other port. After I change port number for tnslsnr from 1521 to 2000 I start geting ORA-12505, TNS:listener does not currently ...
0
votes
1answer
316 views

Creating javaroles in Oracle 11g XE

I have installed Oracle 11g Express Edition in my system.I want to create user who has got the role javauserpriv. After creating the user I ran the following command grant javauserpriv to dbuser(new ...
0
votes
1answer
1k views

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle ...
3
votes
0answers
154 views

mod_ssl client certificates on a reverse proxy

I am trying to add client certificate authentication on a reverse proxy that proxies an oracle application. Before adding, and if i remove the subsequent code, the oracle application is able to start ...
2
votes
1answer
383 views

remote login failed on windows XP, but remote telnet successful on mac

I recently set up an Oracle DB, started the listener on port 1561, and enabled TCP access. I then opened that port to all incoming connections. When I get on my Mac - I can use telnet remoteserver ...
1
vote
0answers
175 views

WebLogic datasource timeout

We have WebLogic 10 with some services running on it. One of our datasources started throwing timeout exceptions. We set Configuration -> Connection Pool -> Test table Name to problem sql. ...
5
votes
1answer
23k 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
2answers
301 views

High iowait despite small amount of write/read

I'm not sure how to interpret this or the next steps, but why is IOWait so high when I have not written/read much from any devices? Background: I am a developer trying to find why the DB seems to be ...
0
votes
1answer
72 views

Is there a way to find out the necessary users, roles, and privileges an Oracle Dump file needs?

I've been tasked with importing this old Oracle dump file from beyond my time - as such, the person that did the exporting, and the server on which it originally resides on is long gone. My knowledge ...
0
votes
2answers
95 views

How do I restore Oracle's default user tables?

The Problem: I've been trying to restore this dump file, but unfortunately, whoever did the exporting did not make it clear on what users, privileges, and roles are required for the database. So I ...
0
votes
0answers
2k 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 ...
1
vote
1answer
3k views

Unable to connect to an Oracle XE database from another PC, or a local program / webpage

I've installed an Oracle 11g XE on a Linux Fedora machine, successfully created a user, and imported a database into it. My ultimate goal here is to connect an existing PHP website (also residing on ...
0
votes
2answers
272 views

cannot connect to oracle after server crash

Our test server (based on windows 2008) crashed because of a power loss during the weekend. After the restart, all services started successfully but Oracle 11.2 didn't. I tried to start all services ...
0
votes
1answer
1k 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
124 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 ...
1
vote
1answer
22 views

Retain SIDs and TNS when upgrading Oracle

I am researching the process to upgrade Oracle from 11.2.0.1 to 11.2.0.3. I am planning on using the DBUA utility. My question is, will the DBUA make the necessary changes to retain my SIDs and update ...
2
votes
1answer
3k 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 ...
1
vote
1answer
57 views

Dataguard needed for onsite virtualization?

In moving both an Oracle DB and it's corresponding dataguard box both to a Virtual Environment, (Same site, same VM Infrastructure) Does it make sense to keep the dataguard setup? The VM ...
1
vote
2answers
560 views

What kind of performance overhead with LVM on Fusion ioDrive2 as Oracle DB 11gR2's Flash Cache?

This is a bit wordy, so please bear with me. :) We have a RAC cluster of 3 Oracle 11gR2 servers and purchased FusionIO ioDrive2 PCIx cards for these servers to use as OracleDB's Flash Cache. These ...
0
votes
1answer
2k views

Resizing partitions/moving /u01 oracle directory

I've got a test server recently set up at work which has oracle installed under /u01 - but without realising it, I've set the root partition to be ~50GB, so have filled the partition very quickly once ...
3
votes
3answers
4k views

What to check during a periodic system health check

I have been tasked with preparing a list of checks to do as a part of a weekly system health check routine which my team is supposed to do. The problem is neither I nor any of my colleagues have ever ...
0
votes
1answer
241 views

Windows 2003 Near Freezing

Problem: Our server becomes very very slow (near freezing) if I copy a file from any directory on C: and D: to any other directory. In short It becomes very slow if I touch the hard disk. Currently I ...
1
vote
2answers
220 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
2answers
12k 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
1answer
410 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
2answers
7k 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
2answers
1k 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
2answers
298 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
2answers
4k 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
1answer
3k 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 ...