Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-11g]

The tag has no usage guidance.

0
votes
0answers
9 views

Oracle Database 11g hangs on windows 7 at step 19

I am trying to install oracle database 11g in windows 7 professional 32 bit. All the steps are okay but in the prerequisite checking after 100% check the UI hangs and even waiting for 1-2hrs doesn't ...
0
votes
0answers
44 views

How to display Oracle SQL code of MATERIALIZED VIEW using DDL command of SqlCl product?

Using Oracle SqlCl tool, when I try to display SQL code of a materialized view using following command DDL mv_address Oracle SqlCl display following message Multiple objects exist with the name ...
0
votes
1answer
559 views

Running my Oracle DB query through Jenkins

I'm automating my deployment process with the help of Jenkins. Running my bat file and I've done all the code deployment process. Now I want to deploy my DB scripts to the corresponding DB servers. ...
2
votes
1answer
861 views

Failed to install Oracle client with an error “path is too long”

I'd like to know how to install Oracle Client on my Windows 10 pro PC/Dell Vostro 3860 properly cause of I got a problem to install the client software that "PATH is too long" error. What I tried to ...
0
votes
1answer
50 views

Failure to restore a table

I am getting familiar with the backup/restore process. For that reason, on Windows 7 I installed Oracle 11.2 g and started to play. Eventually I need to restore database on another server but first I ...
0
votes
1answer
689 views

What is the difference between DELTA & TOTAL columns in dba_hist_sqlstat Oracle?

I am using the following query to measure the performance improvement between two views SELECT PARSING_SCHEMA_NAME, SQL_TEXT, OPTIMIZER_COST, FETCHES_TOTAL, FETCHES_DELTA, ...
0
votes
1answer
257 views

Uninstalling Oracle 11g database

I have a test machine that used to run multiple DBMSes, including Oracle 11g. Since we moved to a new machine with a lot of horse-power, we don't need the old Oracle DB and I need to free its space ...
1
vote
1answer
337 views

Oracle 11g Database + SQL Developer, connection to database

I've successfully set-up my databse, and I can do some queries through my webiste wxplorer http://localhost:8080/apex/f?p=4500:1003:1042268341573744::NO::: But, when I downloaded 4.1.5 Sql ...
0
votes
0answers
757 views

Installing Oracle XE on Macbook Pro

I wanted to install Oracle XE on my MacBook Pro. As of now, I have installed VirtualBox but not sure what else I should download and install. I got Developer VM list, but all seems to be huge in size. ...
0
votes
0answers
1k views

Oracle Discoverer Install Failure: Windows 7, 64-bit

I have multiple users who are having recent issues installing Oracle Discoverer Desktop 11.1.1.3.0 on Windows 7, 64-bit machines. They are running JVM version 1.8.0 update 101. They are running the ...
0
votes
1answer
106 views

Can't find Administration icon on Oracle 11g Express Edition

I am referring the Steps to Create i2b2 Database Users from following documentation. They have in their screenshot an Administration Icon which can be seen as below : However, the Admin console of my ...
0
votes
1answer
1k views

RPM-GPG-KEY Error While Installing Oracle Database 11gr2 on CENTOS 7

I am Trying to install Oracle Database 11gr2 in CENTOS 7.For installation process I am following this procedure https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 ...
1
vote
2answers
3k views

The “shmmax” value is too large when installing Oracle 11g on RHEL7

I am trying to install Oracle Database 11g Release 2 on RHEL 7.2. Executing runfixup.sh, it outputs: # /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/...
0
votes
1answer
139 views

Is it safe to connect (select, update, insert) to Oracle database 10G with a 11G client?

