The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
4 views

ORA-01219: database not open: queries allowed on fixed tables/views only [migrated]

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- ORA-01219: database not open: queries allowed on fixed tables/views only) I looked ...
0
votes
1answer
13 views

Installing Another Virtual machine on a virtual machine using oracle linux 5.8

I am implementing Oracle RAC using 11.2. For shared disc option and low cost, we are planning to use Virtual Machines. I have installed one virtual machine (PARENT) Specifications: Oracle Linux 5.8 ...
0
votes
2answers
20 views

Oracle Linux VM on Virtual Box

I have downloaded 32bit Virtual Box version and 32bit Oracle Linux VM. This my basic settings: But then I'm catching: This kernel requires an x68-64 CPU, but only detected an i686 CPU. Unable to ...
0
votes
1answer
59 views

Can't import a dmp file to oracle 12c database (imp-00037)

I am trying to import a dmp file to my oracle 12c instance, while I used to do that without trouble I got a file which didn't work with both imp and impdp. After long research without a result I ...
0
votes
0answers
18 views

Environment Variable ORACLE_UNQNAME not defined

I'm trying to install Oracle 11gR2 Entreprise Edition but during database creation, I got this Error : Environment Variable ORACLE_UNQNAME not defined And when I tried to lunch 'emctl.bat' From ...
0
votes
0answers
11 views

How can i export virtual machine in virtualbox with snapshots

I have VM on virtualbox with 15 snaps shots saved. Now i can export to ova and ovf with export but that does not include all snapshots of parent VM. Is there any way so that i can put all snapshots ...
0
votes
0answers
16 views

Oracle 11g - Command line error in sqlplus - SP2 -0306

I am a newbie to Oracle 11g. I installed Oracle 11g on my Windows 7 64 bit machine. And when i try to execute the command "CONN SYS as SYSDBA", i am getting the error SP2-0306: Here is a screenshot ...
-3
votes
1answer
265 views

security block self-running java program

I'm running a java program, but it is blocked by security software(maybe McAfee), I got a pop-up which says: Application Blocked by Security settings your security settings have blocked a ...
0
votes
1answer
21 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 ...
0
votes
0answers
49 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
0answers
19 views

Oracle 11g Installed but cannot access SqlPlus from terminal

I have installed Oracle 11g XE edition. It is working fine from browser. But I want to unlock hr user so I want to login from terminal. However I can't access SqlPlus command prompt from terminal. I ...
0
votes
0answers
69 views

JAVA - Error occurred during the installation

My problem figure out for me when i was configuring my Jboss AS 7 on Linux Mint, in the moment i was installing it, the JVM presentation a some problems and not work anymore. With this, i remove JVM ...
1
vote
1answer
28 views

Virtual Box: always receive keyboard input from host

I am using Oracle VM VirtualBox on Windows 7 to run Ubuntu. I would like to have the VM receive input from windows without pressing the host key (R-Ctrl). When I switch to the VM window from windows, ...
0
votes
0answers
11 views

Oracle Cloud Control - Cant execute jobs

Im using Oracle Cloud Control 12c (WebLogic) on Oracle Linux Server 6.3. When I want to apply the downloadet agent-software, the job stucks in 'scheduled' Status. Is there a way to force this job ...
0
votes
0answers
16 views

probe-scsi-all shows two disks with the same PhyNum

I'm attempting to remotely determine the physical location of two disks in an Oracle SPARC T4-1 server prior to performing a Solaris install. Because the disks use World Wide Names (WWNs), the Oracle ...
0
votes
1answer
49 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 ...
0
votes
0answers
15 views

Software for creating DB alter script that ONLY uses DDL scripts

I am looking for a software which can compare two databases by ONLY using DDL script (i.e. I dont want to create a schema but rather do it on the fly). Is this possible ? Any ideas ?
1
vote
0answers
19 views

Ubuntu Oracle VM Error

I am trying to work on a code project and cannot open my virtual machine which is an "oracle VM virtual box. I took a snapshot yesterday at about 11 and it was working fine. Several times I closed and ...
0
votes
2answers
41 views

How to Uninstall Oracle Client?

I needed to install Oracle Client. I installed just Client Mod before Admin Mode. Now I need to uninstall the first installation (client_1). D:\app\user\product\11.2.0 - client_1 - client_2 There ...
0
votes
0answers
59 views

How can I configure permissions of a Synology NAS so Oracle Data Pump can export there?

I am trying to set up Oracle Data Pump Directories on a Synology Diskstation DS412+ running DSM 4.3-3810. The Oracle Database Servers are running the 10g, 11g and 12c. The Diskstation and the database ...
1
vote
2answers
429 views

Install Linux error: Could not allocate requested partitions - not enough free space on disks

I'm using Windows 8.1, now for education purpose, I try to install Oracle Linux 6.5 as dual boot on my computer. At the Disk Partition section, I found that I cannot create a Partition, both with ...
0
votes
1answer
246 views

Does anyone have a copy of Oracle Java SE Critical Patch Update for Java 7.0.40.22 32-bit

I ran Belarc Advisor which advises me I am missing the Oracle Java SE Critical Patch Update for Java 7.0.40.22 32-bit (CpuOct2013-1899837). You need an Oracle support contract to obtain this patch. ...
0
votes
3answers
190 views

How to disable root login from login prompt but allow switching to root

I would like disable logging in as root on the login prompt but it should be possible to 'su' to root, give password and login. Any help will be appreciated.
0
votes
1answer
83 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 ...
4
votes
1answer
140 views

How an unprivileged user could kill a process she didn't start?

