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.

learn more… | top users | synonyms

-1
votes
0answers
8 views

Unable to connect to an Oracle XE database from Oracle Sql Devloper

I've installed an Oracle 11g XE on a Linux ubuntu 14.04, successfully created a user, and imported a database into it. my problem is , if when I want create new connection for connect with DATABASE hr ...
-5
votes
0answers
27 views

Converting project in exe with database [on hold]

I have developed Java project which executes in my laptop but I want it to run in other PC with database.How can I attach database with exe
0
votes
0answers
13 views

Open APEX app outside my network

I have Oracle APEX installed on dB 12c on a linux box on my home network as a sandbox. When on this box I can open firefox and goto the below link and login fine. ...
0
votes
0answers
12 views

What's the clean way to rollback a hung OBIEE 11.1.1.7 installation

Looks like using the deinstall option would wipe out the entire HOME & BI cluster. While we are trying to restore down to the 11.1.1.6 previous installation. Windows platform. We were using the ...
0
votes
1answer
19 views

pear/MDB2_Driver_oci8 requires PHP extension “oci8”

I got this Error: unable to find package 'MDB2_Driver_oci8' file 'MDB2/Driver/oci8.php' so I tried to install it with pear install MDB2_Driver_oci8-1.4.1 but following Error is showing up ...
0
votes
1answer
22 views

Port forwarding via Watchguard

I have problem with accessing oracle database with oracle SQL developer. I'm using Watchguard m400 as my firewall/router and Windows Server 2012 R2 as Oracle DB Server. I have server with local IP, ...
-5
votes
2answers
44 views

Unknown Linux Server Reset [closed]

We have a infamous box out of 4 running on the kernel version below. Linux **** 2.6.32-431.5.1.el6.x86_64 #1 SMP Tue Feb 11 11:09:04 PST 2014 x86_64 x86_64 x86_64 GNU/Linux The box now is suffering ...
1
vote
0answers
10 views

Limiting Oracle instances resources with Cgroups?

Is it possible to limit the amount of resources (I/O, CPU and Memory) a Oracle instance can consume using only cgroups? (no containers or virtualization) The reason I wanna do that is because I want ...
0
votes
0answers
21 views

INS40907 Local node not included in the list of host names for grid installation

My error message indicates that I am not including the local node (even though I am working from the private network local node I assume it is looking for the public network node) [INS - 40907] Local ...
1
vote
1answer
51 views

Oracle invoked oom-killer even when RAM and SWAP is plenty free?

Can you please tell me what cause this Oracle process killed? Seems like plenty of RAM free, and plenty of SWAP free. There followed few other oracle processes killed. The VM has the 16G of vMem and 8 ...
0
votes
0answers
18 views

How to export particular table schema and data using ora2pg migration?

I'm using ora2pg migration tool for migrate table schema and data from ORACLE database to Postgres Database. Using the following query, I can export the entire schema and data from the ORACLE ...
0
votes
1answer
28 views

Establishing new IP address when launching multiple instances of the same Oracle VirtualBox image

I've created a new Oracle Virtual Box image and exported it to an "Open Virtualization Format Archive" (ova file). The original image used "NAT" settings. I've since changed it to "Bridged Adapter" ...
1
vote
2answers
40 views

Add redhat yum repo to oracle linux

I'm running oracle linux 7.2. The Oracle yum repo is comparatively small, containing only core enterprise packages. How can I add the redhat yum repo so I can install other userspace utilities?
0
votes
0answers
45 views

Custom oracle linux 6.7 image on google cloud hangs at 'Booting from 0000:7c00'

I am trying to create a custom oracle linux 6 image on Google compute engine. I followed all the steps as described in the google instructional videos here ...
0
votes
1answer
57 views

Server becomes unresponsive [closed]

Our database-server sometimes become unresponsive. It runs a fully updated Ubuntu 14.04 LTS. Notable non-vanilla software running on it are Nimbus, TSM and Oracle. About once a day, it becomes ...
0
votes
0answers
84 views

Error while running sqlplus after installing Oracle Client 11g R2 on RHEL 7

I am facing issue while running ./sqlplus command after installing Oracle Client 11g R2 on RHEL 7 here's is the error: $ ./sqlplus ./sqlplus: symbol lookup error: ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
1
vote
1answer
173 views

