0
votes
1answer
113 views

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...
0
votes
1answer
173 views

Oracle 11g TNSLSNR LAST_ACK connection flooding

We have Windows 2k3 EE SP2 with Oracle 11.2.0.1.0 DB installed. The DB is used by different applications (including web-apps and services). From time to time, we have some problems with the web ...
1
vote
2answers
92 views

OID (directory service) Installation and configuration on Windows 2003 R2

I need your help in installing and configuring Oracle Internet Directory service on Windows 2003 R2 server machine, I was wondering if anyone can provide any useful tutorial links on the same. I did ...
1
vote
1answer
639 views

How do you read an Oracle .dmp file on a Mac?

I have a ~1GB .dmp file I'd like to get the data out of and I'm on a Mac. Is there any way to do this without either buying Oracle or finding a windows machine? Can you import .dmp files into ...
1
vote
3answers
3k views

How to have oracle database accessible remotely

I can connect to my oracle database using localhost:1521. However, connecting to the IP address does not work. I'm trying to do this because I am trying to connect to my database using another ...
0
votes
2answers
426 views

MS Project Server 2010 and Oracle Database Backend?

After searching far and wide across the internet for an answer I have come here in hope of help. I am aware that MS Project Server 2010 requires a SharePoint server, but does anyone know if it is ...
-3
votes
1answer
82 views

Oracle 11g on a hard disk [closed]

Can I install Oracle 11g on a hard drive. Can I use this hard drive in another computer where 11 g is not installed and just play a bit with Oracle?
2
votes
1answer
3k views

Why Oracle 11g on windows default installation keeps increasing memory usage even when idle?

I installed Oracle 11g on my Windows XP 64 bit desktop with pretty much the default options. Now when I start the database, it just keeps increasing the memory usage few hundred KB at a time even when ...
2
votes
2answers
503 views

Oracle: 32bit vs. 64bit with respect to memory usage

To help us decide whether to install a 32bit or 64bit flavour of Oracle, I need to find out the advantages and disadvantages of the two choices. Yes, I do know that the 32bit option restricts us to ...
0
votes
1answer
982 views

Can I create an oracle ODBC driver without installing the Oracle Client?

recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't ...
3
votes
2answers
3k views

Oracle 11g R2 Install Guide

I have a need to install Oracle 11g R2 on Windows Server 2008 R2. I have downloaded the two files from Oracle (win64_11gR2_database) and the client (win64_11gR2_client). Does anyone have a guide or ...
5
votes
3answers
5k views

ORA-01019 error only as an administrator

I'm having a strange problem. I've installed the Oracle 10g client on a terminal server running Windows Server 2008R2. When I try to connect to Oracle, using, say, Toad, I receive the error ...
0
votes
4answers
2k views

Install Oracle Drive and TNS for Windows XP?

I am building a box with Windows XP with some applications. One application requires connection to an Oracle database on remote. I have installed OracleXEClient.exe from Oracle download. The ...
0
votes
1answer
677 views

What guidance for page file size and other system parameters for Oracle running on Windows Server 2008

Slightly open ended question, but what are guidelines for configuring windows server 2008 running Oracle? For example, should the paging file be kept small (1gb) if I've got 32gb of RAM in the ...
5
votes
2answers
6k views

How to delete .dbf file in oracle?

I am trying to recreate a tablespace in Oracle and get the following error message: "created file already exists" I am running the following script: create smallfile tablespace dev_01 datafile ...
3
votes
5answers
3k views

What is the quickest way to kill all sessions from a specified user in Oracle?

What is the quickest way to kill all sessions from a specified user in Oracle?
1
vote
1answer
1k views

Migrate Oracle database from Windows to Linux

I've got an Oracle 9.2.0.1 database running on Windows XP. This has several schemas and includes a public database link to a remote Oracle database. I'd like to migrate this database to Oracle 11g ...
0
votes
1answer
94 views

Is there any way to configure Oracle without Java support?

I've got an Oracle installation that I'm using on my Windows XP workstation to run tests against. I'm not using Oracle's Java support; is there any way to disable it? Or is that a good idea? My ...
1
vote
2answers
4k views

How do I set the ORACLE_HOME variable for the Local System account?

I've run into an issue with one of my systems where multiple Oracle versions are installed for the support of various applications, but I need to run a program as a Windows service using the Local ...
1
vote
3answers
814 views

How can I install Oracle on my Windows XP machine which uses DHCP?

I'm installing a copy of Oracle on my development workstation because running tests against a remote database is terribly slow. However, it says something about me having to set the loopback adapter ...
8
votes
11answers
2k views

Linux or Windows 2003 (64 bit) for hosting an Oracle database?

Copied from StackOverflow Are there any overwhelming reasons to pick one over the other? I'm in the middle. Our database administrator says that Oracle on Linux is better, but cannot present proof. ...