The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
9 views

Users lose access to the database folder

I work as IT Support for public service. Some of the software our users use rely on Oracle 9 as database. By default, it installs itself in root folder C:\Orant9i. But from time to time a user calls ...
0
votes
0answers
17 views

how to create diagrams like those in oracle documentations? [on hold]

how can I create diagrams like oracle documentation diagrams? like this image from ALTER TABLE .
0
votes
0answers
18 views

Production plan for Two Simultaneous OS in one VirtualBox?

I have not found any public plans about having two OSs in one VirtualBox. Is there any news about having the feature of running two OS instances inside one VirtualBox?
0
votes
1answer
24 views

How to use Window Manager of Linux inside VirtualBox?

I have the same problem in Redhat Linux and Debian Linux. I cannot use the normal switching between windows. I mean this square window manager: I tried all keys CMD, ALT, CTRL, FN and SHIFT and ...
0
votes
1answer
12 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
0answers
29 views

Remove extra blank line in the bottom of spool file

I am creating a spool file. Problem is that it creates a blank row in the bottom which i do not need. I am running the .sql in windows. Any suggestions? below is the sql : ...
0
votes
1answer
23 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
19 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
10 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 ...
2
votes
1answer
52 views

Cannot access Win7 Oracle Database from Ubuntu VM

My main (physical) machine is Windows 7. I have installed a "homestead" Virtual Machine using VirtualBox so that I can develop a Laravel application in the VM. Homestead (the VM) runs Ubuntu 14.10 ...
0
votes
1answer
16 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
0answers
27 views

Oracle VM VirtualBox Win 7 Data Recovery

So I'm running Oracle VM VirtualBox with a Build of Windows 7 Ultimate, and the virtual guest OS just crashed out of no where, and won't allow me to access my windows guest os. I wanted to know if ...
0
votes
0answers
35 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
0answers
17 views

Oracle Virtual Box: No option for 64bit vm's [duplicate]

I've installed virtual box on my pc and I want to use 64 bit operating systems inside my vm. Unfortunatly I can only create 32 bit vms (the 64 option is missing completly). I know it should be there ...
0
votes
0answers
74 views

Task Schedule excel file with ODBC/Oracle connection

I am having problem running an excel file with ODBC connection for Oracle to run via Windows-7 Task Scheduler. It will just say running. What the excle file does. After I open the file, it will ...
0
votes
0answers
25 views

How to Create a VirtualBox like Oracle developer day VM using CentOs?

Oracle has provided us a way to use Oracle Database on Mac with its Developer day VM's. But its of huge size and I couldn't resume the download. So I want to build a VM with Oracle Database installed. ...
0
votes
1answer
64 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
98 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. ...
0
votes
0answers
19 views

Installing java 7 or 8 on Mac OS, some questions

I have java 6 installed on my Mac OS laptop. Due to a requirement of some Android library of having Java 7 installed, I need to install it. Should I install Java 7 or 8? Or both? I know there's no ...
0
votes
1answer
76 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
0answers
64 views

Patch Heartbleed Vulnerability on Oracle Enterprise Linux 6.5

After running an application scan on a webapp hosted on Oracle Enterprise Linux 6.5, the scan reported that the app was vulnerable to Heartbleed. I am having a tough time updating OpenSSL on OEL 6.5. ...
0
votes
1answer
71 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
298 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
51 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
0answers
89 views

Virtualbox Centos / Oracle Express losing connection

I am running a Virtualbox Centos Oracle Express developer machine in a local "Hostonly" network. After a few minutes I can verify with SQLDeveloper that the working connection to Oracle is suddenly ...
0
votes
0answers
20 views

How to backup Oracle database and tomcat directory from Disk with Fedora or other linux live cd?

Some partitions of my disk corrupted (superblock error) and cannot boot, stacked on "Maintenance Mode". How to backup oracle database and tomcat directory on that disk with linux cd ?
0
votes
0answers
36 views

Linux 32 bit CPU + Oracle Limitations

I have 32 bit RedHat 4 server (with hughmem kernel) CPU is 2 x Xeon X5650 (12 total psychical cores, 24 virtual) On the server there is running Oracle 10G (32 bit) database instance. Oracle because ...
0
votes
1answer
81 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
43 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 ...
0
votes
0answers
36 views