How to detect php -oracle using ubuntu nginx php7-fpm

I am running a Ubuntu-nginx-php7-fpm machine and phpinfo() does not detect the oracle extension. How can i tell to nginx or php that the oracle-php extension is installed? The machine is a clone ...
0
votes
0answers
26 views

Weblogic server hangs when “Creating data source connection pool named”

I have just installed Weblogic version 10.3.6.0 and created a data source which connects to MSSQL on my localhost. I have tested my connection and verified that a successful connection can be made ...
0
votes
0answers
56 views

c3p0 commit is always called even if queries are not executed(data is coming from Ehcache)

I have a web service which makes readonly call(bunch of select queries) to get data from DB. But it makes call to the database for the first time only, after that, all entities involved are cached in ...
1
vote
0answers
13 views

How to delete alogs fom Oracle downstream target

I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query: SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG; ...
0
votes
0answers
21 views

export vmware disk share ovf for RAC

I have one oracle RAC, which is configured as share disk(rac-node-2 share the vmdk of rac-node-1). Right now, I want to export the ovf template of oracle RAC, I hope when I import the ovf template ...
2
votes
0answers
324 views

How do I configure in IBM WebSphere 8.5.5 a data source using Oracle Wallet?

I have a server with a fresh installation of WebSphere Application Server 8.5.5 and I'm trying to configure a data source over a connection using JDBC and Oracle Wallet for SSL. The error message in ...
0
votes
1answer
15 views

Oracle RMAN full backup due to gaps in ARCHIVE LOGs

I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard. Because it's been on-line for a sustained period, some logs are missing and I ...
0
votes
0answers
12 views

Oracle 9i - Data Guard - how to completely resync existing stanby?

Thank's to another SF user, I've managed to recover the control file needed to start a target data guard database in standby mode. So I have an active primary running in ALM keeping only the last 14 ...
0
votes
1answer
19 views

Oracle 9i - Data guard target DB - lost control files, can I recreate from primary database?

I'm dealing with a problem whereby a I have a database that is managed using data guard using Redo Apply, so redo logs are copied to the target database, applied and kept in sync ready for fail over. ...
1
vote
0answers
114 views

tnsping and lsnrctl hung when about to exit – Oracle 12.1.0.2.0 on virtual Windows 7 VM on Mac [closed]

I am trying to run an Oracle installation on Windows 7 running in a virtual machine (Parallels or VMware) on a MacBook Pro (Retina, 15-inch, Mid 2015). When executing Oracle utilities like tnsping ...
1
vote
0answers
50 views

How to use java UDF on AWS Oracle RDS?

