Deprecated tag. DO NOT USE.

learn more… | top users | synonyms

0
votes
0answers
15 views

Can't clear Apple Mac Dock Icon after Oracle SQL Developer App has closed

I just started experiencing a bug where the SQLDeveloper 4.1.3 (latest) app icon freezes in the mac OS dock. This prevents me from relaunching the app without a hard reboot of the computer. ...
-1
votes
0answers
12 views

mutt command is not working with huge file size, Can anyone suggest for the same

I am using 'mutt' to send the small number of records(fetched from database and converted into CSV) through email, while if the record grows till 400k from database mutt is not able to send that huge ...
0
votes
1answer
29 views

Oracle orapki - How to install?

I need the Oracle wallet manager / orapki tools to create wallets, but I'm unable to find an installation for them... I want to install them on Ubuntu (but Windows or any linux would also be possible)....
0
votes
1answer
17 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 ...
0
votes
1answer
79 views

PHP 5.6 OCI8 Install Issue:

I am trying to install the OCI8 extension on Red Hat 7 (PHP 5.6.x.) I have spent at least two days trying to figure this out including combing SuperUser and StackOverflow. So far none of the answers ...
0
votes
0answers
43 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 ...
0
votes
0answers
19 views

ORA-12505 error come when connect to db in spring application

Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'workspaceDbdao' defined in class path resource [context-datasource.xml]: Invocation ...
0
votes
0answers
12 views

Failed to Read Description. Error Code 2 Oracle Services

I'm getting Failed to Read Description. Error Code 2 in Oracle services. I'm trying to uninstall it. How I can remove these services? I tried all way but still failed. I'm using Oracle 12c.
0
votes
0answers
19 views

XML Spy Blocks Weblogic 10.3.2

My computer was shut down abruptly and since then i'm not able to run weblogic (10.3.2) locally on my computer ( neither from eclipse or manually from the oracle domain) . i keep getting the message: \...
1
vote
0answers
33 views

Red Hat High Availabilty Oracle Resource Wallet Error

Environment: Running Red Hat 7.2, using Pacemaker 1.1.13-10.el7_2.2 and Corosync 2.3.4-7.el7_2.1 to implement cluster failover of an Oracle 12c Enterprise Edition Release 12.1.0.2.0 Database. ...
1
vote
0answers
213 views

OCI8 extension not loading in PHP 5.4, CentOS 7

I have a CentOS environment running as a VM guest. It runs and Oracle 12.1 Database, along with PHP 5.4.16, on Apache 2.0. I've gone through the installation steps to ensure that the correct OCI ...
0
votes
0answers
143 views

Requirements to install cx_oracle

I'm trying to install cx_oracle on Mint 17.1. At first, I got an error "cannot locate an Oracle software installation". I then attempted to install Oracle 11g, but the installer failed. There was a ...
0
votes
0answers
132 views

Microsoft ODBC for Oracle not working with Oracle 11.2.0.2

I have Oracle client installed and i am able to connect using sqlplus, i am also able to use My requirement is to try to use Microsoft ODBC for Oracle using the following VBSript code my .vbs file ...
1
vote
1answer
504 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
41 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 ...
2
votes
1answer
56 views

Oracle SQL Developer update

I am trying to update my Oracle SQL Developer 4.1.2.20. When I select components such as MySQL JDBC Driver or Perforce Extension then I am asked to log in using my Oracle Web Account. This is when ...
0
votes
1answer
39 views

How to use “$” in SQL plus?

I'm Facing the following problem. When i try to execute the following command in sqlplus in my SLES: sqlplus -S user/password@balancer.domain.cl <<EOF SELECT INSTANCE_NUMBER, HOST_NAME, ...
0
votes
1answer
134 views

How to identiy that how many instances of Oracle are installed on linux environment

Last day, i was at one training for oracle installation and service start & shutdown. There i came to know about some linux commands to start and shutdown oracle instance on linux machine. To ...
0
votes
0answers
6 views