Load data from mailbox to oracle table

I have an incoming mail which has the below format in the body Number of output records -: Consumer Extract |: TOTL_OUTPUT_REC: 10684 Number of output records -: Campaign Extract |: TOTL_OUTPUT_REC: ...
0
votes
0answers
20 views

Permenant link to official Java documentation pages?

Does Oracle's official Java documentation pages such as http://docs.oracle.com/javase/8/docs/api/java/util/concurrent/ConcurrentHashMap.html have permenant links? If so I'd like to use that instead ...
1
vote
2answers
330 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 ...
0
votes
0answers
11 views

data was displayed in my toad even after pressing F9 key

i am using the package dbms_output package for display some in formation for defining particular operation. after writing the procedure we generally F9 key to compile & execute the program. but ...
0
votes
0answers
76 views

How can I connect to apex oracle database using ssh?

I have obtained a workspace in apex.oracle.com , where I can use database provided for me. Now I can run the sql command in browser to do operations, but thats kinda slow. So what I need to do is , ...
1
vote
1answer
276 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
114 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 ...
0
votes
2answers
162 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 ...
0
votes
2answers
114 views

Connect to Oracle Linux Virtualbox Database from Debian Linux Virtualbox

I have an Oracle Linux 6.4 with Oracle 12c running on a Virtual box with NAT and bridged network running on an OSX host. A second guest is a Debian Linux with NAT and bridged network. I'm trying to ...
0
votes
1answer
54 views

Loading Oracle Virtual Box Error

When I tried to install 'Oracle VM Virtual Box' it is giving a error -'VT-x/AMD-V hardware acceleration is not available on your system. Certain guest (e.g. OS/2 and QNX) require this feature and will ...
0
votes
1answer
316 views

Looking to kill frmweb processes with no jobs

So I am trying to figure out a way to kill Oracle frmweb processes that are doing nothing when load begins to get too high. So far, I have found this command: ps -elf | head -1; ps -elf | awk '{if ...
0
votes
1answer
225 views

concurrent scheduled jobs and ora-27477

Need: To have Oracle kick off a shell script that performs processing on tables and data in the Oracle database. The script is instantiated by specific activity from web clients. Issue: Web clients ...
0
votes
0answers
15 views

Oracle RAC 11G Requirements VS Single Node 11G

I have an Oracle 11G Database running on Solaris SPARC. I'm already using NFS for the node. I'm looking at moving to RAC. Would there be any additional requirements for RAC besides an additional ...
1
vote
1answer
293 views

How to use backreferences in oracle sqldeveloper find/replace

How do you use backreferences when doing regular expression find/replace in Oracle SQLDeveloper? \n doesn't work for me and neither does $n.
0
votes
0answers
702 views

Installing Oracle 32-bit Client on Windows Server Already Running 64-bit Oracle Database Server

I have 64-bit Oracle Database Server (11.2.0.3) installed on Windows 2008 R2, and naturally, it automatically installs the 64-bit client. I have to install an application onto this server that is ...
1
vote
1answer
23 views

Bind Solaris 10 swap file

I have created an Oracle swap file to enhance my swap space. I have to do this for a Oracle Client installation. After creating swap file i Run the swap command to specify the additional swap space ...
1
vote
1answer
75 views

Process Monitor Results from two Citrix Servers Application Error

I have two Citrix Servers both running an in-house bespoke software. The software generates files using a word 2003 mail merge template which runs VBA code to query an oracle database. Anyway the ...
1
vote
1answer
172 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
0answers
40 views

Oracle VirtualBox won't let me create a machine

I get this error message: Callee RC: REGDB_E_CLASSNOTREG (0x80040154) When trying to use Gentoo. I ran in administrator mode, but didn't work. I did everything it suggested, without changing a ...
0
votes
1answer
620 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
0answers
147 views

IE10 dropdown menus not resizing properly when page-zooming

Drop-down menus are not displaying right in IE 10 when using anything other than 100% zoom. 100%: 125%: 75%: It is working on one computer, but I can't identify the difference. Both ...