I am trying to use a java udf in AWS Oracle RDS. On a managed Oracle server I can do this by using something like the following: CALL dbms_java.loadjava('-user <username>/<password> ...
0
votes
0answers
44 views

Oracle / Sun ILO reports : Certificate not within the validity period

Trying to use to Oracle ILO(M), when I launch the remote console, Java Web Start starts, but then gives this error : Error screen The more information screen looks like this : More information ...
0
votes
0answers
6 views

Maintain and version controll config- and SQL scripts

I'm looking for recomandations of handling variouse config scripts for a few databaseservers. The scrips fall into the following categories: OS Config scripts and files, such as crontab for multiple ...
0
votes
0answers
72 views

Does CyberArk work with Oracle Dataguard?

Does anyone have experience setting up CyberArk password rotation for oracle databases that use DataGuard. the problem Im running into is that the secondary database is not open, so i need a way to ...
0
votes
1answer
50 views

Simple Paged Results control on Sun-Directory-Server/11.1.1.5.1

I am confused. I am trying to run simple pager results against what I believe is Oracle 11g Directory Server. I know that an old version at some point did not support RFC 2696. Now, according to ...
0
votes
0answers
107 views

What is the difference between Oracle WebCenter Content and Oracle Portal?

I'm having a difficult time understanding the difference between these two technologies. What I have understood is: The business logic, and DB connections lies in the Oracle Portal (weblogic server) ...
1
vote
1answer
234 views

Connecting to Oracle DB hosted on Windows 8.1 Azure VM

I have a windows 8.1 vm created on azure, it has 14 GB of memory and 200 some GB storage. I have installed Oracle with a templated database onto it. Everything is fine with the installation and I can ...
2
votes
1answer
112 views

Are IOPS capped at 3000 for AWS Oracle RDS with General Purpose (SSD) (gp2)?

Documentation at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html says This storage type can deliver single-digit millisecond latencies, with a base performance of 3 IOPS/GB ...
0
votes
0answers
74 views

siginificance of /dev/oracleasm/iid/*

I am a backup admin and our DB team says these files are required in backups. backups usually cannot protect /dev/ and /proc. kind request for any Oracle DBA to help me here to know siginificance of ...
-1
votes
1answer
593 views

HP Proliant DL380 Gen9

I have HP proliant DL380 Gen9 I do the installation oracle linux 6.4 and installation does not detect the logical drive created. i have 300GB SAS- on raid 0 logical drive
1
vote
1answer
91 views

Setup freeIPA to handle Oracle Database name resolution

I am trying to setup freeIPA to handle Oracle Database name resolution. I have followed this tutorial for OpenLDAP http://www.idevelopment.info/data/Oracle/DBA_tips/LDAP/LDAP_8.shtml The schema ...
0
votes
0answers
31 views

Is using sqlplus in a server environment considered as a bad practice?

We have a web application (a COTS product) and we need to query the application DB periodically using an external scheduler for alert purposes. DB is Oracle, se we decided to schedule a job on the ...
0
votes
0answers
226 views

Weblogic silent installation fails

I am trying to install Weblogic 12.1.3 to my Ubuntu Server 15.04 running on Vmware. I followed every step mentioned here (for single instance and instead of using /u02 I used /u01 folder. The rest is ...
-1
votes
1answer
103 views

Using xhost, display and startx - confused

I have a client A (192.168.1.1)(vncviewer) accessing Server B (192.168.2.1) (RHEL6) to run a installer. The installation pre-requisite is to set the xhost and DISPLAY properly. Q1) Please correct me ...
1
vote
1answer
85 views

Can I “flush and lock” an Oracle database to do a filesystem backup?

I'm using ZFS to take snapshots of running OpenVZ containers. For MySQL databases I can use flush tables with read lock to put them in a flushed & locked state. This will put the underlying files ...
0
votes
1answer
94 views

How do I prevent Oracle from writing to datafile when I start database?

I am creating a Docker image for Oracle database, and many different containers will be generated from the same image. When I start the Oracle instance, for some reason a few bytes are written to all ...
0
votes
0answers
465 views

Oracle 11.2 linked server from SQL Server: missing oraclient11.dll required for distributed transactions

I've set up a linked server to Oracle 11g R2 in my 32-bit SQL Server 2005 instance, using the Oracle-provided OraOLEDB.Oracle. When I try to query against the linked server from SSMS, I get OLE DB ...
0
votes
0answers
570 views

Oracle UTL_HTTP with SHA-256

I use Oracle Express Edition 11G (11.2.0.2.0). Sometimes we need to call a webservice using UTL_HTTP. If the webservice is using https we need to use Oracle Wallet where we download the server's SSL ...
0
votes
1answer
217 views

Weblogic Server state changed to FORCE_SHUTTING_DOWN

I have a problem in Weblogic. When you run the script startWebLogic.sh the weblogic does not start. Below is the log. oracle.security.jps.JpsRuntimeException: ...
0
votes
1answer
44 views

Oracle Database with autofs

We run our oracle databases (11 & 12) on NFS on Redhat 6. We do not use ASM. Is it acceptable to use autofs for all of the various oracle files? Thanks, Al
0
votes
0answers
207 views

Oracle 6i reports engine crash on Windows server 2008r2

Background: We have Oracle 6i applications that used to run on Windows server 2003. We've migrated to 2008r2, and we managed to get these applications running almost perfectly (took a while and a lot ...
1
vote
1answer
3k views

ORA-12505, TNS:listener does not currently know of SID after changing port number

I am trying to change oracle tnslsnr port number from default to some other port. After I change port number for tnslsnr from 1521 to 2000 I start geting ORA-12505, TNS:listener does not currently ...
0
votes
0answers
24 views

What does Oracle Data Access Components Release number mean?

I need to document the Oracle Data Access Component installed on our system. The current version we have installed is 12.1.0.1.2. What does each number indicate ? I searched but could only find ...