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

2
votes
4answers
10k views

Oracle XE 10g: missing file spfileXE.ora (Windows Server 2008 64 bit)

I'm having problems installing Oracle XE 10g on a Windows Server 2008 64 bit machine. After the installation the connection to the database administration page http://127.0.0.1:8080/apex fails. If ...
0
votes
0answers
7 views

Server stack for PHP and remote Oracle [on hold]

I have to deploy PHP web app on EC2 server which connects remote AWS Oracle RDS. I know that I will have to install Oracle Instant clients and OCI8 extension to connect Oracle with PHP. Which OS ...
0
votes
0answers
5 views

Starting an Oracle database in upgrade mode?

I have an Oracle database instance running on a Windows 2012 server. I need to start it up in upgrade mode to run some configuration changes. However, I cannot find the right command to get it going. ...
-1
votes
1answer
17 views

Failed while installing Oracle fusion Middleware 11g Release 1 (11.1.1.7)

I am trying to install oracle fusion Middleware 11g Release 1 (11.1.1.7) on Windows 2012 R2 64-bit with Java 7 update 79. But I am receiving below error while running installation wizard: Checking ...
0
votes
1answer
1k views

Best practices in customizing Oracle E-Business Suite and Oracle Applications in general [closed]

I am looking for some best practices in customizing Oracle E-Business Suite, especially in terms of version control of concurrent programs (like Oracle Reports), Oracle Forms tracking/rolling back ...
14
votes
6answers
23k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article (http://...
0
votes
1answer
5k views
0
votes
1answer
2k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
2
votes
1answer
2k 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 ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
4
votes
1answer
5k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
1
vote
2answers
1k views

Can't start WebLogic admin console

I'm wondering how to fix this error. We had the wrong Java installed on my machine when I got it, so my boss installed JRocket to fix things. WebLogic has been having problems ever since. I cannot ...
2
votes
1answer
1k 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
1answer
735 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 ...
1
vote
2answers
2k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
-1
votes
1answer
42 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
vote
5answers
1k views

What is good compression algorithm that can be used for Oracle .DMP files

I'm planning to compress the Oracle export dump files of all Oracle database servers to reduce space usage on their disks. My question is: Do you know of any good compression utility/algorithm for ...
0
votes
0answers
5 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
8 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 ...
1
vote
2answers
1k views

Oracle: TRUNCATE sometimes takes ages

Usually, truncating a table takes 5-10 seconds. But when several people work on the same DB instance (but different tables), the operation can take more than an hour. How do I debug this?
3
votes
5answers
42k views

Oracle database is very slow - Where to start and how to find the cause?

Our Oracle database(11g) is very slow all of a sudden. I donno where to start the debugging process to find what actually is the problem? I tried generating table stats and looked for locks..but i ...
-1
votes
1answer
46 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
40 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 ...
0
votes
0answers
73 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 ...
0
votes
1answer
72 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 ...
7
votes
4answers
109k views

How to restore/import an Oracle database from dmp file?

I've recently recieved the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now i need to restore the original database. Can anyone give me a step to step ...
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
47 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
37 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
79 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 ...
1
vote
1answer
715 views

Powershell execute Queries using SQLPLUS

I have a RHEL server with Oracle 10G installed. I need to write a powershell script to query my database and get the output. I have imported Posh-SSH module and am able to connect to my RHEL server ...
1
vote
1answer
89 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
57 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 ...
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" ...
0
votes
0answers
76 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 ...
1
vote
2answers
46 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?
2
votes
3answers
387 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 works,...
1
vote
0answers
146 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 ...
0
votes
1answer
63 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
66 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/...
2
votes
1answer
3k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
1
vote
1answer
375 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
173 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....
6
votes
4answers
14k views

How to install Oracle's exp / imp binaries

I was browsing the net to find a solution, but I had no luck. :( How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle ...
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
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
3answers
679 views

SQL Server 2005 - Oracle Linked servers stop working

[URGENT - PRODUCTION ISSUE] All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem ...