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
1answer
23 views

Why Zabbix still says “At least one of MySQL, PostgreSQL, Oracle, SQLite3 or IBM DB2 should be supported.”?

At begin of setup, Zabbix shows the following error: At least one of MySQL, PostgreSQL, Oracle, SQLite3 or IBM DB2 should be supported. I already have a site working, and this have connections to a ...
-1
votes
0answers
13 views

SunFire not firing up [closed]

I got a server for free. I know it's ancient and stuff, but still, it's still functioning and I got it for free. It's a SunFire X2200 M2 1U server. My problem is that when I fire it up, it starts ...
0
votes
0answers
4 views

Access to Network Services in Oracle Database 11g

Recently we have switched from Oracle 10g to 11g, and only now I noticed that my mailing function does not work, I now get an error: ORA-24247: network access denied by access control list (ACL) So ...
0
votes
0answers
7 views

multipath soft lockup debian wheezy

Guys, I have attached a screenshot of my error I am on debian sparc port with a Sun T5220 server and a Sun StorageTek 2540 array with 2 fibre channel connections setup with multipath. how would I go ...
0
votes
1answer
32 views

Trouble activating Single Sign-On (SSO) on Trial subscription to Oracle Cloud

everybody First, I am not sure I am really on topic here, but Oracle's own "cloud" support and community forums are not helpful (they get very little traffic and there were no responses yet). Maybe ...
0
votes
0answers
32 views

Cannot create an instance of OLE DB provider. Error 7302

I am trying to connect to Oracle server from SQL server. I have installed Oracle DB and trying to create linked server following this link. But when I click ok on creating linked server it fails ...
-1
votes
1answer
33 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 ...
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. http://oradev.attlocal.net:7172/apex/...
0
votes
0answers
13 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
35 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 pear/...
0
votes
1answer
31 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
73 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
11 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
42 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
74 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
65 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
31 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
45 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
61 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 https://cloud.google.com/compute/docs/...
0
votes
1answer
61 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
163 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: /home/oracle/app/oracle/product/11....
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
320 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
1answer
61 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
67 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
14 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
26 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
458 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
16 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
136 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
66 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> /home/...
0
votes
0answers
47 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
84 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
60 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
122 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
278 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
139 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
85 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
640 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
99 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
32 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 ...
-1
votes
1answer
120 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
95 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
97 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
627 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
237 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
54 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