The oracle tag has no wiki summary.
1
vote
1answer
94 views
VERR_NOT_SUPPORTED when trying to create a windows 8 image in Virtualbox
I'm trying to create a Virtualbox image of windows 8 consumer preview. I tried this tutorial: http://www.addictivetips.com/windows-tips/how-to-install-windows-8-on-virtualbox/
I did exactly what was ...
0
votes
0answers
16 views
Oracle, error while exporting schema [migrated]
I'm using a command:
$ exp userid=apex_public_user/apex_public_user OWNER=apex_public_user DIRECT=Y CONSISTENT=Y FILE=/home/oracle/apex_public_user.dmp
and getting following output:
Export: ...
0
votes
0answers
57 views
Show DB2 Tables in Oracle SQL Developer
(Yes, this is a duplicate question from SO. I made it long ago, and it's still unanswered. I think it may get better results here?)
I'm connecting to a DB2 database with Oracle SQL developer. There's ...
0
votes
0answers
12 views
How to avoid PMON to enable a listener every 60 seconds
My oracle server is starting a listener automatically and making the listener configured in listeners.ora to reject connections, is there a way to avoid this?
I suspect I have to do something like ...
0
votes
2answers
31 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
27 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
18 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 ...
0
votes
0answers
95 views
ORA-00922 and ORA-28000 error while installing
While trying to install Oracle Database 11g Release 2 I ran in to a error while the Database Configuration Assistan was running the Creating and starting Oracle instance.
First It gave me a ...
0
votes
0answers
38 views
How to remove all known media in Virtualbox Media Manager?
I cannot remove any of my media in Virtualbox Media Manager since trying to do so remains in the has 1 child error as below screenshot.
When I try to uninstall then reinstall Virtualbox, the list ...
0
votes
0answers
345 views
importing CSV data in Oracle (trying Apex/SQL Developer) [closed]
I am using recent versions of APEX (4.1.1) and Oracle (11.2.0.3).
I am uploading CSV data to a set of tables.
I have been trying it out and am encountering some problems which I haven’t seen before.
...
0
votes
0answers
49 views
How to install English version of Oracle 11gr2 in German Windows 7?
I am running Windows 7 64bit home edition in German. I want to install Oracle 11gr2 in English. According to the document I've changed system locale to English and rebooted the system. But the oracle ...
1
vote
1answer
35 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
127 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
223 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
119 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
61 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
0
votes
0answers
26 views
Is there a tool that can check the availability of an Oracle 11g database on a remote machine? [closed]
I'm configuring the boot sequence on a Linux box, and one of the startup applications is dependent upon an Oracle instance being available on a different box. I would like a bash scriptable tool to ...
1
vote
1answer
113 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
90 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)
...
0
votes
0answers
220 views
Installing Oracle11g into CentOS6.1 in VMWare 7
The check of packages failed. Some packages have wrong version. For example: libaio-0.3.105. I used rpm to check my system. I have libaio-0.3.107-10.el6.x84_64 installed. And some pacakge missed. For ...
3
votes
1answer
134 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
221 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 ...
0
votes
0answers
110 views
How to write CLOB parameter in a file or XML using shell script?
I executed a oracle stored procedure using shell script.
How can I get the OUT parameter of the procedure (CLOB) and write it to a text or XML file in a UNIX environment using shell script?
1
vote
0answers
193 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: ...
0
votes
1answer
305 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
178 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
143 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
332 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:
...
0
votes
0answers
137 views
debugging Oracle Triggers using PL\SQL Developer 7.0.2?
I am able to debug the procedures and functions in PL\SQL Developer but when i set break points for Trigger its not taking them as a valid break points, And execution is not stopping at those break ...
1
vote
1answer
38 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
2answers
6k 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
60 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
0answers
14 views
Oracle downloads - can downloads be scripted?
I would like to automatically download oracle products including updates. Is it possible to script the downloads for something like instant client?
...
2
votes
1answer
783 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:
...
0
votes
0answers
50 views
Change path for linked table in Microsoft Access 2000
I have a Microsoft Access database which is already linked with many tables in Oracle. I want to add few more tables to that from different server of Oracle.
If I connect to the server through ...
3
votes
2answers
343 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
145 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
1answer
228 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.:
...
0
votes
0answers
68 views
Compare “Date” field in Oracle [closed]
I have 2 questions:
I want to compare a field whose data type is "Date" against a given date.
The DB is oracle and being a mysql guy I'm finding it difficult to come up with simple queries.
The ...
3
votes
1answer
509 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
1answer
21 views
How do I know the biggest list that I have created in the Oracle Collaboration?
How do I know the biggest list that I have created in the Oracle Collaboration?
I also want to know how many members each list has.
Can I get this information through the graphical console or just ...
1
vote
1answer
90 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
301 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
642 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
1answer
832 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
8k 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 ...
0
votes
0answers
206 views
TNS-12535 error while trying to connect to an Oracle Database which is on a bridged VM
I have a Windows XP host running VMWare Workstation 7, hosting a guest running Windows 2003 with Oracle database 9i.
It is a copy of my original physical server which I converted. I also edited ...
1
vote
1answer
220 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
314 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
654 views
Download link for JDK & jre 64 bit [closed]
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
...