Oracle RR math instruction length cut offs? Expert needed

Machine cycles for Oracle Math considering Oracle data type and lengths for the top compilers where are the step thresholds when varying length? Example Answer Well Dave Oracle 10g compiled on a 64 ...
1
vote
0answers
30 views

Logging SOAP-queries in Glassfish v4

I need catch SOAP-queries, which come to my application in GlassFish. I found how this work on GlassFish v3 and v2, but not for v4. I try reed official documentation, but not found nothing interesting
0
votes
1answer
121 views

Why do jre7 is named as jre7 in the installation folder instead of jre1.7 while jre1.8.0_60 is as jre1.8.0_60?

I would like to know the reason for this. There must be a specific reason for the deviation in these naming conventions right? But, in use are both the versions are similar?
0
votes
1answer
209 views

Error on connecting excel to a oracle database

I'm trying to connect to a Oracle Database from a Excel 2010 in a Windows 2010 machine. I installed 64-bit Oracle Data Access Components but when I try to connect to the database on Data > From ...
0
votes
0answers
74 views

Startup Oracle Database with an NFS mount

I currently have an Oracle Database which works just fine on 1 server. I want to share the folder which contains its' control file to another server via an NFS mount. However when mounted I get ...
1
vote
1answer
88 views

Installing Oracle Database and can’t find “Workgroup Manager” in Mac OS X 10.10.5 (Yosemite)

I just started to work with Mac and I’m trying to install Oracle Database using the instructions at this link. Section 6 of this tutorial says that some groups should be constructed using “Workgroup ...
0
votes
1answer
51 views

How relevant today to use JVM? [closed]

Don't we have enough amount of compilers today (for various platforms) ? Python for example - it is considered as a crossplatform langauge.
0
votes
3answers
149 views

Connect to a remote Database at home from work

I have a laptop running Windows 10 in my home, with Oracle DB installed. This laptop is connected to the Internet. I need to access the database on that laptop from anywhere. How do I achieve ...
0
votes
0answers
201 views

Why start power of machine in Oracle VM Virtual box fails with code 0x80004005?

I standartly power off virtual machine in Oracle virtual server (so other VM can run). When I tried to start it again I end up with E_FAIL (0x80004005). Failed to open a session for the virtual ...
0
votes
0answers
14 views

How to compute the number of man day with database of oracle primavera P6?

I want compute the number of man day, man month of the Project or the Resource based on input parameters 'From Date' and 'To Date' with database of Oracle Primavera P6 Project . What is the tables ...
0
votes
0answers
102 views

Connect to Oracle database by powershell

It sound stupid but i want to know how we can connect to oracle database remotly by powershell. I know we can connect by using ODP.net but i am looking for all possible option. I dig a lot on google ...
0
votes
0answers
72 views

Prevent OpenJDK from overriding Oracle's Java Installation

Currently using Lubuntu 15.04 x64. I have had this problem twice now. I install the official Oracle Java (version 1.8) successfully, after which an automatic update (at some point later in the week) ...
0
votes
0answers
221 views

IIS app pool is shutting down when connecting to Oracle DSN?

I am trying to connect to the Oracle database using the DSN in my web application and when I browse the site the app pool crashes. The DSN is set up correctly I think because when I hit Test ...
0
votes
2answers
8k views

Microsoft ODBC driver can't find Oracle Instant Client

I have an old 32-bit software program that connects to an Oracle database but only works with the Microsoft ODBC driver for Oracle. It does not work with the more up-to-date native Oracle ODBC driver....
0
votes
1answer
24 views

null values aren't returned unless specified - Oracle SQL

When attempting to run a select statement that simply excludes some data, null values are wrongfully (?) being excluded as well. Using table a: ID NAME 1 Foo 2 Bar 3 ...
0
votes
1answer
86 views

How can I get my two VM's in virtual box to ping each other?

although each of the adapter are set to "internal network", i keep getting, network is unreachable.. Help Please .. Please make it simple Thanks in advance
0
votes
1answer
71 views

