The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
10 views

Is there any friendly Database terminal for Windows? [on hold]

is there any Database friendly SHELL,terminal for windows that have auto-complete for database commands ,also can display tables in clean way after performing select statement ?
0
votes
0answers
8 views

Can we use a calculation when creating an Oracle SQL table? [migrated]

When creating an Oracle SQL table, can we give a calculation? For example create table test ( item-code number, qty number, rate number, (qty*rate)value number )
0
votes
0answers
23 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
1answer
4k views

How to fix UDI-31623 error in Oracle?

Yesterday I've tried to import another DUMP as a new Oracle schema and failed to to limited space. So the impdp exited with an error. I've successfully deleted outdated schemas using the sysadmin ...
0
votes
0answers
3 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
12 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
25 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) ...
-1
votes
1answer
381 views

How to install Guest Additions in Windows 10 on VirtualBox

I just installed Windows 10 RTM on my VirtualBox and I wanted to install Guest Additions. I inserted virtual CD with it and during installation the graphics crashed and since then (even after reboot) ...
0
votes
3answers
3k views

Oracle VM VirtualBox “instruction at 0x806d58e2 referenced memory at 0x00000000” error

When I start Oracle VM VirtualBox 4.2.18 on Windows 8.1 64bit, the below message shows. What is the meaning of this message and how to solve it? VBoxTestOGL.exe The instruction at 0x806d58e2 ...
0
votes
1answer
34 views

How can I create a 64-bit virtual network with VirtualBox? [duplicate]

I can't find an option to install a 64-bit OS on VirtualBox. I have a 64-bit host, but I can't find an option to make a 64-bit guest, only 32-bit. Help please?
0
votes
1answer
4k views

Oracle11g localhost:1158/em not 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
0answers
38 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
1answer
123 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 ...
0
votes
0answers
11 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
1answer
32 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
18 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
57 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 : ...
3
votes
1answer
13k views

How to get fullscreen in Virtual Box

I am using VirtualBox. I have also added an Operating system to it. Now i need to know how to get a fullscreen view from it. What i get now is a centered screen and i find it difficult to work with. ...
0
votes
1answer
26 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
33 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
17 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
96 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 ...
14
votes
4answers
99k 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.
0
votes
1answer
19 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. ...
3
votes
3answers
7k views

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

I am tring to save the tnsnames.ora fille, but couldn't it showing acess denied. Any one have any idea regarding this? Curently I am using Oracle 11g on Windows 7
0
votes
1answer
89 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 ...
0
votes
0answers
33 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 ...
-1
votes
2answers
141 views

Anyone has and is willing to share BIOS update for Sun X4170? [closed]

I have a Sun X4170 server and would like to update its BIOS (for one, Windows 2008 does not work on it). However, since Sun was bought by Oracle, there is no way to download any BIOS update. Does ...
0
votes
0answers
61 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
1answer
60 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 . ...
2
votes
1answer
232 views

WebLogic 12.1.1.0 is truncating dynamically generated XML file

this is my first question on SU/StackOverflow, so bear with me... We've got an exploded application, residing on a NAS mount, that we just moved from WebLogic 6.1 to WLS 12.1.1.0. Believe it or not, ...
0
votes
0answers
96 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
30 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
104 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
131 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
22 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
107 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
72 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. ...
1
vote
1answer
350 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 ...
-2
votes
2answers
3k 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 ...
0
votes
0answers
100 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 ...
1
vote
2answers
618 views

Database is full; what should be the strategy?

What if my database is full and I don't have any spare hard disk or memory space. What should my strategy to free up the space?
0
votes
2answers
2k views

starting oracle database automatically

I am using Fedora 8 and Oracle 10g Express Edition. Every time I start my fedora I have to click on start database. How can I add startdb.sh to startup so that it automatically executes when Fedora ...
2
votes
1answer
312 views

Trouble installing OpenCOBOL

When I ./configure, I get this error: configure: error: libdb is required I signed up for an Oracle account (yak shaving), downloaded Berkeley DB, untarred and unzipped, wrestled with the unhelpful ...
0
votes
2answers
1k views

Is there sofware that can emulate how Oracle works with disks?

Don't now if its a right place to ask, so if not please give me a hint. I need some software that do can emulate how Oracle works with disks (Notice: Not the Oracle workload tool). I've already took a ...
0
votes
0answers
88 views

What software do I need to query an Oracle database?

I know how to write queries, but haven't had to mess with the software before. I've been given a username, password, and an Oracle TNS string (the text, not a tnsnames.ora file). Nothing I've tried ...
1
vote
1answer
745 views

Install Oracle on Mac OS X Lion 10.8

I have no experience with Oracle but need to install it on my Mac so that I can test pulling data from an Oracle database. I already have Apache, PHP, MySQL installed but have no idea where to start ...
0
votes
1answer
4k views

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
0
votes
1answer
2k views

Oracle database client on OS X?

I am looking for a way to run the Oracle database client on a Mac. The server will be on a remote host. There used to be a Mac version of Oracle 10gR2 Client, but now I can't find it on Oracle's ...