Questions tagged [oracle-11g]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
148 views

Unrecognizable options in TNS Service name for a new System DSN in ODBC administrator, after installing Oracle Client 11gR2

On 64-bit Windows 10 Enterprise, I was asked to install win32_11gR2_client. But I encountered the following problems. When I run setup.exe in the top directory temporarily as an administrator, I got ...
Tim's user avatar
  • 17.2k
0 votes
1 answer
120 views

Getting oracle client installed on a VM to communicate with Oracle 12G on a different VM

Can anyone help me figure this one out? I can sucessfully connect to the VM Oracle Server with sqlplus on my host OS but on VM2 where i have my sqlplus installed i cant seem to connect giving ...
syed umar's user avatar
0 votes
0 answers
2k views

How to setup Oracle ODBC for MS Access 64bit on windows

I have used more time on getting ODBC for Oracle to work than I would like to admit. The crest is simple. Link tables from MS Access to Oracle Everything is running 64bit. Oracle Express 11.2G, ...
Martin Andersen's user avatar
1 vote
0 answers
154 views

DBCP Connections pool connection stuck after no using

We stuck with a strange issue in java with Oracle connections pool If java program gets new data all the time no issue discovered. But if for a long period no requests to DB, and we try make a ...
Ilya Li's user avatar
  • 11
0 votes
2 answers
2k views

TOAD(11.5) - DB Connection fails with 'protocol adapter not loadable' , windows 10

It all started with me trying to import 11g db dump into 12c R2 oracle. DB Dump - 11.02.0 Server - 12.2.0.1.0 I was getting the tns error 'could not resolve connect identifier specified'. After ...
pyroCoder's user avatar
0 votes
1 answer
54 views

SQL Developer - how to assess change to data model

I'm working with a schema I'm not familiar with and am trying to find out if there is a way to do a diff between the state of the data in the schema instance between transactions - does anyone know if ...
harry callahan's user avatar
1 vote
0 answers
15 views

DB Connection Trouble, when starting muliple connections

I'm working on a Windows Server 2016 and want to connect to an Oracle 11gR2 DB. When I'm starting to connect, the Java Application works fine. But when a second Application(Python) starts the first ...
Kumar Yong's user avatar
1 vote
0 answers
18 views

Finding tables without primery keys, and non null unique keys [closed]

I have a requirement to find out tables without primary key or Not-NULL unique constraints. How do I do that in Oracle ? I also want to find out any primary key column which has datatype as TIMESTAMP ...
DBPlayer's user avatar
0 votes
1 answer
1k views

Struggling to import Oracle tables via Excel Power Pivot

I have an issue where i'm trying to pull some data from an Oracle table via Excel Power Pivot. To connect to Oracle, i used Table Import Wizard in Power Pivot and entered all the required info (...
Charles's user avatar
0 votes
0 answers
327 views

why the Listener in Oracle XE database does not start upon the initialization of the Docker container?

I've setup my Oracle XE database on a docker container, but when i start the container even though i get this message on logs Database ready to use. Enjoy! ;) and i can connect to the database ...
konstantinos's user avatar
0 votes
1 answer
303 views

The use of Wget for Downloading Oracle

My basic configuration: Ubuntu 16.04 Wget 1.17.1 when I use the command $ wget --http-user=myuser --http-password=mypasswrd https://download.oracle.com/otn/linux/oracle11g/R2/linux....
user1018097's user avatar
3 votes
0 answers
820 views

No Support for Oracle UDT in latest version of oracle.manageddataaccess.dll

With oracle.DataAccess.Types we were able to integrate user defined types in oracle. But In latest version of Oracle.ManagedDataAccess.Types UDT is not supported. It seems that ODP.NET Managed Driver ...
Madhuri's user avatar
  • 31
0 votes
1 answer
609 views

How to change SQLDeveloper's language to Chinese?

I've seen many posts on how to change SQLDeveloper's language to English, by using the following method: sqldeveloper.exe --AddVMOption=-Duser.language=en I have tried this method with both English (...
Matthew Moisen's user avatar
0 votes
0 answers
56 views

new user password disappear after I create in SQLdeveloper

I have problem when I create new user so the password disappear after I create in SQL developer and when I tried to make connection its giving errors please help.
A.Khan's user avatar
  • 1
1 vote
0 answers
626 views

oracle installation pre requisite check error

I'm trying to install Oracle 11gR2 on Oracle Linux 7.4. While the installer is performing prerequisite checks, we are getting error: This is a prerequisite condition to test whether the OS kernel ...
Kim.K.H's user avatar
  • 11
0 votes
1 answer
2k 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. ...
Narayana Boominathan's user avatar
2 votes
1 answer
2k 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 ...
Seven's user avatar
  • 25
0 votes
1 answer
56 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 ...
susik's user avatar
  • 653
0 votes
1 answer
2k 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, ...
Mohan's user avatar
  • 103
0 votes
1 answer
1k 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 ...
usr-local-ΕΨΗΕΛΩΝ's user avatar
1 vote
1 answer
762 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 ...
Stefan89BEG's user avatar
1 vote
1 answer
1k 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. ...
Ravi's user avatar
  • 167
0 votes
1 answer
214 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 ...
John's user avatar
  • 203
1 vote
2 answers
3k 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 ...
Shyam Bhimani's user avatar
1 vote
2 answers
5k 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/...
Nan Xiao's user avatar
  • 4,113
0 votes
1 answer
230 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 ...
uldics's user avatar
  • 67
0 votes
1 answer
552 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 . ./...
user518066's user avatar
1 vote
0 answers
878 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 (...
aykon's user avatar
  • 35
0 votes
1 answer
6k 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 ...
gerleim's user avatar
  • 195
0 votes
1 answer
560 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 ...
ghostFishKillah's user avatar
2 votes
0 answers
11k 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. ...
sa_'s user avatar
  • 131
0 votes
1 answer
670 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 ...
user3134198's user avatar
2 votes
5 answers
15k 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:...
enigmaticus's user avatar
-1 votes
1 answer
3k 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 ...
Ganesh Dake's user avatar
-1 votes
1 answer
15k 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 ...
Ramkumar's user avatar
0 votes
1 answer
1k 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 ...
peter burg's user avatar
2 votes
2 answers
9k 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 ...
rsjethani's user avatar
  • 245
1 vote
0 answers
1k 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....
Praneeth Pj's user avatar
-1 votes
1 answer
173 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 ...
Anthony Richir's user avatar
0 votes
1 answer
918 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 ...
A T's user avatar
  • 791
2 votes
2 answers
5k 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://...
hamed2's user avatar
  • 21
0 votes
2 answers
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 ...
Chris's user avatar
  • 33
0 votes
2 answers
770 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 ...
bhargavg's user avatar
  • 103
5 votes
3 answers
22k 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
saida's user avatar
  • 59
-1 votes
2 answers
7k 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 ...
paramita's user avatar
1 vote
0 answers
648 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: "...
user avatar
3 votes
4 answers
70k 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 ...
Tapas Bose's user avatar
1 vote
1 answer
296 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 ...
trojanfoe's user avatar
  • 375
0 votes
2 answers
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 ...
Kevin's user avatar
  • 165
1 vote
2 answers
35k 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.) ...
Yanick Rochon's user avatar