Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java.
0
votes
1answer
66 views
Different sqlldr locations on load balanced nodes
We have two nodes in a cluster in a load balancer running third party WebSphere application.
We have noticied that ./sqlldr location is different for both the nodes.
For one node , its:
...
0
votes
0answers
121 views
TPC benchmarks for MySQL and PostgreSQL database
Are there any existing TPC benchmarks for MySQL and PostgreSQL DBMS?
Is there a lack of benchmarks just because it is too expensive to run or because the database performance is not up to par with ...
0
votes
1answer
145 views
install kernel-uek-2.6.32-300.7.1.el5uek.x86_64.rpm fails
While trying to install kernel-uek-2.6.32-300.7.1.el5uek.x86_64.rpm I got following error :( Pls help, really in trouble
[root@nonprodsrv02 kdumprpm]# rpm -ivh ...
0
votes
2answers
59 views
Filessystem sizing issues on root
I recently installed a VM version of Oracle Linux 6.3 and began installing applications for testing. I realized that the "/" mount is small and the "/home" mount is way oversized, See output below.
...
0
votes
0answers
105 views
ORA-00942: table or view does not exist & ORA-01031: insufficient privileges
I can't access any tables on my oracle database.
When selecting the table product I get ORA-00942: table or view does not exist
I have tried this solution but I don't have sufficiënt rights to add a ...
0
votes
1answer
70 views
JBoss 5.1.0 GA configuration for Oracle Data Guard
Can someone please point me to some tutorial or "how to" for configuring Jboss to work along with Oracle Data Guard. Motivation behind this is pretty standard, move some of the users to read from the ...
1
vote
1answer
126 views
Root SSH login works, but su/sudo to root does not work
Im recently working on a clients box, and SSH into the box with root credentials work but when i try to su or sudo to root user it states incorrect password. I tried changed the root password and know ...
0
votes
0answers
109 views
EM Agent Installation Failed (Forms and Reports 11gR2 11.1.2)
I'm new in the oracle world and i have a problem during the installation of Oracle Forms and Reports 11gR2.
I installed weblogic server 10.3.6 without a domain configuration, later when i was trying ...
1
vote
0answers
68 views
iPlanet Authentication provider
Good day. I have stepped into project that requires a server migration that would change the means of authentication for our CAC/PKI SSL enabled website. We are using iPlanet 7 and Oracle Directory ...
0
votes
1answer
111 views
Windows 2003 server with oracle freezes
I am newbie to servers n all.. Please do help.
We are having a windows 2003 machine with the latest hardware configuration (i3 processor) which runs an ORACLE 8 Database server. The machine freezes ...
0
votes
1answer
119 views
SSL certificate for Oracle Application Server 11g
I was asked to get an SSL certificate for an "Oracle Application Server 11g" which has a soon-to-expire certificate. Brushing aside the fact that 10g seems to be the newest version, I got a ...
1
vote
0answers
151 views
Oracle Virtual Server OEL vm fails to start - kernel panic on cpu identify
I am in the process of following a guide to setup various oracle vm templates, so far I have installed OVS 2. 2 and got the OVM Manager working, imported the template for OEL5U5 and created a vm from ...
1
vote
1answer
196 views
How do I ensure that the SQL*Net keepalive is turned on?
I have a public facing application server that accesses an Oracle database that resides behind a firewall.
Some of the processes that are executed through the application server can run for over an ...
3
votes
2answers
149 views
Is disconnecting a network cable different from VMware “Connected” option?
I have an application that connects to a database and retrieves information from it. The way it is written is: for every request received, create a new connection to the DB server and retrieve data.
...
0
votes
1answer
167 views
2 RAC node clusters with different RAID layouts?
I am comparing RAID 10 and RAID 5 configurations for Oracle database in order to determine the best choice in terms of performance for mixed workloads.
Is it possible to have 2 RAC node clusters and ...
1
vote
2answers
57 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 ...
0
votes
1answer
232 views
Configuring DHCPD to use option 66, in a specific subnet
I am trying to configure DHCP to use option 66 to provide a TFTP server to Sunray thin clients. The clients in a specific subnet must use a specific TFTP server so that they are served configuration ...
0
votes
1answer
70 views
Oracle- Can't access objects from other users schema
I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I ...
0
votes
1answer
84 views
Oracle Import Dump [closed]
After system failure I have bought a new server and now Im trying to recreate the oracle database I had. I have a dump file which was made with the command exp and full=y. So can I restore the full ...
0
votes
1answer
50 views
Oracle replication A->B and B<-A?
If you have two unrelated Oracle databases on separate servers, can you replicate A to B and B to A so both servers have a copy of both db's?
Idea is for DR "on the cheap" without buying more Oracle ...
0
votes
2answers
83 views
How Oracle is doing high availability? [closed]
We are searching for some replacement of our mysql cluster - Oracle or pgsql. I read the whole document about HA in Oracle 11 database system, but I really was not able to understand it quite enough. ...
0
votes
1answer
120 views
Are Oracle Database CPU license limits enforced by software, and how do I check them? [duplicate]
Possible Duplicate:
Can you help me with my software licensing issue?
I've inherited a windows VM running Oracle Database 10g. Currently the VM has only one CPU assigned to it, but I can ...
0
votes
2answers
150 views
Performance-optimizing Oracle 10g on a server that is also a Tomcat JSP app server?
I have inherited a simple RedHat 5 - 64bit platform.
It has SCSI disks on RAID1, with 16GB of RAM. Double Core CPU.
Oracle 10g, Release 2.
This would be a decent platform for running the DB ...
1
vote
1answer
698 views
Configure Perl DBI and DBD in Linux
I am new to Perl and I work in a Linux OEL 5x server. I am trying to configure the Perl DB modules for Oracle connectivity (DBD and DBI modules). Can anyone help me out in the installation procedure?
...
0
votes
1answer
39 views
Does Oracle database need to be restarted to use Rman?
We have an Oracle database which uses Rman. The server hosting Rman repositories crashed.
We've put the Rman server back online, but do we need to bounce the Oracle database to get it to start using ...
0
votes
0answers
141 views
Oracle VM repository creation seems contradictory to its server pool?
I found something contradictory in Oracle VM. Clustered server pool creation in Oracle VM would format my FC LUN as ocfs2 , and start o2cb & ocfs2 services to build cluster environment. After ...
0
votes
1answer
54 views
How does Oracle Streams prevent the execution of code during the distribution process?
I thought about Oracle Streams and stumpled into a question.
Oracle Streams is used on the database I am programming for, but I am not the DBA. Therefore I am not familiar with the configuration of ...
0
votes
0answers
630 views
OracleDBConsoleORCL service cannot be started
I installed oracle in my own machine from about two years, but I stopped some oracle services from about seven months. Now I tried to start them again and open the oracle db but I couldn't make a ...
0
votes
2answers
2k views
Can't install kernel-uek-headers for currently running kernel
I have just created a VM in VMWare and installed a minimal install of Oracle Enterprise Linux 6.3.
# cat /etc/oracle-release
Oracle Linux Server release 6.3
It is running with the UEK kernel.
# ...
0
votes
1answer
90 views
Complete Network Disconnection when connected to an Oracle database
Randomly, we get network disconnections when using DBVisualizer or Oracle SQL Developer to connect to a remote database that is accessed through a VPN. The operating system is Windows XP SP3.
We are ...
0
votes
0answers
45 views
How to prevent users from using Manage Identities on Java messaging V6?
In Thunderbird there is an option to Manage Identities which you can tell Thunderbird to use more than one identity per mail account. For example imagine you have email fff@aaa.com and you want to ...
3
votes
2answers
290 views
Why would adding a datafile cause a deadlock in Oracle?
I have noticed something in Oracle which never happened before to me. Though I frequently do this kind of thing for many years now. In this case it's an Oracle11 instance (Oracle Database 11g ...
1
vote
1answer
185 views
Install Oracle Java JRE 7 on Ubuntu with just the command line
I can't use openjdk because it doesn't have native .jpg support.
I can't use sudo apt-get install sun-java6-jre sun-java6-plugin any more because apparently those have been pulled.
JRE version 7 ...
0
votes
1answer
160 views
Exception thrown when trying to access a web service (Weblogic) - java.lang.LinkageError
I've installed Adobe LiveCycle for Weblogic 10.3.4, and when I try to access one of the web services it deployed, I'm getting the following exception:
Exception - java.lang.LinkageError: loader ...
2
votes
3answers
608 views
SELinux is preventing Perl CGI script from accessing Oracle libraries
I'm trying to configure SELinux on a Red Hat Enterprise Linux 6.2 web server that runs Apache 2.2.15 and Perl 5.10.1, and connects to remote Oracle databases. The Oracle 11.2g client is installed. The ...
0
votes
0answers
67 views
Setting oracle disk backup location in oracle enterprise manager
I've got backups with rman working when I do them from the command line, i.e. if I set device type as such:
% CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/opt/test/%U';
% BACKUP DATABASE;
This works ...
2
votes
2answers
66 views
Linux OEL 6x - Compatibility with ACL
Will the ACL [ Access control lists like getfacl, setfacl ] utility work fine with OEL 6x?
It works great with Solaris 5.9 but not sure OEL 6x will support ACL utilities
0
votes
0answers
159 views
SSL Issues in Integrated Oracle Forms 11gR2 and OAM 11g Environment
We have successfully configured 11g Oracle Access Manager (11.1.1.5) with Oracle Forms 11gR2(11.1.2) servers. Although, everything works 100% fine for non-SSL traffic(HTTP), once we began configuring ...
1
vote
1answer
580 views
How to export database from Oracle 10g
I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
3
votes
2answers
89 views
Migration from oracle to DB2
I want to migrate my oracle schema to db2.
Any tool available for migration?
Please help
2
votes
0answers
139 views
Cant open up oracle web console after install db 11gr2 and show weird symbols?
i just finished installing oracle database 11gR2. after successful install, i will usually want to open up web console at http://localhost:1158/em..
however if i open up the page i get a weird symbol ...
0
votes
0answers
86 views
Oracle nls_sort Changing Issue
I am using Persian language therefore correct character sorting requires building a new NLS_SORT via Locale Builder.
I have built a Locale and every thing seems OK but when I am connecting to DB via ...
0
votes
1answer
776 views
Mac Os X 10.7 + PHP OCI8 + MAMP PRO + ERR_EMPTY_RESPONSE
i followed this article:
http://www.enavigo.com/2012/01/04/enabling-oracle-oci8-php-extension-on-os-x-snow-leopard/
and im getting this error: Error 324 (net::ERR_EMPTY_RESPONSE): The server closed ...
0
votes
1answer
537 views
sudo yum install oracle (-instantclient,-instantclient-basic,etc) not working
Specifically I would like to know what the package name is for the yum package for Oracle Instant Client. I've tried some that Google seemed to like, such as oracle, oracle-instantclient-basic, ...
1
vote
2answers
761 views
latest version of oracle developer including forms and reports
What is the latest version of Oracle Developer which includes Oracle Forms and Reports?
I am taking a Database Administration class in college. The professor is installing Oracle Developer 6i but ...
0
votes
0answers
77 views
How do you set up ODBC connections to an Oracle 11.2 server on OS X?
I'm trying to connect to an Oracle 11.2 server through R using the RODBC plugin. However, I can't seem to find any mention of an ODBC driver for OS X Lion on the Oracle website. Any ideas on where to ...
0
votes
1answer
123 views
Install Oracle 11g on Ubuntu using rpm package?
Does anyone have tried to install orcale 11g using offical rpm packages?
I found it is very complicated to install the oracle successfully on Ubuntu server.
And there are many different guides ...
1
vote
1answer
266 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 ...
0
votes
1answer
246 views
Oracle redo log performance degradation when inserting
I have a oracle 11g database. I'm testing in for inserts. The database running in noarchive mode. I have 3 redo log configured, each 2gb.
I'm trying to insert data into test table. At begin it goes ...
0
votes
1answer
65 views
Oracle OID SSO does not logout of partner applications on VM PCs
We have Oracle's OID providing Single Sign-On functionality to Oracle's EnterpriseOne software suite. Everything was working fine and dandy until we provided some developers access to VM PCs (instead ...
