The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
3k 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
0answers
78 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 ...
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 ...
1
vote
1answer
758 views

Process keeps creating dump files

We have a Delphi application running on a terminal server that keeps generating dump files. For the same PID, it keeps creating dump files with an interval of around 1 second until the process is ...
0
votes
2answers
6k views

Installing Oracle 11gR2 on RHEL 6.2

I'm having some difficulty installing Oracle 11gR2 on RHEL 6.2. I have compiled a giant list of every single step I have taken so far. I installed RHEL 6.2 on VMware. It did its easy install ...
0
votes
2answers
221 views

In Solaris how do you startup a script automatically without user input?

I'm using Oracle Solaris, and i would like to startup a script automatically everytime i turn on my computer and log into the desktop, however the script i want to run requires elevated permission, so ...
0
votes
2answers
355 views

bash: ./wls1036_solaris32.bin: Invalid argument

Having some experience in ubuntu, I installed solaris 11g recently to work on WebLogic. I've downloaded wls1036_solaris32.bin file. When I run ./wls1036_solaris32.bin in the terminal, I'm getting ...
0
votes
1answer
36 views

Oracle upgrade issue - view,audits/logs that hold info

is there a way in Oracle DB (regardless of version) and by means of views or traces/logs to retrieve info for a version upgrade (for example the timestamp it took place, prior versiof of database and ...
1
vote
1answer
304 views

Visio ERD cannot fit in A4

I did a reverse engineering on a oracle database into visio 2010, the issue is that i cant find anywhere to make the size of the entities to fit into an A4 format, entities wont shrink.. Am i missing ...
0
votes
1answer
2k views

installing Grid Engine “cannot reach qmaster”

I want to install Grid Engine on my laptop. I am using Ubuntu 11.10 under VirtualBox 4.1.6. (The purpose of installing Grid Engine is not to compute anything, I just want a working Grid Engine ...
1
vote
2answers
13k views

How do I export the data from an Oracle SQL Developer query

How do I export the data from an Oracle SQL Developer query? I can create queries in it fine, but as to export ??
0
votes
2answers
2k 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
1answer
213 views

Cannot connect to oracle

While trying to connect to the oracle from my application(Windows). I am getting this error. Cannot connect to ORACLE: -1 : 0 The server used is Oracle 11g and the client is also Oracle 11g
1
vote
1answer
433 views

Updating a table in oracle using another table rows

I want to update each row of a oracle table based on another table's rows. To be more specific, There's a table called Contact with the following fields: code(PK), name, mobile, email There's ...
1
vote
0answers
248 views

Need Solaris network driver 64bit

I'm newbie in Solaris and I need network driver 64bit for: - pci bus 0x0004 cardnum 0x00 function 0x00: vendor 0x1186 device 0x4b01 D-Link System Inc DGE-530T Gigabit Ethernet Adapter (rev 11) ...
3
votes
2answers
439 views

Installing Sun/Oracle Grid Engine on a single machine

I want to install a Grid Engine cluster entirely on my laptop, the "cluster" having only two nodes, one head node and one node for computing. The nodes should run within the same instance of the same ...
0
votes
1answer
747 views

how to permanently set hostname for sqlplus?

I have the following situation: a windows 7, 64-bit OS; in which I have an Oracle 10g setup; on top of Win 7 - XP Mode; in which I have Oracle 11 client. As I try to connect to the Oracle ...
1
vote
0answers
560 views

CentOS 6.1 + Oracle Express 11g

I have installed CentOS 6.1 and Oracle. And then I closed the firewall, used the right Env Typed /etc/init.d/oracle-xe start and inited OK But, I can not use "get Started" (Firefox displayed: ...
1
vote
1answer
3k views

Running Oracle script from Notepad++

Can we configure Notepad++ to run an Oracle script? I mean, once we wrote some script (assume a PL/SQL script containing a procedure), can it be compiled from Notepad++ editor itself? If it is ...
1
vote
0answers
433 views

How to run a SQL select query in Oracle database through a shell script?

I need to run a SQL select query in an Oracle database and have to capture the list of retrieved records in a shell script. Also I would like to modify the query for certain conditions and need to ...
1
vote
1answer
398 views

Oracle - strange behavior - why?

I had to setup an Oracle environment. The stage is as follows: there are Oracle 11.2 client and 10g express server, the OS is Windows 7, 64-bit. I have the ORACLE_HOME, ORACLE_SID and PATH env. ...
1
vote
1answer
4k views

How can I connect to an Oracle database through a shell script?

I have tried to connect to an Oracle database using the below command: sqlplus -s LOGIN/PASSSWD@SERVERNAME:ORA_PORT/SERVICE_NAME However I couldn't connect. It was throwing the following error: ...
1
vote
2answers
119 views

Tools to manage SQL Server and Oracle database from the desktop

I am using SQL Server 2008 and Oracle 11G on my system. Running both database services is making my system very slow. In order to stop the services I have to go to Services and stop them manually. ...
2
votes
4answers
39k views

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name

I have a batch file which starts the Oracle Services net start OracleOraDb11g_home1TNSListener net start OracleServiceORCL call C:\app\Edifixio\product\11.2.0\dbhome_1\BIN\emctl.bat start dbconsole ...
2
votes
1answer
287 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 ...
90
votes
4answers
182k views

How do I install the Sun/Oracle Java SDK on Ubuntu?

Since 11.10 Ubuntu does not provide the sun-java-jdk, how do I install it?
3
votes
1answer
2k views

Using Virtualbox Bridge Networking fails connection from Guest OS to Oracle XE running on Host

I am trying to make a JDBC connection from a VirtualBox Ubuntu Guest OS to an Oracle XE database running o Host. However, the connection is refused. Here are the details of my environment: ...
8
votes
3answers
8k views

Alternatives to Oracle JRE

I would like to uninstall as many Oracle products from my computer as possible because I don't like that company. However, I require Java for some of my applications, e.g. Eclipse. What alternatives ...
2
votes
0answers
384 views

Access 2010: The Oracle client and networking components were not found

I've installed these Oracle client and ODAC files required for "Microsoft ODBC for Oracle": ODAC112021Xcopy_32bit win32_11gR1_client But alas it will not work! I'm on Windows 7, using Access 2010. ...
0
votes
2answers
1k views

DataStage Client 8.5 Installation Error on Windows 7

I am trying to install Datastage Client 8.5 on Windows 7 x64 and getting the below error: com.ibm.is.install.exception.ActionException: CDIIN5032E: Exception caught by ExecuteProcessAction.: ...
1
vote
1answer
74 views

Ensure libraries in /usr/lib{64} are found before those defined in /etc/ld.so.conf

I am running Fedora 15 x86_64 and have the Oracle 11 client installed, and have an /etc/ld.so.conf.d/oracle.conf file configured so I can automatically pick-up the client shared object file. However ...
8
votes
2answers
5k views

How to connect to Oracle DB via ODBC

I am attempting to connect to a remote Oracle DB via ODBC. I am totally inexperienced and fail to connect. What I have installed: Oracle 'ODBC Driver for RDB' A program I want to connect from ...
1
vote
2answers
320 views

How to pull huge table (80 millions rows) from Oracle into SQL DB or SQL dump via VPN

I have the task to pull a huge table from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting which I access via Cisco VPN (Split tunneling is ...
0
votes
1answer
1k views

Running Oracle XE Server in VMWare Player

I have installed the Oracle XE server an VMWare on Windows XP. In the virtual machine environment I have installed Oracle XE server also. The Oracle server which is running on actual Windows machine ...
0
votes
2answers
4k views

'impdp' is not recognized as an internal or external command, operable program or batch file

I can see impdp.exe in E:\Oracle\product\11.2.0\dbhome_1\bin, and that folder is in the PATH. However when I open a CMD window and try to run impdp, I get this error: 'impdp' is not recognized as ...
0
votes
2answers
2k views

Where'd my System DSN that I just added go to?

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle ...
1
vote
3answers
13k views

OS X Lion - Installing Oracle 10g Standard Edition

Im trying to install oracle 10g on to OS X Lion, I have previous achieved this on snow leopard with the following ...
1
vote
1answer
326 views

Fedora 15 su user problem

I'm new to Fedora 15 and Linux. I've stumbled upon a problem while installing Oracle XE; I can't set environment variables or do anything else - any change I make won't stick. I'm using the terminal: ...
1
vote
0answers
400 views

Oracle XE Fedora 15 Installation problem [closed]

I got a problem installing Oracle XE on Fedora 15. Hope you can help me. I used this tutorial(that worked great for F14) but didn't got lucky with F15. The problem is that during installation goes ...
-1
votes
2answers
3k views

Download link for JDK & jre 64 bit [duplicate]

Possible Duplicate: Windows 7 64-bit and Java JDK download I want to do download jdk 64bit (last update) for Windows and Linux but I can`t download it from oracle.com It says Forbidden ...
0
votes
2answers
1k views

How to download a file properly with a proper hash check? [duplicate]

Possible Duplicate: EXE file package repair I'm trying to download the Oracle VM with Enterprise Linux and database tools from here. It's an appliance that can be imported with VirtualBox ...
1
vote
2answers
23k views

Creating a new user in Oracle Enterprise Manager 11g

I downloaded the Oracle VirtualBox VM containing Oracle SQL Server 11g and all their dev tools. (There's not much documentation along with it and I had to find fragments of info here and there.) ...
3
votes
3answers
9k views

“No message file” problem with Oracle client

I have installed Oracle Client 11g R2 Win64 on Windows 7 x64. However, running tnsping (without parameters) yields the following output: C:\Users\stefan.moebius>tnsping TNS Ping Utility for ...
2
votes
1answer
1k views

Problem occurred while installing Oracle 8i

I am trying to install Oracle 8i but during installation it found an error of jrew.exe file. Oracle 8i was not installed on my computer. I try to install the Oracle product from the CD. So what can I ...
11
votes
4answers
81k 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.
2
votes
4answers
3k views

Login to Oracle database without username and password

I want to login to a database by running an SQL file from a unix script without supplying username and password (as root)....is this possible? Database is oracle
2
votes
2answers
615 views

Oracle admin tool for mac os x

I'm looking for desktop admin tool similar to Navicat for Oracle in Mac os X. Navicat it's ok but it is quite buggy. Any other recomendation?
0
votes
2answers
8k views

Oracle 10g Client for Windows 7?

I downloaded the Oracle 10g Client Release 2 from this link, the one that says it is compatible with Vista, Windows Server, and Windows 7. However, when I run the installer, it says that the ...
0
votes
1answer
2k views

Can't connect SQL*Plus to Oracle 10g from within VMWare Fusion VM

I am attempting to connect to an Oracle 10g server (remote host on LAN) from within a Windows XP VM hosted by VMWare Fusion on OSX. While I can connect to the service using Oracle Net Manager, I can ...
-1
votes
2answers
184 views

Oracle for windows7 [closed]

Does Windows 7 support Oracle? Then how do I install Oracle in Windows 7? Does all the .dll's of Oracle supports Windows 7? is there any new version of Oracle for Windows 7?