I stumbled upon something very surprising which I cannot understand on a Red Hat EL 5.6 box : the user hri (which is in the group dba) is able to kill processes owned by user oracle (which is also in ...
0
votes
0answers
20 views

how to use oracle r12 that is installed in external harddisk?

I am new to oracle r12 installation. And I have this installed in an external segate 1 TB hard disk. Now I want to run this on my laptop just by pluging my hard disk. But I dont know the procedure to ...
0
votes
0answers
35 views

oracle sql developer not using default directory

I cannot figure out why the oracle sql developer tool on a apple mac OSX 10.8.4 does not use my default directory as defined in the Tools->Preferences->Database->Worksheet. Instead of going to the ...
0
votes
2answers
324 views

Using sqlplus as tnsping alternative

Is it possible to use sqlplus as an alternative for tnsping since tnsping wasn't installed with the oracle setup. I simply want to check via batch script, whether the definitions from the tnsnames.ora ...
1
vote
1answer
49 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
1answer
854 views

Genymotion: possible to create a shortcut to an Android virtual device?

I'm using Genymotion as Android emulator, but would like to be able to start a virtual device from the command line or with a Windows shortcut, instead of the Genymotion window. Because Genymotion ...
0
votes
1answer
93 views

What is the thread_stack in Oracle and MSSQL compared to MySQL

I'm using a recursive stocked procedure in MySQL and had to change the thread_stack value in the my.ini from 128K to 512K. I need to deploy the same procedure now to an Oracle and Microsoft SQL ...
4
votes
1answer
52 views

Database integration with …well with sound beep or light? [closed]

Perhaps this post major editing : I work for company which sells services online. I would like to build some kind of software bridge/integration tool which would integrate our Oracle database with ...
0
votes
0answers
64 views

What is libcwait.so

We had a problem today with a file /etc/libcwait.so missing which broke our oracle database on one server. Any information i could find on the internet was related to oracle and redhat-like systems ...
1
vote
1answer
554 views

Created desktop shortcut in Elementary Linux, does not appear in list of applications

After a couple of hours of tinkering I have Oracle SQL Developer installed on ElementaryOS (based off Ubuntu) and created a desktop shortcut Oracle SQL developer.desktop in /usr/share/applicatons ...
1
vote
1answer
43 views

How to update Oracle JDK on Debian

I am planning to install the oracle JDK7 on my Debian Wheezy machine. To do so I am using java-package to install the jdk as a .deb package under Debian, as described here. My question is: Can ...
0
votes
0answers
84 views

PowerPivot Set Advanced Properties Database connection

I'm currently working w/ MS PowerPivot for Excel connecting to an ORACLE Database However I'm having trouble connecting to a new database. I can go into the advanced settings, change the source ...
0
votes
1answer
26 views

Is it possible to disable implicit connection cache while using connection pooling in Oracle OAS?

Hi we are using implicit connection cache under Oracle Application Server (http://www.oracle.com/technetwork/topics/oc4j-ds-083633.html). I am not a system guy, I am just a programmer but I just ...
0
votes
0answers
222 views

Installing Sun grid engine: commlib error: access denied

I am trying to remotely install Sun Grid Engine on Ubuntu 12.10 using the command line (qmon is not an option). I stuck at the commlib error: access denied (client IP resolved to host name ...
0
votes
1answer
109 views

Oracle Linux 6 download files?

I want to download Oracle Linux 6 for basic use to install on my laptop to use oracle 11g r2 database since this is one of only few linux distros which is supported. When I go to the downloads section ...
1
vote
3answers
2k 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 ...
0
votes
1answer
412 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 ...
0
votes
0answers
30 views

What is the minimal form of an Oracle DB instance that I can install locally on my Mac?

What is the procedure to get an Oracle (10g or 11g) DB instance running on my Mac, with it taking as little memory and disk as possible?
0
votes
1answer
167 views

Code folding in SQL Developer's SQL Worksheet

Is there a way to enable code folding in Oracle SQL Developer's SQL Worksheet? Using version 3.2.20.09.
0
votes
0answers
148 views

Oracle ORA-12154 could not resolve service name

I have read through many postings on the ORA-12154 error and have fixed it a few times on various computers but can't figure this one out. Generally every time I seen this error in the past it has ...
0
votes
0answers
20 views

Detect conflicting forwarded ports on VM

I am using Oracle VirtualBox on Windows. I've setup NAT and forwarded ports. When some forwarded ports are accidentally conflicting with host machine's ones, no errors are shown and all forwarded ...
0
votes
0answers
259 views

Connection with Oracle SQL Developer to Oracle 11g database on remote Windows Server 2012 machine

I have running up my oracle database 11g on server 2012, I connected to database via oracle sql developer from my server. Now I wanna connect to database via my home computer(windows8) also with ...
0
votes
0answers
10 views

Space between the bars of multicolumn Stacked Bar graph Using Oracle report builder10

I am tryng to Build a Multicolumn stacked Bar graph using Oracle Report Builder but I am Not able to make any space between the two adjoining bars of same group. How can i Put the space between the ...
0
votes
1answer
124 views

Make a database (Oracle 7.3) consisting of several .DBF files into one .MDF file (Oracle dump file)

Can you make a database (Oracle 7.3) consisting of several .DBF files into one .MDF file (Oracle dump file) in Windows 7 or so. Is there a tool that can do that "export" ?
0
votes
0answers
112 views

Where can I find SQL*Plus 8 to Download?

I am working with Oracle 8i (very old database) and I need to be able to run a bunch of SQL scripts against it. The latest versions of Oracle Clients I can find online all complain it is not supported ...
0
votes
1answer
642 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 ...