The oracle tag has no wiki summary.
1
vote
1answer
11 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
32 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)
...
-1
votes
0answers
29 views
Reading a text file using utl_file package [closed]
I have this text file :
#
#
#
DATE=20120105
QVN Index,aaa,0.75757
Q1W Index,sss,0.832899
M Index,aaa,0.3232
M Index,sss,0.34232423
I wrote a code to read file to database using utl_file package, ...
0
votes
0answers
8 views
sending data in a file.txt by oracle store procedure using utl_file package [migrated]
I want to send data in a file.txt to a table in databse by oracle store procedure using utl_file package,
the file.txt contain:
QRIFR6M Index,BID,0.7875, aaa
QRIFR9M Index,BID,0.8625, bbb
QRIFR1Y ...
0
votes
0answers
77 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
41 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
72 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
79 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
115 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
123 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
106 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
90 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
78 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
41 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
24 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
1answer
2k 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
32 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
9 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
349 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
19 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
146 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
56 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
0answers
118 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
27 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
0answers
231 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
20 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
0answers
65 views
When will Java 7 be pushed out to users as an update? [closed]
Has Oracle announced a plan or schedule for when Java 7 will be pushed out to end users of Java 6?
1
vote
1answer
60 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
137 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
327 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
462 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 ...
0
votes
2answers
5k 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
140 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
175 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
274 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
389 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
...
0
votes
1answer
142 views
Oracle 11gR2 Client connection to Oracle11gR1 DB?
Is it possible to connect to a Oracle 11g R1 DB instance from a Oracle 11g R2 client?
0
votes
0answers
51 views
Macbook does not recognise oracle enterprise linux on boot
Hey, I deleted my snow-leopard 10.6.7 and then tried installing Oracle Enterprise linux on my bare system.
The installation was succesful but no OS of any kind is detected upon rebooting(as prompted ...
0
votes
2answers
289 views
How to download a file properly with a proper hash check? [closed]
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
2k 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.) ...
0
votes
0answers
18 views
oracle removing error [closed]
Possible Duplicate:
how to Completely remove Oracle 11g from my computer ?
when i am trying to remove oracle service an error is coming that access denied.
i have logged in as admin user ...
2
votes
1answer
829 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
359 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 ...
2
votes
2answers
8k views
how to Completely remove Oracle 11g from my computer?
how to Completely remove Oracle 11g from my computer?
I have Windows7 64-bit.
2
votes
3answers
350 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
1
vote
2answers
112 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
1answer
2k 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
683 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
109 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?
1
vote
3answers
381 views
Oracle licensing /pricing?
Question: I'd like to download Oracle 11g database for evaluation purposes.
Now I found this link for downloads:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
...