I have to work in an Oracle 10G database. The normally used client is Oracle SQLDeveloper. But it has some limitations not related to the database use (Java versions on my PC, but that is another ...
0
votes
1answer
442 views

Oracle 11g express install on Linux

Do I have to be root user to install Oracle 11g on RHEL 6.5 (Santiago)? I am able to install the rpm as a different user, rpm2cpio oracle-xe-11.2.0-1.0.x86_64.rpm | cpio -idv But when I run . ./...
1
vote
1answer
661 views

Oracle Client 11g for Solaris

OS: solaris 11_2-text-x86 I want to install an Oracle Client but can only see the Oracle Database 11g Release 2 Client (SPARC) but my Solaris OS isn´t sparc. When i still install the sparc version (...
0
votes
1answer
4k views

What is OracleXETNSListener service?

What OracleXETNSListener service does? I know it is installed with Oracle (11g Express), but I couldn't find a description. What I checked: The service description field is empty. Google hits show ...
0
votes
1answer
540 views

SQLPLUS 32-bit Linux Pathing Issue

I am running linux 32 bit and installed Oracle 11g in it. I am trying to start sqlplus from command line but get the command not found error. I checked the environment variables and have ...
2
votes
0answers
7k views

Oracle telnet localhost 1521 connect failed

Our service provider installed Oracle 11G on our Windows 2008 R2 server on vmware. But we can not connect from another client on port 1521. And we can not also telnet localhost 1521 port on server. ...
0
votes
1answer
610 views

Comparison between Oracle RAC Cluster Database (10gR2, 11gR2 and 12cR1) and deployed Oracle DB on Linux Cluster [closed]

Oracle RAC implementation may be costly for small enterprise, but how it would be if Linux cluster is implemented and then standard Oracle DB is deployed on that cluster to achieve availability like ...
2
votes
5answers
13k views

Sqldeveloper /as sysdba connection

I'm a total newbie in Oracle. I installed Oracle 11g XE R2. Also I installed SqlDeveloper 3.2.20.09 version. I generated auto connections, and I have 2 connections. One is: /as sysdba and another:...
0
votes
1answer
2k views

Unable to shrink memory allocated to Oracle 11g

Recently I have installed Oracle 11g (11.2.0.1.0) on my Windows 7 desktop having 1GB RAM, and while installation I have allocated 512 MB RAM to Oracle which causes high memory utilization and ...
-1
votes
1answer
11k views

Oracle11g localhost: 1158/em cannot connect

In my Windows 7 professional edition, I installed Oracle Database Express Edition 11g Release 2 which is downloaded from Oracle.com. The SID is 'orcl', username is 'system'. When I attempt connect to ...
0
votes
1answer
400 views

Can't unistall Oracle Database 11g

I'm having huge issues trying to delete Oracle Database 11g. I tried the OUI (Oracle Universal Installer) but it didn't work. (It showed a warning telling me that you should use deinstall, but that ...
2
votes
2answers
8k views

Linker error while installing Oracle 11g on Fedora 18

I have to teach database programming against Oracle DB using C/C++ on Linux. So first step is to install Oracle 11g on Linux. Machine config : HOST: Windows 8 Enterprise 64 bit Guest: Fedora 18 XFCE ...
1
vote
0answers
977 views

Installation of Oracle Database 11g Express Edition on Ubuntu 12.10

I intalled the Oracle database have followed this steps [link|http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html?showComment=1357195285714#c4393074524447658792] . 1....
-1
votes
1answer
125 views

Should a dev team use a local database or a remote shared one? [closed]

I'm part of a team of developer and today, we do our developments against an Oracle 11g database installed on our own machine each. I would like to know your point of view about this way of working ...
0
votes
1answer
686 views

Tunneling through SSH for 1521 port access?

I am developing locally on my computer, using my own Apache server with PHP configured. My database however is remotely located on an Oracle 11g Database Server. We were also given a separate remote ...
2
votes
2answers
4k views

How to find oracle database installation path on solaris 8?

I have a server that solaris 8 is on it. I want to connect to oracle's management system . I found this article getting started with oracle . To connect to management system I should enter http://...
0
votes
2answers
9k views

Installing Oracle 11gR2 on RHEL 6.2

I'm having some difficulty installing Oracle 11gR2 on RHEL 6.2. I have compiled a giant list of every single step I have taken so far. I installed RHEL 6.2 on VMware. It did its easy install ...
0
votes
2answers
631 views

bash: ./wls1036_solaris32.bin: Invalid argument

Having some experience in ubuntu, I installed solaris 11g recently to work on WebLogic. I've downloaded wls1036_solaris32.bin file. When I run ./wls1036_solaris32.bin in the terminal, I'm getting ...
4
votes
3answers
16k views

I am not able to save the changes in tnsnames.ora file

I am trying to save the tnsnames.ora file, but couldn't. It showed access denied. Any one have any idea regarding this? Currently I am using Oracle 11g on Windows 7
-2
votes
2answers
4k views

Missing scott user in Oracle 11 g database

I have installed Oracle 11g R2 on my Windows. During the installation, in password management, the "scott" user is missing. I'm unable to login in "scott" as my sample schema. What do I have to do in ...
1
vote
0answers
639 views

CentOS 6.1 + Oracle Express 11g

I have installed CentOS 6.1 and Oracle. And then I closed the firewall, used the right Env Typed /etc/init.d/oracle-xe start and inited OK But, I can not use "get Started" (Firefox displayed: "...
3
votes
4answers
60k views

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name

I have a batch file which starts the Oracle Services net start OracleOraDb11g_home1TNSListener net start OracleServiceORCL call C:\app\Edifixio\product\11.2.0\dbhome_1\BIN\emctl.bat start dbconsole ...
1
vote
1answer
123 views

Ensure libraries in /usr/lib{64} are found before those defined in /etc/ld.so.conf

I am running Fedora 15 x86_64 and have the Oracle 11 client installed, and have an /etc/ld.so.conf.d/oracle.conf file configured so I can automatically pick-up the client shared object file. However ...
0
votes
2answers
3k views

Where'd my System DSN that I just added go to?

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle ...
1
vote
2answers
33k views

Creating a new user in Oracle Enterprise Manager 11g

I downloaded the Oracle VirtualBox VM containing Oracle SQL Server 11g and all their dev tools. (There's not much documentation along with it and I had to find fragments of info here and there.) ...
19
votes
4answers
178k views

How do I completely remove Oracle 11g?

How do I completely remove the Oracle 11g client from my computer? I am running Windows 7, 64-bit. I have tried running deinstall.bat, but this doesn't work.
2
votes
3answers
2k views

Oracle licensing and pricing [closed]

Question: I'd like to download Oracle 11g database for evaluation purposes. Now I found this link for downloads: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ...
0
votes
3answers
1k views

Is it possible extract/delete part of oracle data dump?

We have an Oracle 11g schema and data dump. As this dump is very large, I would like to extract only part of schema with data. Is this possible to achieve?
1
vote
2answers
967 views

Are Oracle & Visual Studio compatible with Windows 7 64-bit? [closed]

I'm considering moving to Windows 7 64-bit: Will it work faster than Windows 7 32bit? Will Oracle 11g & Visual Studio work on it? Do I need special hardware? (I have a Dell Latitude D520 laptop)
0
votes
0answers
521 views

Problems during binding SpotLight to the instance

I have RAC Oracle11 installation built from 2 nodes running on Linux Red Hat OS. Now, I try to make connection from SpotLight running on Windows 7 to the Instance of one of nodes (TNS name of it is: ...
3
votes
4answers
18k views

I just installed oracle 11g and I can't figure out how to log into the enterprise manager.

Any idea what the default login is? None of my oracle accounts are working.