oracle AQ for scheduled jobs

We have a process that currently uses the Oracle DBMS_SCHEDULER to execute. The process runs every time the backend receives data from an external device. The Oracle scheduler is set up such that a ...
1
vote
0answers
66 views

.bad file not generated in SQLLOADER

I am invoking sqlloader from windows batch script. I have a WHEN clause added in control file. Error record generates and log says that .bad file is generated at designated path. However, no .bad file ...
0
votes
1answer
37 views

In Solaris how do you start App Builder CDE?

I have a Oracle Solaris 11 installed on a VM. I am trying to start the App. Builder program by dtbuilder as mentioned in the documentation but unable to start. I cannot find /usr/dt directory either. ...
0
votes
1answer
301 views

Oracle SQL Developer Data Modeler: How to Search for a Table and Show in the Diagram

In the Oracle SQL Developer Data Modeler 4.0, there is find functionality. It's icon is the binoculars in the top right corner. When we use that find operation, we receive a list view of results that ...
0
votes
1answer
323 views

I moved Oracle Instant Client, but it didn't actually move?

I set up our local intranet on IIS running on a Windows Server 2012 using Oracle Instant Client to connect to our database. I installed Oracle Instant Client to C:\instantclient during set up. It ...
1
vote
0answers
249 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. nagios@servername:/usr/local/...
0
votes
1answer
204 views

How do I check for command line parameters in sqlplus?

I am trying to write a sql file which will run under sqlplus. My goal is to create a mechanism by which sqlplus will prompt for password if no parameters are passed, and if &1 is present, continue ...
0
votes
1answer
217 views

Toad Query Builder Object Palette is empty

I realize this is a re-ask of In Toad for Oracle's Schema Browser, my Tables list is empty, but I don't have the ability to just add a comment yet. I'm running Toad 12.6 and I've setup a ...
1
vote
1answer
610 views

Oracle SQL Plus expdp in bat file

I try to export all my bases with a .bat file, but when the .bat file open and connect in sqlplus, the program don't read the last of file. I need export and log all export with Spool. The .bat is ...
0
votes
1answer
111 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 . ./...
0
votes
1answer
233 views

What does this “3-line to column” icon indicate about an object in SQL Developer?

In SQL Developer, under Tables, almost all of my tables are just a normal table icon, however, every so often I come across a table that has the icon/image shown below. I wasn't around when some of ...
0
votes
1answer
90 views

Why is oracle instant client so slow on OSX?

I have both a PC and Mac environment setup to connect to the same Oracle server. Both are using Oracle instant client 11.2.0.4 and are on the same network. Both machines are similarly configured (e.g.,...
1
vote
2answers
733 views

Add a file to /etc/yum.repos.d to install Oracle JDK 1.6.0-45 from yum?

I have a fresh RedHat 6.5 virtual machine on Amazon Web Services (EC2), its repos look like this currently: [root@ip-172-31-11-112 tmp]# ls -1 /etc/yum.repos.d/ redhat-rhui-client-config.repo redhat-...
1
vote
1answer
620 views

Oracle SQL Select: If not exist, leave blank

I have two tables: Table1 [ID] [Number] 1 40 2 100 3 7 and Table2 [ID] [Number] [Name] 1 40 A 3 7 C Data originates in Table1, then gets copied to ...
0
votes
1answer
332 views

SQL Developer 4 Toolbar

Recently my SQL Developer toolbar became messed up. I'm not sure what I did, and I can't change it back. When I got to View-->Show toolbars-->Customize Main Toolbar, it just says "initializing"...
0
votes
2answers
249 views

Is it possible to install OS Windows 8.1, Windows 7, Windows Server 2012, Oracle Linux, Oracle Solaris, Fedora Linux?

I'm planning to have 6 operating systems in my laptop. And wanted to have more in the future. I want to install 2 versions of desktop OS in windows (7 and 8.1) and a server OS in windows (Windows ...