The oracle tag has no wiki summary.
0
votes
0answers
24 views
PHP5 OCI8 FreeBSD
I'm running a FreeBSD server with Apache and PHP 5.3. I'm trying to get the Oracle DB extension (OCI8) running with PHP but I can't find a port or anything for it. Half of the Internet says it's no ...
0
votes
1answer
16 views
Blocking locks and performance
My main question is if high amounts of blocking locks degrade Oracle server performance. I understand that it can hurt users performance, but does it cause high load on Oracle itself?
0
votes
0answers
11 views
oracle proxy connection
I have a standard 3-tier of web, app, oracle db servers.
currently due to network policies, the web cannot access the oracle db and instead is required to go through the app. is there anyway i can ...
0
votes
0answers
40 views
cx_Oracle - InterfaceError: Unable to acquire Oracle environment handle
I have installed Django on Ubuntu 12.04 behind NGINX with uWSGI.
I use Postgresql as the main database for the application however I need to retrieve some data from an Oracle database.
I have ...
0
votes
1answer
21 views
getting oracle error ora-00103 when I try to execute a package in oracle 10g
I have to delete and repopulate tables on a remote database.To access the remote tables I have created synonyms. my package is as follows
create or replace
PACKAGE eco_push IS
PROCEDURE ...
0
votes
1answer
28 views
I compiled samba 3.6.4 on Solaris 9, and can't get smbd to run
I compiled the latest release of samba on a Solaris 5.9 system to address CVE-2012-1182, and I'm getting this result when I run smbd.
fs17151# ./smbd -i
smbd version 3.6.4 started.
Copyright Andrew ...
0
votes
0answers
49 views
VirtualBox setup of Bodhi Linux
I have a .vdi file that has a setup of Bodhi Linux which I am trying to run with virtualbox. Everything goes fine and the system starts but stops at the grub screen, not loading the linux on the ...
0
votes
1answer
26 views
display sql syntax in Oracle's sqlplus?
What is in Oracle's sqlplus equivalent of Linux's man or --help ?
When I'm in sqlplus and type help index, I get some commands displayed, but there is no way to get specific sql syntax. For example ...
2
votes
2answers
217 views
unable to install sun jdk on ubuntu
I have Ubuntu 12.04 x64 and I'm trying to install sun jdk for opennms.
sudo apt-get install sun-java6-jdk
when i run above given command i get following msg:
root@fido:~# sudo apt-get install ...
0
votes
2answers
30 views
Improving latency between developer machine and oracle db
It seems our developers are concerned with the latency they are getting between their dev machines at site a and the database which is at site b.
Ofcourse the obvious thing is to have as little as ...
-2
votes
0answers
23 views
What makes a great Oracle Middleware consultant or SI? What makes a bad one? [closed]
Just trying to get a sense of the various shops in this space? Particularly in the Bay Area.
Thanks
0
votes
1answer
49 views
Oracle 10g queries very slow and CPU usage very high after applying patch
So I recently updated an Oracle Database 10g from 10.2.0.3.0 to 10.2.0.4.0, as advised by Oracle Support, due to stability issues (a known issue under some systems where the instance would freeze ...
1
vote
2answers
27 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
0answers
6 views
oracle - security by table or security by column? are both there? [migrated]
If there is a customer table, and some extra-private/secure information like SSN is there, should I create another table to store such information and lock that table so only certain people can view ...
1
vote
2answers
30 views
create a 'definition' file from Oracle
I have inherited an oracle database, and have no Oracle experience. I have been tasked with building a 'clone' of the database on a new server. I am searching around, but not finding the things I am ...
0
votes
1answer
79 views
Connect to Oracle Database that is hosted in a Virtual Machine from the host machine
Good day,
I've just setup a Virtual Machine (using VirtualBox) of Oracle Linux with Oracle Database in it. After setting it up, I can verify that I can connect to it using sqlplus (sqlplus of the ...
0
votes
2answers
70 views
Setting up Oracle Database in Oracle Linux
Good day,
I am trying to install Oracle Database in Oracle Linux. However, it is looking for some dependencies. Anybody knows where I can get them?
Package: gcc-3.4.6 FAILED
Package: ...
2
votes
1answer
57 views
Need to downgrade from an intel xeon 5675 [closed]
I'll skip my sob story and just say Oracle has weird licensing, and because of this I'm trying to see if I can avoid buying three new ESX host servers by downgrading from 12 cores (6 licensed ...
2
votes
1answer
84 views
Can I enable Kerberos authentication for Oracle 11g Database Standard edition?
I have an Oracle 11g Database Standard instance running on Windows Server 2008 R2 and I need to enable Kerberos authentication. I followed the documentation for activating Kerberos 5, but cannot get ...
0
votes
1answer
20 views
Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history
Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history? For instance, I want to move from BPEL instances deployed to defined partition on Oracle SOA to ...
0
votes
1answer
78 views
INS-40719 error when Install Oracle RAC?
I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6
all went OK so far but I get INS-40719 Error message regarding SCAN Name
I do not have DNS server and I'm not going to try to use it on ...
5
votes
2answers
47 views
My table half-exists. Can't drop it
I have a table that is taking up quite a bit of space even though it has no rows. I also dropped it a while ago. When I try to drop it now, it says the table doesn't exist.
It shows up in ...
1
vote
1answer
102 views
Reporting Services: Cannot connect to Oracle using Integrated Security
Context
I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with ...
1
vote
1answer
66 views
How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server?
I am evaluating the impact of additional CPUs on Oracle database performance.
I am looking to license Oracle Standard Edition One (SEO, being most cost effective) or Oracle Standard Edition (SE). As ...
2
votes
1answer
27 views
Migrating Oracle DB to another operating system from Red Hat Enterprise by using a disk image
I have a Red Hat Enterprise server disk image that Oracle DB is installed on it. My question is : Is it even possible to use this disk image in order to setup same DB on another Oracle supported ...
2
votes
1answer
91 views
logfile deleted on Oracle database how to re-create it?
For my database assignment we were looking into 'database corruption' and I was asked to delete the second redo log file which I have done with the command: rm log02a.rdo this was in the ...
1
vote
0answers
32 views
Oracle concurrent programming execution methods
I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
-5
votes
1answer
52 views
What is the stability level of Oracle 11g? Is it suitable for production? [closed]
We are using both Express edition and Commercial edition to power up a Distributed application. Is Oracle 11g a good candidate for this application since we need data synchronization? Or is Oracle 10G ...
1
vote
2answers
202 views
Running SQL*Plus with bash causes wrong encoding
I have a problem with running SQL*Plus in the bash. Here is my code
#!/bin/bash
#curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql
wget -O script.sql ...
2
votes
2answers
115 views
Sunfire v100 Reinstall Problems
I own two Sunfire v100 servers, and I use hyperterminal to connect to them.
I am trying to re-install Solaris on one of them, so I put in the LOM cable and unplugged the harddrives.
Here's the ...
0
votes
0answers
299 views
Oracle XE 11g install on Windows 7 64 Bit [closed]
I am having a hack of a time of getting a good install of Oracle XE on my Windows 7 64 Bit box.
When I follow the install steps, I get an error about a reg key - I found an answer here ...
1
vote
1answer
169 views
How to execute datapump commands as sysdba from remote machine
I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine.
I know that when logged on the machine which runs the database, I can use :
...
2
votes
3answers
107 views
Change local admin password. Impacts on Oracle and Citrix?
I need to change the local admin password on some Citrix and Oracle servers. These servers are in production.
Then we will start using a secure password procedure, and change them every X month.
...
0
votes
2answers
34 views
Configuring swapfile error
I installed oracle linux 6 on my desktop but I forgot to configure the swapfile, I want to install oracle 11gr2 on it and it requires 2gig or ram, if I type the following commands on the terminal I ...
0
votes
0answers
38 views
hagrp + hagrp -offline oracle1 not succeeded
I run the following command on my solaris machine and this is what I got
hagrp -offline oracle1 -sys `hostname`
VCS WARNING V-16-1-10484 Group dependency is violated if group oracle1 goes ...
1
vote
2answers
61 views
Oracle only starts with autostart, doesn't when trying manually
I have installed oracle on my ubuntu system a few months ago and its been working pretty well. I have it setup to start on system boot and I run the following commands to stop/start the service
sudo ...
0
votes
0answers
25 views
Why Oracle8i listener service has to be restarted via vnc to fix protocol adapter error?
I'm not sure if this is the correct stackexchange page for such a question, but I couldn't find any better. I was also unable to find answer to my question.
Recently I had to fix TNS-12560: Protocol ...
0
votes
0answers
27 views
oracle case insensitive search issue
I need to case insensitive search for my oracle server.
I have set NLS_COMP=LINGUISTIC and NLS_SORT=BINARY_CI
It works well but when I execute a query like this:
SELECT MAX(SUBSTRING(acc_no, 9, 3)) ...
0
votes
2answers
65 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 ...
0
votes
1answer
38 views
DB2 to Oracle Migration
I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
0
votes
1answer
71 views
How to enable Oracle-Managed Files on Oracle Express for Windows XP
I'm trying to enable Oracle-Managed Files on Oracle Express for Windows XP.
From everything I've read, I need to set db_create_file_dest to an existing directory in the file system.
I've tried ...
0
votes
0answers
51 views
Hanging between Oracle client and Shadow Process
We are having an occasional (ie non-reproducible) issue where the Oracle client process (EnterpriseOne kernel process) and the Oracle shadow process seem to get out of sync. I perform a stack dump of ...
2
votes
1answer
145 views
How to keep filesystem layout identical in every RedHat Installation?
I want to keep the following layout same in every installation on the identical servers:
dm-0 /dev/VolGroup00/LogVol00
dm-1 /dev/VolGroup00/LogVol01
dm-2 /dev/VolGroup00/LogVol02
dm-3 ...
-2
votes
1answer
54 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?
0
votes
0answers
125 views
TNS-12532: TNS:invalid argument
I am trying to set up an Oracle 11g database server on windows 2008 R2. The server runs in VMWare Player which runs on Windows 7 Enterprise edition. The host and virtual pcs are connected with a ...
2
votes
1answer
73 views
Installation ORACLE 11g in an external hardrive
I am working on a project in which i have to deal with oracle 11g.
My project manager wants me to install Oracle 11g in an external hard drive. I already installed it in the hard drive, though when ...
0
votes
3answers
60 views
where does Tomcat and application logic sit on 2-server system (database server or webserver)?
I have an application depending on BlazeDS and Oracle Application Express, which both require the use of Tomcat or equivalent. I have the following two Linux servers:
(1) Oracle database 11G
(2) ...
0
votes
2answers
897 views
oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist
I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried.
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 ...
1
vote
0answers
159 views
ORA-12514: Message 12514 not found with two Oracle clients
A user is getting the following error when attempting to connect to an Oracle database through an Oracle Forms app. I also get the same error when I try to connect from their computer using sqlplus.
...
1
vote
1answer
71 views
One Way Replication of Oracle 11g to MSSQL 2008R2
We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS.
What is a good method to automate a one-way, read-only ...
