Questions tagged [oracle-11g]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
83 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 ...
0
votes
0answers
273 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, ...
0
votes
0answers
89 views

Environment variable ORACLE_UNQNAME not defined for Em agent on db server

Have OMS 13c installed on one server and have deployed em agent to various linux db servers running multiple db instances. On our 12C db hosting 2 instances, emctl start/stop agent works - no ...
0
votes
0answers
54 views

Issue in installing Oracle DB 11G in Oracle linux

I am trying to install Oracle DataBase 11g in oracle linux 7.1 , I have performed pre-requisite checks of system configurations as per oracle given matrix and also have created oracle user and dba,...
0
votes
0answers
24 views

Migrating from one Data Modeler to another (Toad Data Modeler to Enterprise Architect)

I have been using Toad Data Modeler 6.5. The free trial is up, and my company just bought "Enterprise Architect". Is there a way to convert the Toad Model project (.txp) to Enterprise Architect ...
1
vote
0answers
21 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 ...
0
votes
2answers
257 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 ...
0
votes
1answer
28 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 ...
0
votes
0answers
488 views

SQL Developer throws error,'Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection'

getting this error when trying to connect database on my laptop. ORACLE VERSION:- 11.02.00.01 sqldeveloper-19.2.1.247.2212-x64 OracleOraDb11g_home1TNSListener service if off new user, appreciate any ...
0
votes
0answers
76 views

ODI Studio standalone agent installation

java version = 1.8.0_73, oracle version 11.2g 1. successfully installed RCU 2. Successfully installed ODI 11.1.1 with a standalone agents.Agent details as follows: port 20910, protocol=http, name =...
0
votes
0answers
20 views

Connect Oracle 11g Express with Microsoft Access

I have a database instance Oracle 11g Express. I' ve done this and now i have to make the front-end using Microsoft Access. I tried to link my Database with Access by doing this: (on Access) Exernal ...
0
votes
0answers
56 views

Does DB2 have any internal JMS queuing mechanism

Does DB2 have any internal JMS queuing mechanism similar like Oracle Active Queue (AQ). DB2 version 11.1.4.4 Server is Linux Redhat 7.5
0
votes
0answers
24 views

Oracle SQL Developer - Reveal /Unhide the password

draft saved Hi, does anyone know how I can see my password in Oracle SQl Developer version 3.0....? I have found this site http://show-me-password.tomecode.com/ but I am on a company computer. But my ...
1
vote
0answers
12 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 ...
0
votes
0answers
205 views

How to access existing Oracle db from Docker container

I have a problem: there is a Spring Boot application container running on VirtualBox VM (particularly CentOS 7) and there is an Oracle test database server and on my host, Windows 10 Oracle client set ...
0
votes
0answers
8 views

Arguments passed Flow directory name: TestCase name: JAVA_HOME location: ERROR: you need to provide flow directory name

I am using OUTA(Oracle Utility Testing Accelerator) Script to run regression testing, however it wasn't successful and got that message in the testlog.txt under the directory runtime/Logs. Right now, ...
0
votes
0answers
32 views

Oracle EM 11g Console Not Loaded Properly

When I try to open Oracle EM 11g console, I get a messy look shown below. I have the same problem with all browsers. Does anyone know what the problem is?
0
votes
0answers
441 views

oracle-xe-18c configure fails with No valid IP Address returned for the host

I have tried to install oracle 18C Expression edition which got fail throwing error Parsing command line arguments: Parameter "orahome" = C:\app\HP\product\18.0.0\dbhomeXE Parameter "instype" ...
0
votes
0answers
19 views

Oracle 11g How to drop a datafile that does not exist on the OS side

I've inherited an Oracle 11g application for which there is a table space that references a data file, but the data file has no physical existence. It is offline, but considered available with no ...
0
votes
0answers
1k views

Connect to Remote Oracle DB via Python: DPI-1047: 64-bit Oracle Client library cannot be loaded

Summary: I am having trouble connecting to a remote Oracle database via the Python library, cx_oracle. Error: DPI-1047: Cannot locate a 64-bit Oracle Client library: "C:\Oracle\product\11.2.0\...
1
vote
0answers
16 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 ...
0
votes
1answer
356 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 (...
0
votes
0answers
117 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 ...
0
votes
1answer
163 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....
3
votes
0answers
425 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 ...
0
votes
1answer
224 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 (...
1
vote
0answers
178 views

TNS:protocol adapter error (ORA-12560) on Windows Server 2008 R2

I just took over a new Oracle Database Administrator role and in the course of studying my environment, I can't access one of the databases. I keep getting this ORA error. ORA-12560: TNS:protocol ...
0
votes
0answers
13 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.
1
vote
0answers
359 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 ...
0
votes
1answer
1k 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
1k 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
54 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
1k 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
785 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
650 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 ...
1
vote
1answer
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. ...
0
votes
1answer
167 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
2k 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
4k 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
191 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
534 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
0answers
807 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
5k 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
556 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
9k 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
661 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
14k 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
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 ...
-1
votes
1answer
13k 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
926 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 ...